Add group_by to Cargo queries

Nookipedia / nookipedia-api

Nookipedia's custom API for querying data from the Animal Crossing video game series.

https://api.nookipedia.com/

MIT License

40 stars 12 forks source link

Add group_by to Cargo queries #64

Closed KevinPayravi closed 3 years ago

KevinPayravi commented 3 years ago

On the wiki, Cargo is a bit finicky and can sometimes insert duplicate rows in a database table. As a result, the Nookipedia API sometimes returns duplicate objects.

We should consider adding group_by=<fields> to all our Cargo queries. Grouping by all fields will remove any duplicates in the query's return.

KevinPayravi commented 3 years ago

Marking as resolved for now with this commit: https://github.com/Nookipedia/nookipedia-api/commit/d746350eb04f054508de5dddcffc3616adf255a2

It's a hotfix (and not a performant one at that) but, it'll work until we resolve the duplication issue on the Nookipedia side.