Changelog sql-expanders

Filter x

2.1.0 (2021-06-11)

Added

  • (SQL-16) DataInstanceXmlWriter class to for external use.
  • (SQL-16) Moved pojos and XML IO classes for init data to new sql-expanders-dataxml module.

2.0.7 (2021-06-10)

Fixed

  • Both Hibernate and OpenJPA default to identity columns for HSQLDB.

2.0.6 (2021-06-08)

Fixed

  • SQL Server CREATE SEQUENCE statements cannot contain IF EXISTS.

2.0.5 (2021-06-08)

Fixed

  • SQL Server sequences section was missing.

2.0.4 (2021-06-07)

Fixed

  • Changed syntax of id sequence table update statements to a more widely supported format. HSQLDB did not accept the previous syntax.

2.0.3 (2021-05-28)

Fixed

  • (SQL-13) Timestamp value fields in initial data were not put in quotes.
  • (SQL-12) String value fields in initial data were not escaped.

2.0.2 (2021-05-27)

Fixed

  • Added COMMIT statements to Oracle initial data script.

2.0.1 (2021-05-07)

Fixed

  • Initial data scripts for MariaDB and Mysql didn’t update the correct sequence table when experimental.persistence.defaultIdentifier was set to sequence.

2.0.0 (2021-05-06)

This version contains some breaking changes. Please refer to the update guide in the documentation for more information about this change and what code is affected.

Added

  • (SQL-3) Generate initial data script from a common XML data format.
  • (SQL-4) Support for Oracle databases.

1.5.0 (2021-04-23)

Fixed

  • SQL Server:
    • DROP statements included CASCADE, which is not part of the SQL Server syntax.
    • Schema names were not escaped for sequences.

Added

  • Added support for HyperSQL (SQL scripts, not database script files).
  • (SQL-1) Added support for identity columns and sequences with the options experimental.persistence.defaultIdentifier, experimental.persistence.sequence.defaultSchema and experimental.persistence.sequence.defaultName introduced in Expanders 4.15.0.
  • Support for foreign key constraint names generated by Hibernate 4 and Hibernate 5 in HyperSQL where it is strongly enforced by the frameworks.
  • Added support for options experimental.valueFieldType.storageType and experimental.openjpa.CharacterColumnSize in Expanders 4.14.0.
  • (SQL-2) Added support for isDetails option.

Changed

  • Updated expander dependency:
    • net.democritus:Expanders: 4.4.12 > 4.13.5

1.4.0 (2020-12-04)

Added

  • Added anchors to all relevant script expanders:
    • custom-before-cleanup
    • custom-cleanup
  • Added feature anchors expanders:
    • before-cleanup
    • cleanup
    • databases
    • foreign-keys
    • join-tables
    • schemas
    • sequences
    • tables
  • Generate OpenJPA sequence tables when native sequences are not enabled.

Changed

  • Updated expander dependency:
    • net.democritus:Expanders: 4.1.1 > 4.4.12
  • Moved sequence generation statements to individual feature expanders for each persistence provider.

1.3.1 (2020-05-07)

Fixed

  • Schema names were escaped incorrectly for Postgres.

1.3.0 (2020-05-07)

Added

  • Statements to remove all schemas and sequence generated by the script to empty the database before provisioning.
  • ApplicationInstance option sql.cleanup.disabled to disable the DROP statements.

Changed

  • Scripts for MySQL and MariaDB now use the DATABASE keyword instead of SCHEMA.

1.2.1 (2020-05-04)

Added

  • Fields with value types other than basic string types which were stored as strings now map correctly.

1.2.0 (2020-04-08)

Added

  • Support for noDataLayer option on Component and DataElement level.
  • Support for native sequence with Hibernate.

1.1.1 (2020-01-28)

Changed

  • PRIMARY KEY is now listed as a table constraint instead of column constraint.

Fixed

  • Columns now sorted alphabetically to avoid issues with OpenJPA.

1.1.0 (2020-01-23)

Added

  • Support for Microsoft SQL Server (Transact-SQL)
  • Support for MySQL
  • Support for MariaDB

Fixed

  • DataElements with no fields now generate correct SQL.
  • Implicit name fields are now also added, with support for nameNotWanted option.
  • Foreign key constraint names removed, will be generated by database.
  • Primary keys were missing NOT NULL constraint.
  • Fixed anchors for join tables.