odata-objection-pg Service modules - PostgreSQL Connector
Odata services requests from a PostgreSQL data store for Objection.js (knex.js) ORM for Node.js
This is a modified and specific version of odata-v4-pg. That library has forked and moved here as I continue to develop it.
The odata-objection-pg Connector provides functionality to convert the various types of OData segments into SQL query statements suitable for Objection / knex.js raw() where clause
This library assumes your Nest/Objection/knex are leveraging Postgre snake_case for table names. As such, OData queries for camelCase properties will be converted to snake_case automatically.
In knex.js - Named bindings such as :name are interpreted as values and :name: interpreted as identifiers. Named bindings are processed so long as the value is anything other than undefined.
As such, odata-objection-pg will set placeholders as :0 (index value) for all placeholders.
This helps alleviate issues for
createDate eq null statements, that are absent of any placeholders. With named bindings, this does not present a problem.
Potential usage scenarios
- Nest.js & Objection.js (or direct Knex.js) library helper
See the (index.spec.ts)[./src/lib/index.spec.ts] for sanity tests
Usage as server - TypeScript
//example request/query filter:const raw = ;const sDay = moment;const query = $filter: `(startDate ne null or startDate ge '')` $expand: '' ;Object;await Person;}
Supported OData segments
Change the version in your package.json or use npm version .
npm version patch
After changing the version number in your package.json, run
npm publish to publish the new version to NPM.
npm install will install the latest version in the NPM repository.