# Change Log All notable changes to this project will be documented in this file automatically by Versionist. DO NOT EDIT THIS FILE MANUALLY! This project adheres to [Semantic Versioning](http://semver.org/). ## 12.4.1 - 2020-06-18 * Update dependencies [Pagan Gazzard] ## 12.4.0 - 2020-06-17 * Export migrator types [Pagan Gazzard] * Export common-types types [Pagan Gazzard] * Export config-loader types [Pagan Gazzard] * Export env as a standalone [Pagan Gazzard] * Export errors as a standalone [Pagan Gazzard] * Export permissions as a standalone [Pagan Gazzard] * Move `AnyObject` type to common-types [Pagan Gazzard] ## 12.3.14 - 2020-06-11 * Add missing and remove unused dependencies [Pagan Gazzard] ## 12.3.13 - 2020-06-04 * More async/await conversion [Pagan Gazzard] ## 12.3.12 - 2020-05-23 * Convert javascript files to async/await [Pagan Gazzard] ## 12.3.11 - 2020-05-22

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.13.6 - 2020-05-19 > >

Update dependencies [Pagan Gazzard]

>> #### sbvr-parser-1.0.1 - 2020-05-11 >> >> * Update to mocha 7.x [Pagan Gazzard] >> #### sbvr-parser-1.0.0 - 2020-05-08 >> >> * Convert coffeescript tests to javascript [Pagan Gazzard] >> * Drop support for node 6/8 [Pagan Gazzard] >> * Rename to @balena/sbvr-parser [Pagan Gazzard] >> #### sbvr-parser-0.2.11 - 2020-05-08 >> >> * CI: Add nodejs 14 to the test matrix [Pagan Gazzard] >> * CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard] >> #### sbvr-parser-0.2.10 - 2020-05-08 >> >> * Update to to @balena/sbvr-types [Pagan Gazzard] >> #### sbvr-parser-0.2.9 - 2020-05-08 >> >> * Update to @balena/lint 5.x [Pagan Gazzard] >> #### sbvr-parser-0.2.8 - 2020-04-27 >> >> * Reduce lodash usage [Pagan Gazzard] >> #### lf-to-abstract-sql-4.0.0 - 2020-05-11 >> >> * Include linting as part of the tests [Pagan Gazzard] >> * Convert from UMD module to commonjs module [Pagan Gazzard] >> * Rename to @balena/lf-to-abstract-sql [Pagan Gazzard] >> * Drop support for node 8 [Pagan Gazzard] >> * Move @balena/sbvr-parser to production dependencies [Pagan Gazzard] >> #### lf-to-abstract-sql-3.2.6 - 2020-05-11 >> >>

Update to @balena/sbvr-parser [Pagan Gazzard]

>>> ##### sbvr-parser-1.0.1 - 2020-05-11 >>> >>> * Update to mocha 7.x [Pagan Gazzard] >>> ##### sbvr-parser-1.0.0 - 2020-05-08 >>> >>> * Convert coffeescript tests to javascript [Pagan Gazzard] >>> * Drop support for node 6/8 [Pagan Gazzard] >>> * Rename to @balena/sbvr-parser [Pagan Gazzard] >>> ##### sbvr-parser-0.2.11 - 2020-05-08 >>> >>> * CI: Add nodejs 14 to the test matrix [Pagan Gazzard] >>> * CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard] >>> ##### sbvr-parser-0.2.10 - 2020-05-08 >>> >>> * Update to to @balena/sbvr-types [Pagan Gazzard] >>> ##### sbvr-parser-0.2.9 - 2020-05-08 >>> >>> * Update to @balena/lint 5.x [Pagan Gazzard] >>> ##### sbvr-parser-0.2.8 - 2020-04-27 >>> >>> * Reduce lodash usage [Pagan Gazzard]

>> >> #### lf-to-abstract-sql-3.2.5 - 2020-05-08 >> >> * CI: Add nodejs 14 to the test matrix [Pagan Gazzard] >> #### lf-to-abstract-sql-3.2.4 - 2020-05-08 >> >>

Update to @balena/sbvr-types 3.0.0 [Pagan Gazzard]

>>> ##### sbvr-types-3.0.0 - 2020-05-08 >>> >>> * Convert `fetchProcessing` to synchronous functions [Pagan Gazzard] >>> * Update to bcrypt 4.x [Pagan Gazzard] >>> * Enable strict tsconfig [Pagan Gazzard] >>> * Make use of `import type` where relevant [Pagan Gazzard] >>> * Update to balena-lint 5.x [Pagan Gazzard] >>> * Rename to @balena/sbvr-types [Pagan Gazzard] >>> * Drop node 8 support [Pagan Gazzard] >>> * Update tsconfig target to es2018 [Pagan Gazzard] >>> * Convert all returned promises to native promises instead of bluebird [Pagan Gazzard] >>> ##### sbvr-types-2.0.9 - 2020-05-07 >>> >>> * Switch to balena-lint [Pagan Gazzard] >>> ##### sbvr-types-2.0.8 - 2020-05-05 >>> >>> * Improve typings [Pagan Gazzard] >>> ##### sbvr-types-2.0.7 - 2020-04-30 >>> >>> * Remove unused imports [Pagan Gazzard] >>> ##### sbvr-types-2.0.6 - 2020-04-27 >>> >>> * Remove production lodash dependency [Pagan Gazzard]

>> >> #### lf-to-abstract-sql-3.2.3 - 2020-04-20 >> >> * Switch to native some [Pagan Gazzard] >> * Switch to native findIndex [Pagan Gazzard] >> * Switch to native every [Pagan Gazzard] >> * Switch to native find [Pagan Gazzard] >> * Switch to native forEach where possible [Pagan Gazzard] >> * Switch to native includes [Pagan Gazzard] >> * Switch to native array type checking [Pagan Gazzard] >> * Switch to native string type checking [Pagan Gazzard] >> * Switch to native Object.assign [Pagan Gazzard] >> #### lf-to-abstract-sql-3.2.2 - 2020-04-16 >> >> * Always treat numbered terms as if they're used [Pagan Gazzard] >> #### lf-to-abstract-sql-3.2.1 - 2020-04-14 >> >>

Update dependencies [Pagan Gazzard]

>>> ##### sbvr-types-2.0.5 - 2020-03-17 >>> >>> * CI: Remove circleci deploy in favor of balenaCI [Pagan Gazzard] >>> * CI: Add node 12 to the test matrix [Pagan Gazzard] >>> * CI: Remove node 6 from the test matrix [Pagan Gazzard] >>> * Update dependencies and use resin-lint for automatic lint fixes [Pagan Gazzard] >>> ##### sbvr-types-2.0.4 - 2020-01-22 >>> >>> * Add node 12 to the test matrix [Pagan Gazzard] >>> * Update dependencies [Pagan Gazzard] >>> * Add CODEOWNERS [Pagan Gazzard] >>> ##### sbvr-parser-0.2.7 - 2020-01-22 >>> >>> * Add CODEOWNERS [Pagan Gazzard] >>> ##### sbvr-parser-0.2.6 - 2019-12-30 >>> >>> * Add support for using `of` instead of `that is of` [Pagan Gazzard] >>> ##### sbvr-parser-0.2.5 - 2019-12-30 >>> >>> * Add support for `a given` as a universal quantification [Pagan Gazzard] >>> ##### sbvr-parser-0.2.4 - 2019-12-27 >>> >>> * Allow including terms as part of a verb by using `[]` brackets [Pagan Gazzard]

>> >> #### lf-to-abstract-sql-3.2.0 - 2020-04-13 >> >> * Only add the destination of a link table if it's actually necessary [Pagan Gazzard] >> #### lf-to-abstract-sql-3.1.2 - 2020-02-26 >> >> * CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard] >> #### lf-to-abstract-sql-3.1.1 - 2020-01-22 >> >> * Add CODEOWNERS [Pagan Gazzard] >> #### lf-to-abstract-sql-3.1.0 - 2019-11-01 >> >> * Add support for enum definitions on fact types [Pagan Gazzard] >> #### lf-to-abstract-sql-3.0.2 - 2019-06-14 >> >> * Fix `updateModifiedAt` formatting [Pagan Gazzard] >> #### lf-to-abstract-sql-3.0.1 - 2019-05-08 >> >> * Add node 12 tests [Pagan Gazzard] >> * Add repo.yml for upstream changelogs [Pagan Gazzard] >> * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard] >> #### lf-to-abstract-sql-3.0.0 - 2019-03-08 >> >> * Add automatic modified at fields [Pagan Gazzard] >> #### odata-parser-2.0.0 - 2020-05-11 >> >> * Rename to @balena/odata-parser [Pagan Gazzard] >> * Update to @balena/lint 5.x [Pagan Gazzard] >> * Drop support for nodejs 8 [Pagan Gazzard] >> * CI: Add nodejs 14 to the test matrix [Pagan Gazzard] >> * CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard] >> #### odata-to-abstract-sql-3.3.0 - 2019-06-07 >> >>

Make use of odata-parser types [Pagan Gazzard]

>>> ##### odata-parser-1.1.1 - 2019-06-07 >>> >>> * Improve typings [Pagan Gazzard] >>> ##### odata-parser-1.1.0 - 2019-06-06 >>> >>> * Add typings [Pagan Gazzard] >>> ##### abstract-sql-compiler-6.6.0 - 2019-06-03 >>> >>> * Improve aliased from handling in `getReferencedFields` [Pagan Gazzard] >>> ##### abstract-sql-compiler-6.5.1 - 2019-06-03 >>> >>> * Use an abstract-sql-optimiser prepass to simplify getReferencedFields [Pagan Gazzard] >>> ##### sbvr-parser-0.2.3 - 2019-06-04 >>> >>> * Optimise exactly 0 to not exists [Pagan Gazzard]

>> >> #### odata-to-abstract-sql-3.2.0 - 2019-05-31 >> >> * Add support for computed fields [Pagan Gazzard] >> #### odata-to-abstract-sql-3.1.3 - 2019-05-31 >> >>

Unify the handling of adding fields with or without a $select [Pagan Gazzard]

>>> ##### odata-parser-1.0.4 - 2019-05-27 >>> >>> * Fix adding parameter alias to the options object [Pagan Gazzard] >>> ##### odata-parser-1.0.3 - 2019-05-08 >>> >>> * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard] >>> ##### abstract-sql-compiler-6.5.0 - 2019-05-30 >>> >>> * Add support for computed fields [Pagan Gazzard] >>> ##### abstract-sql-compiler-6.4.3 - 2019-05-30 >>> >>> * Add tests for `getReferencedFields` [Pagan Gazzard] >>> ##### abstract-sql-compiler-6.4.2 - 2019-05-09 >>> >>> * Update and fix lodash typings [Pagan Gazzard] >>> * Update husky/mocha dev dependencies [Pagan Gazzard] >>> ##### abstract-sql-compiler-6.4.1 - 2019-05-08 >>> >>>

Fix typescript compilation [Pagan Gazzard]

>>>> ###### sbvr-parser-0.2.2 - 2019-05-08 >>>> >>>> * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

>>> >>> * Add node 12 tests [Pagan Gazzard] >>> * Add repo.yml for upstream changelogs [Pagan Gazzard] >>> * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

>> >> #### odata-to-abstract-sql-3.1.2 - 2019-05-08 >> >> * Add node 12 tests [Pagan Gazzard] >> * Add repo.yml for upstream changelogs [Pagan Gazzard] >> * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard] >> #### odata-to-abstract-sql-3.1.1 - 2019-04-22 >> >> * Fix off-by-one error when having to resort to a random alias [Pagan Gazzard] >> #### odata-to-abstract-sql-3.1.0 - 2019-03-08 >> >> * Add support for definitions for the target table of insert queries [Pagan Gazzard] >> * Add path key where statements to the select subquery for inserts [Pagan Gazzard] >> * Convert == to === [Pagan Gazzard]

> > ### odata-to-abstract-sql-4.5.3 - 2020-05-19 > > * Enforce strict type checking [Pagan Gazzard] > ### odata-to-abstract-sql-4.5.2 - 2020-05-18 > >

Dev: Update to @balena/sbvr-parser 1.x [Pagan Gazzard]

> > ### odata-to-abstract-sql-4.5.1 - 2020-05-18 > >

Dev: Update to @balena/lf-to-abstract-sql 4.x [Pagan Gazzard]

>> #### lf-to-abstract-sql-4.0.0 - 2020-05-11 >> >> * Include linting as part of the tests [Pagan Gazzard] >> * Convert from UMD module to commonjs module [Pagan Gazzard] >> * Rename to @balena/lf-to-abstract-sql [Pagan Gazzard] >> * Drop support for node 8 [Pagan Gazzard] >> * Move @balena/sbvr-parser to production dependencies [Pagan Gazzard]

> > ### odata-to-abstract-sql-4.5.0 - 2020-05-12 > >

Update to @balena/odata-parser 2.x [Pagan Gazzard]

>> #### odata-parser-2.0.0 - 2020-05-11 >> >> * Rename to @balena/odata-parser [Pagan Gazzard] >> * Update to @balena/lint 5.x [Pagan Gazzard] >> * Drop support for nodejs 8 [Pagan Gazzard] >> * CI: Add nodejs 14 to the test matrix [Pagan Gazzard] >> * CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard]

> > ### odata-to-abstract-sql-4.4.7 - 2020-05-12 > >

Dev: Update lf-to-abstract-sql to 3.x [Pagan Gazzard]

>> #### lf-to-abstract-sql-3.2.6 - 2020-05-11 >> >>

Update to @balena/sbvr-parser [Pagan Gazzard]

>> >> #### lf-to-abstract-sql-3.2.5 - 2020-05-08 >> >> * CI: Add nodejs 14 to the test matrix [Pagan Gazzard] >> #### lf-to-abstract-sql-3.2.4 - 2020-05-08 >> >>

Update to @balena/sbvr-types 3.0.0 [Pagan Gazzard]

Update dependencies [Pagan Gazzard]

Update to @balena/lf-to-abstract-sql 4.x [Pagan Gazzard]

> ### lf-to-abstract-sql-4.0.0 - 2020-05-11 > > * Include linting as part of the tests [Pagan Gazzard] > * Convert from UMD module to commonjs module [Pagan Gazzard] > * Rename to @balena/lf-to-abstract-sql [Pagan Gazzard] > * Drop support for node 8 [Pagan Gazzard] > * Move @balena/sbvr-parser to production dependencies [Pagan Gazzard] > ### lf-to-abstract-sql-3.2.6 - 2020-05-11 > >

Update to @balena/sbvr-parser [Pagan Gazzard]

> > ### lf-to-abstract-sql-3.2.5 - 2020-05-08 > > * CI: Add nodejs 14 to the test matrix [Pagan Gazzard] > ### lf-to-abstract-sql-3.2.4 - 2020-05-08 > >

Update to @balena/sbvr-types 3.0.0 [Pagan Gazzard]

>> #### sbvr-types-3.0.0 - 2020-05-08 >> >> * Convert `fetchProcessing` to synchronous functions [Pagan Gazzard] >> * Update to bcrypt 4.x [Pagan Gazzard] >> * Enable strict tsconfig [Pagan Gazzard] >> * Make use of `import type` where relevant [Pagan Gazzard] >> * Update to balena-lint 5.x [Pagan Gazzard] >> * Rename to @balena/sbvr-types [Pagan Gazzard] >> * Drop node 8 support [Pagan Gazzard] >> * Update tsconfig target to es2018 [Pagan Gazzard] >> * Convert all returned promises to native promises instead of bluebird [Pagan Gazzard] >> #### sbvr-types-2.0.9 - 2020-05-07 >> >> * Switch to balena-lint [Pagan Gazzard] >> #### sbvr-types-2.0.8 - 2020-05-05 >> >> * Improve typings [Pagan Gazzard] >> #### sbvr-types-2.0.7 - 2020-04-30 >> >> * Remove unused imports [Pagan Gazzard] >> #### sbvr-types-2.0.6 - 2020-04-27 >> >> * Remove production lodash dependency [Pagan Gazzard]

## 12.3.10 - 2020-05-14

Update to @balena/odata-parser 2.x [Pagan Gazzard]

> ### odata-parser-2.0.0 - 2020-05-11 > > * Rename to @balena/odata-parser [Pagan Gazzard] > * Update to @balena/lint 5.x [Pagan Gazzard] > * Drop support for nodejs 8 [Pagan Gazzard] > * CI: Add nodejs 14 to the test matrix [Pagan Gazzard] > * CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard]

## 12.3.9 - 2020-05-12 * Make use of `import type` [Pagan Gazzard] ## 12.3.8 - 2020-05-12

Update to @balena/sbvr-parser 1.x [Pagan Gazzard]

> ### lf-to-abstract-sql-3.2.6 - 2020-05-11 > >

Update to @balena/sbvr-parser [Pagan Gazzard]

> > ### lf-to-abstract-sql-3.2.5 - 2020-05-08 > > * CI: Add nodejs 14 to the test matrix [Pagan Gazzard] > ### lf-to-abstract-sql-3.2.4 - 2020-05-08 > >

Update to @balena/sbvr-types 3.0.0 [Pagan Gazzard]

> > ### sbvr-parser-1.0.1 - 2020-05-11 > > * Update to mocha 7.x [Pagan Gazzard] > ### sbvr-parser-1.0.0 - 2020-05-08 > > * Convert coffeescript tests to javascript [Pagan Gazzard] > * Drop support for node 6/8 [Pagan Gazzard] > * Rename to @balena/sbvr-parser [Pagan Gazzard] > ### sbvr-parser-0.2.11 - 2020-05-08 > > * CI: Add nodejs 14 to the test matrix [Pagan Gazzard] > * CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard] > ### sbvr-parser-0.2.10 - 2020-05-08 > > * Update to to @balena/sbvr-types [Pagan Gazzard] > ### sbvr-parser-0.2.9 - 2020-05-08 > > * Update to @balena/lint 5.x [Pagan Gazzard] > ### odata-to-abstract-sql-4.4.6 - 2020-05-08 > >

Update to @balena/sbvr-types 3.0.0 [Pagan Gazzard]

## 12.3.7 - 2020-05-12 * Fix fetching sbvr-types version [Pagan Gazzard] ## 12.3.6 - 2020-05-12 * Make wider use of async/await [Pagan Gazzard] ## 12.3.5 - 2020-05-07

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.13.5 - 2020-05-07 > >

Improve typing of `dataTypeValidate` and sbvr-types [Pagan Gazzard]

>> #### sbvr-types-2.0.9 - 2020-05-07 >> >> * Switch to balena-lint [Pagan Gazzard] >> #### sbvr-types-2.0.8 - 2020-05-05 >> >> * Improve typings [Pagan Gazzard] >> #### sbvr-types-2.0.7 - 2020-04-30 >> >> * Remove unused imports [Pagan Gazzard] >> #### sbvr-types-2.0.6 - 2020-04-27 >> >> * Remove production lodash dependency [Pagan Gazzard]

> > ### sbvr-types-2.0.9 - 2020-05-07 > > * Switch to balena-lint [Pagan Gazzard] > ### sbvr-types-2.0.8 - 2020-05-05 > > * Improve typings [Pagan Gazzard]

## 12.3.4 - 2020-05-05

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.13.4 - 2020-04-30 > > * Reduce lodash usage [Pagan Gazzard] > ### abstract-sql-compiler-6.13.3 - 2020-04-14 > >

Update dependencies [Pagan Gazzard]

> > ### sbvr-parser-0.2.8 - 2020-04-27 > > * Reduce lodash usage [Pagan Gazzard] > ### sbvr-types-2.0.7 - 2020-04-30 > > * Remove unused imports [Pagan Gazzard] > ### sbvr-types-2.0.6 - 2020-04-27 > > * Remove production lodash dependency [Pagan Gazzard] > ### lf-to-abstract-sql-3.2.3 - 2020-04-20 > > * Switch to native some [Pagan Gazzard] > * Switch to native findIndex [Pagan Gazzard] > * Switch to native every [Pagan Gazzard] > * Switch to native find [Pagan Gazzard] > * Switch to native forEach where possible [Pagan Gazzard] > * Switch to native includes [Pagan Gazzard] > * Switch to native array type checking [Pagan Gazzard] > * Switch to native string type checking [Pagan Gazzard] > * Switch to native Object.assign [Pagan Gazzard] > ### odata-to-abstract-sql-4.4.5 - 2020-05-05 > >

Optimize `getRelationships` [Pagan Gazzard]

>> #### abstract-sql-compiler-6.13.4 - 2020-04-30 >> >> * Reduce lodash usage [Pagan Gazzard] >> #### abstract-sql-compiler-6.13.3 - 2020-04-14 >> >>

Update dependencies [Pagan Gazzard]

> > ### odata-to-abstract-sql-4.4.4 - 2020-04-27 > > * Reduce lodash usage [Pagan Gazzard] > ### odata-to-abstract-sql-4.4.3 - 2020-04-20 > > * Switch to native forEach where possible [Pagan Gazzard] > * Switch to native map [Pagan Gazzard] > * Switch to native find [Pagan Gazzard] > * Switch to native some [Pagan Gazzard] > * Switch to native includes [Pagan Gazzard] > * Switch to native string type check [Pagan Gazzard] > * Switch to native number type check [Pagan Gazzard] > * Switch to native array type check [Pagan Gazzard] > ### odata-to-abstract-sql-4.4.2 - 2020-04-14 > > * Fix linting and make use of import type [Pagan Gazzard]

## 12.3.3 - 2020-04-16

Update dependencies [Pagan Gazzard]

> ### lf-to-abstract-sql-3.2.2 - 2020-04-16 > > * Always treat numbered terms as if they're used [Pagan Gazzard] > ### pinejs-client-js-5.7.0 - 2020-04-15 > > * Make transformGetResult a method , to ease overriding the get method [Thodoris Greasidis]

## 12.3.2 - 2020-04-14 * Ensure request.values is an object rather than nullish [Pagan Gazzard] ## 12.3.1 - 2020-04-14

Update dependencies [Pagan Gazzard]

> ### lf-to-abstract-sql-3.2.1 - 2020-04-14 > >

Update dependencies [Pagan Gazzard]

>> #### sbvr-types-2.0.5 - 2020-03-17 >> >> * CI: Remove circleci deploy in favor of balenaCI [Pagan Gazzard] >> * CI: Add node 12 to the test matrix [Pagan Gazzard] >> * CI: Remove node 6 from the test matrix [Pagan Gazzard] >> * Update dependencies and use resin-lint for automatic lint fixes [Pagan Gazzard] >> #### sbvr-types-2.0.4 - 2020-01-22 >> >> * Add node 12 to the test matrix [Pagan Gazzard] >> * Update dependencies [Pagan Gazzard] >> * Add CODEOWNERS [Pagan Gazzard] >> #### sbvr-parser-0.2.7 - 2020-01-22 >> >> * Add CODEOWNERS [Pagan Gazzard] >> #### sbvr-parser-0.2.6 - 2019-12-30 >> >> * Add support for using `of` instead of `that is of` [Pagan Gazzard] >> #### sbvr-parser-0.2.5 - 2019-12-30 >> >> * Add support for `a given` as a universal quantification [Pagan Gazzard] >> #### sbvr-parser-0.2.4 - 2019-12-27 >> >> * Allow including terms as part of a verb by using `[]` brackets [Pagan Gazzard]

> > ### lf-to-abstract-sql-3.2.0 - 2020-04-13 > > * Only add the destination of a link table if it's actually necessary [Pagan Gazzard] > ### odata-parser-1.4.1 - 2020-04-10 > > * Update dependencies [Pagan Gazzard] > ### odata-to-abstract-sql-4.4.1 - 2020-04-14 > >

Update dependencies [Pagan Gazzard]

>> #### sbvr-parser-0.2.7 - 2020-01-22 >> >> * Add CODEOWNERS [Pagan Gazzard] >> #### sbvr-parser-0.2.6 - 2019-12-30 >> >> * Add support for using `of` instead of `that is of` [Pagan Gazzard] >> #### sbvr-parser-0.2.5 - 2019-12-30 >> >> * Add support for `a given` as a universal quantification [Pagan Gazzard] >> #### sbvr-parser-0.2.4 - 2019-12-27 >> >> * Allow including terms as part of a verb by using `[]` brackets [Pagan Gazzard] >> #### odata-parser-1.4.1 - 2020-04-10 >> >> * Update dependencies [Pagan Gazzard] >> #### sbvr-types-2.0.5 - 2020-03-17 >> >> * CI: Remove circleci deploy in favor of balenaCI [Pagan Gazzard] >> * CI: Add node 12 to the test matrix [Pagan Gazzard] >> * CI: Remove node 6 from the test matrix [Pagan Gazzard] >> * Update dependencies and use resin-lint for automatic lint fixes [Pagan Gazzard] >> #### sbvr-types-2.0.4 - 2020-01-22 >> >> * Add node 12 to the test matrix [Pagan Gazzard] >> * Update dependencies [Pagan Gazzard] >> * Add CODEOWNERS [Pagan Gazzard] >> #### abstract-sql-compiler-6.13.2 - 2020-03-25 >> >> * 📝♻️ : Improve RelationshipMapping typing and docs [Andreas Fitzek] >> #### abstract-sql-compiler-6.13.1 - 2020-02-26 >> >> * Only create functions if they don't already exist [Pagan Gazzard] >> #### abstract-sql-compiler-6.13.0 - 2020-02-21 >> >> * Add support for sum [Pagan Gazzard] >> * Add support for average [Pagan Gazzard] >> * Add tests for count [Pagan Gazzard] >> #### abstract-sql-compiler-6.12.0 - 2020-02-21 >> >> * Add support for coalesce [Pagan Gazzard] >> #### abstract-sql-compiler-6.11.6 - 2020-02-21 >> >>

Update dependencies [Pagan Gazzard]

>>> ##### sbvr-types-2.0.4 - 2020-01-22 >>> >>> * Add node 12 to the test matrix [Pagan Gazzard] >>> * Update dependencies [Pagan Gazzard] >>> * Add CODEOWNERS [Pagan Gazzard]

>> >> #### abstract-sql-compiler-6.11.5 - 2020-02-06 >> >> * Update resin-lint to 3.x and use it for auto-linting [Pagan Gazzard] >> #### abstract-sql-compiler-6.11.4 - 2020-02-06 >> >> * Fix query type check [Pagan Gazzard] >> #### abstract-sql-compiler-6.11.3 - 2020-01-22 >> >> * Add CODEOWNERS [Pagan Gazzard] >> #### abstract-sql-compiler-6.11.2 - 2020-01-09 >> >> * Trim trigger names to the max of 63 characters [Pagan Gazzard] >> #### abstract-sql-compiler-6.11.1 - 2019-11-22 >> >> * Update dev dependencies [Pagan Gazzard]

## 12.3.0 - 2020-04-03 * Convert express-emulator/express.coffee to javascript [Pagan Gazzard] * Convert transactions.coffee to javascript [Pagan Gazzard] * Convert SBVRServer.coffee to javascript [Pagan Gazzard] ## 12.2.3 - 2020-04-03 * Switch to using native forEach where possible [Pagan Gazzard] * Switch to using native some [Pagan Gazzard] * Switch to using native map [Pagan Gazzard] * Use nullish coalescing in favor of _.get where sensible [Pagan Gazzard] * Switch to using native findIndex [Pagan Gazzard] * Switch to using native find [Pagan Gazzard] * Switch to using native cloning [Pagan Gazzard] * Switch to using native parseInt [Pagan Gazzard] * Switch to using native filter [Pagan Gazzard] * Switch to using native Object.keys [Pagan Gazzard] * Switch to using native Object.values [Pagan Gazzard] * Switch to using native Object.assign [Pagan Gazzard] * Switch to using native startsWith [Pagan Gazzard] * Switch to using native endsWith [Pagan Gazzard] * Switch to using native includes [Pagan Gazzard] ## 12.2.2 - 2020-04-02 * Use native Number.isNaN type check [Pagan Gazzard] * Use native function type check [Pagan Gazzard] * Use native finite type check [Pagan Gazzard] * Use native integer type check [Pagan Gazzard] * Use native undefined type check [Pagan Gazzard] * Use native array type check [Pagan Gazzard] * Use native boolean type check [Pagan Gazzard] * Use native string type check [Pagan Gazzard] ## 12.2.1 - 2020-03-31

Update dependencies [Pagan Gazzard]

> ### sbvr-types-2.0.5 - 2020-03-17 > > * CI: Remove circleci deploy in favor of balenaCI [Pagan Gazzard] > * CI: Add node 12 to the test matrix [Pagan Gazzard] > * CI: Remove node 6 from the test matrix [Pagan Gazzard] > * Update dependencies and use resin-lint for automatic lint fixes [Pagan Gazzard]

## 12.2.0 - 2020-03-27 * ✨: Optimize database queries for `canAccess()` permissions [Andreas Fitzek] ## 12.1.0 - 2020-03-27 * ♻️ : Dissallow circle permissions with `canAccess()` [Andreas Fitzek] ## 12.0.0 - 2020-03-27 * 🔒: Only allow one credential to provide permissions for the request [Andreas Fitzek] ## 11.3.1 - 2020-03-17

Update dependencies [Pagan Gazzard]

> ### lf-to-abstract-sql-3.1.2 - 2020-02-26 > > * CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard]

## 11.3.0 - 2020-03-13 * CI: Remove circleci publish in favor of balenaCI [Pagan Gazzard]

✨: Add support for `canAccess()` function in permission. [Andreas Fitzek]

> ### odata-parser-1.4.0 - 2020-03-02 > > * ✨: Add support for canAccess method call on resource [Andreas Fitzek] > ### odata-to-abstract-sql-4.4.0 - 2020-03-02 > > * ✨: Add custom resource functions [Andreas Fitzek]

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.13.1 - 2020-02-26 > > * Only create functions if they don't already exist [Pagan Gazzard]

## 11.2.0 - 2020-02-26 * ✨: Add an `POSTRUN-ERROR` handler in resource hooks [Andreas Fitzek] * CI: Remove circleci publish in favor of balenaCI [Pagan Gazzard]

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.13.1 - 2020-02-26 > > * Only create functions if they don't already exist [Pagan Gazzard]

## 11.1.1 - 2020-02-24 * CI: Remove circleci publish in favor of balenaCI [Pagan Gazzard] ## 11.1.0 - 2020-02-24 * Fixes for resin-lint 3.x [Pagan Gazzard]

Update dependencies [Pagan Gazzard]

> ### odata-to-abstract-sql-4.3.0 - 2020-02-11 > > * Remove unsupported node 6 from the test matrix [Pagan Gazzard] > * Add support for computed field when selecting from a resource alias [Pagan Gazzard] > ### pinejs-client-js-5.6.11 - 2020-02-21 > > * 🐛: Fix missing `deprecated.getStringParams` function [Andreas Fitzek] > ### pinejs-client-js-5.6.10 - 2020-02-14 > > * Update to resin-lint 3.x [Pagan Gazzard] > ### pinejs-client-js-5.6.9 - 2020-02-14 > > * CircleCI: Remove deploy job as it's handled by balenaCI [Pagan Gazzard] > ### pinejs-client-js-5.6.8 - 2020-02-14 > > * Add the missing `method` on the post method [Thodoris Greasidis] > ### pinejs-client-js-5.6.7 - 2020-02-14 > > * Deprecate request overrides [Pagan Gazzard] > * Deprecate queries using a string url [Pagan Gazzard] > * Deprecate `query` in favor of `get` [Pagan Gazzard] > ### pinejs-client-js-5.6.6 - 2020-02-14 > > * Allow resource/$count in $filter [Pagan Gazzard] > ### abstract-sql-compiler-6.13.0 - 2020-02-21 > > * Add support for sum [Pagan Gazzard] > * Add support for average [Pagan Gazzard] > * Add tests for count [Pagan Gazzard] > ### abstract-sql-compiler-6.12.0 - 2020-02-21 > > * Add support for coalesce [Pagan Gazzard] > ### abstract-sql-compiler-6.11.6 - 2020-02-21 > >

Update dependencies [Pagan Gazzard]

>> #### sbvr-types-2.0.4 - 2020-01-22 >> >> * Add node 12 to the test matrix [Pagan Gazzard] >> * Update dependencies [Pagan Gazzard] >> * Add CODEOWNERS [Pagan Gazzard]

> > ### abstract-sql-compiler-6.11.5 - 2020-02-06 > > * Update resin-lint to 3.x and use it for auto-linting [Pagan Gazzard]

## 11.0.7 - 2020-02-06

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.11.4 - 2020-02-06 > > * Fix query type check [Pagan Gazzard] > ### abstract-sql-compiler-6.11.3 - 2020-01-22 > > * Add CODEOWNERS [Pagan Gazzard] > ### lf-to-abstract-sql-3.1.1 - 2020-01-22 > > * Add CODEOWNERS [Pagan Gazzard] > ### odata-parser-1.3.1 - 2020-01-22 > > * Add CODEOWNERS [Pagan Gazzard] > ### sbvr-parser-0.2.7 - 2020-01-22 > > * Add CODEOWNERS [Pagan Gazzard] > ### odata-to-abstract-sql-4.2.1 - 2020-01-22 > > * Add CODEOWNERS [Pagan Gazzard] > ### pinejs-client-js-5.6.5 - 2020-01-30 > > * Remove `defaults` helper in favour of `??` [Pagan Gazzard] > ### pinejs-client-js-5.6.4 - 2020-01-30 > > * Avoid allocations when destroying a poll [Pagan Gazzard] > ### pinejs-client-js-5.6.3 - 2020-01-30 > > * Improve `RawFilter` typing [Pagan Gazzard] > ### pinejs-client-js-5.6.2 - 2020-01-29 > > * Update dependencies [Pagan Gazzard] > ### pinejs-client-js-5.6.1 - 2020-01-22 > > * Switch most CODEOWNERS entries to a team [Pagan Gazzard] > ### sbvr-types-2.0.4 - 2020-01-22 > > * Add node 12 to the test matrix [Pagan Gazzard] > * Update dependencies [Pagan Gazzard] > * Add CODEOWNERS [Pagan Gazzard]

## 11.0.6 - 2020-02-03 * Deduplicate get or create functionality in config-loader [Pagan Gazzard] * Convert internal config-loader functions to async/await [Pagan Gazzard] * Convert internal permissions functions to async/await [Pagan Gazzard] ## 11.0.5 - 2020-01-31 * Fix missing `await` [Pagan Gazzard] ## 11.0.4 - 2020-01-24 * Convert internal sbvr-utils functions to async/await [Pagan Gazzard] * Convert internal migrator functions to async/await [Pagan Gazzard] * Convert sbvr-api/hooks to async/await [Pagan Gazzard] * Convert sbvr-api/odata-response to async/await [Pagan Gazzard] * Import bluebird as Bluebird instead of Promise [Pagan Gazzard] ## 11.0.3 - 2020-01-22 * Add CODEOWNERS [Pagan Gazzard] ## 11.0.2 - 2020-01-22 * Avoid allocations when clearing tx listeners [Pagan Gazzard] ## 11.0.1 - 2020-01-20 * Add missing "modified at" migrations [Pagan Gazzard] ## 11.0.0 - 2020-01-20 * Update lint-staged to 10.x [Pagan Gazzard] * Update husky to 4.x [Pagan Gazzard] * Update terser-webpack-plugin to 2.x [Pagan Gazzard] * Remove unnecessary throws now that typescript understands process.exit [Pagan Gazzard] * Make use of the nodejs fs.promises api rather than promisifying [Pagan Gazzard] * Convert extended-sbvr-parser to standard es module exports [Pagan Gazzard] * Convert odata-metadata-generator to standard es module exports [Pagan Gazzard] * Convert pinejs-session-store to standard es module exports [Pagan Gazzard] * Update load-grunt-tasks to 5.x [Pagan Gazzard] * Update raw-loader to 4.x [Pagan Gazzard] * Update ts-loader to 6.x [Pagan Gazzard] * Return the original error object on internal api call failures [Pagan Gazzard] * Remove `UnsupportedMethodError` in favor of `MethodNotAllowedError` [Pagan Gazzard] * Update target to es2018 [Pagan Gazzard] * Stop applying default for `null` in `runURI` and `customAuthorizationMiddleware` [Pagan Gazzard] * Drop dual promise/callback based interfaces in favour of promise based [Pagan Gazzard]

Add an automatic "modified at" field [Pagan Gazzard]

> ### abstract-sql-compiler-6.11.2 - 2020-01-09 > > * Trim trigger names to the max of 63 characters [Pagan Gazzard] > ### lf-to-abstract-sql-3.1.0 - 2019-11-01 > > * Add support for enum definitions on fact types [Pagan Gazzard] > ### lf-to-abstract-sql-3.0.2 - 2019-06-14 > > * Fix `updateModifiedAt` formatting [Pagan Gazzard] > ### lf-to-abstract-sql-3.0.1 - 2019-05-08 > > * Add node 12 tests [Pagan Gazzard] > * Add repo.yml for upstream changelogs [Pagan Gazzard] > * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard] > ### lf-to-abstract-sql-3.0.0 - 2019-03-08 > > * Add automatic modified at fields [Pagan Gazzard]

Update typed-error to 3.2.0 [Pagan Gazzard]

> ### typed-error-3.2.0 - 2019-11-20 > > * update deps and specify minimum engine requirements [Will Boyce] > ### typed-error-3.1.0 - 2019-04-01 > > * dev: Enforce prettier coding standards [Will Boyce] > * npm: Update dependencies and remove `package-lock.json` [Will Boyce] > * codeowners: Add top contributors @wrboyce, @Page-, and @dfunckt [Will Boyce] > * versionbot: Add CHANGELOG.yml (for nested changelogs) [Will Boyce] > ### typed-error-3.0.2 - 2018-11-01 > > * Update README with new import style [CameronDiver] > ### typed-error-3.0.1 - 2018-10-29 > > * Update to typescript 3 [Pagan Gazzard] > * Update dev dependencies [Pagan Gazzard] > * Add node-10 to the circle test suite [Pagan Gazzard] > ### typed-error-3.0.0 - 2018-04-17 > > * Distribute generated typescript declaration [Will Boyce] > * use circle for build/publish and add package-lock [Will Boyce] > * add lint scripts/requirements [Will Boyce] > * Remove `BaseError` class and directly subclass `Error` [Will Boyce] > * Update dependencies, clean up package/tsconfig [Will Boyce]

## 10.25.0 - 2020-01-16 * Switch to SQL migrations to enable migrating internal models [Pagan Gazzard] ## 10.24.0 - 2020-01-14 * Immediately run tx event handlers if the tx event has already triggered [Pagan Gazzard] * Clear queued tx event handlers once they've been scheduled to run [Pagan Gazzard] * Run tx event handlers asynchronously [Pagan Gazzard] ## 10.23.1 - 2020-01-10 * Remove unnecessary Promise.method [Pagan Gazzard] ## 10.23.0 - 2019-12-31

Update dependencies [Pagan Gazzard]

> ### sbvr-parser-0.2.6 - 2019-12-30 > > * Add support for using `of` instead of `that is of` [Pagan Gazzard] > ### sbvr-parser-0.2.5 - 2019-12-30 > > * Add support for `a given` as a universal quantification [Pagan Gazzard] > ### sbvr-parser-0.2.4 - 2019-12-27 > > * Allow including terms as part of a verb by using `[]` brackets [Pagan Gazzard] > ### abstract-sql-compiler-6.11.1 - 2019-11-22 > > * Update dev dependencies [Pagan Gazzard]

## 10.22.3 - 2019-11-22

Update dependencies [Pagan Gazzard]

> ### odata-to-abstract-sql-4.2.0 - 2019-11-22 > > * Add support for `/$count` in filters [Pagan Gazzard] > ### odata-parser-1.3.0 - 2019-11-21 > > * Add support for `/$count` in filters [Pagan Gazzard] > ### abstract-sql-compiler-6.11.0 - 2019-11-19 > > * Add support for `CrossJoin` [Pagan Gazzard] > ### abstract-sql-compiler-6.10.3 - 2019-11-19 > > * Update dependencies [Pagan Gazzard]

## 10.22.2 - 2019-11-15 * Remove duplicated stack trace printing [Pagan Gazzard] ## 10.22.1 - 2019-11-14

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.10.2 - 2019-11-04 > > * Fix CHECK syntax [Pagan Gazzard]

## 10.22.0 - 2019-11-04

Update dependencies to enable enum definitions to check constraint [Pagan Gazzard]

> ### abstract-sql-compiler-6.10.1 - 2019-11-04 > > * Fix `compileRule` typings [Pagan Gazzard] > ### abstract-sql-compiler-6.10.0 - 2019-11-04 > > * Add support for basic check constraints [Pagan Gazzard]

## 10.21.0 - 2019-10-15 * permissions: Set actor on api key [Roman Mazur] ## 10.20.4 - 2019-10-14

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.9.2 - 2019-10-11 > > * Allow combining/adding to existing NOT IN statements [Pagan Gazzard] > * Allow combining/adding to existing IN statements [Pagan Gazzard] > * Prioritise collapsing nested ANDs over converting them to an NOT IN [Pagan Gazzard] > * Prioritise collapsing nested ORs over converting them to an IN [Pagan Gazzard]

## 10.20.3 - 2019-10-14 * Reuse a single permission error for `getApiKeyActorId` [Pagan Gazzard] * Reuse a single permission error for `generateConstrainedAbstractSql` [Pagan Gazzard] ## 10.20.2 - 2019-09-24 * Use string.split with a limit where relevant [Pagan Gazzard] ## 10.20.1 - 2019-09-23

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.9.1 - 2019-09-20 > > * Switch to a lookup table for finding existing bind var entries [Pagan Gazzard] > ### odata-parser-1.2.3 - 2019-09-20 > > * Optimise merging of operands in `FilterByExpressionLoop` [Pagan Gazzard] > ### odata-to-abstract-sql-4.1.2 - 2019-09-23 > >

Optimise generating resource mappings [Pagan Gazzard]

>> #### odata-parser-1.2.3 - 2019-09-20 >> >> * Optimise merging of operands in `FilterByExpressionLoop` [Pagan Gazzard]

> > ### odata-to-abstract-sql-4.1.1 - 2019-09-19 > > * Improve error messages on failing to resolve relationships [Pagan Gazzard]

## 10.20.0 - 2019-09-19

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.9.0 - 2019-09-16 > > * Add support for resolving directly circular dependencies on postgres [Pagan Gazzard]

## 10.19.7 - 2019-09-18 * Avoid caching odata urls with a hardcoded key parameter [Pagan Gazzard] ## 10.19.6 - 2019-09-11

Update dependencies [Pagan Gazzard]

> ### abstract-sql-compiler-6.8.1 - 2019-09-10 > > * Optimise finding of existing binds when adding a bind variable [Pagan Gazzard]

## 10.19.5 - 2019-08-29

Update dependencies [Pagan Gazzard]

> ### odata-to-abstract-sql-4.1.0 - 2019-08-29 > > * Add support for `TableNode` definitions [Pagan Gazzard] >

Add typings support for `ResourceNode`s in join nodes [Pagan Gazzard]

>> #### abstract-sql-compiler-6.8.0 - 2019-08-29 >> >> * Add support for inner/left/right/full joins [Pagan Gazzard]

> > ### odata-to-abstract-sql-4.0.1 - 2019-08-22 > > * Update dependencies [Pagan Gazzard] > ### abstract-sql-compiler-6.8.0 - 2019-08-29 > > * Add support for inner/left/right/full joins [Pagan Gazzard]

## 10.19.4 - 2019-08-23 * Accept `instanceof Error` as valid errors [Pagan Gazzard] ## 10.19.3 - 2019-08-20

Update dependencies [Pagan Gazzard]

> ### pinejs-client-js-5.6.0 - 2019-07-12 > > * Add 'upsert' method supporting natural keys, requires Pinejs ^10.19.1 [Thodoris Greasidis]

## 10.19.2 - 2019-07-26 * Correctly use the database table name for prettifying constraint errors [Pagan Gazzard] ## 10.19.1 - 2019-07-08 * Only send the error message as the response body for constraint errors [Pagan Gazzard] ## 10.19.0 - 2019-07-05 * Return a more accurate 409 status for constraint errors [Pagan Gazzard] ## 10.18.1 - 2019-07-05 * Schedule clearing compile cache on any use [Pagan Gazzard] ## 10.18.0 - 2019-07-04 * Add caching of odata that uses parameter aliases [Pagan Gazzard] ## 10.17.3 - 2019-07-04 * Don't generate a `resourceURI` if there is no resource id [Pagan Gazzard] ## 10.17.2 - 2019-07-02 * Stop sending `type` in the response as it's always an empty string [Pagan Gazzard] ## 10.17.1 - 2019-07-02 * Clear the cache upon persisting it to disk [Pagan Gazzard] ## 10.17.0 - 2019-06-25 * ✨: Support TS migrations [Andreas Fitzek] ## 10.16.1 - 2019-06-20 * Fix missing `promise: true` option for memoized `$getApiKeyPermissions` [Pagan Gazzard]

View details

### pinejs-client-js-5.5.4 - 2019-06-18 * Remove unnecessary `string` type that is handled by the `Params` type [Pagan Gazzard] ### pinejs-client-js-5.5.3 - 2019-06-18 * Use an .npmrc to prevent creating a package-lock on each install [Thodoris Greasidis] ### pinejs-client-js-5.5.2 - 2019-06-10 * Add some type casting so that it compiles on TypeScript 3.5 [Thodoris Greasidis] ### abstract-sql-compiler-6.7.1 - 2019-06-17 * Change `IsDistinctFrom` for postgres to a version that can use indexes [Pagan Gazzard] * Optimise `IsDistinctFrom`/`IsNotDistinctFrom` when either arg is `Null` [Pagan Gazzard]

## 10.16.0 - 2019-06-14 * Fix handling of odata eq/ne when fields contain null [Pagan Gazzard]

View details

### odata-to-abstract-sql-4.0.0 - 2019-06-14 * Update tsconfig target to es2018 [Pagan Gazzard] * Use `IsDistinctFrom`/`IsNotDistinctFrom` for odata `eq`/`ne` [Pagan Gazzard] ### abstract-sql-compiler-6.7.0 - 2019-06-14 * Add support for `IsDistinctFrom`/`IsNotDistinctFrom` [Pagan Gazzard]

## 10.15.7 - 2019-06-10 * Remove unused odata options to improve cache hits [Pagan Gazzard] ## 10.15.6 - 2019-06-10 * Update odata-parser to make use of its types [Pagan Gazzard]

View details

### odata-to-abstract-sql-3.3.0 - 2019-06-07 * Make use of odata-parser types [Pagan Gazzard]

View details

#### odata-parser-1.1.1 - 2019-06-07 * Improve typings [Pagan Gazzard] #### odata-parser-1.1.0 - 2019-06-06 * Add typings [Pagan Gazzard] #### abstract-sql-compiler-6.6.0 - 2019-06-03 * Improve aliased from handling in `getReferencedFields` [Pagan Gazzard] #### abstract-sql-compiler-6.5.1 - 2019-06-03 * Use an abstract-sql-optimiser prepass to simplify getReferencedFields [Pagan Gazzard] #### sbvr-parser-0.2.3 - 2019-06-04 * Optimise exactly 0 to not exists [Pagan Gazzard]

### sbvr-parser-0.2.3 - 2019-06-04 * Optimise exactly 0 to not exists [Pagan Gazzard] ### odata-parser-1.2.0 - 2019-06-07 * Support `;` for separating expand options [Pagan Gazzard] ### odata-parser-1.1.1 - 2019-06-07 * Improve typings [Pagan Gazzard] ### odata-parser-1.1.0 - 2019-06-06 * Add typings [Pagan Gazzard]

## 10.15.5 - 2019-06-04 * Remove unnecessary `process.env` accesses [Pagan Gazzard] ## 10.15.4 - 2019-06-03 * Use `PromiseLike` to be more accepting with promise returning functions [Pagan Gazzard] ## 10.15.3 - 2019-06-03 * Update the alias instead of stripping for non-field nodes [Pagan Gazzard]

View details

### odata-to-abstract-sql-3.2.0 - 2019-05-31 * Add support for computed fields [Pagan Gazzard] ### odata-to-abstract-sql-3.1.3 - 2019-05-31 * Unify the handling of adding fields with or without a $select [Pagan Gazzard]

View details

#### odata-parser-1.0.4 - 2019-05-27 * Fix adding parameter alias to the options object [Pagan Gazzard] #### odata-parser-1.0.3 - 2019-05-08 * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard] #### abstract-sql-compiler-6.5.0 - 2019-05-30 * Add support for computed fields [Pagan Gazzard] #### abstract-sql-compiler-6.4.3 - 2019-05-30 * Add tests for `getReferencedFields` [Pagan Gazzard] #### abstract-sql-compiler-6.4.2 - 2019-05-09 * Update and fix lodash typings [Pagan Gazzard] * Update husky/mocha dev dependencies [Pagan Gazzard] #### abstract-sql-compiler-6.4.1 - 2019-05-08 * Fix typescript compilation [Pagan Gazzard]

View details

##### sbvr-parser-0.2.2 - 2019-05-08 * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

* Add node 12 tests [Pagan Gazzard] * Add repo.yml for upstream changelogs [Pagan Gazzard] * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

### abstract-sql-compiler-6.6.0 - 2019-06-03 * Improve aliased from handling in `getReferencedFields` [Pagan Gazzard] ### abstract-sql-compiler-6.5.1 - 2019-06-03 * Use an abstract-sql-optimiser prepass to simplify getReferencedFields [Pagan Gazzard]

## 10.15.2 - 2019-06-03 * Update lodash types [Pagan Gazzard] ## 10.15.1 - 2019-05-31 * Update dependencies [Pagan Gazzard]

View details

### odata-parser-1.0.4 - 2019-05-27 * Fix adding parameter alias to the options object [Pagan Gazzard] ### abstract-sql-compiler-6.5.0 - 2019-05-30 * Add support for computed fields [Pagan Gazzard] ### abstract-sql-compiler-6.4.3 - 2019-05-30 * Add tests for `getReferencedFields` [Pagan Gazzard]

## 10.15.0 - 2019-05-21 * Add basic support for non-number fields in __metadata.uri [Pagan Gazzard] ## 10.14.3 - 2019-05-21 * Memoize `resolveNavigationResource` [Pagan Gazzard] ## 10.14.2 - 2019-05-21 * Fix `getMemoizedCompileRule` not correctly memoizing [Pagan Gazzard] ## 10.14.1 - 2019-05-20 * Remove unused functions [Pagan Gazzard] ## 10.14.0 - 2019-05-15 * Update pinejs-client-core and make use of prepared queries [Pagan Gazzard]

View details

### odata-parser-1.0.3 - 2019-05-08 * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard] ### odata-parser-1.0.2 - 2019-04-15 * Update dependencies [Pagan Gazzard] ### abstract-sql-compiler-6.4.2 - 2019-05-09 * Update and fix lodash typings [Pagan Gazzard] * Update husky/mocha dev dependencies [Pagan Gazzard] ### abstract-sql-compiler-6.4.1 - 2019-05-08 * Fix typescript compilation [Pagan Gazzard]

View details

#### sbvr-parser-0.2.2 - 2019-05-08 * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

* Add node 12 tests [Pagan Gazzard] * Add repo.yml for upstream changelogs [Pagan Gazzard] * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard] ### pinejs-client-js-5.5.1 - 2019-05-15 * Fix downstream declaration creation errors due to `Dictionary` [Pagan Gazzard] ### pinejs-client-js-5.5.0 - 2019-05-15 * Add a prepare method that prepares a query into a function [Pagan Gazzard] ### pinejs-client-js-5.4.1 - 2019-05-10 * Add CODEOWNERS [Gergely Imreh] ### pinejs-client-js-5.4.0 - 2019-05-10 * Add support for parameter aliases in resource ids [Pagan Gazzard] ### pinejs-client-js-5.3.10 - 2019-05-10 * Deduplicate transformation of GET results [Pagan Gazzard] ### pinejs-client-js-5.3.9 - 2019-05-10 * Simplify how we expose types, which means `subscribe` is now exposed [Pagan Gazzard] ### pinejs-client-js-5.3.8 - 2019-05-09 * Add automatic formatting via prettier [Pagan Gazzard] ### pinejs-client-js-5.3.7 - 2019-05-08 * Remove node 4 build, add node 12 [Pagan Gazzard] * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard] ### odata-to-abstract-sql-3.1.2 - 2019-05-08 * Add node 12 tests [Pagan Gazzard] * Add repo.yml for upstream changelogs [Pagan Gazzard] * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard] ### sbvr-types-2.0.3 - 2019-05-08 * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard] ### sbvr-parser-0.2.2 - 2019-05-08 * Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

## 10.13.3 - 2019-05-14 * Fix possible null error when using a parameter alias with no value [Pagan Gazzard] ## 10.13.2 - 2019-05-08 * Add repo.yml for nested changelogs [Pagan Gazzard] ## 10.13.1 - 2019-05-06 * Add node 12 to the circle tests [Pagan Gazzard] ## 10.13.0 - 2019-05-06 * Expose odata-compiler as a bin script [Pagan Gazzard] ## 10.12.0 - 2019-05-01 * Expose sbvr-compiler as a bin script [Pagan Gazzard] * Move odata-metadata-generator into odata-metadata directory [Pagan Gazzard] ## 10.11.3 - 2019-05-01 * Update @types/lodash, avoiding `_.isObject` where necessary [Pagan Gazzard] ## 10.11.2 - 2019-04-22 * Only validate the model if the query affected at least 1 row [Pagan Gazzard] ## 10.11.1 - 2019-04-11 * Switch odata-metadata-generator to using an abstract sql model [Pagan Gazzard] ## 10.11.0 - 2019-04-11 * Allow specifying the abstract sql directly in the config [Pagan Gazzard] ## 10.10.0 - 2019-04-10 * Allow specifying absolute paths in the config [Pagan Gazzard] ## 10.9.0 - 2019-04-10 * Allow any importable config file type rather than just JSON [Pagan Gazzard] ## 10.8.2 - 2019-04-06 * Only print the error message on pool errors [Pagan Gazzard] ## 10.8.1 - 2019-04-01 * Add an error handler to the pg pool [Pagan Gazzard] ## 10.8.0 - 2019-03-25 * Add support for read-only transactions for postgres/mysql backends [Pagan Gazzard] ## 10.7.0 - 2019-03-12 * Use definitions for all permission types [Pagan Gazzard] ## 10.6.1 - 2019-03-11 * Update to sbvr-types 2.0.2 [Pagan Gazzard] ## 10.6.0 - 2019-03-07 * Update pg to ^7.8.1 [Pagan Gazzard] ## 10.5.3 - 2019-03-07 * Use `?` to check for complex urls as it's more accurate than `$` [Pagan Gazzard] ## 10.5.2 - 2019-03-07 * Fix for latest bluebird typings [Pagan Gazzard] ## 10.5.1 - 2019-02-25 * Correctly propagate transaction creation errors in `db.transaction(fn)` [Pagan Gazzard] ## 10.5.0 - 2019-02-07 * Update to webpack 4 [Pagan Gazzard] * Update to webpack 3 [Pagan Gazzard] * Update to webpack 2 [Pagan Gazzard] ## 10.4.4 - 2019-02-06 * Switch to a single module level models lookup instead of multiple [Pagan Gazzard] * Drop unnecessary req.hooks usage [Pagan Gazzard] ## 10.4.3 - 2019-02-05 * Extract odata response related functions from sbvr-utils [Pagan Gazzard] ## 10.4.2 - 2019-02-04 * Extract out abstract-sql related functions from sbvr-utils [Pagan Gazzard] ## 10.4.1 - 2019-02-04 * Fix `data` parameter passed to GET PRERESPOND hooks [Pagan Gazzard] ## 10.4.0 - 2019-02-04 * Convert sbvr-utils to typescript [Pagan Gazzard] ## 10.3.8 - 2019-01-28 * Fix require path [Pagan Gazzard] ## 10.3.7 - 2019-01-28 * Update `odata-to-abstract-sql` to pick up improved typings [Pagan Gazzard] ## 10.3.6 - 2019-01-28 * Add parsable representation of changelog [Giovanni Garufi] ## 10.3.5 - 2019-01-25 * Re-add `rootDir` that was accidentally removed [Pagan Gazzard] ## 10.3.4 - 2019-01-24 * Fix rolling back req hooks [Pagan Gazzard] ## 10.3.3 - 2019-01-24 * Improve uri-parser typings [Pagan Gazzard] * Improve hooks typings [Pagan Gazzard] * Improve cached-compile typings [Pagan Gazzard] * Improve control-flow typings [Pagan Gazzard] ## 10.3.2 - 2019-01-24 * Convert gruntfile to typescript [Pagan Gazzard] * Convert build/server to typescript [Pagan Gazzard] * Convert build/module to typescript [Pagan Gazzard] * Convert build/browser to typescript [Pagan Gazzard] * Convert build/config to typescript [Pagan Gazzard] ## 10.3.1 - 2019-01-23 * Convert odata-metadata-generator to typescript [Pagan Gazzard] ## 10.3.0 - 2019-01-22 * Convert permissions to typescript [Pagan Gazzard] ## 10.2.3 - 2019-01-18 * Use the Engines enum for engines names to guarantee consistency [Pagan Gazzard] ## 10.2.2 - 2019-01-17 * Add prettier and a precommit hook [Pagan Gazzard] ## 10.2.1 - 2019-01-16 * Add types for sbvr-parser and use es6 exports for extended-sbvr-parser [Pagan Gazzard] ## 10.2.0 - 2019-01-16 * Convert pinejs-session-store to typescript [Pagan Gazzard] ## 10.1.4 - 2019-01-16 * Add typings for odata-parser [Pagan Gazzard] ## 10.1.3 - 2019-01-16 * Fix nestedCheck and/or merging [Pagan Gazzard] ## 10.1.2 - 2019-01-16 * Minor code cleanup in the permissions module [Pagan Gazzard] ## 10.1.1 - 2019-01-04 * Use Promise.method instead of Promise.try [Pagan Gazzard] ## 10.1.0 - 2018-12-14 * Make the $bypass version of definition based tables bypass permissions [Pagan Gazzard] ## 10.0.1 - 2018-12-13 * Of course, chaning the variable to `metrics` means we have to update it everywhere [dt-rush] * Renamed metricsEmitter to metrics [dt-rush] * Small comment about query type [dt-rush] * Using more efficient event emitter `eventemitter3` [dt-rush] * Added db query time metric via event emitter on db module [dt-rush] * Query times report in ms, two metrics-TODO added for future improvements [dt-rush] * Using more efficient event emitter `eventemitter3` [dt-rush] * Send db error metrics [dt-rush] * Added db query time metric via event emitter on db module [dt-rush] ## 10.0.0 - 2018-12-07 * Update to odata-to-abstract-sql v3.0.0 [Pagan Gazzard] ## 9.1.12 - 2018-12-07 * Don't override existing definitions when generating the constrained sql [Pagan Gazzard] * Use the table key when aliasing for the constrained key [Pagan Gazzard] ## 9.1.11 - 2018-11-27 * Avoid unnecessary duplicated call to `addRelationshipBypasses` [Pagan Gazzard] ## 9.1.10 - 2018-11-26 * Merge concat and uniq into union for `checkPermissions` [Pagan Gazzard] ## 9.1.9 - 2018-11-26 * Avoid bluebird catch sugar for performance [Pagan Gazzard] ## 9.1.8 - 2018-11-21 * Support stripping explicit alias nodes [Pagan Gazzard] ## 9.1.7 - 2018-11-17 * Optimise `memoizedGetConstrainedModel` [Pagan Gazzard] ## 9.1.6 - 2018-11-15 * Optimise `checkForExpansion` [Pagan Gazzard] ## 9.1.5 - 2018-11-05 * Fix webpack builds [Pagan Gazzard] ## 9.1.4 - 2018-11-05 * Remove unused ometa-js dependency [Pagan Gazzard] ## 9.1.3 - 2018-11-05 * Update to coffeescript 2 [Pagan Gazzard] ## v9.1.2 - 2018-11-05 * Switch to `coffeescript` instead of `coffee-script` [Pagan Gazzard] ## v9.1.1 - 2018-11-03 * Update dependencies [Pagan Gazzard] ## v9.1.0 - 2018-10-31 * Update odata-parser to 1.0.0 to switch to the pegjs version [Pagan Gazzard] ## v9.0.3 - 2018-10-24 * Remove unnecessary `do` block [Pagan Gazzard] ## v9.0.2 - 2018-10-24 * Move the insert id logging behind the DEBUG flag [Pagan Gazzard] ## v9.0.1 - 2018-10-18 * Improve typings [Pagan Gazzard] ## v9.0.0 - 2018-10-12 * Reject internal requests with errors instead of numbers/strings [Pagan Gazzard] * Update abstract-sql-compiler to 6.x and sbvr-types to 2.x [Pagan Gazzard] ## v8.4.2 - 2018-10-04 * Resolve the root argument as an absolute path [Pagan Gazzard] ## v8.4.1 - 2018-09-27 * Merge hook/odata request types as they're the same [Pagan Gazzard] ## v8.4.0 - 2018-09-27 * Add `initSqlPath`/`initSql` which are run only on first model execution [Pagan Gazzard] ## v8.3.4 - 2018-09-26 * Convert config-loader to typescript [Pagan Gazzard] ## v8.3.3 - 2018-09-26 * Convert uri-parser to typescript [Pagan Gazzard] ## v8.3.2 - 2018-09-26 * Skip typescript lib checking, fixing git install in some ts projects [Pagan Gazzard] ## v8.3.1 - 2018-09-25 * Add a prepare script so it is possible to install via git [Pagan Gazzard] ## v8.3.0 - 2018-09-24 * Add a migrations lock so only one pinejs instance will run migrations [Pagan Gazzard] ## v8.2.8 - 2018-09-07 * Update dependencies [Pagan Gazzard] ## v8.2.7 - 2018-09-06 * Use a default message for any database errors not explicitly rewritten [Pagan Gazzard] ## v8.2.6 - 2018-09-04 * Expose actor type and add getApiKeyPermissions typing [Pagan Gazzard] ## v8.2.5 - 2018-08-31 * Add typing for hash comparisons [Pagan Gazzard] ## v8.2.4 - 2018-08-29 * More type improvements #199 [Pagan Gazzard] ## v8.2.3 - 2018-08-29 * More typing improvements #198 [Pagan Gazzard] ## v8.2.2 - 2018-08-28 * Improve typings #197 [Pagan Gazzard] ## v8.2.1 - 2018-08-24 * Improve/fix db-layer types #196 [Pagan Gazzard] ## v8.2.0 - 2018-08-21 * Convert the migrator to typescript #194 [Pagan Gazzard] ## v8.1.12 - 2018-08-21 * Add types for `resolveOdataBind` and `odataBinds` #195 [Pagan Gazzard] ## v8.1.11 - 2018-08-20 * Export all the interfaces so they can be used downstream #193 [Pagan Gazzard] ## v8.1.10 - 2018-08-15 * Add a type for the exported `api` const #192 [Pagan Gazzard] * Export the PinejsClient interface #192 [Pagan Gazzard] * Add a type definition for `getAffectedIds` #192 [Pagan Gazzard] ## v8.1.9 - 2018-08-15 * Update dependencies #191 [Pagan Gazzard] ## v8.1.8 - 2018-08-09 * Update to typescript 3 #190 [Pagan Gazzard] ## v8.1.7 - 2018-08-07 * Fix missing `promise: true` for memoisation #189 [Pagan Gazzard] ## v8.1.6 - 2018-08-07 * Switch to using memoizee for our guest permissions cache #187 [Pagan Gazzard] ## v8.1.5 - 2018-08-01 * Improve the typings we expose #186 [Pagan Gazzard] ## v8.1.4 - 2018-08-01 * Throw a PermissionError on a missing apikey to return 401 instead of 404 #184 [Pagan Gazzard] ## v8.1.3 - 2018-08-01 * Improve `constructError` performance by avoiding unnecessary sugar work #185 [Pagan Gazzard] ## v8.1.2 - 2018-07-20 * Fix `addPermissions` sometimes returning undefined rather than a promise. #183 [Pagan Gazzard] ## v8.1.1 - 2018-07-19 * Fix adding permissions for `getAffectedIds` #182 [Pagan Gazzard] ## v8.1.0 - 2018-07-11 * Add `getAffectedIds` which can be used to get a list of ids a request will affect. #181 [Pagan Gazzard] ## v8.0.1 - 2018-06-25 * Fix a promise was not returned from handler warning when using end/rollback listeners. #180 [Pagan Gazzard] ## v8.0.0 - 2018-06-24 * Move pg settings to env.ts #179 [Pagan Gazzard] * Standardise the api key cache settings location. #179 [Pagan Gazzard] * Only apply the user's actor to user permissions and api key actor to api key permissions, and block actor ids for guests completely. #179 [Pagan Gazzard] * Switch from `$ACTOR.ID` to the more standard `@__ACTOR_ID` for the actor id parameter. #179 [Pagan Gazzard] * Reduce the number of calls to `getPermissionsLookup` by passing around the already fetched permissions lookup object. #179 [Pagan Gazzard] * Reuse the odata parsing memoisation between the uri-parser and permissions checking #179 [Pagan Gazzard] * Memoize the rewriting of odata options #179 [Pagan Gazzard] * Convert permissions to being applied at the SQL level via definitions where possible, rather than via merging OData filters. #179 [Pagan Gazzard] ## v7.4.0 - 2018-06-08 * Add support for string bind keys #178 [Pagan Gazzard] ## v7.3.4 - 2018-06-07 * Removed broken link for clarity #177 [Rich Bayliss] ## v7.3.3 - 2018-05-18 * Update dependencies. #176 [Pagan Gazzard] ## v7.3.2 - 2018-05-17 * Reduce the default max size for permissions lookup to 5000 #175 [Pagan Gazzard] ## v7.3.1 - 2018-05-10 * Memoize the replacement of `$ACTOR.ID` as part of getting the permissions lookup object. #174 [Pagan Gazzard] ## v7.3.0 - 2018-05-08 * Add typed errors for the primary http response statuses #172 [Thodoris Greasidis] ## v7.2.1 - 2018-05-07 * Fix missing env requires. #173 [Pagan Gazzard] ## v7.2.0 - 2018-05-04 * Add a setting for max cache entries for the odata to abstract sql cache, and default to 10000. #170 [Pagan Gazzard] * Add a setting for max cache entries for the odata to abstract sql cache, and default to 10000. #170 [Pagan Gazzard] * Add a setting for max cache entries for the odata parsing cache, and default to 100000. #170 [Pagan Gazzard] * Add a setting for max cache entries for the parsing permissions cache, and default to 100000. #170 [Pagan Gazzard] * Add a setting for max cache entries for the permissions lookup cache, and default to 10000. #170 [Pagan Gazzard] * Increase the default max apiKey permissions cached to 10000 #170 [Pagan Gazzard] * Convert env.coffee to typescript #170 [Pagan Gazzard] ## v7.1.2 - 2018-05-03 * Remove unused dependencies #169 [Pagan Gazzard] ## v7.1.1 - 2018-05-02 * Remove ometajs loader registration, since we use a separate build step now. #166 [Pagan Gazzard] ## v7.1.0 - 2018-05-02 * Add a model compilation cache to improve startup times. #167 [Pagan Gazzard] ## v7.0.2 - 2018-05-01 * Switch types to using generated declaration files, this solves issues where the global typings we use are unavailable for dependent typescript projects. #165 [Pagan Gazzard] ## v7.0.1 - 2018-04-30 * Add node 10 to the test matrix. #163 [Pagan Gazzard] ## v7.0.0 - 2018-04-30 * Remove the callback interface from `checkPermissions`, which greatly simplifies the code. #149 [Pagan Gazzard] * Remove unused callback interface for `_getGuestPermissions` #149 [Pagan Gazzard] * Update the abstract-sql chain to a version that uses the resource name for references files rather than the table name #149 [Pagan Gazzard] * Cache the modified fields as part of the abstractSqlQuery compilation #149 [Pagan Gazzard] * Remove the database-layer callback interface, simplifying the code. #149 [Pagan Gazzard] * Convert most of the database layer to using prototype functions rather than bound functions #149 [Pagan Gazzard] * Use `Object.freeze` to prevent mutating the cached abstract sql which allows us to skip a costly Object.freeze #149 [Pagan Gazzard] * Update to abstract-sql-compiler which now generates native postgres bindings. #149 [Pagan Gazzard] * Remove special handling for arrays in the pg layer, node-pg support array binds now. #149 [Pagan Gazzard] * Remove the ability to use `undefined` to generate a default value, as undefined can't exist in tthe JSON body anyway. #149 [Pagan Gazzard] * Change the `rows` property of a db result from a websql-like format to a standard array. #149 [Pagan Gazzard] * Generate es2015 output, dropping support for node 4. #149 [Pagan Gazzard] * Return a 401 when a POST fails to create any resources. #149 [Pagan Gazzard] * Fix prettifying db errors, making the thrown constraint errors a bit nicer again. #149 [Pagan Gazzard] * Update to pinejs-client-core 5.x #149 [Pagan Gazzard] * Cancel any ongoing work when the request/response is closed. #149 [Pagan Gazzard] * Change `db.transaction` to take a fn that after completing will automatically close/rollback the transaction, handling cancellation nicely #149 [Pagan Gazzard] * Add rollback function for hooks that perform side-effects. #149 [Giovanni Garufi] ## v6.10.9 - 2018-04-26 * Generate a lookup object for permissions and use it to speed up checking permissions. #161 [Pagan Gazzard] ## v6.10.8 - 2018-04-26 * Generate local and fetch processing fields caches as part of executing the model, avoiding the need to generate them on the fly later. #160 [Pagan Gazzard] ## v6.10.7 - 2018-04-26 * Memoize resolveSynonym as it's called very regularly #162 [Pagan Gazzard] ## v6.10.6 - 2018-04-19 * Remove the delayed sql compilation for batch requests with content references as only the execution needs to be delayed. #157 [Pagan Gazzard] ## v6.10.5 - 2018-04-17 * Avoid fetching the full response on internal POSTs where possible #156 [Pagan Gazzard] ## v6.10.4 - 2018-04-06 * Avoid the work of defining a property if there are no hooks that will use it. #153 [Pagan Gazzard] ## v6.10.3 - 2018-04-06 * Avoid running `bindDefaultValues` for postgres since the postgres bind handling already handles it #152 [Pagan Gazzard] ## v6.10.2 - 2018-04-06 * Switch to using the array form for _.get, improving performance in a hot function. #151 [Pagan Gazzard] ## v6.10.1 - 2018-04-05 * Fix getStackTrace to respect the DEBUG setting correctly, and use _.noop for the noop version. #150 [Pagan Gazzard] ## v6.10.0 - 2018-04-03 * Add grunt command to build and copy out folder to target directory. #143 [Giovanni Garufi] ## v6.9.7 - 2018-03-29 * Add the $ prefix to all pinejs-client options since the automatic prefixing is deprecated #148 [Pagan Gazzard] ## v6.9.6 - 2018-03-29 * Remove references to pinejs being private from the docs as it's been public for a while #146 [Pagan Gazzard] ## v6.9.5 - 2018-03-29 * Fix rethrowing a nicer db error. #147 [Pagan Gazzard] ## v6.9.4 - 2018-03-28 * Switch to using `tapCatch` instead of manually rethrowing where possible #144 [Pagan Gazzard] ## v6.9.3 - 2018-03-22 * Simplify creating transactions #141 [Pagan Gazzard] ## v6.9.2 - 2018-03-22 * Avoid memoising the bind length in parsePermissions, allowing a higher cache hit rate and lower memory usage. #140 [Pagan Gazzard] ## v6.9.1 - 2018-03-19 * Return a rejected promise rather than killing the process when failing to connect. #138 [Pagan Gazzard] ## v6.9.0 - 2018-03-14 * Update @resin/odata-parser, @resin/odata-to-abstract-sql, @resin/sbvr-types, and pinejs-client #137 [Pagan Gazzard] ## v6.8.1 - 2018-03-13 * Remove _getPermissions cache as it had far too many combinations. #136 [Pagan Gazzard] ## v6.8.0 - 2018-03-06 * Memoise basic odata queries. #135 [Pagan Gazzard] ## v6.7.1 - 2018-03-06 * Fix some lint errors. #134 [Pagan Gazzard] ## v6.7.0 - 2018-03-03 * Only create errors for nice stack traces in debug mode due to the overhead it causes #130 [Pagan Gazzard] ## v6.6.3 - 2018-03-03 * Fix permissions memoisation #133 [Pagan Gazzard] ## v6.6.2 - 2018-03-02 * Memoise checking the permissions that apply to the current request #128 [Pagan Gazzard] ## v6.6.1 - 2018-03-02 * Memoise getting hooks for the request #126 [Pagan Gazzard] ## v6.6.0 - 2018-03-02 * Add a forbidden error type that results in a 403 http error code #132 [Andreas Fitzek] ## v6.5.1 - 2018-03-02 * Move search path setting to be run once in a pool hook on client creation, rather than for each transaction #127 [Pagan Gazzard] ## v6.5.0 - 2018-02-22 * Add a `returnResource` option to POST requests, which when set will return only the id in the response and save fetching the entire result #123 [Pagan Gazzard] ## v6.4.3 - 2018-02-22 * Switch to using memoizee instead of bluebird-lru-cache #122 [Pagan Gazzard] ## v6.4.2 - 2018-02-22 * Cache the api key's actor id along with its permissions, meaning we don't have to continually refetch it. #121 [Pagan Gazzard] ## v6.4.1 - 2018-02-09 * Simplify `runTransaction` #120 [Pagan Gazzard] ## v6.4.0 - 2018-01-31 * Export sbvr-api errors #119 [Thodoris Greasidis] ## v6.3.4 - 2018-01-29 * Propagate the error message of BadRequestErrors #118 [Thodoris Greasidis] ## v6.3.3 - 2018-01-24 * Fix backwards incompatible change introduced by #109 #114 [Pagan Gazzard] ## v6.3.2 - 2018-01-12 * Delete hooks from the external req object after setting them on the internal request. This prevents hooks by being collected twice in runHook #112 [Giovanni Garufi] ## v6.3.1 - 2018-01-11 * Fix missing argument in translateUri function #110 [Giovanni Garufi] ## v6.3.0 - 2018-01-11 * Save request specific hooks on the request object so they don't get mixed up in batch requests. #101 [Giovanni Garufi] ## v6.2.0 - 2018-01-10 * Add generic `canAccess` action for every resource #98 [Andreas Fitzek] ## v6.1.0 - 2018-01-09 * Expose `permissions.addPermissions` so it is possible to add permissions directly #102 [Pagan Gazzard] ## v6.0.0 - 2018-01-09 * Store the abstract SQL model for a request on the request object, and use it when resolving navigations and synonyms. #106 [Pagan Gazzard] ## v5.3.2 - 2018-01-09 * Use get/set properties to define a passthrough for the fake filter objects to the real ones so that permissions are applied correctly. #109 [Pagan Gazzard] ## v5.3.1 - 2018-01-05 * Update dependencies #107 [Pagan Gazzard] ## v5.3.0 - 2018-01-04 * Allow hooks to generate a custom abstractSqlQuery that will be used instead of generating our own. #105 [Pagan Gazzard] ## v5.2.19 - 2018-01-04 * Improve error message when resolving a navigation resource fails because we find a direct field rather than a navigation #104 [Pagan Gazzard] ## v5.2.18 - 2018-01-04 * Remove undefined values from the body of internal requests to match what happens during an external/http request #103 [Pagan Gazzard] ## v5.2.17 - 2017-12-11 * Publish the available typings #97 [Pagan Gazzard] ## v5.2.16 - 2017-11-29 * Set up circleci auto-publishing #96 [Pagan Gazzard] ## v5.2.15 - 2017-11-26 * Improve error message when api key permission checking fails, and just use no permissions for that case rather than rejecting the entire check. #95 [Pagan Gazzard] ## v5.2.14 - 2017-11-20 * Guarantee that any error returned from the settle functions is an error object, this fixes later code that checks if an error was returned by using `_.isError` #94 [Pagan Gazzard] ## v5.2.13 - 2017-10-25 * Convert control-flow to typescript #83 [Pagan Gazzard] ## v5.2.12 - 2017-10-20 * Add a circle.yml to test on CircleCI #90 [Pablo Carranza Velez] ## v5.2.11 - 2017-10-19 * Clone the abstract sql tree before returning to ensure hooks cannot mutate and pollute the cache #88 [Pagan Gazzard] ## v5.2.10 - 2017-10-11 * Added Apache-2.0 license and updated repository link in package.json #81 [Giovanni Garufi] ## v5.2.9 - 2017-10-09 * Update lf-to-abstract-sql to ^1.0.3 to include fixes #87 [Pagan Gazzard] ## v5.2.8 - 2017-10-02 * Added test and build scripts to package.json, making it easier to build pinejs #86 [Pagan Gazzard] ## v5.2.7 - 2017-10-02 * Improve the error message when failing to resolve a navigation by using the name the user provided rather than the resolved name #84 [Pagan Gazzard] ## v5.2.6 - 2017-09-27 * Update typescript to ^2.5.3 #80 [Giovanni Garufi] ## v5.2.5 - 2017-09-27 * Improve error message when trying to resolve an invalid navigation #79 [Pagan Gazzard] ## v5.2.4 - 2017-09-25 * Fix error where we used a fat arrow function but we needed standard function semantics. #78 [Pagan Gazzard] ## v5.2.3 - 2017-09-25 * Convert extended-sbvr-parser to typescript #77 [Pagan Gazzard] ## v5.2.2 - 2017-09-22 * Added Advanced Usage guide and improved docs #28 [Giovanni Garufi] ## v5.2.1 - 2017-09-22 * Added permission check on resource involved in OData filters #63 [Giovanni Garufi] ## v5.2.0 - 2017-09-22 * Convert db to typescript #57 [Pagan Gazzard] ## v5.1.5 - 2017-09-21 * Remove an unnecessary warning #76 [Pagan Gazzard] ## v5.1.4 - 2017-09-21 * Add some missing migration steps #75 [Pagan Gazzard] ## v5.1.3 - 2017-09-20 * Rework the checking if a rule is affected to be clearer about the reasoning for each case and fix a couple #67 [Pagan Gazzard] ## v5.1.2 - 2017-09-20 * Use Promise.mapSeries to run migrations #74 [Cameron Diver] ## v5.1.1 - 2017-09-20 * Update lf-to-abstract-sql to guarantee including the negation fix. #73 [Pagan Gazzard] ## v5.1.0 - 2017-09-19 * Fixed rule validation that would fail with unbound values #71 [Akis Kesoglou] ## v5.0.3 - 2017-09-04 * Disable affected rule optimisation to guarantee all relevant rules are always run, guaranteeing the database cannot enter an invalid state #68 [Pagan Gazzard] ## v5.0.2 - 2017-09-04 * Fix check for matching fields when deciding if a rule needs to run. #66 [Pagan Gazzard] ## v5.0.1 - 2017-08-31 * Added versionist #65 [Giovanni Garufi] ## v5.0.0 * Converted sql-binds to typescript * Updated sbvr-parser to ^0.1.0 * Updated lf-to-abstract-sql to ^1.0.0 * Breaking: verbs are now included in field names (except for `has`), eg `pilot can fly plane` now creates a field called `can fly-plane` instead of `plane`, allowing multiple relationships between two terms * Adds relationship and synonym info to the generated abstract sql for odata-to-abstract-sql to use * Updated odata-to-abstract-sql to ^1.0.0, which supports lf-to-abstract-sql v1.0.0 * Breaking: table names now use ` ` rather than `_` within terms and verbs and `-` between them (matching the way fields are named) * Breaking: requires verbs to specify the relationship between two terms, eg `pilot/plane` becomes `pilot/can_fly__plane` * Adds support for synonym and synonymous form usage, which makes it possible to specify the direction of a relationship for self-referential fields. * Removed abstract-sql-to-odata-schema as it is no longer needed, since the abstract-sql now has all the info necessary. ## v4.0.0 * Changed permission name to text, to allow unlimited length permissions * Separated out the client * Added OData batch support * Added the ability to pass a custom properties object through the internal api that will be available as `req.custom` in any hooks. * Only run rules if a field they query has been attempted to be changed. * Updated pinejs-client to ^4.0.0 * Converted src/server/src/server-glue/server.coffee to typescript. * Converted src/server/src/passport-pinejs/passport-pinejs.coffee to typescript. * Converted src/server/src/server-glue/module.coffee to typescript. * Added support for typescript within pinejs. ## v3.5.2 * Use a proper $count in pinejs-session-store. * Use PATCH rather than PUT to update models to avoid issues with db layers that don't support `SET x = DEFAULT` * Use null-loader for pg/lib/connection-parameters in browser builds to avoid a webpack warning. * Update to jquery-ui ^1.12.1 and rely on the `main` in package.json for resolution so it can stay up to date. ## v3.5.1 * Add a .npmignore to make sure the output folder isn't ignored on publishing. ## v3.5.0 * Compile all of the common/server coffee-script at prepublish time, so that it doesn't need to be compiled by dependents. * Use `process.exit(1)` when exiting abnormally * Don't try to register the coffee-script loader if one already exists, it allows for using custom coffee-script loaders. ## v3.4.0 * Map permissions in serial to make sure binds are always added in the same order/location to aid cache hits. * Avoid even loading the SBVRServer and http-transactions code in the cases where they're disabled * Always register the .sbvr and .ometajs handlers when running in nodejs ## v3.3.1 * Fixed a typo in unique constraint violation error message. ## v3.3.0 * Fixed unique constraint violation error message. * Updated coffee-script to ~1.12.2 * Updated pinejs-client to ^3.0.0 * Updated dev/bower dependencies ## v3.2.0 * Updated lf-to-abstract-sql to v0.0.19 to include the concept types optimisation. ## v3.1.1 * Fixed expanding foreign keys where the foreign key attribute was on the other resource. ## v3.1.0 * Skip attempting to apply field processing if there are no fields needing it. * Added caching for the lists of expandable fields and fields requiring processing. * Removed the try/catch in uri parsing, allowing v8 optimisation * Improved error messages when uri parsing fails ## v3.0.0 * Reimplemented memoisation of the permissions partial parse which was removed in the bind vars update. (test case went from ~2.9s warm to ~2.6s warm) * Updated odata-to-abstract-sql and added memoisation of the translate step. (test case went from ~3.2s warm to ~2.9s warm) * Update to odata-parser/odata-to-abstract-sql/abstract-sql-compiler versions with support for odata binds and use it to memoise the abstract sql compilation step (test case went from ~8.4s warm to ~4.3s warm). ## v2.3.1 * Allow passing userId as a numeric string to `getUserPermissions`. ## v2.3.0 * Converted sql binds parsing from ometa to coffeescript, it reduces my test case (matching production usage) from ~1300ms to ~100ms * Used webpack's resolve.extensions to remove the need for adding .coffee to require calls. * Updated pg to ^6.0.0 and use an explicit pool. * Updated memoizee * Updated dev dependencies. * Update documentation * Fix use of multer in server builds ## v2.2.0 * Updated sbvr-parser and lf-to-abstract-sql to add support for concept types on term form fact types. ## v2.1.1 * Fixed getting api key actor ids * Fixed the 2.0-add-actors migrations ## v2.1.0 * Updated odata-to-abstract-sql and switch to using `setClientModel` to have it shorten aliases when necessary. * Fixed invalid permission filters not being rejected. * Return result for $count * Updated to abstract-sql-compiler 2.1.0 * Updated to odata-parser 0.1.10 * Updated to odata-to-abstract-sql 0.3.5 ## v2.0.0 * Return a 400 error when a request ends fails SBVR model validation (previously 404). * Switched to adding users/permissions after a model and it's migrations are run, this makes it much easier to migrate permissions. * Added a concept of actors and switched the permission filter `$USER.ID` magic to be `$ACTOR.ID` * Updated to abstract-sql-compiler 2.0.0, meaning empty strings are no longer treated as null. * Dropped expressjs3 compatibility, fixing deprecated notices on expressjs4. * Added expiry date fields onto the permissions system. ## v1.4.2 * Updated minimum odata-to-abstract-sql to v0.3.4 in order to bring in support for self-referencing resources (eg application depends on application) ## v1.4.1 * Added PREPARSE hooks and use them in the permissions module in order to be backwards compatible with the behavior in <1.4.0 ## v1.4.0 * Isolated the http transactions code purely into a module so it is optional. * Separated permissions into a mostly isolated module, using proper hooks instead of hardcoded hooks. * Added support for 'all' hooks on the api and method levels. * Switched to throwing specific errors for unique/foreign key/general constraint errors, rather than always just a generic database error. * Converted cases of throwing strings into throwing error objects. * Separated out the api key permissions cache settings so they can be overridden if need be. ## v1.3.0 * Updated odata-parser, odata-to-abstract-sql, and abstract-sql-compiler to add support for date/time functions and some bugfixes. * Added memoisation for permission filter generating. * Simplified permission filter checking. * Respond with 400 Bad Request to malformed odata queries. * Avoid recreating the collapse function. * Separated out the OData schema generation. ## v1.2.0 * Updated to pinejs-client ^2.3.1 and remove deprecated uses of it. ## v1.1.0 * Added express 4 compatibility. ## v1.0.5 * Fixed 'all' hooks overriding resource hooks. * Fixed `read` permission for $expands. ## v1.0.3 * Updated to lodash 4 * Updated pinejs-client to ^2.1.1 to make sure the escaping fix is included. * The OData functions `startswith` and `endswith` are now correctly `(haystack, needle)` instead of `(needle, haystack)` * Changed the 'POSTPARSE' hook to run immediately after the uri parsing, before any permissions are added. * Added support for hooks on the 'all' resource, which will be run for any resource. * Updated to bluebird 3. ## v0.6.4 * Updated odata-to-abstract-sql to ~0.3.0 and abstract-sql-compiler to ~0.4.2. * Added bower to the local dependencies. ## v0.6.3 * Update odata-to-abstract-sql to ~0.2.6 to guarantee the $expand($expand) fix is available. ## v0.6.2 * Now returns 201 with `{ id }` instead of 401 when creating a resource without permission to read it. ## v0.6.1 * Updated abstract-sql-compiler and switched to using it for schema generation. ## v0.6.0 * Removed the default root permissions for internal requests, you must now explicitly specify them. ## v0.5.6 * Pass an `api` instance to hooks, which is bound to the same user and transaction scope as the original request. ## v0.5.5 * Added `authorizationMiddleware` and `customAuthorizationMiddleware` middlewares which allow supporting the passing api keys via an `Authorization` header. * Add the following additional permissions: read, create, update. These can be used for finer grained permission and also to allow specifying permissions via the CRUD names. ## v0.5.4 * Switched to using npm private packages rather than private git repo links. * Updated package.json to specify that nodejs 0.12 is also supported. ## v0.5.3 * Update passport to ^0.2.1 and passport-local to ^1.0.0 * Expose the initialisation promise from server.coffee so that it is possible to wait on it. * Fix in-browser server. ## v0.5.2 * Updated sbvr-types to v0.1.2 ## v0.5.1 * Updated odata-to-abstract-sql to v0.2.4 ## v0.5.0 * Config loader will directly use the customServerCode entry if it is an object. * Config loader no longer tries to use requirejs to load the custom server code - it only uses require now. * Removed the requirejs param from the custom code setup function. * Added support for falling back to bcryptjs if bcrypt isn't available (eg in the browser) * Added support for $expand options (eg $expand=resource($filter=id eq 1)) * Added support for "It is forbidden that.." in the sbvr parser. * Updated lodash to ^3.0.0 * Updated coffee-script to ~1.9.0 * Updated postgres to ^4.0.0 * Updated mysql to ^2.1.0 * Updated express to ^4.11.2 * Updated pinejs-client to ^1.0.0 * Fixed issues with auto incrementing fields on mysql/websql. * Permission filters are now applied to `$expand`s as well. * Improved error messages, particularly for config.json users/custom code loading errors. * Moved express, mysql, passport, passport-local, and pg to optional dependencies, as they are indeed optional. * Fixed certain combinations of permission filters failing to translate. * Added support for loading config.json via absolute paths * Added support for loading pinejs via npm ## v0.4.5 * Fix a `ReferenceError: logger is not defined` when compiling abstract sql fails. * Update abstract-sql-compiler to v0.2.1 which properly supports null comparisons. * Fix visualisation of vocabularies containing term forms. * Fix visualisation links not appearing if you go to the LF tab first. ## v0.4.4 * Fix a `"Cannot parse required checks: false"` error that could happen with permission checking if api key or guest permissions returned `false`. * Update pinejs-client-js to v0.3.1 which supports true/false/null filters, making them easier to use. ## v0.4.3 * Update odata-parser and odata-to-abstract-sql to add support for true/false/null in OData filters. ## v0.4.2 * Update bcrypt to ~0.8.0 * Update bluebird to ~2.3.11 * Update bluebird-lru-cache to ~0.1.2 * Update coffee-script to ~1.8.0 * Updated odata-to-abstract-sql and abstract-sql-compiler to add support for $filter on PUT requests and enhanced security. * Update lf-to-abstract-sql to add support for setting foreign keys nullable in a term form. ## v0.4.1 * Update odata-to-abstract-sql and abstract-sql-compiler to add support for CASTing bind vars to the correct type when necessary (avoids issues in cases where implicit casts failed) ## v0.4.0 * All instances of `platform`/`rulemotion-canvas` have been renamed to `pinejs` * __model is no longer sent on GET requests to a resource. * `ConfigLoader.loadNodeConfig` has been removed (use `ConfigLoader.loadApplicationConfig` instead) * Correctly process expanded results again (an update to `node-pg` made the `JSON.parse` unnecessary and hence fail). * Update to pinejs-client-js v0.3.0, this adds greatly enhanced filter support. * Support has been added for filters on POST requests. ## v0.3.11 * Update resin-platform-api to v0.2.5 * Add an `sbvrUtils.apiKeyMiddleware` connect middleware that can be used to fetch the permissions of an api key on the request and add them to `req.apiKey`. * Add support for running migrations before a model executes: * Can specify `migrations` or a `migrationsPath` in config.json * Migrations which haven't been executed will run in order before the model is executed ## v0.3.10 * Added a PRERESPOND hook for manipulating the response to OData queries * Update sbvr-types to v0.0.2, fixes issues with: * Saying max length of a string is 255 even if it is actually another value. * Sending a colour object to the api. * Sending an invalid JSON string to a JSON field. * Add a __resourceName property in the response to running a rule, so you know what resource you are dealing with. * Built-in web server now logs all requests it receives - not just OData requests * Increase default transaction timeout from 5s to 10s * configLoader.loadNodeConfig has been renamed to configLoader.loadApplicationConfig ## v0.3.9 * SQL queries are only logged when debugging * Dev model .log output is now suppressed * TRANSACTION_TIMEOUT_MS environment variable can be used again ## v0.3.8 * PlatformSessionStore is now exported from module build ## v0.3.7 * Adds a new 'module' build type, which allows you to: * Configure your own express application * Use the platform as a library, rather than having your app loaded as custom code * Added support for `and`/`or` within SBVR rules. * Fix bower requirejs to v2.1.9 as later versions break the platform client-side (due to shim dependencies not working correctly) ## v0.3.6 * Fix internal POST requests that are run within a passed in transaction, introduced in v0.3.4. ## v0.3.5 * Custom code modules no longer have to define a setup() method ## v0.3.4 * Enable disabling the default platform login/logout handling with the `DISABLE_DEFAULT_AUTH` env var. * POST requests now include the whole entity in the response. * Expose `{ app, sbvrUtils }` on the built `platform.js`, meaning you can require it in order to get access to these objects. ## v0.3.3 * Changed config-loader to return 200 for any OPTIONS requests on the API endpoints it sets up. * Added an LRU cache for API key permissions - improves performance for repeated requests using the same API key. ## v0.3.2 * Add API hooks entry for OPTIONS * Fixed an error when handleODataRequest was called from a method it did not recognise for API hooks. * Properly send a 405 for unsupported methods. * Handle responding to an OPTIONS request, and use the model permission for it (since it's a metadata request) ## v0.3.1 * Updated pg to v3.3.0 * Update bluebird to v2.2.1 * Improved performance of SQL queries when we do not need to bind any default values. * Improve performance of creating a transaction. * Improve performance of all PostgreSQL queries and any SQL queries that bind default values. * Improve the performance of PostgreSQL queries when there are no binds in the SQL. ## v0.3.0 * Change runURI signature from `(method, uri, body = {}, tx, callback) ->` to `(method, uri, body = {}, tx, req, callback) ->`, where if `req` is an object then it will have its `user` property used for permission checking rather than using the default of full permissions if it's not an object. * Update sbvr-parser to v0.0.12 * Fixes an error being logged when trying to get hints for the verb part of a new fact type * Fixes rule-like definitions for terms and names * Fix an issue where api keys that looked like valid user ids were treated as a user id. * Replaced `runGet`, `runPost`, `runPut`, and `runDelete` with a new middleware called `handleODataRequest` that can be used in their place. * Updated bluebird to v2.1.3 * The `checkPermissions` function had its `res` argument removed. * Added API hooks facilities via `sbvrUtils.addHook` with the following hook points: * POSTPARSE * PRERUN * POSTRUN * In the case of trying to respond to a request with an `Error` instance, we instead send the `message` property instead, as it's generally much more useful. ## v0.2.29 * Update ometa-js to ~1.3.0 and use the new line by line highlight option, which removes the need for the custom codemirror change and also updates to work with the latest codemirror (including a switch to the newer hinting module). * Update codemirror to v4.2.0 and load it from bower now that a custom change is no longer needed. * Use a SQL hinter for the database import/export tab. * Improve generic error messages returned for foreign/unique key violations in cases where detailed info cannot be obtained. ## v0.2.28 * Add support for a TRANSACTION_TIMEOUT_MS env var, that specifies how long before a transaction is automatically closed (via a rollback). * Use error codes to detect the error type for postgresql, this makes the checking much more resilient. * Updated bluebird to ~1.2.4 ## v0.2.27 * sbvrUtils.executeModel and sbvrUtils.executeModels now expect a model object, rather than vocabulary name/sbvr text. * Improved constraint failure checks for WebSQL. * 500 errors are now used correctly, rather than incorrect 50x variants. * PUT requests are now correctly rolled back on a rule violation * Database errors (that are not related to constraints) now return a 500 and no longer leak the error to the client. * Logging levels can now be configured on a per-model basis. * Session model requests now only log errors.