summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3/operations.py
Commit message (Collapse)AuthorAgeFilesLines
* Fixed #34370 -- Added integer fields validation as 64-bit on SQLite.nabil-rady2023-03-081-2/+9
|
* Removed obsolete references to pysqlite.Nick Pope2022-11-041-3/+1
| | | | Obsolete since 1b06d5e6f6be8e567ce78c892c485af039830d7d.
* Refs CVE-2022-34265 -- Properly escaped Extract() and Trunc() parameters.Simon Charette2022-07-061-24/+24
| | | | Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
* Refs #33476 -- Refactored code to strictly match 88 characters line length.Mariusz Felisiak2022-02-071-2/+5
|
* Refs #33476 -- Reformatted code with Black.django-bot2022-02-071-77/+106
|
* Fixed #33460 -- Used VALUES clause for insert in bulk on SQLite.Keryn Knight2022-01-241-4/+3
| | | | | | SQLite 3.7.11 introduced the ability to use multiple values directly. SQLite 3.8.8 made multiple values not subject to the SQLITE_LIMIT_COMPOUND_SELECT (500).
* Fixed #31685 -- Added support for updating conflicts to QuerySet.bulk_create().sean_c_hsu2022-01-191-2/+21
| | | | | Thanks Florian Apolloner, Chris Jerdonek, Hannes Ljungberg, Nick Pope, and Mariusz Felisiak for reviews.
* Refs #25287 -- Added support for multiplying and dividing DurationField by ↵Tobias Bengfort2021-04-201-1/+1
| | | | scalar values on SQLite.
* Fixed #32501 -- Added support for returning fields from INSERT statements on ↵girishsontakke2021-04-071-0/+19
| | | | SQLite 3.35+.
* Fixed #32483 -- Fixed QuerySet.values()/values_list() on JSONField key ↵Mariusz Felisiak2021-03-231-0/+3
| | | | | | transforms with booleans on SQLite. Thanks Matthew Cornell for the report.
* Refs #31369 -- Removed models.NullBooleanField per deprecation timeline.Mariusz Felisiak2021-01-141-1/+1
|
* Fixed #31640 -- Made Trunc() truncate datetimes to Date/TimeField in a ↵David-Wobrock2020-10-141-5/+13
| | | | specific timezone.
* Fixed #28925 -- Fixed durations-only expressions crash on SQLite and MySQL.Sergey Fedoseev2020-06-301-4/+0
| | | | This removes also unused DatabaseOperations.date_interval_sql().
* Fixed #31479 -- Added support to reset sequences on SQLite.Jon Dufresne2020-04-211-3/+23
|
* Fixed #31473 -- Made sql_flush() use RESTART IDENTITY to reset sequences on ↵Jon Dufresne2020-04-171-1/+1
| | | | | | | | | | | | 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.
* Fixed #31396 -- Added binary XOR operator to F expressions.Hannes Ljungberg2020-03-251-0/+2
|
* Fixed #31228 -- Reallowed aggregates to be used with multiple expressions ↵Taoup2020-02-181-1/+5
| | | | | | | | and no DISTINCT on SQLite. Regression in bc05547cd8c1dd511c6b6a6c873a1bc63417b111. Thanks Andy Terra for the report.
* Simplified imports from django.db and django.contrib.gis.db.Nick Pope2020-02-041-8/+7
|
* Fixed #31133 -- Fixed crash when subtracting against a subquery annotation.Simon Charette2020-01-031-2/+3
| | | | | | | | | 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.
* Fixed #30859 -- Fixed DatabaseFeatures.supports_aggregate_filter_clause on ↵Mariusz Felisiak2019-10-151-1/+1
| | | | SQLite 3.30.1+.
* Removed unnecessary assignments in various code.Jon Dufresne2019-04-241-4/+3
|
* Fixed #28373 -- Used connection timezone instead of UTC when making dates ↵can2019-04-081-10/+12
| | | | | | | | timezone-aware on MySQL, SQLite, and Oracle. Thanks vtalpaert for the initial patch. Co-Authored-By: Mariusz Felisiak <felisiak.mariusz@gmail.com>
* Fixed #28658 -- Added DISTINCT handling to the Aggregate class.Simon Charette2019-01-091-0/+5
|
* Refs #30054, #20483 -- Cached SQLite references graph retrieval on sql_flush().Simon Charette2018-12-261-18/+29
|
* Fixed #30054 -- Implemented cascaded flush on SQLite.Simon Charette2018-12-221-6/+21
| | | | | | This is required to maintain foreign key integrity when using TransactionTestCase.available_apps. Refs #30033, #14204, #20483.
* Fixed #28668 -- Allowed QuerySet.bulk_create() to ignore insert conflicts.Tom2018-08-031-0/+3
|
* Refs #28643 -- Added math database functions.Junyi Jiao2018-07-051-3/+3
| | | Thanks Nick Pope for much review.
* Fixed #28574 -- Added QuerySet.explain().Tom2018-04-191-0/+1
|
* Refs #28459 -- Improved performance of duration expressions on SQLite.Sergey Fedoseev2018-01-041-2/+2
|
* Refs #28459 -- Improved performance of loading DecimalField on SQLite.Sergey Fedoseev2017-12-261-10/+16
|
* Refs #23941 -- Prevented incorrect rounding of DecimalField annotations on ↵Sergey Fedoseev2017-12-211-2/+7
| | | | SQLite.
* Fixed #28727 -- Fixed Cast crash on SQLite when casting a Python ↵Mariusz Felisiak2017-12-191-0/+4
| | | | date/datetime to Date/DateTimeField.
* Fixed #28915 -- Prevented SQLite from truncating trailing zeros in the ↵Sergey Fedoseev2017-12-121-6/+3
| | | | | | | fractional part of DecimalField. This reverts commit a146b65628e702a9a3ed5be21542ca45366fbb29 and adds a test for the regression.
* Fixed #28665 -- Change some database exceptions to NotImplementedError per ↵Simon Charette2017-10-061-1/+1
| | | | PEP 249.
* Reverted "Fixed #27818 -- Replaced try/except/pass with contextlib.suppress()."Tim Graham2017-09-071-4/+6
| | | | This reverts commit 550cb3a365dee4edfdd1563224d5304de2a57fda because try/except performs better.
* Refs #28459 -- Improved performance of loading DecimalField on SQLite.Sergey Fedoseev2017-08-101-3/+6
|
* Fixed #28371 -- Fixed Cast() with CharField if the max_length argument isn't ↵Mariusz Felisiak2017-07-271-0/+2
| | | | | provided. Thanks Tim Graham for the review.
* Fixed #28370 -- Deprecated the context arg of Field.from_db_value() and ↵Tim Graham2017-07-201-6/+6
| | | | | | Expression.convert_value(). Unused since a0d166306fbdc41f49e6fadf4ec84b17eb147daa.
* Fixed #14204 -- Enforced SQLite foreign key constraints.Claude Paroz2017-07-111-3/+6
| | | | | Thanks Tim Graham for contributing to the patch and Simon Charette for advice and review.
* Fixed #28365 -- Unified DatabaseOperations.date_interval_sql() return value ↵Mariusz Felisiak2017-07-061-1/+1
| | | | with similar methods.
* Fixed #27818 -- Replaced try/except/pass with contextlib.suppress().Mads Jensen2017-06-281-5/+4
|
* Fixed #28249 -- Removed unnecessary dict.keys() calls.Jon Dufresne2017-05-271-2/+1
| | | iter(dict) is equivalent to iter(dict.keys()).
* Refs #21160 -- Replaced DatabaseFeatures.supports_1000_query_parameters by a ↵Mariusz Felisiak2017-03-241-2/+6
| | | | DatabaseFeatures.max_query_params.
* Refs #27656 -- Updated django.db docstring verbs according to PEP 257.Anton Samarchyan2017-02-281-19/+6
|
* Fixed #27802 -- Unified return value of db backend datetime SQL methods.Mariusz Felisiak2017-02-061-6/+15
|
* Refs #23919 -- Replaced super(ClassName, self) with super().chillaranand2017-01-251-2/+2
|
* Refs #23919 -- Removed six.<various>_types usageClaude Paroz2017-01-181-3/+3
| | | | Thanks Tim Graham and Simon Charette for the reviews.
* Refs #23919 -- Removed encoding preambles and future importsClaude Paroz2017-01-181-2/+0
|
* Fixed #27544 -- Fixed QuerySet.update(dt=F('dt') + timedelta) crash on SQLite.Andrew Nester2016-11-291-1/+1
|
* Fixed grammar in sqlite's DatabaseOperations.bulk_batch_size()'s docstring.Daniel Hahler2016-11-251-2/+2
|