Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
},
},
"datatype_postgres": {
"source_ddl":
"""
CREATE TABLE Test_Table (
Col_01 character varying(100) PRIMARY KEY,
Col_02 json NOT NULL,
Col_03 integer[], -- one dimensional array
Col_04 integer[][], -- two dimensional array
Col_05 integer[][][], -- multiple dimensional array
Col_06 character varying[] -- character varying array
);
""",
"bq_ddl": {
DdlParse.NAME_CASE.original:
"""\
#standardSQL
CREATE TABLE `project.dataset.Test_Table`
(
Col_01 STRING NOT NULL,
Col_02 STRING NOT NULL,
Col_03 ARRAY,
Col_04 ARRAY>>,
Col_05 ARRAY>>>>,
Col_06 ARRAY
)""",
DdlParse.NAME_CASE.lower:
"""\
#standardSQL
CREATE TABLE `project.dataset.test_table`
(
TEST_DATA_DDL = {
"exist_schema_name": {
"source_ddl":
"""
CREATE TABLE Test_Schema.Test_Table (
Col_01 varchar(100) PRIMARY KEY,
Col_02 char(200) NOT NULL UNIQUE,
Col_03 integer UNIQUE,
Col_04 double,
Col_05 datetime NOT NULL,
Col_06 bool
);
""",
"bq_ddl": {
DdlParse.NAME_CASE.original:
"""\
#standardSQL
CREATE TABLE `project.Test_Schema.Test_Table`
(
Col_01 STRING NOT NULL,
Col_02 STRING NOT NULL,
Col_03 INT64,
Col_04 FLOAT64,
Col_05 DATETIME NOT NULL,
Col_06 BOOL
)""",
DdlParse.NAME_CASE.lower:
"""\
#standardSQL
CREATE TABLE `project.test_schema.test_table`
(