summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3
AgeCommit message (Collapse)Author
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
2018-07-05Refs #28643 -- Added math database functions.Junyi Jiao
Thanks Nick Pope for much review.
2018-07-02Simplified SQLite's Decimal adapter.Sergey Fedoseev
2018-06-25Fixed #29517 -- Added support for SQLite column check constraints on ↵Tim Graham
positive integer fields.
2018-05-08Refs #29350 -- Fixed 'invalid escape sequence' warning in SQLite introspection.Tim Graham
2018-04-28Fixed #29350 -- Fix get_primary_key_column() method in sqlite3 backendZackary Troop
Thanks Tim Graham and Mariusz Felisiak for the reviews.
2018-04-19Fixed #28574 -- Added QuerySet.explain().Tom
2018-04-03Refs #28643 -- Added Repeat database function.Mariusz Felisiak
Thanks Tim Graham and Nick Pope for reviews.
generated by cgit v1.3 (git 2.53.0) at 2026-07-09 17:32:09 +0000