github.com/openfoodfacts/openfoodfacts-query commits

Merge pull request #38 from openfoodfacts:redis-url

Pass redis url to container

36bfea06320e3f6a6dd379d1df38924f7e385cd8 authored 10 months ago by john-gom <[email protected]>

Pass redis url to container

05b7f7dd7778fa04b9a32528f476f01bab123134 authored 10 months ago by John Gomersall <[email protected]>

Merge pull request #37 from openfoodfacts/fix-env

Fix environment for deploy

58fc2ed76628af2d7c35df9b6ddcc7084b929c5a authored 10 months ago by john-gom <[email protected]>

Fix environment for deploy

05cdc3ae6b0dc74a2236cade4499a352829bc9cd authored 10 months ago by John Gomersall <[email protected]>

Merge pull request #35 from openfoodfacts/configure-redis

Add redis configuration for staging and production

4e1e4931286a9095a22224b53ca043a381f308d1 authored 10 months ago by john-gom <[email protected]>

Merge branch 'main' into configure-redis

0af29353b5e9e159e9757786c66161c7ce8d406a authored 10 months ago by john-gom <[email protected]>

Make most import messages debug level

d0431b1887474c26b7b614f49d4375978d9e6827 authored 10 months ago by John Gomersall <[email protected]>

Default to no redis for local dev

5afb35d6a73497adaff6aeb5ae3aeade87a89175 authored 10 months ago by John Gomersall <[email protected]>

Make docker more explicit to avoid unnecessary builds

29ac449a0c0a4f5f354b463046dfa8f6ad53837f authored 10 months ago by John Gomersall <[email protected]>

Disable redis for tests

346d8b59dada697f4ed459a3b2e49366cfce111d authored 10 months ago by John Gomersall <[email protected]>

Merge pull request #36 from openfoodfacts/chore-always-restart-in-prod

chore: always restart in production

c96c987196a325abd3ebc8ac0712db546c46a16e authored 10 months ago by Raphaël Bournhonesque <[email protected]>

chore: always restart in production

7d87af7a4370b32bfe1e1d032e3b681a7c5b7217 authored 10 months ago by Alex Garel <[email protected]>

chore: always restart in production

592b36453afad4d83b42546fb7f3800c7fd63f8f authored 10 months ago by Alex Garel <[email protected]>

chore: always restart in production

38436a22dfea69349c135ed9247ab36046017c69 authored 10 months ago by Alex Garel <[email protected]>

Add redis configuration for staging and production

a49bca42e68e836922ace17b3acb6b95cf3068a3 authored 10 months ago by John Gomersall <[email protected]>

Merge pull request #32 from openfoodfacts/chore-mongodb-stunnel-client

chore: change prod mongodb address (again)

d821661a049d450c5fccfe6e616ea19c6068d382 authored 12 months ago by Alex Garel <[email protected]>

chore: change prod mongodb address (again)

Use stunnel-client container for more security.

ec675e83aff5e4292b3dd7a24fce6f0bfd9cb8cc authored 12 months ago by Alex Garel <[email protected]>

Merge pull request #31 from openfoodfacts/chore-mongodb-migration

chore: new mongodb connection through stunnel

27e9add087d7fd280252ba8cc72b4ee4c72c7e0b authored 12 months ago by john-gom <[email protected]>

Make sure log level is passed to docker

29b543fe1298697f09e09aa43df1cf0fff093995 authored 12 months ago by John Gomersall <[email protected]>

Override log level for deployment

e12da33ff2c8f2d1d6f445d9685f253e2bea83c6 authored 12 months ago by John Gomersall <[email protected]>

Merge branch 'main' into chore-mongodb-migration

17e518638acabf19de7c80e366500843f6806a5a authored 12 months ago by john-gom <[email protected]>

Merge pull request #29 from openfoodfacts/issues/19

Skip if already importing and deal with invalid dates

dad4abb33e852aacfdb96df54f69b6d101479676 authored 12 months ago by john-gom <[email protected]>

Fixed typos

faa1b5a0e201579c89ff60685b52442b0231b5d8 authored 12 months ago by John Gomersall <[email protected]>

chore: new mongodb connection through stunnel

09701f71394e1a2de15a04ff8a79bdd2a4997339 authored 12 months ago by Alex Garel <[email protected]>

Allow log level to be specified

c3a7c6f7b7602d11d2c4aeb429a914877521a6d4 authored 12 months ago by John Gomersall <[email protected]>

Skip if already importing and deal with invalid dates

7bcc86e955ce771807499ac0a063dd76f68a6972 authored 12 months ago by John Gomersall <[email protected]>

Merge pull request #28 from openfoodfacts/fix-redis-test

Allow time for the Redis testcontainer to start

980f60a329de6c35f63b426c5da0d0fd873012d2 authored about 1 year ago by john-gom <[email protected]>

Allow time for the Redis testcontainer to start

9c7d916b54d033f472fd6ac975e2b92cbdad9592 authored about 1 year ago by John Gomersall <[email protected]>

Merge pull request #27 from openfoodfacts/ingredients

Support for Ingredients and Redis

d38d19cf026db4f00c9fcb5aa8becbca0757e672 authored about 1 year ago by john-gom <[email protected]>

Addressing PR comments

6bcd6cddc01fdea1329992c1192d9f0e49719df3 authored about 1 year ago by John Gomersall <[email protected]>

Move migration to global setup (looks like previous issue is fixed)

1856b461d52a8714abb771f08eda1ecc1535860b authored about 1 year ago by John Gomersall <[email protected]>

Save lastMessageId in the database

633f1895ca34ac86674ba7a81cf640e55eb78214 authored about 1 year ago by John Gomersall <[email protected]>

Add redis tests

e1819c56073da5a8e29cdb0020a620d1c258537b authored about 1 year ago by John Gomersall <[email protected]>

Few more tags on detailed review

7b4b00683627a6caa12fe662e15fb36cf203edfe authored about 1 year ago by John Gomersall <[email protected]>

New tags that could be found in sample data

5c3a3515f2d735f0751511664d7836716828310f authored about 1 year ago by John Gomersall <[email protected]>

Make sure settings are saved properly

2903011fbb81348bb0f23eedbc18a16ca3d895c9 authored about 1 year ago by John Gomersall <[email protected]>

Use a stored date for incremental updates because of Redis support

cc427b553e91f8f3598e7b903f2cc3ea7567c72f authored about 1 year ago by John Gomersall <[email protected]>

Automatically do a full import iof new tags have been added

f426a69a89d84d221561c999190df4a700c8eb97 authored about 1 year ago by John Gomersall <[email protected]>

Add source

a40b0dd09f042e7a2fa7a07f6f60d297123aaae3 authored about 1 year ago by John Gomersall <[email protected]>

Fix transposed tags

ce8372fab324674da50132ed8e49ed5f9fcddc11 authored about 1 year ago by John Gomersall <[email protected]>

Typo

162af018b4b7801fbdf948f1b04fd83374e25857 authored about 1 year ago by John Gomersall <[email protected]>

Add import from Redis

4425286cd75b39869a89abfbfda2816ec87f817b authored about 1 year ago by John Gomersall <[email protected]>

Switch percent to string and add method to fix tags

2c8e1fb52088231cb99fc2fb887b4e35a5c1b650 authored about 1 year ago by John Gomersall <[email protected]>

Migration down convenience task

34988a668652e34bb5a2d5fe0fe0adba0bce41ef authored about 1 year ago by John Gomersall <[email protected]>

Adding ingredients

cfc17dba460c06e8ee07896ea63748a326337758 authored about 1 year ago by John Gomersall <[email protected]>

Switch from JSONB to JSON to improve insert performance

4cb7e9e8896e8e38d9b9cf30eff97dcea06640fa authored about 1 year ago by John Gomersall <[email protected]>

Merge pull request #25 from openfoodfacts/issues/24

Cope with $in / $nin unknown queries

4d97969d48e346aa91e83b627dc413b64a62f868 authored about 1 year ago by john-gom <[email protected]>

Notes on adding new tags

c9c68faca9ba6801381eb0ff02f217057cb2ebdb authored about 1 year ago by John Gomersall <[email protected]>

Simplify adding new tags and resolce review comments

3ea2fcb40e8cf3b774ad1dc4c3e1704cdd034821 authored about 1 year ago by John Gomersall <[email protected]>

Extra $nin test

0fe79e03896d4335fcbe29e101a3c0f236ad15c6 authored about 1 year ago by John Gomersall <[email protected]>

$nin null

bcd5c2fa8e598c186d62f351affc2e5e3e5a8804 authored about 1 year ago by John Gomersall <[email protected]>

Cope with $nin

55ac6f298ec41601c07e36fcbae67a22055119c4 authored about 1 year ago by John Gomersall <[email protected]>

Cope with $in: [null,[]]

18ddd20c5e107510aefdd9f4f1b0036d958c26b5 authored about 1 year ago by John Gomersall <[email protected]>

Make sure unknown value objects are thrown correctly

b3b0470102bfc80c8506ab9145dcb2db5b3b510d authored about 1 year ago by John Gomersall <[email protected]>

Merge pull request #23 from openfoodfacts:test-failure

Use a different tag to test loaded tags is updated

78c473643abfeeb7566147d3a241a7e837966e50 authored about 1 year ago by john-gom <[email protected]>

Prevent any deletions during import test to avoid interference

be6aa26fa82d1071fc429c4d9b5292a115b58e9b authored about 1 year ago by John Gomersall <[email protected]>

Use a different tag to test loaded tags is updated

084ba62e2560aaa4e47c03396f68a11a2d721555 authored about 1 year ago by John Gomersall <[email protected]>

Merge pull request #21 from openfoodfacts:issues/20

Support $in but not other value objects. Fix NOT on count

feae0f21def9932ff6d3b0f2b136cce6e7605740 authored about 1 year ago by john-gom <[email protected]>

Support $in

4a9b2ea3d790eb17da1e5392f45ab19cdd5c1307 authored about 1 year ago by John Gomersall <[email protected]>

Refactor where to use structured approach

a56813221c9a822ca101093524957b6610bbedb8 authored about 1 year ago by John Gomersall <[email protected]>

Throw unprocessable exception for unhandled value types

bea1f480261ce59f98cd246faf506a63be5b0167 authored about 1 year ago by John Gomersall <[email protected]>

Fix issue with NOT on count

62167f790165f0fbbbb8371da5fb80b3a40e5f76 authored about 1 year ago by John Gomersall <[email protected]>

Merge pull request #18 from openfoodfacts/issues/17

bug: Wrap delete and insert of tags in a transaction

dae02147b1480955446f3cdbe7c23f4d37ec073a authored about 1 year ago by john-gom <[email protected]>

Add timeout for query tests too

89392be9f2e037f348da96fb7ad73b59eff5dca1 authored about 1 year ago by John Gomersall <[email protected]>

Increase timeout for import test

9866af4c29a91b564ddec4e438360844675bbb6c authored about 1 year ago by John Gomersall <[email protected]>

Wrap delete and insert of tags in a transaction

6afa19854c884fd478c579d19ddbe84796b3bf45 authored about 1 year ago by John Gomersall <[email protected]>

Merge pull request #16 from openfoodfacts/issues/15

bug: Cope with nuls in tags

0c73b8f78e5d32ad28ee4ad68ab714cc153f1e99 authored about 1 year ago by john-gom <[email protected]>

Log when values have been stripped

fc91cafab8e97b4265c102db909f03d5abf156ba authored about 1 year ago by John Gomersall <[email protected]>

Strip nulls from data

974390c1eb0b74283bafca80a5198f8c818747b4 authored about 1 year ago by John Gomersall <[email protected]>

Test to catch nul characters

ced861bebe84d398650bd4379b09c0c42e4ebace authored about 1 year ago by John Gomersall <[email protected]>

Merge pull request #14 from openfoodfacts/issues/10

Support additional tags and query operators

90993a58545c27f8594686fc4c7ffc962e961cf7 authored about 1 year ago by john-gom <[email protected]>

Delete products not touched on full import

606cbbeab9afe72af71547dd14827672df27bec4 authored about 1 year ago by John Gomersall <[email protected]>

npm audit fix

63aec888d5ad1c737b04a9e0b3e8b5b6aaf9ee87 authored about 1 year ago by John Gomersall <[email protected]>

Add scheduling of refresh

e9d8acd0f5aa6b2abdca30998d4d62e8685e1a20 authored about 1 year ago by John Gomersall <[email protected]>

Extra comments

f3bc1eb20d6e802672f68970510c709eccd16ec3 authored about 1 year ago by John Gomersall <[email protected]>

Make obsolete a query parameter rather than changing the query body

7abb0ce48eb72289d307e01a63737299f57035ec authored about 1 year ago by John Gomersall <[email protected]>

Remove redundant code

8b1280dd2f406d922d563235ef263bd65ed40448 authored about 1 year ago by John Gomersall <[email protected]>

Generic all handling

ecc563cc0882d3c7d1e0070d1dd8ec18ace22e0e authored about 1 year ago by John Gomersall <[email protected]>

Cope with $and

c034aae87760b016b9fcf4e377fc37696303c546 authored about 1 year ago by John Gomersall <[email protected]>

More tags

c5d3a70273e96a6bc2681a0274baf6ef7f3689b7 authored about 1 year ago by John Gomersall <[email protected]>

Cater for $all

c9c9c40b3a42127a5cfe6f31a9fe3bcbb09c1b02 authored about 1 year ago by John Gomersall <[email protected]>

Don't import unless a tag is fully loaded

b2a73c6fd67f13d202ba44878764562839d2abe7 authored about 1 year ago by John Gomersall <[email protected]>

Populate loaded tags on import

acf927c0a7387cb887f4ff1c3ea809dbe027d84c authored about 1 year ago by John Gomersall <[email protected]>

Comments and lint fixes

f423bc95ec10d8876460a071a435ec86391d5602 authored about 1 year ago by John Gomersall <[email protected]>

Incremental import on full load

b8dababe7c8614830f0bdc430c0d8fa9a3ae2a77 authored about 1 year ago by John Gomersall <[email protected]>

Failing test for full import to not delete

ad0f9ff2629a307aedce78decca5e52d66e1a7d6 authored about 1 year ago by John Gomersall <[email protected]>

Merge pull request #11 from openfoodfacts:filter-by-product

Fix matching on a product column

8e61d5da64a481562a393f332473f2a8d23034c3 authored about 1 year ago by john-gom <[email protected]>

Fix matching on a product column

5e02974d151dce3c2d1f57bb23b61e461c39d57e authored about 1 year ago by John Gomersall <[email protected]>

Merge pull request #9 from openfoodfacts/obsolete-handling

feat: Obsolete product handling

35b2a1f7a0f8bfb22ef37d80ef929f5c72e6fe31 authored about 1 year ago by john-gom <[email protected]>

Fix spelling

72b0f2b0876e4fe54c5cb16a6086d8521cfb024d authored about 1 year ago by John Gomersall <[email protected]>

Fix aggregations where Product field is at the root

012c642da2ffa1f8b6dc9aedb64c97a77acf5895 authored about 1 year ago by John Gomersall <[email protected]>

Lint fixes

552b49ba2c5abb5e94d0318726e6d33497fbecc7 authored about 1 year ago by John Gomersall <[email protected]>

Cope with supplied false obsolete value

143a25acc85c367bfa3b3ad66042ce8af393ff84 authored about 1 year ago by John Gomersall <[email protected]>

Fix postgres port mapping

54c0f10bc0871f96356cb07bb260794e4e86ef18 authored about 1 year ago by John Gomersall <[email protected]>

Support obsolete on select

02e3aae0c43e8be715353d2f7e4ee3511c103d81 authored about 1 year ago by John Gomersall <[email protected]>

Fix test for obsolete aggregate

1bc3d90d4bfeaf3d0853c9325a5feeabfd98006b authored about 1 year ago by John Gomersall <[email protected]>

Fix obsolete for count

3ae28791b6373c4694faca6c391c0f4938bf1d78 authored about 1 year ago by John Gomersall <[email protected]>

Failing test for obsolete

3f208eb562c032b1f04f2d3807c601039f498d99 authored about 1 year ago by John Gomersall <[email protected]>

Listen at 0.0.0.0 so that docker can call through to host

ccdc7c991be7396439378336fba3b6d6ac368b50 authored about 1 year ago by John Gomersall <[email protected]>

Merge pull request #7 from openfoodfacts:select-service

Add select service for testing

cf19c212bd3fbee28718f410c34362f0cf3b3c99 authored about 1 year ago by john-gom <[email protected]>

Ecosyste.ms: OpenCollective

github.com/openfoodfacts/openfoodfacts-query