feathers-sequelize
feathers-sequelize copied to clipboard
A Feathers service adapter for the Sequelize ORM. Supporting MySQL, MariaDB, Postgres, SQLite, and SQL Server
### Steps to reproduce Build a feathers instance using Postgres with a JSONB Column. The resulting object lets say for the sake of example looks like this: ```javascript var user...
https://github.com/feathersjs-ecosystem/feathers-sequelize/blob/165288f644e5b5a54a5dca6bcd10f4ad3d8d67ee/lib/index.js#L144 This line makes sequelize to use primary key instead of `*` while `options.col` is not defined in model `beforeCount` hook. That causes `count` on the first primary key which...
I want to put a sequelize.literal query under `Op.and` symbol before `get` and `patch` method to attach an `EXISTS` query. But at the same time, seems like because of the...
### Steps to reproduce I'm not 100% sure if this is a bug or if I'm misusing something, but here goes. This is a port of the chat app to...
Multi-patch without `$limit` in `params.query` results in an incomplete operation, because `filterQuery` adds the default `$limit: -1` to the request. Not sure if this problem exists in multi-remove as well....
## Issue Description I am using sequelize(postgresql) with feather js which throws an uncaught exception ``` RangeError: "size" argument must not be larger than 2147483647 at Function.Buffer.alloc (buffer.js:233:3) at module.exports.Reader.addChunk...
Sequelize with `version: true` option for models does internal optimistic locking. But if you want to provide your own version, to do "manual" optimistic locking from an api level you...
Follow up from https://github.com/feathersjs-ecosystem/feathers-sequelize/issues/211. Managing relationships with Sequelize is quite strange. For example it doesn't allow updating nested entries and creating nested relationship does not include them in the result...
This covers situations where a user might want to instantiate a model in the "before" phase of a service. This is useful if a user wants to trigger getters/setters/validations and/or...