You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
It came to mind that the metadata plugin for pixiv doesn't enforce uniqueness on certain tags, which can result in data integrity issues. In particular, the values for "date_uploaded" and "artist" should be unique when called by the pixiv metadata plugin on an artwork ID.
Case for "date_uploaded": If an artist privates their artwork and unprivates it, the date of upload will change to the more recent unprivated date. The metadata plugin should overwrite the date_uploaded field so that any archive should only reflect the most recent uploaded date.
Case for "artist": Pixiv archives always have exactly one artist. If the Pixiv artist changes their name, the name of the artist corresponding to the artwork should be changed to the new name, rather than having both new and old names.
Other tags like "pixiv_user_id" or "source" or "date_created" are assumed to never change, so they're OK.
This is probably a theoretical bug I don't think many people have run into; it requires you to call the plugin on an already-tagged archive in which the source upload date or artist name have changed, but I should fix this sometime in the future.
The text was updated successfully, but these errors were encountered:
psilabs-dev
changed the title
[Pixiv] Uniqueness for metadata plugin on "date_uploaded" and "artist"
[Pixiv] Key constraint for metadata plugin on "date_uploaded" and "artist"
Dec 29, 2024
It came to mind that the metadata plugin for pixiv doesn't enforce uniqueness on certain tags, which can result in data integrity issues. In particular, the values for "date_uploaded" and "artist" should be unique when called by the pixiv metadata plugin on an artwork ID.
Case for "date_uploaded": If an artist privates their artwork and unprivates it, the date of upload will change to the more recent unprivated date. The metadata plugin should overwrite the date_uploaded field so that any archive should only reflect the most recent uploaded date.
Case for "artist": Pixiv archives always have exactly one artist. If the Pixiv artist changes their name, the name of the artist corresponding to the artwork should be changed to the new name, rather than having both new and old names.
Other tags like "pixiv_user_id" or "source" or "date_created" are assumed to never change, so they're OK.
This is probably a theoretical bug I don't think many people have run into; it requires you to call the plugin on an already-tagged archive in which the source upload date or artist name have changed, but I should fix this sometime in the future.
The text was updated successfully, but these errors were encountered: