summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3/features.py
Commit message (Collapse)AuthorAgeFilesLines
* Fixed #470 -- Added support for database defaults on fields.Ian Foote2023-05-121-0/+2
| | | | | | | | Special thanks to Hannes Ljungberg for finding multiple implementation gaps. Thanks also to Simon Charette, Adam Johnson, and Mariusz Felisiak for reviews.
* Fixed #34201 -- Bumped minimum supported SQLite to 3.21.0.Mariusz Felisiak2022-12-081-6/+2
|
* Refs #31169 -- Skipped test_get_test_db_clone_settings_not_supported on not ↵Mariusz Felisiak2022-11-281-0/+5
| | | | | | in-memory SQLite database. multiprocessing's start method is checked only for in-memory SQLite databases.
* Used DatabaseFeatures.django_test_skips to skip ↵Christophe Baldy2022-11-241-0/+5
| | | | AssertNumQueriesUponConnectionTests tests.
* Fixed #29062 -- Prevented possibility of database lock when using ↵baldychristophe2022-11-241-0/+10
| | | | | | LiveServerTestCase with in-memory SQLite database. Thanks Chris Jerdonek for the implementation idea.
* Fixed #10070 -- Added support for pyformat style parameters on SQLite.Ryan Cheley2022-11-081-1/+0
| | | | Co-authored-by: Nick Pope <nick@nickpope.me.uk>
* Refs #33768 -- Fixed ordering compound queries by NULLs on SQLite < 3.30.Simon Charette2022-11-011-0/+2
| | | | | | The lack of support for native nulls last/first on SQLite 3.28 and 3.29 requires the compound query to be wrapped for emulation layer to work properly.
* Fixed #32234 -- Made inspectdb inform about composite primary keys.Anv3sh2022-06-011-0/+7
|
* Fixed #33379 -- Added minimum database version checks.Hasan Ramezani2022-02-181-0/+1
| | | | Thanks Tim Graham for the review.
* Refs #32502 -- Avoided table rebuild when removing fields on SQLite 3.35.5+.Mariusz Felisiak2022-02-111-0/+2
| | | | ALTER TABLE ... DROP COLUMN was introduced in SQLite 3.35+ however a data corruption issue was fixed in SQLite 3.35.5.
* Refs #33476 -- Refactored code to strictly match 88 characters line length.Mariusz Felisiak2022-02-071-10/+20
|
* Refs #33476 -- Reformatted code with Black.django-bot2022-02-071-35/+41
|
* Fixed #31685 -- Added support for updating conflicts to QuerySet.bulk_create().sean_c_hsu2022-01-191-0/+2
| | | | | Thanks Florian Apolloner, Chris Jerdonek, Hannes Ljungberg, Nick Pope, and Mariusz Felisiak for reviews.
* Refs #29517 -- Removed obsolete PositiveIntegerField test skip.Tim Graham2021-12-271-3/+0
|
* Fixed DatabaseFeatures.requires_literal_defaults on SQLite.Mariusz Felisiak2021-12-101-0/+1
| | | | | | This flag is currently unused on SQLite because it doesn't support dropping a DEFAULT clause, however it requires literal defaults, rather than parameterized ones, so we can set it for clarity.
* Fixed #31765 -- Enforced enhanced ALTER TABLE behavior for SQLite connections.Adam Johnson2021-12-071-5/+0
|
* Removed unneeded can_use_chunked_reads feature flag on SQLite.Mariusz Felisiak2021-11-251-4/+0
| | | Unneeded since c0e3c65b9d1b26cfc38137b7666ef0e108aab77f.
* Fixed #33224 -- Removed ↵Hasan Ramezani2021-11-021-1/+5
| | | | DatabaseFeatures.supports_mixed_date_datetime_comparisons.
* Fixed #33228 -- Changed value of ↵Chinmoy2021-10-281-0/+1
| | | | BaseDatabaseFeatures.has_case_insensitive_like to False.
* Fixed #32416 -- Made ThreadedWSGIServer close connections after each thread.Chris Jerdonek2021-04-121-0/+1
| | | | ThreadedWSGIServer is used by LiveServerTestCase.
* Fixed #32501 -- Added support for returning fields from INSERT statements on ↵girishsontakke2021-04-071-0/+6
| | | | SQLite 3.35+.
* Fixed #31487 -- Added precision argument to Round().Nick Pope2021-03-291-0/+6
|
* Refs #26167 -- Changed default value of ↵Hannes Ljungberg2021-01-141-1/+0
| | | | DatabaseFeatures.supports_expression_indexes to True.
* Fixed #26167 -- Added support for functional indexes.Hannes Ljungberg2021-01-131-0/+1
| | | | | | Thanks Simon Charette, Mads Jensen, and Mariusz Felisiak for reviews. Co-authored-by: Markus Holtermann <info@markusholtermann.eu>
* Fixed #32178 -- Allowed database backends to skip tests and mark expected ↵Hasan Ramezani2020-12-101-0/+31
| | | | | failures. Co-authored-by: Tim Graham <timograham@gmail.com>
* Fixed #32179 -- Added JSONObject database function.Artur Beltsov2020-12-021-0/+1
|
* Fixed #32224 -- Avoided suppressing connection errors in supports_json_field ↵Mariusz Felisiak2020-11-251-5/+6
| | | | | | | on SQLite.` Regression in 6789ded0a6ab797f0dcdfa6ad5d1cfa46e23abcd. Thanks Juan Garcia Alvite for the report.
* Fixed #31777 -- Added support for database collations to Char/TextFields.Tom Carrick2020-09-211-0/+1
| | | | Thanks Simon Charette and Mariusz Felisiak for reviews.
* Fixed #21181 -- Added Collate database function.Tom Carrick2020-08-111-0/+4
| | | | Thanks Simon Charette for reviews.
* Fixed #31836 -- Dropped support for JSONField __contains and __contained_by ↵Mariusz Felisiak2020-07-281-0/+1
| | | | | | | | | | 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".
* Fixed #31765 -- Disabled bundled SQLite renaming atomic references on macOS ↵Tom Forbes2020-07-221-1/+9
| | | | 10.15.
* Refs #31630 -- Removed DatabaseFeatures.can_introspect_autofield.Tim Graham2020-06-041-1/+0
|
* Fixed #31630 -- Replaced introspection features with ↵Hasan Ramezani2020-06-041-6/+10
| | | | DatabaseFeatures.introspected_field_types.
* Fixed #12990, Refs #27694 -- Added JSONField model field.sage2020-05-081-0/+16
| | | | | | | | | | | 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>
* Fixed #31479 -- Added support to reset sequences on SQLite.Jon Dufresne2020-04-211-1/+0
|
* Fixed #31376 -- Optimized nulls ordering when possible on SQLite and MySQL.Simon Charette2020-03-181-0/+1
| | | | | | | 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.
* Refs #13312 -- Simplified handling of nulls ordering on MySQL.Nick Pope2019-11-041-0/+1
| | | | | | | 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.
* Fixed #30859 -- Fixed DatabaseFeatures.supports_aggregate_filter_clause on ↵Mariusz Felisiak2019-10-151-0/+1
| | | | SQLite 3.30.1+.
* Refs #26608 -- Fixed DatabaseFeatures.supports_frame_range_fixed_distance on ↵Mariusz Felisiak2019-10-091-0/+1
| | | | SQLite 3.28+, MariaDB 10.2+, and MySQL 8.0.2+.
* Fixed #30661 -- Added models.SmallAutoField.Nick Pope2019-08-021-0/+1
|
* Refs #30027 -- Enabled window function tests on SQLite 3.25+.Simon Charette2019-02-091-0/+1
|
* Fixed #30116 -- Dropped support for Python 3.5.Tim Graham2019-01-301-3/+0
|
* Fixed #30108 -- Allowed adding foreign key constraints in the same statement ↵Dan Tao2019-01-291-0/+1
| | | | that adds a field.
* Refs #23748 -- Added AutoField introspection for SQLite.Nick Pope2019-01-091-0/+2
|
* Refs #29547 -- Skipped an unsupported partial index test on older versions ↵Tim Graham2018-12-261-0/+1
| | | | | of SQLite. Follow up to e5b8626c0eb223cc3d643163882c5902c40ec972.
* Fixed #30056 -- Added SQLite support for StdDev and Variance functions.Nick Pope2018-12-241-21/+0
|
* Fixed #30055 -- Dropped support for SQLite < 3.8.3.Tim Graham2018-12-221-1/+0
|
* Refs #29928 -- Added supports_pragma_foreign_key_check SQLite feature flag.Simon Charette2018-12-221-1/+2
|
* Refs #29928 -- Corrected SQLite's can_defer_constraint_checks feature flag.Simon Charette2018-12-221-1/+1
|
* Refs #29182 -- Corrected SQLite's supports_atomic_references_rename feature ↵Simon Charette2018-12-221-1/+1
| | | | flag.