simple-ddl-parser
simple-ddl-parser copied to clipboard
xnuinside
Simple DDL Parser to parse SQL (HQL, TSQL, AWS Redshift, BigQuery, Snowflake and other dialects) ddl files to json/python dict with full information about columns: types, defaults, primary keys, etc....
**Describe the bug** KeyError 'columns' generated instead of DDLParserError **To Reproduce** Steps to reproduce the behavior: 1. Take file https://github.com/penguin9360/School-Projects/blob/3b1d67fae9a95518936e742412d0977f9127dccf/CS%20427%20-%20Software%20Engineering/iTrust/sql/createTables.sql 2. Use code ddl = parse_from_file(filepath) 3. See error KeyError...
I tried latest version simple-ddl-parser==0.26.4 but didn't work. Sample schema. CREATE EXTERNAL TABLE aaa.bbb ( test ARRAY COMMENT 'xxxxxx', ) COMMENT 'xxxxx' PARTITIONED BY (date STRING) STORED AS PARQUET LOCATION...
**Describe the bug** Error DDLParserError: Unknown symbol '@' happens on certain files **To Reproduce** Steps to reproduce the behavior: 1. Take file https://github.com/timduru/platform-external-chromium_org/blob/16a18d799b9def43936f9f1fa2e325bcf616762c/components/test/data/web_database/version_30.sql?raw=True 2. Use code `ddl = parse_from_file(filepath)` 4....
**Describe the bug** AttributeError: 'NoneType' object has no attribute 'update' for certain SQL files **To Reproduce** Steps to reproduce the behavior: 1. Take file https://github.com/svn2github/oa-system/blob/c698a0c09bbd6b902700e9ccab7018470c538e70/tags/1.0.0/doc/dbchange_20081128.sql?raw=True 2. Use code ddl =...
**Describe the bug** TypeError argument of type 'NoneType' is not iterable **To Reproduce** Steps to reproduce the behavior: 1. Take file https://github.com/centreon/centreon-broker/blob/aae49ea83a14c74885935f4e8058eefbadc24abd/test/mysql_v2/timeperiod_exceptions.sql?raw=True 2. Use code ddl = parse_from_file(filepath) 3. See...
**Describe the bug** ValueError 'Found ALTER statement to not existed TABLE COMTCCMMNCODE with SCHEMA None' on certain files **To Reproduce** Steps to reproduce the behavior: 1. Take file https://github.com/LeeBaekHaeng/GodTest2016/blob/a080fc963eaaf372ec5fab132b954849090a3225/god.test20170818/src/script/tibero/ddl/sts.cst_create_tibero.sql?raw=True 2....
**Describe the bug** Right now if you parse files different than the system default encoding, parse_from_file generates UnicodeDecodeError. **To Reproduce** Steps to reproduce the behavior: 1. Try this SQL file...
**Describe the bug** Using 'print' is a bad practice for code debuging. Please remove print from output/common.py and dialects/snowflake.py. Better use logging module. **To Reproduce** Steps to reproduce the behavior:...
**Describe the bug** TypeError 'NoneType' object is not subscriptable generated instead of DDLParserError **To Reproduce** Steps to reproduce the behavior: 1. Take file https://github.com/congnd91/html/blob/dceec6e8f0a494da74a8ce449293bd65ee83dcfe/wp/iwpserver/admin/phpMyAdmin/scripts/upgrade_tables_mysql_4_1_2%2B.sql 2. Use code ddl = parse_from_file(filepath)...
**Describe the bug** Error DDLParserError: Unknown symbol '\\' happens on certain files **To Reproduce** Steps to reproduce the behavior: 1. Take file https://github.com/UGTU\UGTUKadrProject\blob\14ba90064feaf83b00a66b38500458d50d4337c8\Kadr\HRDatabase\dbo\Tables\OK_DopInf.sql 2. Use code `ddl = parse_from_file(filepath)` 4....