Ecosyste.ms: OpenCollective

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

github.com/openfoodfacts/open-prices

An open database of prices šŸ§¾šŸ’øšŸ’°šŸ·ļøšŸ¤‘šŸ½ļø
https://github.com/openfoodfacts/open-prices

chore: add typing information

cc5e383c88bfb9fd69a309230ad691f3b1ac5757 authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: add index on products.price_count field

9fdfdcd14fc8322697f6d35a27846c310d552122 authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: add price.price_without_discount field (#130)

5e3be7309572bd2082023f5775f16c34875bfedc authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: add product.price_count field to keep track of number of prices (#129)

73b32e69377075e24d4768503c1530c483f9115e authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: add price.price_per field (#127)

57402714cb0eee7962d48d340da07e76115ffe33 authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
chore(main): release 1.7.0 (#120)

27b7f0faac4642f44657ca4668c99c11b891e1f9 authored 12 months ago by Open Food Facts Bot <[email protected]>
fix: fix product_quantity DB error

8196bc238b645d3f22d50e87bf3ba3d038fa7f85 authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: add proof.is_public field (#126)

20a4b16651467c82c134f5e5532e3b44a23802b0 authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: fix unique_scans_n null values

b967d5a4eb3a09f93aab4562f7c052d8db7f684a authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: fix product.unique_scans_n server_default

54202d002aad78f0ab3adf036f8eb8b1f7f27403 authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: fix db error (#125)

* fix: fix OutOfRangeError

Some product quantity triggered an OutOfRangeError in PostgreSQL
...

57e4adb41bf29ef94fc5542e3179141f28727c09 authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: add --batch-size param to CLI command

dca9098e949c538e811ecb34a3439ad79137212c authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: products GET endpoint (#122)

* New endpoint with filters GET /products

* Add tests

f80d80bf6370f80da5fe4eaa6551a92b01459e88 authored 12 months ago by Raphael Odini <[email protected]>
fix: fix duplicate key error due to duplicate products

bd6ff9c8b2d531a83469c232988a6c0352583887 authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: import product DB every day (#119)

b60c3ac867d972f31a2c8dd731246d21437e2ecc authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
chore(main): release 1.6.1 (#117)

970ff2c2cfc55c57cda21e79b15d891e5dce9f4b authored 12 months ago by Open Food Facts Bot <[email protected]>
fix: improve price fetch performance (#118)

we were performing heavy model validation on trusted input.

1b65ea22e31fdf38bcbadb58314e200ff095964c authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
docs: add tutorial + improve main doc page (#116)

a01a5a0b043954fb0f5b7c7d078cfed5c91e55fb authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
chore(main): release 1.6.0 (#112)

7f006abed633c5dad9a55c5af938119c45e6ba12 authored 12 months ago by Open Food Facts Bot <[email protected]>
feat: add price filters on category_tag, labels_tags & origins_tags (#113)

* Add filters on Price.category_tag, Price.labels_tags & Price.origins_tags

* Add extra test ...

2a1e350e7ecc5bb6b3aaa0d9042f96a6153c219e authored 12 months ago by Raphael Odini <[email protected]>
docs: add a link to the frontend repo (#111)

cd2f34b90d454ae708e08fb5994b0cecb256e728 authored 12 months ago by Pierre Slamich <[email protected]>
chore(main): release 1.5.0 (#105)

4bfc6b91d3e546da19184a258100570fcf9abdda authored 12 months ago by Open Food Facts Bot <[email protected]>
feat: add price.origins_tags field (#110)

46e0c7fc8de9bf66dd401786cfd83fc7468f6584 authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: add endpoint to retrieve location by osm data (#108)

* Add endpoint /locations/<osm_type>/<osm_id>

* Add tests

b3170148fb4585448de82336fcb871c315228130 authored 12 months ago by Raphael Odini <[email protected]>
feat: add endpoint to retrieve product by code (#106)

* Add endpoint /products/code/<code>

* Update tests

70f4567bf5a97d7014064bae2b0454e04cd6f7e1 authored 12 months ago by Raphael Odini <[email protected]>
chore: improve landing page (#109)

Add button link to the app (/app/)

ee2cbd869f25157204d942db3ce2c3e17b4439b5 authored 12 months ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: return Price.owner info

6e922f30029a9f9558ff070d3dc7c4330dd7e08f authored 12 months ago by Raphael Odini <[email protected]>
chore(main): release 1.4.2 (#102)

3ed09e21639596c460573c13a72694703f3fe3df authored almost 1 year ago by Open Food Facts Bot <[email protected]>
fix: better fetch location city from OSM. ref #38

c37e7a6e85b4999622cd503d7f65481f69050540 authored almost 1 year ago by Raphael Odini <[email protected]>
chore(main): release 1.4.1 (#101)

1c51e734a6b37cea5c7f7e4c09de37dda122048b authored almost 1 year ago by Open Food Facts Bot <[email protected]>
fix: Product.brands should be a string. ref #93

7bbf1fcdf470bf74546ac740870694017b1a35a1 authored almost 1 year ago by Raphael Odini <[email protected]>
chore(main): release 1.4.0 (#99)

4c355cece2e202b2b9ad07dea8817ab227340f80 authored about 1 year ago by Open Food Facts Bot <[email protected]>
feat: add extra filters on GET /prices (#100)

27edae3db6fb00b352192b3e9cdb30f05d6c87e2 authored about 1 year ago by Raphael Odini <[email protected]>
feat: ask for proof type when creating (#95)

* Pass type on proof upload

* Add test

529cdcebb75d95f8f1e3e5596da36cdc51c8b444 authored about 1 year ago by Raphael Odini <[email protected]>
feat: manage webp proof uploads (#98)

830315bff181761eb9c015d931471f81db9a429b authored about 1 year ago by Raphael Odini <[email protected]>
feat: new Product.brands field (#93)

* New Product.brands field

* Get data from OFF sync

fd359dc3b6635455e21c1df8393559d0a7c62224 authored about 1 year ago by Raphael Odini <[email protected]>
chore(main): release 1.3.0 (#86)

8b98d0d062c47868c7bdf4940a1076ecda52ef57 authored about 1 year ago by Open Food Facts Bot <[email protected]>
feat: add sorting on GET /prices (#90)

7139ec950fd44d42d9d6e3a6816c579ca91a4dde authored about 1 year ago by Raphael Odini <[email protected]>
feat: add relationship objects in response of GET /prices (#92)

* New schema PriceFull with product & location objects. Return this for GET /prices

* Add tes...

21566904373fde48a4b5f5a7af11450bf2606896 authored about 1 year ago by Raphael Odini <[email protected]>
feat: add openapi tags on endpoints (#88)

e7b0c14f88e8ae11279ffe7abed06172fda1998b authored about 1 year ago by Raphael Odini <[email protected]>
Add CORS config for frontend app in local. ref #62

e6e56661e368d6f3e18e1243f424ca9f1ebe1564 authored about 1 year ago by Raphael Odini <[email protected]>
feat: add Price.product_name field (#83)

* Add price.product_name field

* Remove index. Fix typo

36d551f441c2cbe83c76680a0f69e98c34a963c4 authored about 1 year ago by Raphael Odini <[email protected]>
fix: fix ProofCreate schema

the proof type is not mandatory

ed345675a414a6f6aea43036de52a914239f9fc6 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
chore: make migration files available in dev

So that we can do a `make migrate-db` without building the image again

494bb96564830d4557c935e54fac8d105238e73d authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: add vue.js frontend on /app

The front-end (the content in the dist folder) must be deployed under
/static/app

- use an ngin...

ca38cbf0fd5222be59c53e650ea114d249c72834 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
build(deps): bump actions/setup-python from 4 to 5 (#81)

Bumps [actions/setup-python](https://github.com/actions/setup-python) from 4 to 5.
- [Release n...

4c8faafd667832020b05e45574c537bc019d2c58 authored about 1 year ago by dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
build(deps): bump github/codeql-action from 2 to 3 (#84)

Bumps [github/codeql-action](https://github.com/github/codeql-action) from 2 to 3.
- [Release n...

36cbfa0b375350bf978ae7c38b4c2126620cec44 authored about 1 year ago by dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
chore(main): release 1.2.1 (#75)

Co-authored-by: Open Food Facts Bot <[email protected]>

25fdec8f23894fabb668f53f83af7d67880afe64 authored about 1 year ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
fix: bump release please version

a37e7daf66548b3c168491d7c68585ed4753c90e authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: fix github config

7edfa8dd9b777c50be2f4f78aa43ef87dd7c93e2 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: fix release please (#78)

a personal access token is necessary to trigger Github actions

86bb5911758c359d6e2218ac836191f58b91fc4f authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: add /api/v1 prefix to all relevant routes (#74)

353e59fb772c3067a1db5db4ecd8d6ad3fe49e60 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
Merge pull request #73 from openfoodfacts/dependabot/github_actions/JamesIves/github-pages-deploy-action-4.5.0

build(deps): bump JamesIves/github-pages-deploy-action from 4.4.3 to 4.5.0

dac5c36faf5c27323dd4bf693b000b82851d215a authored about 1 year ago by Pierre Slamich <[email protected]>
build(deps): bump JamesIves/github-pages-deploy-action

Bumps [JamesIves/github-pages-deploy-action](https://github.com/jamesives/github-pages-deploy-ac...

49eb505f6ee7ddc09536c8a841929e5d196f1195 authored about 1 year ago by dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
chore(main): release 1.2.0 (#55)

Co-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>

3f61b069f57f84af1347219b3ae2c1a1b69d63d1 authored about 1 year ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
fix: improve landing page (#71)

- underline all links
- fix a few sentences (minor edits)

ec79ccc3ff1eac44e65b98ed2e3561227648e674 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
build: improve tests (#70)

* Make tests run on SQlite (JSONB compatibility)

* fix 201

* Add test on labels_tags

* ...

6550898d54a1041b6b56f525f7d32a8b821f6828 authored about 1 year ago by Raphael Odini <[email protected]>
feat: add Proof.type field (#68)

* Add Proof.type field

* Update schema

* remove retailer

d211c0a8b920bc8dc1b9e19c6af0995fed9c15eb authored about 1 year ago by Raphael Odini <[email protected]>
fix: fix labels_tags field validator (#69)

5f23977116d846acf288a031f70da0adac5ce34f authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: simply Price.currency validation (#67)

* Replace sqlalchemy_utils CurrencyType by custom CurrencyEnum

* Rename LocationOSMType to Lo...

d7dfb0cbb3d8e8efeb2f5e6b92cffb5296ab9863 authored about 1 year ago by Raphael Odini <[email protected]>
fix: CORS: revert configuration. add openfoodfacts-explorer to whitelist

e3e9098a766785833500f4bcd0db545f4a374bbd authored about 1 year ago by Raphael Odini <[email protected]>
fix: return 201 instead of 200 on price (& proof) create (#66)

af543cf924f7502000d13b369717d7c22967d980 authored about 1 year ago by Raphael Odini <[email protected]>
fix: CORS: temporarily allow all origins in deployed envs. ref #65

06f2560906f64ceb5add4d850cb15ec15a98b425 authored about 1 year ago by Raphael Odini <[email protected]>
chore: fix CORS config

d4e363a1ccc24d883187cb370df1d15f7327a87b authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: add support for cookie authentication

9e8413d83ed1916cf170a0d1c286a4990adcd540 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: add labels_tags field

This field is used to store labels of products without barcode

ea2bdb07e66a6c302a929a6f1ca348f3f5bf5a54 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: add CORS configuration (#62)

* Add CORS configuration

* Update docker config

* Improve BaseSettings typing. fix typo

79de31bb867c1ea945adf8bab6f12d841012d207 authored about 1 year ago by Raphael Odini <[email protected]>
feat: additional tests on Price create (#60)

* Price create: add tests on product_code & category_tag exclusive validation

* Add tests on ...

bcbcc2aa96767e5ce5abbcb1155f4b5208236e71 authored about 1 year ago by Raphael Odini <[email protected]>
build: fix CI (linting of migration file) (#59)

7634ee788e71e5122d3ea70333cda4bc08760513 authored about 1 year ago by Raphael Odini <[email protected]>
Product schema: inherit ProductBase from ProductCreate

2686533d797a9d1d8e38a05e0ce0fc51c7f5b01c authored about 1 year ago by Raphael Odini <[email protected]>
ProductBase: add description

4f3eadc959bc526f55bdadf3c6d49b34261d9e03 authored about 1 year ago by Raphael Odini <[email protected]>
Add examples

1fa567e27f2fe222e9881658d39b4a6ed187fbe9 authored about 1 year ago by Raphael Odini <[email protected]>
ProductCreate: add description

1ff5942b742d4c1a08aaa31677930ad2a781c8aa authored about 1 year ago by Raphael Odini <[email protected]>
fix: use time.sleep instead of asyncio.sleep in non-corountine function

1ccffd6f5dfb22342bea65f63cb2cde39d5ac352 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: add image serving

We need to allow users to fetch images they uploaded

5808b7a1effad8ccccdf88681f5a31aa2c77a891 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: lint last alembic version

1b0667d09b19c4dc531c74eabdec85ec44caa23c authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
docs: replace venv with poetry (#54)

249c09286a0062f2e0f153e8b2a2cc86acc1c3b3 authored about 1 year ago by Raphael Odini <[email protected]>
feat: allow to upload price of barcode-less products (#53)

d44d86df2829b62db5441904a0644f062923cde3 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
chore: migrate before deployment (#52)

bb91bfc4242a5ea541856f0332c5519a0d01deeb authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
chore(main): release 1.1.0 (#41)

Co-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>

954e0e7f5191b6b60a3876beb589a4cdb4c1108e authored about 1 year ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
feat: fetch product data from OpenFoodFacts (#49)

* Product get_or_create: get info if created

* Fetch data from OFF

* Update product

* F...

cc5a778d11bb0596582c488614b45c176ea7b123 authored about 1 year ago by Raphael Odini <[email protected]>
fix: fix some typos in the landing page (#51)

e5fee84246304e375c3fa0421e08cdd53ba07ad1 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
Merge pull request #48 from openfoodfacts/meeting-doc

docs: document the Weekly meeting

e302aa1085a3e4873ddfa3307870aac3443d12f8 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
fix: fix landing page

cf9bb9d44c324e7b7a016be9ff2e1fdc23795917 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
add a real landing page

c5656db3456d8a8d462cee9eb26a094e1e34403d authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
feat: fetch location data from OpenStreetMap Nominatim (#38)

* Install OSMPythonTools package

* Fetch data from OSM Nominatim

* Add logger, fix async

2044e6bdc287e361e891505dca55df8ce9140082 authored about 1 year ago by Raphael Odini <[email protected]>
doc: document the Weekly meeting

25b43276865cd3a4beada1315c646ad48e8f45be authored about 1 year ago by Pierre Slamich <[email protected]>
feat: GET /products/id endpoint to get product details (#46)

* New endpoint to fetch product data per id

* Add tests

* Remove async (not supported yet)

74f011ce1d112445f18a132de060edf612683e53 authored about 1 year ago by Raphael Odini <[email protected]>
feat: on Price create, create (or get) Product, and link them (#45)

* Create relationship between Price & Product

* On Price create, background task to create Pr...

71cf40ac914599d7884f848ae09dde02402cf1c7 authored about 1 year ago by Raphael Odini <[email protected]>
feat: simple Product model (#44)

* Add Product model

* Add schema. Fix migration name

* Replace ProductOFFSource with openf...

2bfa8f682148b97299be2c7e483e16e93d743d0c authored about 1 year ago by Raphael Odini <[email protected]>
Merge pull request #42 from openfoodfacts/dependabot/github_actions/actions/checkout-4

build(deps): bump actions/checkout from 3 to 4

8643b2135bbad14da71ce7d52e439712c202a7a6 authored about 1 year ago by Pierre Slamich <[email protected]>
Merge pull request #43 from openfoodfacts/dependabot/github_actions/JamesIves/github-pages-deploy-action-4.4.3

build(deps): bump JamesIves/github-pages-deploy-action from 4.4.1 to 4.4.3

45a3710563163ec1a2c4b773f122e1bdbea40cca authored about 1 year ago by Pierre Slamich <[email protected]>
build(deps): bump JamesIves/github-pages-deploy-action

Bumps [JamesIves/github-pages-deploy-action](https://github.com/jamesives/github-pages-deploy-ac...

c21c21164b4142418238598b227f69e21b1795fc authored about 1 year ago by dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
build(deps): bump actions/checkout from 3 to 4

Bumps [actions/checkout](https://github.com/actions/checkout) from 3 to 4.
- [Release notes](htt...

6cd3c4b76aff8374997d5604ba44dc29968e1ad2 authored about 1 year ago by dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
feat: GET /locations/id endpoint to get location details (#37)

* New endpoint to fetch location data per id

* Add tests & typing

4a4eca1c1a8fc4e618d189f66a6e2bea5467c6d4 authored about 1 year ago by Raphael Odini <[email protected]>
feat: on Price create, create (or get) Location, and link them (#36)

* On Price create, background task to create Location

* Create relationship between Price & L...

003de11bb2ffc30e0e4af5631b1aa1fabc24a763 authored about 1 year ago by Raphael Odini <[email protected]>
feat: simple Location model (#35)

* Add Location model

* Add schema

* Rename PriceLocationOSMType to LocationOSMType

32562adcf52544a0ac388bdefa7df0cccdc3fb67 authored about 1 year ago by Raphael Odini <[email protected]>
chore: add github workflow to generate doc

afb83441d2f62e3f7294fb20c8e451989dc769f5 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
docs: add gh_pages documentation

6f8bf6e9de54ce5d9795871499d8c8190966d718 authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>
Merge pull request #40 from openfoodfacts/release-please--branches--main

chore(main): release 1.0.3

540c1500a596aca374acc0e05168b96dbea2a84f authored about 1 year ago by RaphaĆ«l Bournhonesque <[email protected]>