Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Management command for cleaning up old data #349

Closed
alexlittle opened this issue Apr 21, 2016 · 1 comment
Closed

Management command for cleaning up old data #349

alexlittle opened this issue Apr 21, 2016 · 1 comment
Labels
enhancement medium priority
Milestone
Sept 2016

Comments

@alexlittle
Copy link
Member

alexlittle commented Apr 21, 2016 •
edited

For example, removing old quizzes and questions. Just need to be cautious about how much is removed, since users may still have and be using quizzes on their phones, even though not currently linked to an active course
@alexlittle alexlittle added this to the Jun 2016 milestone Apr 21, 2016
@alexlittle alexlittle modified the milestones: Jun 2016, Jul 2016 May 5, 2016
@alexlittle alexlittle modified the milestones: Jul 2016, Sept 2016 Aug 26, 2016
@jjoseba
Copy link
Member

jjoseba commented Sep 23, 2016

Rule to find objects to remove:

  • find all the old quizzes: quizzes which digest is not associated with any present activity
  • from these ones, keep the ones that have some QuizAttempt received
  • remove every object linked with this quiz: questions, responses and props

Is there any additional rule I should have in mind to exclude some more quizzes from deletion? With this approach, in my last production DB dump there are 1278 out of 2425 to remove.
Are there any other objects besides the Quizzes that need some kind of clean up?

jjoseba added a commit to chaotic-kingdoms/django-oppia that referenced this issue Sep 26, 2016
@jjoseba
DigitalCampus#349: Added basic squeleton for clean-up management command
166f4cf
jjoseba added a commit to chaotic-kingdoms/django-oppia that referenced this issue Sep 26, 2016
@jjoseba
DigitalCampus#349: Added all queries for unused elements and prompt t…
6884d65 
…he user with a summary before attempting the deletion
jjoseba added a commit to chaotic-kingdoms/django-oppia that referenced this issue Sep 26, 2016
@jjoseba
DigitalCampus#349: Reordering the deletion of tables to avoid foreign…
b570468 
… key conflicts
@jjoseba jjoseba mentioned this issue Sep 26, 2016
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement medium priority
Projects
None yet
Milestone
Sept 2016
Development

No branches or pull requests
2 participants
@alexlittle @jjoseba