All notable changes to this project will be documented in this file. See standard-version for commit guidelines.
5.7.1 (2018-12-12)
- use cached promise implementation to cover transaction resolve/reject edge cases (d319ca4)
5.7.0 (2018-12-05)
- package: update pg-promise to version 8.5.3 (2b938f9)
5.6.0 (2018-11-27)
5.5.3 (2018-11-10)
- pass undefined args to query() for scripts without parameters (fixes #649) (1a1c0a6)
- package: update pg-promise to version 8.5.2 (cc7afc3)
5.5.2 (2018-11-10)
5.5.1 (2018-10-17)
- package: update commander to version 2.19.0 (68d72e3)
- correct param defaults for Database.query (49e6af3)
- package: update pg-promise and pg-query-stream to the latest version 🚀 (#641) (8de72f8)
5.5.0 (2018-09-30)
- introspect and load enums as static db.enums (095266f)
5.4.0 (2018-09-16)
- package: update commander to version 2.18.0 (c2209ee)
- package: update lodash to version 4.17.11 (8863a10)
- correct where generation logic from bad merge (5891b00)
- load non-pk sequences and get current value (a2912b2)
- reset and increment sequences (3796b27)
- restrict returned fields from persistence queries (8a10110)
5.3.0 (2018-09-07)
- specify null sorting in order by (149b7b9)
5.2.1 (2018-09-05)
- package: update glob to version 7.1.3 (f8ec670)
- package: update pg-promise to version 8.4.6 (8a885f1)
5.2.0 (2018-08-12)
- package: update commander to version 2.17.0 (74a784f)
- package: update commander to version 2.17.1 (3b60ea9)
- keyset pagination on sorted queries (1ce70c7)
5.1.3 (2018-07-17)
- clean unused params from updates (352969f)
5.1.2 (2018-07-17)
- filter out nonexistent columns from update generation (e913088)
5.1.1 (2018-07-12)
5.1.0 (2018-07-06)
5.0.0 (2018-06-03)
- apply allowedSchemas to function loader (8bcccc3)
- better error messaging around writing to foreign tables (73cef19)
- correct behavior for save with tables lacking pks (d87e340)
- process document search vectors from text for backwards-compatibility (dacb3ec)
- reject if select options.fields is explicitly empty (fixes #583) (18e05ce)
- updateDoc takes query options (95760cb)
- change modify to updateDoc for table/document api consistency (373088a)
- remove deprecated '*' criteria (80fb89d)
- remove deprecated columns select option (64c294d)
- remove deprecated db.run (705bd83)
- remove unary update in favor of save (d2b8d56)
- add withConnection for tasks (2d13133)
- allow primary key in update() (c606a8d)
- brute force copy api for transactions (ceeb202)
- disable deep insert by default (ed7a655)
- full document search with stored vector (b8f84f7)
- introduce order exprs (f42a187)
- load tables even if they don't have primary keys (0457cc1)
- metadata in documents (25212d9)
- support updatable views (fixes #528) (9aac96a)
- empty options.fields is now recognized as an error instead of falling back to '*'
- db.run is gone; please use db.query instead
- 'created_at' and 'updated_at' are now reserved keys in documents
- db.doctable.modify is now db.doctable.updateDoc
- update() now requires separate criteria and changes objects, use save() to update self-contained record objects
- field for updateDoc() against non-standard json column name should now be specified with options.body
- deepInsert option must be truthy to enable this behavior
- unsafe literal {order: 'string asc'} syntax has been removed
- find, countDoc, etc no longer accept '*' in place of an empty criteria object
- using 'columns' option in find etc has been removed; use 'fields' for columns themselves and 'exprs' for potentially unsafe operations
- functions in disallowed schemas will no longer be loaded
5.0.0-rc.2 (2018-05-28)
- apply allowedSchemas to function loader (51d5839)
- better error messaging around writing to foreign tables (9f087a1)
- correct behavior for save with tables lacking pks (ff235fe)
- process document search vectors from text for backwards-compatibility (e6e1c50)
- reject if select options.fields is explicitly empty (fixes #583) (7a5463c)
- updateDoc takes query options (6523402)
- change modify to updateDoc for table/document api consistency (1744f8a)
- remove deprecated '*' criteria (d3c63d2)
- remove deprecated columns select option (63eda28)
- remove deprecated db.run (0df49df)
- remove unary update in favor of save (c570f13)
- add withConnection for tasks (0510766)
- allow primary key in update() (a2cb9ae)
- brute force copy api for transactions (5b7e7f7)
- disable deep insert by default (7ad25e1)
- full document search with stored vector (8564da3)
- introduce order exprs (d4b76fc)
- load tables even if they don't have primary keys (8f58ecb)
- metadata in documents (c782ce1)
- support updatable views (fixes #528) (8000888)
- empty options.fields is now recognized as an error instead of falling back to '*'
- db.run is gone; please use db.query instead
- 'created_at' and 'updated_at' are now reserved keys in documents
- db.doctable.modify is now db.doctable.updateDoc
- update() now requires separate criteria and changes, use save() to update record objects
- field should now be specified with options.body
- deepInsert option must be truthy to enable this behavior
- unsafe literal {order: 'string asc'} syntax has been removed
- find, countDoc, etc no longer accept '*' in place of an empty criteria object
- using 'columns' option in find etc has been removed; use 'fields' for columns themselves and 'exprs' for potentially unsafe operations
- functions in disallowed schemas will no longer be loaded
4.8.3 (2018-05-22)
- delimit junction table names in deep inserts (bbd784d)
4.8.2 (2018-05-12)
- fields can be restricted in document searches (fixes #595) (162b3d9)
- support traversal properly inside documents (fixes #594) (8b49661)
4.8.0 (2018-05-06)
- package: update pg-promise to version 8.3.0 (#587) (8111477)
- package: update pg-promise to version 8.4.0 (#588) (8c8dfac)
- refresh materialized views (ac278af)
4.7.2 (2018-04-17)
- better messaging for deep insert errors (closes #556) (#571) (8ff4045)
- throw an appropriate error if decompose encounters a null root pk (closes #568) (#570) (5569060)
- use Object.hasOwnProperty (fixes #579) (d0c4bec)
4.7.1 (2018-03-10)
- date casting in documents should use timestamptz (fixes #563) (a8c603f)
- package: update commander to version 2.15.0 (#562) (d5434f9)
- package: update pg-promise to version 8.1.1 (#560) (4265e21), closes #554
- package: update pg-promise to version 8.2.0 (#566) (9cd4e65)
4.7.0 (2018-02-22)
4.6.6 (2018-02-20)
4.6.5 (2018-02-14)
- package: update commander to version 2.14.0 (#532) (157a17c)
- package: update pg-promise to version 7.5.2 (#538) (b4cec78), closes #537
- rework table load for inheritance with proper pk tracking (fixes #539) (#540) (4d35bc8)
4.6.4 (2018-02-03)
4.6.3 (2018-01-12)
- package: update commander to version 2.13.0 (#523) (c173bb8)
- pass decompose option from non-select statements (fixes #522) (#524) (19c668b)
4.6.2 (2018-01-08)
- prevent double-counting foreign tables which inherit from other tables (90ec61e)
4.6.1 (2018-01-05)
4.6.0 (2018-01-01)
4.5.0 (2017-11-12)
- improve connect/reload handling in tests (6f47708)
- deep insert into related tables (6bb4c6b)
- deprecate columns for split fields+exprs with idiomatic json traversal (1deba7f)
- variadic function support (closes #431) (ae00a50)