summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3
AgeCommit message (Collapse)Author
2018-12-17[2.1.x] Fixed #30023 -- Prevented SQLite schema alterations while foreign ↵Simon Charette
key checks 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. Backport of 315357ad25a6590e7f4564ec2e56a22132b09001 from master.
2018-12-07[2.1.x] Fixed #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. Backport of c8ffdbe514b55ff5c9a2b8cb8bbdf2d3978c188f from master.
2018-10-09[2.1.x] Refs #29784 -- Switched to https:// links where available.Jon Dufresne
Backport of 82f286cf6f198d37850d3c5df637b5665566a66b from master.
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.
2018-03-19Refs #28643 -- Added LPad and RPad database functions.Mariusz Felisiak
Thanks Tim Graham for the review.
2018-02-26Refs #28909 -- Simplifed code using unpacking generalizations.Mariusz Felisiak
2018-01-31Removed uneeded comment in DatabaseWrapper.check_constraints() on ↵Mariusz Felisiak
SQLite/MySQL backends.
2018-01-27Fixed #29004 -- Added inspectdb --include-views option.bquinn
2018-01-27Fixed #28650 -- Added TruncWeek database function.Sigurd Ljødal
2018-01-04Refs #28459 -- Improved performance of duration expressions on SQLite.Sergey Fedoseev
2017-12-29Refs #28459 -- Used default date converter on SQLite for better performance.Sergey Fedoseev
See https://docs.python.org/3/library/sqlite3.html#default-adapters-and-converters.
2017-12-28Fixed #28926 -- Fixed loss of precision of big DurationField values on ↵Sergey Fedoseev
SQLite and MySQL.
2017-12-26Refs #28459 -- Improved performance of loading DecimalField on SQLite.Sergey Fedoseev
2017-12-22Fixed #28884 -- Fixed crash on SQLite when renaming a field in a model ↵Simon Charette
referenced by a ManyToManyField. Introspected database constraints instead of relying on _meta.related_objects to determine whether or not a table or a column is referenced on rename operations. This has the side effect of ignoring both db_constraint=False and virtual fields such as GenericRelation which aren't backend by database level constraints and thus shouldn't prevent the rename operations from being performed in a transaction. Regression in 095c1aaa898bed40568009db836aa8434f1b983d. Thanks Tim for the additional tests and edits, and Mariusz for the review.
2017-12-21Refs #23941 -- Prevented incorrect rounding of DecimalField annotations on ↵Sergey Fedoseev
SQLite.
2017-12-19Fixed #28727 -- Fixed Cast crash on SQLite when casting a Python ↵Mariusz Felisiak
date/datetime to Date/DateTimeField.
2017-12-12Fixed #28915 -- Prevented SQLite from truncating trailing zeros in the ↵Sergey Fedoseev
fractional part of DecimalField. This reverts commit a146b65628e702a9a3ed5be21542ca45366fbb29 and adds a test for the regression.
2017-12-12Simplified SQLite converter for bool type.Sergey Fedoseev
2017-12-11Fixed #28909 -- Simplified code using tuple/list/set/dict unpacking.Nick Pope
2017-12-01Fixed #28849 -- Fixed referenced table and column rename on SQLite.Simon Charette
Thanks Ramiro for the input and Tim for the review.
2017-11-28Fixed #28853 -- Updated connection.cursor() uses to use a context manager.Jon Dufresne
2017-11-28Fixed #28854 -- Replaced type(True) with bool in sqlite's SchemaEditor.Дилян Палаузов
2017-11-23Used bytes.hex() and bytes.fromhex() to simplify.Sergey Fedoseev
2017-11-07Fixed #28769 -- Replaced 'x if x else y' with 'x or y'.Дилян Палаузов
2017-10-06Fixed #28665 -- Change some database exceptions to NotImplementedError per ↵Simon Charette
PEP 249.
2017-10-03Refs #28584 -- Removed unused DatabaseFeatures.can_share_in_memory_db.Tim Graham
2017-10-03Fixed #28584 -- Dropped support for SQLite < 3.7.15.Tim Graham
2017-09-22Refs #27098 -- Removed DatabaseIntrospection.get_indexes() per deprecation ↵Tim Graham
timeline.
2017-09-18Changed default value of DatabaseFeatures.has_bulk_insert to True.Mads Jensen
2017-09-13Refs #27090 -- Added real database sequence introspection.Mariusz Felisiak
Thanks Mariusz Felisiak for the Oracle part and Tim Graham for the review.
2017-09-11Fixed #28578 -- Renamed DatabaseCreation number arguments to suffix.Jon Dufresne
2017-09-07Reverted "Fixed #27818 -- Replaced try/except/pass with contextlib.suppress()."Tim Graham
This reverts commit 550cb3a365dee4edfdd1563224d5304de2a57fda because try/except performs better.
2017-09-06Replaced @cached_property with class attributes where possible.Sergey Fedoseev
2017-08-11Replaced typecast_decimal() with decimal.Decimal().Sergey Fedoseev
2017-08-10Refs #28459 -- Improved performance of loading DecimalField on SQLite.Sergey Fedoseev
2017-08-09Simplified SQLite converter for bool type.Sergey Fedoseev
2017-07-27Fixed #28371 -- Fixed Cast() with CharField if the max_length argument isn't ↵Mariusz Felisiak
provided. Thanks Tim Graham for the review.
2017-07-20Fixed #28370 -- Deprecated the context arg of Field.from_db_value() and ↵Tim Graham
Expression.convert_value(). Unused since a0d166306fbdc41f49e6fadf4ec84b17eb147daa.
2017-07-17Fixed #28391 -- Fixed Cast() with CharField and max_length on MySQL.Mariusz Felisiak
Thanks Tim Graham for the review.
2017-07-11Fixed #14204 -- Enforced SQLite foreign key constraints.Claude Paroz
Thanks Tim Graham for contributing to the patch and Simon Charette for advice and review.
2017-07-06Fixed #28365 -- Unified DatabaseOperations.date_interval_sql() return value ↵Mariusz Felisiak
with similar methods.
2017-06-28Fixed #27818 -- Replaced try/except/pass with contextlib.suppress().Mads Jensen
2017-06-21Refs #25530 -- Deleted deferred SQL references on delete operation.Simon Charette
2017-06-21Refs #25530 -- Tracked references of deferred SQL statements.Simon Charette
2017-06-08Fixed #28103 -- Added quarter extract, truncation, and lookup.Mads Jensen
Thanks Mariusz Felisiak, Tim Graham, and Adam Johnson for review.
2017-06-01Refs #23968 -- Removed unnecessary lists, generators, and tuple calls.Jon Dufresne
2017-05-27Fixed #28249 -- Removed unnecessary dict.keys() calls.Jon Dufresne
iter(dict) is equivalent to iter(dict.keys()).
generated by cgit v1.3 (git 2.53.0) at 2026-07-10 19:46:56 +0000