summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3
AgeCommit message (Collapse)Author
2021-02-17[3.2.x] Fixed #32453 -- Added introspection of unique constraint field ↵Hannes Ljungberg
ordering on SQLite. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com> Backport of 4d99375b46ad03fa4b4795319973046f438328c8 from master
2021-01-14Refs #26167 -- Changed default value of ↵Hannes Ljungberg
DatabaseFeatures.supports_expression_indexes to True.
2021-01-13Fixed #26167 -- Added support for functional indexes.Hannes Ljungberg
Thanks Simon Charette, Mads Jensen, and Mariusz Felisiak for reviews. Co-authored-by: Markus Holtermann <info@markusholtermann.eu>
2020-12-30Fixed #32303 -- Bumped minimum supported SQLite to 3.9.0.Mariusz Felisiak
2020-12-28Fixed #32158 -- Fixed loaddata crash on SQLite when table/column names are ↵Chinmoy Chakraborty
SQL keywords.
2020-12-10Fixed #32178 -- Allowed database backends to skip tests and mark expected ↵Hasan Ramezani
failures. Co-authored-by: Tim Graham <timograham@gmail.com>
2020-12-02Fixed #32179 -- Added JSONObject database function.Artur Beltsov
2020-11-25Fixed #32224 -- Avoided suppressing connection errors in supports_json_field ↵Mariusz Felisiak
on SQLite.` Regression in 6789ded0a6ab797f0dcdfa6ad5d1cfa46e23abcd. Thanks Juan Garcia Alvite for the report.
2020-11-19Fixed #32201 -- Removed obsolete isort:skip's.Seamus Quinn
Obsolete as of isort 5.
2020-10-29Refs #32061 -- Unified DatabaseClient.runshell() in db backends.Simon Charette
2020-10-14Fixed #31640 -- Made Trunc() truncate datetimes to Date/TimeField in a ↵David-Wobrock
specific timezone.
2020-10-02Fixed #32060 -- Added Random database function.Nick Pope
2020-09-21Fixed #31777 -- Added support for database collations to Char/TextFields.Tom Carrick
Thanks Simon Charette and Mariusz Felisiak for reviews.
2020-08-13Fixed #31825 -- Made RenameField operation a noop for fields with db_column.Iuri de Silvio
2020-08-11Fixed #21181 -- Added Collate database function.Tom Carrick
Thanks Simon Charette for reviews.
2020-07-28Fixed #31836 -- Dropped support for JSONField __contains and __contained_by ↵Mariusz Felisiak
lookups on SQLite. The current implementation works only for basic examples without supporting nested structures and doesn't follow "the general principle that the contained object must match the containing object as to structure and data contents, possibly after discarding some non-matching array elements or object key/value pairs from the containing object".
2020-07-22Fixed #31765 -- Disabled bundled SQLite renaming atomic references on macOS ↵Tom Forbes
10.15.
2020-07-03Removed duplicated sqlite3 converter.Sergey Fedoseev
Converters typenames are case-insensitive. See https://docs.python.org/3/library/sqlite3.html#sqlite3.register_converter.
2020-06-30Fixed #28925 -- Fixed durations-only expressions crash on SQLite and MySQL.Sergey Fedoseev
This removes also unused DatabaseOperations.date_interval_sql().
2020-06-04Refs #31630 -- Removed DatabaseFeatures.can_introspect_autofield.Tim Graham
2020-06-04Fixed #31630 -- Replaced introspection features with ↵Hasan Ramezani
DatabaseFeatures.introspected_field_types.
2020-05-11Refs #30116 -- Simplified regex match group access with Match.__getitem__().Jon Dufresne
The method has been available since Python 3.6. The shorter syntax is also marginally faster.
2020-05-08Fixed #12990, Refs #27694 -- Added JSONField model field.sage
Thanks to Adam Johnson, Carlton Gibson, Mariusz Felisiak, and Raphael Michel for mentoring this Google Summer of Code 2019 project and everyone else who helped with the patch. Special thanks to Mads Jensen, Nick Pope, and Simon Charette for extensive reviews. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
2020-04-21Fixed #31479 -- Added support to reset sequences on SQLite.Jon Dufresne
2020-04-21Refs #30591 -- Adjusted table rebuild for non-pk relationship on SQLite.Simon Charette
The existing code was only accounting for primary key changes and not all unique key fields that can be referenced.
2020-04-21Fixed #31064 -- Recreated auto-created many-to-many tables on primary key ↵Simon Charette
data type change on SQLite. Both local and remote auto-created many-to-many relationships were affected.
2020-04-20Stopped rebuilding referenced tables multiple times on SQLite alterations.Simon Charette
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-04-14Fixed #29501 -- Allowed dbshell to pass options to underlying tool.Adam Johnson
2020-04-06Fixed #31030 -- Registered SQLite functions as deterministic on Python 3.8+.Sergey Fedoseev
2020-03-25Fixed #31396 -- Added binary XOR operator to F expressions.Hannes Ljungberg
2020-03-18Fixed #31376 -- Optimized nulls ordering when possible on SQLite and MySQL.Simon Charette
Both backends order NULLs first on ascending ordering and last on descending ordering which makes ORDER BY IS (NOT)? NULL wasteful when asc(nulls_first) and desc(nulls_last) are used since it prevents indice usage.
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-06Fixed #31233 -- Closed database connections and cursors after use.Jon Dufresne
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-12-16Fixed #31076 -- Fixed dbshell crash on Windows with Python < 3.8.Zeynel Özdemir
subprocess.run()'s args parameter accepts path-like objects on Windows since Python 3.8.
2019-11-21Fixed #30413 -- Fixed test database signature on SQLite when test database ↵Farhaan Bukhsh
name is provided. Previously, the same signature was created for multiple in-memory databases on SQLite when they had tests databases names DATABASES['TEST']['NAME'].
2019-11-19Fixed #30987 -- Added models.PositiveBigIntegerField.Caio Ariede
2019-11-07Refs #29983 -- Added support for using pathlib.Path in all settings.Jon Dufresne
2019-11-04Refs #13312 -- Simplified handling of nulls ordering on MySQL.Nick Pope
MySQL & MariaDB support the standard IS NULL and IS NOT NULL so the same workaround used for NULLS FIRST and NULLS LAST that is used for SQLite < 3.30.0 can be used. Thanks Simon Charette for the discussion.
2019-10-29Fixed #30899 -- Lazily compiled import time regular expressions.Hasan Ramezani
2019-10-15Fixed #30859 -- Fixed DatabaseFeatures.supports_aggregate_filter_clause on ↵Mariusz Felisiak
SQLite 3.30.1+.
2019-10-09Refs #26608 -- Fixed DatabaseFeatures.supports_frame_range_fixed_distance on ↵Mariusz Felisiak
SQLite 3.28+, MariaDB 10.2+, and MySQL 8.0.2+.
2019-10-02Fixed #30821 -- Added ExtractIsoWeekYear database function and iso_week_day ↵Anatol Ulrich
lookup.
2019-08-23Replaced subprocess commands by run() wherever possible.Claude Paroz
2019-08-02Fixed #30661 -- Added models.SmallAutoField.Nick Pope
2019-08-01Fixed #30664 -- Fixed migrations crash when altering table on SQLite or ↵Ngalim Siregar
altering AutoField/BigAutoField on PostgreSQL for models with quoted db_table.
2019-06-20Fixed #30451 -- Added ASGI handler and coroutine-safety.Andrew Godwin
This adds an ASGI handler, asgi.py file for the default project layout, a few async utilities and adds async-safety to many parts of Django.
2019-06-13Fixed #30128 -- Fixed handling timedelta timezone in database functions.can
generated by cgit v1.3 (git 2.53.0) at 2026-07-06 21:07:29 +0000