Changes between Initial Version and Version 1 of Ticket #29928, comment 7
- Timestamp:
- Nov 8, 2018, 3:03:40 AM (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #29928, comment 7
initial v1 1 1 I see more possible solutions here. We can go sequentailly over them: 2 1. (short term) document that sqlite isn't checking foreign keys in intests2 1. (short term) document that sqlite isn't checking foreign keys in tests 3 3 2. (mid-term) allow changing the checking mode for sqlite in settings.py via and option in the database dict and document it. Mention it can cause slowness 4 4 3. (holy grail) contribute to sqlite a simple refactor/feature which will allow calling something like check_constraints on an uncommitted transaction and get the integrity errors more effectively (checking only uncommitted objects, not whole db). I guess this is the way how it works now for postgreSQL and Oracle. I'm already thinking of filing a feature request in sqlite for this but first I would like to hear your opinion on it :)