search

eosfrontier / orthanc

2 stars 1 forks source link

Meta cleanup #29

Open rolf-yoast opened 3 years ago

rolf-yoast commented 3 years ago

Between events we want to cleanup the meta table so it doesn't get cluttered.

So we have to make a function that get all the character_id's in the meta table. Check if those id's are in the ecc_characters table. If they aren't delete the rows associated with that character_id.

It would be smart to also first automatically make an export of the meta table first so we can also get the data back if needed.

jogoldberg commented 3 years ago

It would be smart to also first automatically make an export of the meta table first so we can also get the data back if needed.

Aurora RDS is now making regular backups, so this is a nice-to-have but not strictly speaking 100% necessary

WafflesMcDuff commented 3 years ago

This can probably be done with a SQL Stored procedure on a schedule.

willemm commented 3 years ago

This cannot be done until the refactor of roster app to use the new app-scoped metadata api. https://github.com/eosfrontier/rosterapp/issues/20