summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3
AgeCommit message (Collapse)Author
2019-03-15[2.2.x] Fixed #30183 -- Added introspection of inline SQLite constraints.Paveł Tyślacki
Backport of 782d85b6dfa191e67c0f1d572641d8236c79174c from master.
2019-03-15[2.2.x] Refs #30183 -- Moved SQLite table constraint parsing to a method.Paveł Tyślacki
Backport of 4492be348ad6fb24957068e63448142399629d18 from master.
2019-03-15[2.2.x] Unified nonexistent foreign key introspection value for SQLite.Paveł Tyślacki
Backport of b777c0675ef7aadc299844025cf1f9b53562524f from master.
2019-02-13[2.2.x] Fixed #30184 -- Removed ellipsis characters from shell output strings.Dan Davis
Partially reverted 50b8493581fea3d7137dd8db33bac7008868d23a (refs #29654) to avoid a crash when the user shell doesn't support non-ASCII characters. Backport of 2bd8df243ac6fc35e58c9fe90b20c9e42519a5ac from master.
2019-01-28[2.2.x] Refs #30055 -- Added a helpful error when SQLite is too old.Tim Graham
Backport of 7444f3252757ed4384623e5afd7dcfeef3e0c74e from master.
2019-01-22[2.2.x] Fixed #30115 -- Fixed SQLite introspection crash with a varchar ↵Nick Pope
primary key. Removed obsolete max_length handling for CharField that caused the issue. Regression in a35d2a4510d5beec398b1007aaa26492d6aedf97. Backport of bff748df3e1e1c0077e02df2b77bda2b827ad129 from master.
2019-01-12Refs #28643 -- Added Reverse database function.Nick Pope
Thanks Mariusz Felisiak for Oracle advice and review.
2019-01-12Fixed #30062 -- Added support for unique conditional constraints.Paveł Tyślacki
2019-01-09Fixed #28658 -- Added DISTINCT handling to the Aggregate class.Simon Charette
2019-01-09Refs #23748 -- Added AutoField introspection for SQLite.Nick Pope
2019-01-01Fixed #30060 -- Moved SQL generation for indexes and constraints to ↵Paveł Tyślacki
SchemaEditor.
2018-12-26Refs #29547 -- Skipped an unsupported partial index test on older versions ↵Tim Graham
of SQLite. Follow up to e5b8626c0eb223cc3d643163882c5902c40ec972.
2018-12-26Refs #30054, #20483 -- Cached SQLite references graph retrieval on sql_flush().Simon Charette
2018-12-24Fixed #30056 -- Added SQLite support for StdDev and Variance functions.Nick Pope
2018-12-22Renamed Sqlite and Sqlite3 references to SQLite.Nick Pope
2018-12-22Fixed #30054 -- Implemented cascaded flush on SQLite.Simon Charette
This is required to maintain foreign key integrity when using TransactionTestCase.available_apps. Refs #30033, #14204, #20483.
2018-12-22Fixed #30055 -- Dropped support for SQLite < 3.8.3.Tim Graham
2018-12-22Refs #30033 -- Checked constraints before committing SQLite schema changes.Simon Charette
This order of operations is more in line with SQLite's documented table rebuild procedure and ensures that changes aren't committed if foreign key integrity is broken.
2018-12-22Refs #29928 -- Added supports_pragma_foreign_key_check SQLite feature flag.Simon Charette
2018-12-22Refs #29928 -- Corrected SQLite's can_defer_constraint_checks feature flag.Simon Charette
2018-12-22Refs #29182 -- Corrected SQLite's supports_atomic_references_rename feature ↵Simon Charette
flag.
2018-12-22Refs #29547 -- Corrected SQLite's supports_partial_indexes feature flag.Simon Charette
2018-12-22Renamed SQLite3 references to to SQLite.Simon Charette
The version suffix isn't part of the product name.
2018-12-17Fixed #29928 -- Enabled deferred constraint checks on SQLite 3.20+.Simon Charette
Refs #11665, #14204. Thanks Michel Samia for the report.
2018-12-17Refs #29182 -- Stopped relying on legacy alter table semantic on SQLite 3.26+.Simon Charette
SQLite 3.26 changed the behavior of table and column renaming operations to repoint foreign key references even if foreign key checks are disabled. This makes the workarounds in place to simulate this behavior unnecessary on SQLite 3.26+. Refs #30033.
2018-12-17Fixed #30033 -- Conformed to the recommended table alterations procedure on ↵Simon Charette
SQlite3. Refs #29182. The previous implementation was following a procedure explicitly documented as incorrect and was the origin of the breakage experienced on SQLite 3.26 release that were addressed by c8ffdbe514b55ff5c9a2b8cb8bbdf2d3978c188f. Thanks to Richard Hipp for pointing out the usage of the incorrect procedure.
2018-12-17Refs #29928 -- Implemented fast constraint checking on SQLite 3.20+.Simon Charette
2018-12-15Fixed #30023 -- Prevented SQLite schema alterations while foreign key checks ↵Simon Charette
are enabled. Prior to this change foreign key constraint references could be left pointing at tables dropped during operations simulating unsupported table alterations because of an unexpected failure to disable foreign key constraint checks. SQLite3 does not allow disabling such checks while in a transaction so they must be disabled beforehand. Thanks ezaquarii for the report and Carlton and Tim for the review.
2018-12-07Fixed #29182 -- Fixed schema table alteration on SQLite 3.26+.Simon Charette
SQLite 3.26 repoints foreign key constraints on table renames even when foreign_keys pragma is off which breaks every operation that requires a table rebuild to simulate unsupported ALTER TABLE statements. The newly introduced legacy_alter_table pragma disables this behavior and restores the previous schema editor assumptions. Thanks Florian Apolloner, Christoph Trassl, Chris Lamb for the report and troubleshooting assistance.
2018-12-06Fixed #29932 -- Fixed combining compound queries with sub-compound queries ↵Mariusz Felisiak
on SQLite and Oracle.
2018-11-13Fixed #29641 -- Added support for unique constraints in Meta.constraints.Simon Charette
This constraint is similar to Meta.unique_together but also allows specifying a name. Co-authored-by: Ian Foote <python@ian.feete.org>
2018-11-13Refs #29641 -- Refactored database schema constraint creation.Simon Charette
Added a test for constraint names in the database. Updated SQLite introspection to use sqlparse to allow reading the constraint name for table check and unique constraints. Co-authored-by: Ian Foote <python@ian.feete.org>
2018-10-29Fixed #29547 -- Added support for partial indexes.Mads Jensen
Thanks to Ian Foote, Mariusz Felisiak, Simon Charettes, and Markus Holtermann for comments and feedback.
2018-10-29Fixed #29868 -- Retained database constraints on SQLite table rebuilds.Simon Charette
Refs #11964. Thanks Scott Stevens for testing this upcoming feature and the report.
2018-10-27Fixed #29763 -- Added support for column renaming on SQLite.Hampus Dunström
2018-10-25Refs #27025 -- Removed obsolete sqlite3 transaction management workaround ↵Tim Graham
for Python 3.6+. Obsolete per https://bugs.python.org/issue10740#msg274816.
2018-10-25Removed useless check in sqlite's DatabaseWrapper._savepoint_allowed().Tim Graham
Obsolete since 27193aea0088b238e3ee0f0f235364a34a09265c.
2018-10-25Made DatabaseFeatures.uses_savepoints default to True.Tim Graham
2018-10-21Fixed #29870 -- Added DurationField introspection for Oracle and PostgreSQL.Mariusz Felisiak
Thanks Tim Graham for the review.
2018-10-01Fixed #29767 -- Made date-related casts work on SQLiteClaude Paroz
Thanks Rémy Hubscher for the report and Tim Graham and Simon Charette for the reviews.
2018-09-26Refs #29784 -- Switched to https:// links where available.Jon Dufresne
2018-09-10Fixed #29500 -- Fixed SQLite function crashes on null values.Srinivas Reddy Thatiparthy
Co-authored-by: Srinivas Reddy Thatiparthy <thatiparthysreenivas@gmail.com> Co-authored-by: Nick Pope <nick.pope@flightdataservices.com>
2018-09-10Combined two identical SQLite functions.Nick Pope
2018-09-10Made some date parsing in SQLite functions more DRY.Nick Pope
2018-08-22Refs #29654 -- Replaced three dots with ellipsis character in output strings.Claude Paroz
2018-08-18Fixed #28649 -- Added ExtractIsoYear database function and iso_year lookup.Sigurd Ljødal
2018-08-03Fixed #28668 -- Allowed QuerySet.bulk_create() to ignore insert conflicts.Tom
2018-07-25Fixed #29563 -- Added result streaming for QuerySet.iterator() on SQLite.Andrew Brown
2018-07-19Fixed #29040 -- Made test database creation messages use a consistent output ↵Claude Paroz
stream.
2018-07-10Fixed #11964 -- Added support for database check constraints.Ian Foote
generated by cgit v1.3 (git 2.53.0) at 2026-07-07 02:46:50 +0000