summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3/operations.py
AgeCommit message (Collapse)Author
2020-10-14Fixed #31640 -- Made Trunc() truncate datetimes to Date/TimeField in a ↵David-Wobrock
specific timezone.
2020-06-30Fixed #28925 -- Fixed durations-only expressions crash on SQLite and MySQL.Sergey Fedoseev
This removes also unused DatabaseOperations.date_interval_sql().
2020-04-21Fixed #31479 -- Added support to reset sequences on SQLite.Jon Dufresne
2020-04-17Fixed #31473 -- Made sql_flush() use RESTART IDENTITY to reset sequences on ↵Jon Dufresne
PostgreSQL. The sql_flush() positional argument sequences is replaced by the boolean keyword-only argument reset_sequences. This ensures that the old function signature can't be used by mistake when upgrading Django. When the new argument is True, the sequences of the truncated tables will reset. Using a single boolean value, rather than a list, allows making a binary yes/no choice as to whether to reset all sequences rather than a working on a completely different set.
2020-03-25Fixed #31396 -- Added binary XOR operator to F expressions.Hannes Ljungberg
2020-02-18Fixed #31228 -- Reallowed aggregates to be used with multiple expressions ↵Taoup
and no DISTINCT on SQLite. Regression in bc05547cd8c1dd511c6b6a6c873a1bc63417b111. Thanks Andy Terra for the report.
2020-02-04Simplified imports from django.db and django.contrib.gis.db.Nick Pope
2020-01-03Fixed #31133 -- Fixed crash when subtracting against a subquery annotation.Simon Charette
The subtract_temporals() database operation was not handling expressions returning SQL params in mixed database types. Regression in 35431298226165986ad07e91f9d3aca721ff38ec. Thanks Reupen Shah for the report.
2019-10-15Fixed #30859 -- Fixed DatabaseFeatures.supports_aggregate_filter_clause on ↵Mariusz Felisiak
SQLite 3.30.1+.
2019-04-24Removed unnecessary assignments in various code.Jon Dufresne
2019-04-08Fixed #28373 -- Used connection timezone instead of UTC when making dates ↵can
timezone-aware on MySQL, SQLite, and Oracle. Thanks vtalpaert for the initial patch. Co-Authored-By: Mariusz Felisiak <felisiak.mariusz@gmail.com>
2019-01-09Fixed #28658 -- Added DISTINCT handling to the Aggregate class.Simon Charette
2018-12-26Refs #30054, #20483 -- Cached SQLite references graph retrieval on sql_flush().Simon Charette
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-08-03Fixed #28668 -- Allowed QuerySet.bulk_create() to ignore insert conflicts.Tom
2018-07-05Refs #28643 -- Added math database functions.Junyi Jiao
Thanks Nick Pope for much review.
2018-04-19Fixed #28574 -- Added QuerySet.explain().Tom
2018-01-04Refs #28459 -- Improved performance of duration expressions on SQLite.Sergey Fedoseev
2017-12-26Refs #28459 -- Improved performance of loading DecimalField on SQLite.Sergey Fedoseev
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-10-06Fixed #28665 -- Change some database exceptions to NotImplementedError per ↵Simon Charette
PEP 249.
2017-09-07Reverted "Fixed #27818 -- Replaced try/except/pass with contextlib.suppress()."Tim Graham
This reverts commit 550cb3a365dee4edfdd1563224d5304de2a57fda because try/except performs better.
2017-08-10Refs #28459 -- Improved performance of loading DecimalField on SQLite.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-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-05-27Fixed #28249 -- Removed unnecessary dict.keys() calls.Jon Dufresne
iter(dict) is equivalent to iter(dict.keys()).
2017-03-24Refs #21160 -- Replaced DatabaseFeatures.supports_1000_query_parameters by a ↵Mariusz Felisiak
DatabaseFeatures.max_query_params.
2017-02-28Refs #27656 -- Updated django.db docstring verbs according to PEP 257.Anton Samarchyan
2017-02-06Fixed #27802 -- Unified return value of db backend datetime SQL methods.Mariusz Felisiak
2017-01-25Refs #23919 -- Replaced super(ClassName, self) with super().chillaranand
2017-01-18Refs #23919 -- Removed six.<various>_types usageClaude Paroz
Thanks Tim Graham and Simon Charette for the reviews.
2017-01-18Refs #23919 -- Removed encoding preambles and future importsClaude Paroz
2016-11-29Fixed #27544 -- Fixed QuerySet.update(dt=F('dt') + timedelta) crash on SQLite.Andrew Nester
2016-11-25Fixed grammar in sqlite's DatabaseOperations.bulk_batch_size()'s docstring.Daniel Hahler
2016-11-14Fixed #27481 -- Made SQLite return annotated boolean values as boolean, not ↵Sergey Fedoseev
integer. Thanks Simon Charette for review.
2016-10-27Fixed #27327 -- Simplified time zone handling by requiring pytz.Tim Graham
2016-08-19Fixed #22288 -- Fixed F() expressions with the __range lookup.Matthew Wilkes
2016-07-27Fixed #26950 -- Removed obsolete DatabaseOperations SQL methods.Anderson Resende
Unused as of 2b039d966f6e61a5ffb5ffac25aa198f9043de3d.
2016-07-08Fixed #26348 -- Added TruncTime and exposed it through the __time lookup.Simon Charette
Thanks Tim for the review.
2016-07-08Refs #25774, #26348 -- Allowed Trunc functions to operate with time fields.Simon Charette
Thanks Josh for the amazing testing setup and Tim for the review.
2016-02-26Fixed #24793 -- Unified temporal difference support.Simon Charette
2016-01-23Fixed typo in django/db/backends/sqlite3/operations.py.seungkwon
2016-01-21Fixed #26063 -- Crash when passing > 2000 params.Aymeric Augustin
If SQLITE_MAX_VARIABLE_NUMBER (default = 999) is changed at compile time to be greater than SQLITE_MAX_COLUMN (default = 2000), which Debian does by setting the former to 250000, Django raised an exception on queries containing more than 2000 parameters when DEBUG = True.
2015-09-22Fixed #24509 -- Added Expression support to SQLInsertCompilerAlex Hill
2015-09-17Refs #14091 -- Fixed connection.queries on SQLite.Aymeric Augustin
generated by cgit v1.3 (git 2.53.0) at 2026-07-14 07:12:39 +0000