Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
"ddl":
"""
CREATE TABLE Sample_Table (
Col_01 varchar(100),
Col_02 char(200),
Col_03 integer,
Col_04 double,
Col_05 datetime,
Col_06 decimal(2,1) not null default '0.0',
Col_07 integer,
CONSTRAINT const_01 PRIMARY KEY (Col_01, Col_02),
CONSTRAINT \"const_02\" UNIQUE (Col_03, Col_04),
CONSTRAINT \"const_03\" FOREIGN KEY (Col_04, \"Col_05\") REFERENCES ref_table_01 (\"Col_04\", Col_05)
);
""",
"database": DdlParse.DATABASE.mysql,
"table": {"schema": None, "name": "Sample_Table", "temp": False},
"columns": [
{"name": "Col_01", "type": "VARCHAR", "length": 100, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": True, "pk": True, "unique": False, "constraint": "PRIMARY KEY", "description": None},
{"name": "Col_02", "type": "CHAR", "length": 200, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": True, "pk": True, "unique": False, "constraint": "PRIMARY KEY", "description": None},
{"name": "Col_03", "type": "INTEGER", "length": None, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": True, "constraint": "UNIQUE", "description": None},
{"name": "Col_04", "type": "DOUBLE", "length": None, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": True, "constraint": "UNIQUE", "description": None},
{"name": "Col_05", "type": "DATETIME", "length": None, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": False, "constraint": "", "description": None},
{"name": "Col_06", "type": "DECIMAL", "length": 2, "scale": 1, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": True, "pk": False, "unique": False, "constraint": "NOT NULL", "description": None},
{"name": "Col_07", "type": "INTEGER", "length": None, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": False, "constraint": "", "description": None},
],
"bq_field": [
'{"name": "Col_01", "type": "STRING", "mode": "REQUIRED"}',
'{"name": "Col_02", "type": "STRING", "mode": "REQUIRED"}',
'{"name": "Col_03", "type": "INTEGER", "mode": "NULLABLE"}',
'{"name": "Col_04", "type": "FLOAT", "mode": "NULLABLE"}',
'{"name": "Col_05", "type": "DATETIME", "mode": "NULLABLE"}',