js-data-sql

js-data-sql copied to clipboard

Fix warning when using mysql or sqlite with knex >= 0.16.4

6

Fixes # (it's a good idea to open an issue first for discussion) - [x] - `npm test` succeeds - [ ] - Code coverage does not decrease (if any...

eldridge

Querying through relations

1

I've been working on upgrading all of my js-data stuff to v3 and I've run into an issue with querying through relations. I'm using js-data/js-data-http (both v3) on the front...

scott-taj

``` javascript if (params instanceof Object.getPrototypeOf(this.query.client).QueryBuilder) { ``` should spell ``` javascript if (params instanceof Object.getPrototypeOf(this.query.client).queryBuilder) { ``` Refer to knex source: [client.js#L61](https://github.com/tgriesser/knex/blob/master/src/client.js#L61) for reference. `node -v` yields `v4.6.0` and...

peteut

Investigate loading hasOne and belongsTo using join

2

Currently all relations loaded via `with` are done so using a [subsequent](https://github.com/js-data/js-data-sql/blob/master/src/index.js#L80) `select * from relationTable where id in (...)`. For `hasOne` and `belongsTo` relations, loading these relatoins should be...

techniq

Full-text search support

1

I'm proposing to add the `search` query operator to support full-text search ``` js Comment.filter({ where: { content: { 'search': 'some search terms' } } }); ``` you could also...

techniq

Create tests for specifying other key when loading a "with" relation

3

Need to create some tests for [this change](https://github.com/js-data/js-data-sql/commit/1f4f2bf4a9d8b92330e98d24899b10187bec8017), which requires some new non-standard tables/relations to test against

techniq

Enhancements to "with"

3

Just logging some notes to think about at this point ## Retrieve a subset of properties - asked by aaike on [Slack#i-need-help](https://js-data.slack.com/archives/i-need-help/p1455526001000021) ``` js var users = yield Event.findAll({...}, {...

techniq

LIKEI operator not supported

1

> Regarding to this documentation LIKEI operator should be supported > > http://www.js-data.io/docs/query-syntax > > but it is not - at least for DSSqlAdapter (PostgreSQL) > > Error is :...

jmdobry

Setup CI to test against Postgres

6

Need to [configure](https://github.com/js-data/js-data-sql/blob/develop/circle.yml) Circle CI to test not just MySQL but also Postgres (and possibly others) https://circleci.com/docs/configuration#services

techniq

Need to add a test with regards to PR #53

techniq