Tags: xnuinside/simple-ddl-parser
Tags
**v1.6.0** In this versions there is some output changes & fixes that can break your code. 1. Now all arguments inside brackets are parsed as separate strings in the list. For example: `file_format = (TYPE=JSON NULL_IF=('field')` this was parsed like 'NULL_IF': "('field')", now it will be: 'NULL_IF': ["'field'"], 2. Added separate tokens for EQ `=` and IN (previously they was parsed as IDs also - for internal info, for contributors. 3. Some check statements in columns now parsed validly, also IN statements parsed as normal lists. So this statement include_exclude_ind CHAR(1) NOT NULL CONSTRAINT chk_metalistcombo_logicalopr CHECK (include_exclude_ind IN ('I', 'E')), will produce this output: {'check': {'constraint_name': 'chk_metalistcombo_logicalopr', 'statement': {'in_statement': {'in': ["'I'", "'E'"], 'name': 'include_exclude_ind'}}}, 1. DEFAULT word now is not arriving in key 'default' (it was before in some cases) 1. Added Athena output mode and initial support - datacontract/datacontract-cli#332
**v1.3.0** PostgreSQL: 1. Timezone was moved out from type definition to keyword 'with_time_zone' it can be True (if with time zone) or False (if without) BigQuery: 1. Previously Range in RANGE_BUCKETS was parsed as a columns, now this behaviour is changed and range placed in own keyword - 'range' (can be array or str). Also for all ``*_TRUNC PARTITIONS` like DATETIME_TRUNC, TIMESTAMP_TRUNC, etc, second argument moved to arg 'trunc_by' PostgreSQL: 1. Added support for PostgreSQL with / without time zone - #250 BigQuery: 1. Added support for GENERATE_ARRAY in RANGE_BUCKETS #183
**v1.2.1** MySQL: 1. Fixed issue relative to auto_increment that caused empty output if auto_increment defined in table properties - #206 MySQL: 1. auto_increment added as property to mysql output Oracle: 1. Added support for constraint name in column definition - #203 2. Added support for GENERATED (ALWAYS | (BY DEFAULT [ON NULL])) AS IDENTITY in column definition PostgreSQL: 1. Added support for CAST statement in column GENERATE ALWAYS expression - #198
**v1.0.3** 1. Fixed bug with `CREATE OR REPLACE SCHEMA`. 2. Added support of create empty tables without columns CREATE TABLE tablename (); (valid syntax in SQL) 1. Fixed bug with snowflake `stage_` fileformat option value equal a single string as `FIELD_OPTIONALLY_ENCLOSED_BY = '\"'`, `FIELD_DELIMITER = '|'` 2. improve snowflake fileformat key equals value into dict. type.
**v1.0.2** 1. Fixed bug with places first table property value in 'authorization' key. Now it is used real property name. 2. Fixed typo on Databricks dialect 3. improved equals symbols support within COMMENT statement. 4. turn regexp into functions 1. UNSIGNED property after int parsed validly now 1. Snowflake TAG now available on SCHEMA definitions.
PreviousNext