Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

github.com/TryGhost/mongo-knex


https://github.com/TryGhost/mongo-knex

Updated all dependencies

- this commit updates all dependencies and makes minor code changes to
accommodate for new lin...

bc5e6a2762f7b4fa244e80228d09890b2071026b authored almost 3 years ago by Daniel Lockyer <[email protected]>
Updated database related dev dependencies

- `@vscode/sqlite3` is a better maintained fork of sqlite3 but requires
the latest knex versio...

98ca6f174a8ff58c757f8265a00b4dfccbf2cdb6 authored almost 3 years ago by Daniel Lockyer <[email protected]>
2022

45783457dd0eb92f409c68a8627f09e68dd15b5e authored almost 3 years ago by John O'Nolan <[email protected]>
v0.5.0

d7fae0741940d80892e3fd44ee8ed30d73a18e89 authored over 3 years ago by Fabien O'Carroll <[email protected]>
Added support for joining to virtual tables

refs https://github.com/TryGhost/Team/issues/944

Currently mongo-knex does not allow setting up...

a1a7e4a7b31baa5609bca4e76d60b4e068fd0b60 authored over 3 years ago by Fabien O'Carroll <[email protected]>
Supported custom foreign keys for joined resources

refs https://github.com/TryGhost/Team/issues/944

This allows us to support join tables which do...

d901959875652f303794585b8e0e56d8fd10f301 authored over 3 years ago by Fabien O'Carroll <[email protected]>
v0.4.1

1a8f51548aa3287ff48517b8a9b8cddf70589276 authored over 3 years ago by Daniel Lockyer <[email protected]>
Bumped minimum versions of dependencies

no issue

- this bumps the minimum versions of the dependencies to keep things
fresh and to ov...

70b2da89de98d9548753f2ab333744dd7f27e68e authored over 3 years ago by Daniel Lockyer <[email protected]>
2021

33e26940d06f52c382489994062f04766b6d075b authored almost 4 years ago by John O'Nolan <[email protected]>
v0.4.0

241a186e6d69bb00cae3facd05f5ad0c3f4877cd authored about 4 years ago by Naz <[email protected]>
Fixed negation queries with "whereNull" comparison

no issue

- `whereNull` and `whereNotNull` didn't go through double negation converation needed...

1681915ccc733dfd944e8f21a97f6fe3be7bde46 authored about 4 years ago by Naz <[email protected]>
✨ Added 1:1 relation filtering support (#36)

closes #35

- Support for 1:1 relation is needed to solve https://github.com/TryGhost/Ghost/is...

cc8762d325f1829ea273a55835a2a65b64ef1352 authored about 4 years ago by naz <[email protected]>
Bumped sqlite3 to 4.2.0

no issue

- The tests are failing otherwise and this is the version which is shipped by default ...

917e4dadf1f66167f0f89d6418c8465bf96bea3e authored about 4 years ago by Naz <[email protected]>
2020

8bf33496dea5f306ab3535fcce0f4d9830d44a16 authored almost 5 years ago by John O'Nolan <[email protected]>
2019

e4838b7ca662115bc4eaed3921ca33aa36f3038b authored almost 6 years ago by John O'Nolan <[email protected]>
v0.3.0

da0297c537ea5b347c7703c793c94f4f70d39c5f authored about 6 years ago by Nazar Gargol <[email protected]>
:boom: Changed relations configuration key names to have consistent naming (#30)

closes #4

0c996e8b68892f789c6258564f346e9efde85f60 authored about 6 years ago by Naz Gargol <[email protected]>
:bug: Fixed group key collision (#29)

closes #21

- Added test case showing key collision is a reproducible issue
- Fixed group key...

c21474cdee22e5e817f3bd7ae5de4fdcb65b2cff authored about 6 years ago by Naz Gargol <[email protected]>
v0.2.0

1f7dbafbf5e4d596936567b06fcf2a10941dddac authored about 6 years ago by kirrg001 <[email protected]>
✨Added support for comparison operators: $gt / $gte / $lt / $lte (#26)

closes #26

a488b3c8e3a7ad46d9df0ee7c71c0535812945eb authored about 6 years ago by Naz Gargol <[email protected]>
πŸ› Fixed handling if statement was not detected as a relation (#28)

closes #27

- see comments on https://github.com/NexesJS/mongo-knex/issues/27
- see https://g...

9c89f145f7187fcb401336776126ce7a3f0b73f8 authored about 6 years ago by Katharina Irrgang <[email protected]>
Added test assertions to avoid false positive results

closes #23

- decided to go with simple id matching for now
- future improvement could be: retur...

2899f351e61e49880517d3ab25da364a328f8a66 authored about 6 years ago by kirrg001 <[email protected]>
Clarified unclear test describe

no issue

- there was a describe which was called `Multiple where clauses for relations`
- it wa...

b30ee7de82e81bc32d9163f477bbf7f2b51e2e46 authored about 6 years ago by kirrg001 <[email protected]>
Removed empty test describes

no issue

- also removed the test fixtures
- the many-to-many-extended-cases equaled many-to-man...

ad34da2ebceda592b228afd97fd427f10f10617a authored about 6 years ago by kirrg001 <[email protected]>
Enabled and moved complex $or conjunction case

no issue

161fb3d404dd2f1602f54f2f46f6af4403f4aeb3 authored about 6 years ago by kirrg001 <[email protected]>
Moved count tests to correct place

no issue

b054917a6ecee3f750f3d2655e367ddba7e19491 authored about 6 years ago by kirrg001 <[email protected]>
Enabled and moved extended $or conjunction cases

no issue

- these tests were not covered and not enabled

4c5801f4b613000ebd107177ebf0c40d54a489f2 authored about 6 years ago by kirrg001 <[email protected]>
Enabled and moved extended $and conjunction case

no issue

- this test was not covered/enabled yet
- Ghost only uses many-to-many relations for n...

eaf3937eef09f354638fcc4e3676d94833da337c authored about 6 years ago by kirrg001 <[email protected]>
Tidied up relations_spec: moved not implemented relation types to bottom

refs https://github.com/NexesJS/mongo-knex/issues/19#issuecomment-444237523

- one-to-many and o...

64b026152bd891ebd4d487ba87c6c1929c10369c authored about 6 years ago by kirrg001 <[email protected]>
Removed occurrences of aliases

refs #4

- mongo-knex does not know about the aliases/expansions concept
- mongo-knex receives a...

762c2f98129428639e0f264372020559c00523d3 authored about 6 years ago by kirrg001 <[email protected]>
Added ability to define table join name

no issue

- e.g. you query `authors:pat`
- but the target table is called users
- it's helpful t...

94b35faac27c164cbd6bf739c012462519fa0b29 authored about 6 years ago by kirrg001 <[email protected]>
Added same table test coverage for $ne

closes #7

- added some simple tests for same table negation
- renamed test file from where.test...

8f4ce69a7cfa95f01435d054d957ea523ef1d7c9 authored about 6 years ago by kirrg001 <[email protected]>
:art: Added support for negation and conjunctions on join table in M:M relations (#18)

refs #5
refs #7

- Improved group comparison operator check
- Improved negation handling in ...

677b0a3b1453c399c8d1356a515260fcaae656dc authored about 6 years ago by Naz Gargol <[email protected]>
Refactored relations test suite and some general improvements

no issue

- General structural improvements and reshufles in relations.test.js
- Extended existi...

8c51d42d4597e3c3f0ea94d1897a7a2defa71dc1 authored about 6 years ago by Nazar Gargol <[email protected]>
Refactored relational table/column names variables into more explicit ones

b9de0186127b47e08897dd893f18ac3cc86f8575 authored about 6 years ago by Nazar Gargol <[email protected]>
v0.1.2

47a50251dfba4314aee5eb1b4e1794e8deec3a93 authored about 6 years ago by Nazar Gargol <[email protected]>
🎨 Added more cases for $or and $and conjunctions

refs #5, refs #7

- (tags.slug = animal and sort_order = 0) OR visibility:internal (group)
- tag...

8b6a12f83b15cc5f88adad48ad2cae46aaa0ec9d authored about 6 years ago by kirrg001 <[email protected]>
Increased timeout for tests

no issue

65f4edbce2d4f1529ac84ed4f6b5450da3389002 authored about 6 years ago by kirrg001 <[email protected]>
Added some code comments

no issue

7c8b6a700c26350519fe56b1015f39f9fae8fedd authored about 6 years ago by kirrg001 <[email protected]>
Optimised the code a little

no issue

d323a40091d903e449a3001025f0049b9721b266 authored about 6 years ago by kirrg001 <[email protected]>
🎨 Added another $and conjunction case

refs #5

- $and: [{'tags.slug': 'animal'},{'tags.slug': {$nin: ['classic']}}]

30c1fb54b38594b6108b67329b35985c91edaa97 authored about 6 years ago by kirrg001 <[email protected]>
✨ Added support for one negation case for relations

refs #7

- `tags.slug:-animal`

6f9adfb3861b00320ad784023116226fe9927a2e authored about 6 years ago by kirrg001 <[email protected]>
✨ Added support for one $and conjunction case

refs #5

- $and: [tags.slug:en, tags.slug:de]

e32cb21742a489dd2186ff0d56596a6a45633e26 authored about 6 years ago by kirrg001 <[email protected]>
Added post without tags to test suite1

no issue

627e8a88248a4b34e9373f98d5322fb8012c940b authored about 6 years ago by kirrg001 <[email protected]>
Updated README.md

no issue

- how to show debug logs?

c6958992acf51a4890f12dd1177632e2f2dab1cb authored about 6 years ago by kirrg001 <[email protected]>
✨ Added support for filtering by multiple relation columns (#15)

closes #14

- the code becomes a little hard to read, but i'd not refactor it till we have all...

44cd6232c296b5bc454e22c583e64bff0f1d25e3 authored about 6 years ago by Katharina Irrgang <[email protected]>
v0.1.1

771cc0b99caf949b278b3ffe036dd44760e23afd authored about 6 years ago by kirrg001 <[email protected]>
Added defaults for config objects

no issue

1d5f0ac7d3d15e37f360937c8ffd49efbeff0c2d authored about 6 years ago by kirrg001 <[email protected]>
v0.1.0

60561496c0f367e4eba4fc23ead954a2cab3d007 authored about 6 years ago by kirrg001 <[email protected]>
✨Added support for relations: OR conjunction cases (#12)

refs #5

- supports for many to many relations:
- tags.slug IN (animal)
- featured:true ...

055ecce23d78156e9e3879fdaad8ba6e8631bde8 authored about 6 years ago by Katharina Irrgang <[email protected]>
Added code comments

no issue

e9f4b107fc8d56c29b8c8fc9fcabb70ece233a4f authored about 6 years ago by kirrg001 <[email protected]>
Improved debug logs

no issue

- DEBUG=mongo-knex:*
- DEBUG=mongo-knex:converter
- DEBUG=mongo-knex:converter,mongo-k...

5c07f8c1645c7df6abe880ba817f7964125f1361 authored about 6 years ago by kirrg001 <[email protected]>
Used constantly const

no issue

d123401a3cd3a91cfd7f92d3367e7f2cd08cde92 authored about 6 years ago by kirrg001 <[email protected]>
Clarify the `qb` object usage

no issue

- tidy up/clarify

08b6e27eb6f00e98a812fe3c0c0931628a2fd2db authored about 6 years ago by kirrg001 <[email protected]>
Replaced `print` with `debug`

no issue

9d545031a20dcc9be8e949863ed627360c877835 authored about 6 years ago by kirrg001 <[email protected]>
Extended test cases for relations filters

closes #3

- Added base cases for M:M relations filtering

2185a1bd9302bed3f78d23e5c2886f5642f81dc5 authored about 6 years ago by Nazar Gargol <[email protected]>
Added .travis.yml (#11)

closes #9

38c6422f7b1dd90c75c890373851b7a03796b304 authored about 6 years ago by Katharina Irrgang <[email protected]>
Bumped eslint-plugin-ghost to version 0.0.27

no issue

7ff7ce6b4a7f6c6956f5e74f8317114eaa4d89d0 authored about 6 years ago by kirrg001 <[email protected]>
Fixed MySQL tests & simplified test utility

closes #10

- MySQL did not work
- e.g. constraints could not be added
- e.g. table order wa...

2e7777b8f156e0f87e5f57c47387fd385314d110 authored about 6 years ago by kirrg001 <[email protected]>
Added --exit for `yarn test`

no issue

- mocha automatically forces an exit

d8e548efce5bdcefb0d3fd80855fdbc91ce7b613 authored about 6 years ago by kirrg001 <[email protected]>
Updated README.md

no issue

05d4b16ac3c5f8196fa78d366f4822a7432016bc authored about 6 years ago by kirrg001 <[email protected]>
Fixed test utility: debug & logic

refs #10

8b5337c8b4c7fefc3c33275545ae3399747b68fc authored about 6 years ago by kirrg001 <[email protected]>
Added working and simple integration test

refs #10

b26c209c1a38c6f8daeb84062c5c2a268abad0ed authored about 6 years ago by kirrg001 <[email protected]>
Added config support

refs #10

- we need a proper way of reading a database config

3ae36feaa89f92a10fb4511dcebc4fc8dd5eab07 authored about 6 years ago by kirrg001 <[email protected]>
Added framework for integration tests (#1)

refs #2

- we will use knex to test real scenarios e.g. relations, complex uses cases
- adde...

5ad50cabd1837e3afc5361a863252c59f02577d3 authored about 6 years ago by Hannah Wolfe <[email protected]>
v0.0.1

69c747b55a21c65b6fa254f69b383069c241ac40 authored over 6 years ago by Hannah Wolfe <[email protected]>
🎨 Added simple join detection

- Detect where fields already contain a table, and don't prefix the base table
- E.g. `tags.slug...

495deaaa0f7375076653ace4792fd7ed535fb178 authored over 6 years ago by Hannah Wolfe <[email protected]>
πŸ›  Added basic convertor tests

- Checks that the most common converter paths work well
- Same test suite as NQL and NQL-Lang

2417c00f2eab52e82ac8ee8bbf4a3c38b3ed106b authored over 6 years ago by Hannah Wolfe <[email protected]>
πŸ›  Changed `yarn test` to support args

- The existing implementation means passing args to `yarn test` gets misunderstood
- E.g. yarn t...

9507260cd4d035a5ec91f0b0991b3882d8d72bf1 authored over 6 years ago by Hannah Wolfe <[email protected]>
✨ First implementation of the convertor

- Simple convertor, doesn't deal with any context, joins, etc
- Very minimal tests
- Should just...

cc91bf07e7112291d63f442cda61fe5baa7ffa60 authored over 6 years ago by Hannah Wolfe <[email protected]>
✨ Initial commit

7591982463d27986ecb4d659409251e8273f8889 authored over 6 years ago by Hannah Wolfe <[email protected]>