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

Handle deletions correctly #745

Closed
jrjohnson opened this issue Feb 17, 2015 · 1 comment
Closed

Handle deletions correctly #745

jrjohnson opened this issue Feb 17, 2015 · 1 comment
Assignees

Comments

@jrjohnson
Copy link
Member

For tables which have a soft delete option set their deleted flag to true instead of attempting to remove them from the database.

@jrjohnson
Copy link
Member Author

@saschaben - I found the following list of tables with a deleted column:

+-----------------+
| TABLE_NAME      |
+-----------------+
| course          |
| department      |
| offering        |
| program         |
| program_year    |
| report          |
| report_po_value |
| school          |
| session         |
+-----------------+

A lot of these have relationships and I'm not sure how we want to handle them. I think if we delete a course we should probably walk through and set a deleted flag on all of its sessions, offerings, objectives, etc. Not all of these tables support a soft delete though so we would need to add that to the schema.

@jrjohnson jrjohnson reopened this Aug 6, 2015
@jrjohnson jrjohnson mentioned this issue Aug 6, 2015
16 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant