search

ecosyste-ms / packages

An open API service providing package, version and dependency metadata of many open source software ecosystems and registries.
https://packages.ecosyste.ms
GNU Affero General Public License v3.0
23 stars 4 forks source link

Duplicate pypi maintainers #690

Closed andrew closed 2 months ago

andrew commented 4 months ago

Example: https://packages.ecosyste.ms/registries/pypi.org/packages/google-generativeai/maintainers

Not yet sure if it's duplicate database records or just the sql query that's not distinct.

Screenshot 2024-03-11 at 17 50 00

Upvote & Fund

Fund with Polar

andrew commented 3 months ago

Just had a look, it's duplicate maintainership records in the db, so that will need to be fixed and then data cleaned up.

andrew commented 3 months ago

The bug will be here: https://github.com/ecosyste-ms/packages/blob/main/app/models/registry.rb#L254-L292

andrew commented 2 months ago

Going to add a unique index to ensure there can't be duplicates in the maintainerships table, but first need to clean up the existing duplicates.