The code from simple_ddl_parser import ddl_parser sql = "CREATE TABLE public.test (date_updated timestamp with time zone);" result = ddl_parser.DDLParser(sql).run() print(result) results in [] This type is used by Directus CMS, so I can'...
description = "Simple DDL Parser to parse SQL & dialects like HQL, TSQL (MSSQL), Oracle, AWS Redshift, Snowflake, MySQL, PostgreSQL, etc ddl files to json/python dict with full information about columns: types, defaults, primary keys, etc.; sequences, alters, custom types & other entiti...
I think both parsing should be able to parse the field information. Additional context python==3.11 simple-ddl-parser==0.31.0
1. Python 3.6 is deprecated in tests and by default, try to move to Python3.7, but better to 3.8, because 3.7 will be deprecated in 2023. 1. Fix for https://github.com/xnuinside/simple-ddl-parser/issues/177 1. Added support for Oracle 2 component size for types, like '30 CHAR'. ...
1. Fix for https://github.com/xnuinside/simple-ddl-parser/issues/177 ### Imporvements ### Improvements 1. Added support for Oracle 2 component size for types, like '30 CHAR'. From https://github.com/xnuinside/simple-ddl-parser/issues/176 @@ -52,8 +54,8 @@ It shows in column ...
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. & table properties, types, domains, etc. - Compare ·
from simple_ddl_parser.exception import SimpleDDLParserException as DDLParserError from simple_ddl_parser.parser import Parser class DDLParserError(Exception): pass class Dialects( SparkSQL, Snowflake, 9 changes: 9 additions & 0 deletions 9 simple_ddl_parser/exception.py Original file line numberDif...
It will be released in version 0.31.1 together with your PR. xnuinside closed this as completed Nov 5, 2023 Owner xnuinside commented Nov 5, 2023 @PBalsdon 0.31.1 was released https://pypi.org/project/simple-ddl-parser/Sign up for free to join this conversation on GitHub. Already ...
fromsimple_ddl_generatorimportDDLGeneratorfromsimple_ddl_parserimportDDLParser# take initial DDLddl="""CREATE EXTERNAL TABLE IF NOT EXISTS database.table_name(day_long_nm string,calendar_dt date,source_batch_id string,field_qty decimal(10, 0),field_bool boolean,field_float float,create_tmst tim...
Hello create table event_types ( id number constraint event_types_id_pk primary key ) ; and create table event_types ( id number generated by default on null as identity ) ; unfortunately return empty array those could also be written li...