summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3
Commit message (Collapse)AuthorAgeFilesLines
* Fixed #470 -- Added support for database defaults on fields.Ian Foote2023-05-122-4/+22
| | | | | | | | Special thanks to Hannes Ljungberg for finding multiple implementation gaps. Thanks also to Simon Charette, Adam Johnson, and Mariusz Felisiak for reviews.
* Moved SQLite DatabaseSchemaEditor.add_field()'s comment to the correct line.Mariusz Felisiak2023-05-091-2/+1
|
* Refs #27236 -- Made more cosmetic edits to Meta.index_together deprecation.Mariusz Felisiak2023-05-051-2/+3
|
* Fixed #34370 -- Added integer fields validation as 64-bit on SQLite.nabil-rady2023-03-081-2/+9
|
* Refs #33476 -- Applied Black's 2023 stable style.David Smith2023-02-011-1/+1
| | | | | | | | Black 23.1.0 is released which, as the first release of the year, introduces the 2023 stable style. This incorporates most of last year's preview style. https://github.com/psf/black/releases/tag/23.1.0
* Refs #34233 -- Referenced isocalendar() results by names not indexes.Mariusz Felisiak2023-01-181-2/+2
| | | isocalendar() returns a namedtuple() instead of tuple in Python 3.9+
* Fixed #34233 -- Dropped support for Python 3.8 and 3.9.Mariusz Felisiak2023-01-181-7/+2
|
* Refs #32365 -- Removed support for pytz timezones per deprecation timeline.Mariusz Felisiak2023-01-171-3/+7
|
* Made inspectdb used Cursor.description.display_size for CharFields' max_length.Mariusz Felisiak2022-12-081-1/+1
| | | internal_size is size for fixed-size types not for char types.
* Fixed #34201 -- Bumped minimum supported SQLite to 3.21.0.Mariusz Felisiak2022-12-082-102/+48
|
* 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 #28987 -- Fixed altering ManyToManyField when changing to ↵DevilsAutumn2022-11-171-18/+31
| | | | self-referential.
* Used super().execute/executemany() in SQLiteCursorWrapper.Nick Pope2022-11-081-3/+3
|
* Fixed #10070 -- Added support for pyformat style parameters on SQLite.Ryan Cheley2022-11-082-9/+29
| | | | Co-authored-by: Nick Pope <nick@nickpope.me.uk>
* Fixed #34138 -- Avoided table rebuild when adding inline m2m fields on SQLite.Mariusz Felisiak2022-11-041-1/+4
| | | | | Regression in 2f73e5406d54cb8945e187eff302a3a3373350be. Thanks David Wobrock for the report.
* Removed obsolete references to pysqlite.Nick Pope2022-11-042-5/+3
| | | | Obsolete since 1b06d5e6f6be8e567ce78c892c485af039830d7d.
* 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.
* Used more augmented assignment statements.Nick Pope2022-10-311-2/+2
| | | | | | Identified using the following command: $ git grep -I '\(\<[_a-zA-Z0-9]\+\>\) *= *\1 *[-+/*^%&|<>@]'
* Refs #33173 -- Fixed destroying test databases when running tests in ↵Mariusz Felisiak2022-10-261-0/+1
| | | | | | parallel using spawn on Windows. Thanks Simon Willison for inspiration.
* Fixed #33960 -- Fixed migrations crash on SQLite < 3.26.Mariusz Felisiak2022-08-291-1/+1
| | | | | Regression in 0b95a96ee10d3e12aef01d449467bcf4641286b4. Thanks Aristotelis Mikropoulos for the report.
* Fixed #33899 -- Fixed migration crash when removing indexed field on SQLite ↵Fiza Ashraf2022-08-081-2/+3
| | | | | | | | 3.35.5+. Regression in 702819227fd0cdd9b581cd99e11d1561d51cbeb. Thanks cessor for the report.
* Stopped using default adapters/converters on SQLite backend.Mariusz Felisiak2022-07-211-1/+13
| | | | Default adapters/converters were deprecated in Python 3.12, see https://github.com/python/cpython/issues/90016.
* 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>
* Fixed #32234 -- Made inspectdb inform about composite primary keys.Anv3sh2022-06-012-9/+12
|
* Fixed #33413 -- Made migrations propage collations to related fields.David Wobrock2022-05-021-1/+5
|
* Fixed #33670 -- Fixed altering primary key on SQLite.Mariusz Felisiak2022-04-291-1/+6
|
* Fixed #31169 -- Adapted the parallel test runner to use spawn.David Smith2022-03-151-5/+55
| | | | | Co-authored-by: Valz <ahmadahussein0@gmail.com> Co-authored-by: Nick Pope <nick@nickpope.me.uk>
* Fixed #33553 -- Used built-in math functions in SQLite 3.35+.Nick Pope2022-03-021-18/+21
| | | | | | In SQLite 3.35+ some math functions are available built-in as long as they are not disabled at compile time. We can introspect this and use these built-in functions in preference to our slower implementations.
* Fixed #33379 -- Added minimum database version checks.Hasan Ramezani2022-02-182-12/+4
| | | | Thanks Tim Graham for the review.
* Refs #32502 -- Avoided table rebuild when removing fields on SQLite 3.35.5+.Mariusz Felisiak2022-02-112-0/+12
| | | | 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-075-18/+47
|
* Refs #33476 -- Reformatted code with Black.django-bot2022-02-078-544/+774
|
* 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-192-2/+23
| | | | | Thanks Florian Apolloner, Chris Jerdonek, Hannes Ljungberg, Nick Pope, and Mariusz Felisiak for reviews.
* Fixed #33408 -- Fixed adding nullable unique fields on SQLite.Mariusz Felisiak2022-01-041-4/+9
| | | | | Regression in 2f73e5406d54cb8945e187eff302a3a3373350be. Thanks Alan Crosswell for the report.
* Refs #29517 -- Removed obsolete PositiveIntegerField test skip.Tim Graham2021-12-271-3/+0
|
* Refs #33355 -- Constructed SQLite list aggregate types once.Adam Johnson2021-12-231-12/+24
|
* Refs #33355 -- Removed @none_guard from SQLite functions.Adam Johnson2021-12-231-49/+212
| | | | Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
* Refs #33355 -- Made trunc functions raise ValueError on invalid lookups on ↵Adam Johnson2021-12-231-0/+3
| | | | | | SQLite. Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
* Refs #33355 -- Moved SQLite functions to separate module.Adam Johnson2021-12-232-289/+307
| | | | Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
* Refs #33355 -- Optimized LPad() database function on SQLite.Adam Johnson2021-12-231-2/+3
| | | | Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
* Refs #33355 -- Optimized Trunc() on SQLite by using f-strings.Adam Johnson2021-12-221-16/+16
| | | | Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
* Refs #33355 -- Fixed Trunc() with years < 1000 on SQLite.Adam Johnson2021-12-131-13/+13
| | | | | | Thanks to Nick Pope for spotting the bug in Code Review. Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
* Refs #32502 -- Avoided table rebuild when adding fields with no default on ↵Mariusz Felisiak2021-12-101-8/+9
| | | | SQLite.
* 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.
* Refs #32502 -- Added SchemaEditor.prepare_default() on SQLite.Mariusz Felisiak2021-12-101-3/+6
|
* Fixed #31765 -- Enforced enhanced ALTER TABLE behavior for SQLite connections.Adam Johnson2021-12-072-5/+3
|
* Removed unneeded can_use_chunked_reads feature flag on SQLite.Mariusz Felisiak2021-11-251-4/+0
| | | Unneeded since c0e3c65b9d1b26cfc38137b7666ef0e108aab77f.