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
PreviousNext