Skip to content
This repository has been archived by the owner on Apr 18, 2024. It is now read-only.

Reset DB feature #110

Open
pavelskipenes opened this issue Dec 8, 2021 · 0 comments
Open

Reset DB feature #110

pavelskipenes opened this issue Dec 8, 2021 · 0 comments
Labels
admin Admin related pages

Comments

@pavelskipenes
Copy link
Collaborator

pavelskipenes commented Dec 8, 2021

Add new feature where db is being reset and getting ready for next year.
Transactions:

  • TRUNCATE svommer_web.access_log
  • TRUNCATE svommer_web.friday_beer
  • TRUNCATE svommer_web.orders
  • Generate CIN hash for each user in svommer_member.members and save it to svommer_member.member_CIN.
  • TRUNCATE svommer_member.members
  • DELETE FROM svommer_web.friday_beer WHERE last_used + 5 years > NOW()
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
admin Admin related pages
Projects
None yet
Development

No branches or pull requests

1 participant