hpqtypes-extras

Build Status Hackage

The following extras for hpqtypes library:

  • DSL for easy, modular construction of SQL queries.

  • System for automatic validation and migration of a database schema.

Changes

hpqtypes-extras-1.16.4.4 (2023-08-23)

  • Switch from cryptonite to crypton.
  • Make sqlWhereEqualsAny, sqlWhereIn and sqlWhereNotIn prepared-query friendly.

hpqtypes-extras-1.16.4.3 (2023-06-12)

  • Synchronize timezone of a session with timezone of a database after changing the latter.

hpqtypes-extras-1.16.4.2 (2023-05-23)

  • Make order of tables during schema creation irrelevant.

hpqtypes-extras-1.16.4.1 (2023-05-15)

  • Relax checks around indexes related to the REINDEX operation.

hpqtypes-extras-1.16.4.0 (2023-04-20)

  • Add support for the UNION ALL clause via sqlUnionAll.

hpqtypes-extras-1.16.3.1 (2023-04-13)

  • Add support for GHC 9.6.
  • Fix checkAndRememberMaterializationSupport’s query.

hpqtypes-extras-1.16.3.0 (2023-01-25)

  • Add support for WITH MATERIALIZED with backward compatibility.
  • Add sqlWhereEqualsAny.

hpqtypes-extras-1.16.2.0 (2022-10-27)

  • Add support for setting collation method for columns.

hpqtypes-extras-1.16.1.0 (2022-08-02)

  • Add support for sqlResult in sqlDelete.
  • Add a migration type for modifying columns.

hpqtypes-extras-1.16.0.0 (2022-05-20)

  • Trigger functions are now part of triggers and have their names generated.

hpqtypes-extras-1.15.0.0 (2022-05-11)

  • Add support for GHC 9.2.
  • Drop support for GHC < 8.8.
  • Add support for triggers and trigger functions.
  • Allow to specify the operator class of an index column.

hpqtypes-extras-1.14.1.0 (2022-01-11)

  • Support unmanaged local indexes whose names start with “local_”.

hpqtypes-extras-1.14.0.0 (2021-12-13)

  • Add support for ON CONFLICT to sqlInsertSelect.
  • Remove upper bounds from library dependencies.
  • Remove kRun* and kWhyNot functions.

hpqtypes-extras-1.13.1.0 (2021-11-26)

  • Add support for including columns in indexes.

hpqtypes-extras-1.13.0.0 (2021-11-08)

  • Add support for handling lock_timeout during migrations.
  • Improvements for making no downtime migrations easier to write.
  • Commiting after each migration was made non-optional.

hpqtypes-extras-1.12.0.1 (2021-10-11)

  • Add support for log-base-0.11.0.0

hpqtypes-extras-1.12.0.0 (2021-09-29)

  • Use plain exceptions instead of DBExtraException

hpqtypes-extras-1.11.0.0 (2021-03-29)

  • Support running with higher table versions in the database than in the code

hpqtypes-extras-1.10.4.0 (2021-02-04)

  • Generate valid INSERT SELECT query with data modifying WITH clauses
  • Add DerivingVia helpers for enums

hpqtypes-extras-1.10.3.0 (2020-11-16)

  • Include LIMIT clause in UNION subqueries of the select

hpqtypes-extras-1.10.2.1 (2020-05-05)

  • Add support for GHC 8.10

hpqtypes-extras-1.10.2.0 (2020-01-20)

  • Add support for UNION clause
  • Add support for GHC 8.8

hpqtypes-extras-1.10.1.0 (2020-01-09)

  • Add support for ON CONFLICT clause

hpqtypes-extras-1.10.0.0 (2019-11-05)

  • Implement UuidT Column Type (#28).
  • Fix sqlValidateCheck and sqlValidateFK

hpqtypes-extras-1.9.0.1 (2019-06-04)

  • Create composite types automatically only if database is empty (#24).

hpqtypes-extras-1.9.0.0 (2019-05-22)

  • Extend checkDatabaseAllowUnknownTables to allow unknown composite types and rename it to checkDatabaseAllowUnknownObjects (#22).
  • Remove the Default instance for ExtrasOptions; use defaultExtrasOptions instead (#23).

hpqtypes-extras-1.8.0.0 (2019-04-30)

  • Make composite types subject to migration process (#21).
  • Add a migration type for concurrent creation of an index (#21).

hpqtypes-extras-1.7.1.0 (2019-02-04)

  • Fix an issue where unnecessary migrations were run sometimes (#18).

hpqtypes-extras-1.7.0.0 (2019-01-08)

  • Added support for no-downtime migrations (#17):
    • sqlCreateIndex is deprecated. Use either sqlCreateIndexSequentially or sqlCreateIndexConcurrently (no-downtime migration variant) instead.
    • sqlAddFK is deprecated. Use either sqlAddValidFK or sqlAddNotValidFK (no-downtime migration variant) instead.
    • API addition: sqlValidateFK, for validating a foreign key previously added with sqlAddNotValidFK.
    • sqlAddCheck is deprecated. Use either sqlAddValidCheck or sqlAddNotValidCheck (no-downtime migration variant) instead.
    • API addition: sqlValidateCheck, for validating a check previously added with sqlAddNotValidCheck.
    • API addition: sqlAddPKUsing, converts a unique index to a primary key.
    • New Table field: tblAcceptedDbVersions.
  • ValidationResult is now an abstract type.
  • ValidationResult now supports info-level messages in addition to errors.

hpqtypes-extras-1.6.4.0 (2019-02-04)

  • Fix an issue where unnecessary migrations were run sometimes (#19).

hpqtypes-extras-1.6.3.0 (2018-11-19)

  • API addition: sqlWhereAnyE (#16).

hpqtypes-extras-1.6.2.0 (2018-07-11)

  • Support hpqtypes-1.6.0.0.
  • Drop support for GHC < 8.

hpqtypes-extras-1.6.1.0 (2018-03-18)

  • Add support for GHC 8.4.
  • Drop support for GHC 7.8.

hpqtypes-extras-1.6.0.0 (2018-01-25)

  • Introduce checkPKPresence to enforce primary keys on all tables supplied to checkDatabase
  • Introduce an options data type, ExtrasOptions

hpqtypes-extras-1.5.0.1 (2018-01-09)

  • Changed getDBTableNames to only schemas explicitly in search path, rather than an exclusion list. Affects table version and unknown tables checks.

hpqtypes-extras-1.5.0.0 (2017-12-08)

  • Changed internal representation of PrimaryKey to NubList (#11) This will break existing PKs set on multiple columns unless they are alphabetically sorted in the defining list.

hpqtypes-extras-1.4.0.0 (2017-11-24)

  • Introduced tsvector postgres type and indexing methods GIN and BTree

hpqtypes-extras-1.3.1.1 (2017-07-21)

  • Now depends on ‘log-base’ instead of ‘log’.

hpqtypes-extras-1.3.1.0 (2017-07-20)

  • Improved migration order sanity checking (#7).

hpqtypes-extras-1.3.0.0 (2017-05-17)

  • Add drop table migrations.
  • Add a test suite.
  • Improve documentation.
  • Add option to force commit after every migration.

hpqtypes-extras-1.2.4 (2016-07-28)

  • Initial release.