ddlparse

Added

• Added supports for Python 3.9

Fixed

• Fixed parsing of columns with NULL/NOT NULL constraint.

Added

• Add supports Cloud Spanner data-type.
  • STRING
  • BYTES
• Add supports MySQL data-type.
  • BINARY
  • VARBINARY
• Add supports PostgreSQL data-type.
  • BYTEA

Added

• Add DdlParseColumn.character_set property.
• Add supports for parsing MySQL FOREIGN KEY options MATCH, ON DELETE and ON UPDATE

Added

• Add DdlParseColumn.default property.
• Add DdlParseColumn.auto_increment property.
• Add DdlParseColumn.encode property.
• Add DdlParseColumn.distkey property.
• Add DdlParseColumn.sortkey property.

Changed

• Enhancement parse of Redshift DDL.

Fixed

• Fix parse of column name with space character.
• Change Email Address.

Fixed

• Fix parse Redshift ENCODE attribute.

Added

• Add property.
  • DdlParseColumn.is_unsigned
  • DdlParseColumn.is_zerofill
• Add supports for numeric type attributes of MySQL.
  • UNSIGNED
  • ZEROFILL
• Add supports MySQL data-type.
  • TINYINT
  • SMALLINT
  • MEDIUMINT
  • DEC
  • FIXED

Fixed

• Miner fix.

Added

• Add supports for Python 3.8

Removed

• End of support for Python 3.4

Fixed

• Fix parse for column-constraint.
• Miner fix.

Added

• Add supports to BigQuery NUMERIC data type.

Data-type Conditions

Fixed

• Fix parsing failure for include (*) format of Oracle NUMBER data type.

Fixed

• Fixed parsing failure for columns include dot at default values.

Added

• Add supports the parse of COMMENT statements.
• Add DdlParseColumn.comment property.
• Add DdlParseColumn.description property for the DdlParseColumn.comment property alias.
• Add supports column comments in BigQuery DDL.

Changes

• Fix parse error for MySQL DDL with FOREIGN KEY.
• Fix not completely parsed with block comments.

Changes

• Fix FutureWarning of Python 3.7.
• Add supports PostgreSQL data type.
  • UUID
• Fix parse DEFAULT value.
  • Add parse regex of DEFAULT value.

Changes

• Add supports for Python 3.7.
  • Pass Python 3.7 test.
• Add supports PostgreSQL data type.
  • CHARACTER VARYING
  • JSON
  • Array type
• Fix parse DEFAULT value.
  • Add decimal point to DEFAULT parse character.

Changes

• Add DdlParseTable.to_bigquery_ddl function. (#20)
  • BigQuery DDL (CREATE TABLE) statement generate function.
• Add DdlParseColumn.bigquery_legacy_data_type property. (#21)
  • Get BigQuery Legacy SQL data property.
  • Alias of DdlParseColumn.bigquery_data_type property.
• Add DdlParseColumn.bigquery_standard_data_type property. (#22)
  • Get BigQuery Standard SQL data property.

Changes

• Added support inline comment (#17)
• Added support constraint name with quotes (#15)
• Added support Oracle Length Semantics for Character Datatypes (#16)

Changes

• Add support Oracle data type.
  • CLOB, NCLOB (#9)
  • NUMBER with no length & scale specification (#10)
• Miner fix. (#13)

Changes

• Fix Postgres/Redshift parse of "::" syntax in field attribute. (#11)

Changes

• Add source_database option. (#7)
• Add to_bigquery_fields method to Columns dicttionary(DdlParseColumnDict class). (#5)
• Fix BigQuery convert of Oracle data type.
  • Oracle 'DATE' -> BigQuery 'DATETIME' (#7)
  • Oracle 'NUMBER' -> BigQuery 'INTEGER' or 'FLOAT' (#4)

Initial release

Changes

• enhancement
  • ddlparse.py : Exclude unused module.
  • example.py : Modified comment.
  • README.md : Miner fix.