summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3
AgeCommit message (Collapse)Author
2022-11-04[4.1.x] Fixed #34138 -- Avoided table rebuild when adding inline m2m fields ↵Mariusz Felisiak
on SQLite. Regression in 2f73e5406d54cb8945e187eff302a3a3373350be. Thanks David Wobrock for the report. Backport of 7b0e9ea53ca99de2f485ec582f3a79be34b531d4 from main
2022-10-26[4.1.x] Refs #33173 -- Fixed destroying test databases when running tests in ↵Mariusz Felisiak
parallel using spawn on Windows. Thanks Simon Willison for inspiration. Backport of 80777d30b34968c39479d943822d2d335aba1571 from main
2022-08-29[4.1.x] Fixed #33960 -- Fixed migrations crash on SQLite < 3.26.Mariusz Felisiak
Regression in 0b95a96ee10d3e12aef01d449467bcf4641286b4. Thanks Aristotelis Mikropoulos for the report. Backport of 4483a9b12f295908e68b82d6599f460de943444f from main
2022-08-08[4.1.x] Fixed #33899 -- Fixed migration crash when removing indexed field on ↵Fiza Ashraf
SQLite 3.35.5+. Regression in 702819227fd0cdd9b581cd99e11d1561d51cbeb. Thanks cessor for the report. Backport of c0beff21239e70cbdcc9597e5be09e505bb8f76c from main
2022-07-06[4.1.x] Refs CVE-2022-34265 -- Properly escaped Extract() and Trunc() ↵Simon Charette
parameters. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com> Backport of 877c800f255ccaa7abde1fb944de45d1616f5cc9 from main
2022-05-02Fixed #33413 -- Made migrations propage collations to related fields.David Wobrock
2022-04-29Fixed #33670 -- Fixed altering primary key on SQLite.Mariusz Felisiak
2022-03-15Fixed #31169 -- Adapted the parallel test runner to use spawn.David Smith
Co-authored-by: Valz <ahmadahussein0@gmail.com> Co-authored-by: Nick Pope <nick@nickpope.me.uk>
2022-03-02Fixed #33553 -- Used built-in math functions in SQLite 3.35+.Nick Pope
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.
2022-02-18Fixed #33379 -- Added minimum database version checks.Hasan Ramezani
Thanks Tim Graham for the review.
2022-02-11Refs #32502 -- Avoided table rebuild when removing fields on SQLite 3.35.5+.Mariusz Felisiak
ALTER TABLE ... DROP COLUMN was introduced in SQLite 3.35+ however a data corruption issue was fixed in SQLite 3.35.5.
2022-02-07Refs #33476 -- Refactored code to strictly match 88 characters line length.Mariusz Felisiak
2022-02-07Refs #33476 -- Reformatted code with Black.django-bot
2022-01-24Fixed #33460 -- Used VALUES clause for insert in bulk on SQLite.Keryn Knight
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).
2022-01-19Fixed #31685 -- Added support for updating conflicts to QuerySet.bulk_create().sean_c_hsu
Thanks Florian Apolloner, Chris Jerdonek, Hannes Ljungberg, Nick Pope, and Mariusz Felisiak for reviews.
2022-01-04Fixed #33408 -- Fixed adding nullable unique fields on SQLite.Mariusz Felisiak
Regression in 2f73e5406d54cb8945e187eff302a3a3373350be. Thanks Alan Crosswell for the report.
2021-12-27Refs #29517 -- Removed obsolete PositiveIntegerField test skip.Tim Graham
2021-12-23Refs #33355 -- Constructed SQLite list aggregate types once.Adam Johnson
2021-12-23Refs #33355 -- Removed @none_guard from SQLite functions.Adam Johnson
Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
2021-12-23Refs #33355 -- Made trunc functions raise ValueError on invalid lookups on ↵Adam Johnson
SQLite. Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
2021-12-23Refs #33355 -- Moved SQLite functions to separate module.Adam Johnson
Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
2021-12-23Refs #33355 -- Optimized LPad() database function on SQLite.Adam Johnson
Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
2021-12-22Refs #33355 -- Optimized Trunc() on SQLite by using f-strings.Adam Johnson
Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
2021-12-13Refs #33355 -- Fixed Trunc() with years < 1000 on SQLite.Adam Johnson
Thanks to Nick Pope for spotting the bug in Code Review. Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
2021-12-10Refs #32502 -- Avoided table rebuild when adding fields with no default on ↵Mariusz Felisiak
SQLite.
2021-12-10Fixed DatabaseFeatures.requires_literal_defaults on SQLite.Mariusz Felisiak
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.
2021-12-10Refs #32502 -- Added SchemaEditor.prepare_default() on SQLite.Mariusz Felisiak
2021-12-07Fixed #31765 -- Enforced enhanced ALTER TABLE behavior for SQLite connections.Adam Johnson
2021-11-25Removed unneeded can_use_chunked_reads feature flag on SQLite.Mariusz Felisiak
Unneeded since c0e3c65b9d1b26cfc38137b7666ef0e108aab77f.
2021-11-15Refs #33288 -- Removed SQLite's ↵Simon Charette
DatabaseIntrospection._get_foreign_key_constraints(). The get_relations() method returns the exact same data in a more generic format.
2021-11-15Fixed #33288 -- Made SQLite introspection use information schema for relations.Simon Charette
Previous solution was using brittle and complex parsing rules to extract them from the SQL used to define the tables. Removed a now unnecessary unit test that ensured the removed parsing logic accounted for optional spacing.
2021-11-15Refs #33288 -- Made SQLite introspection raise DatabaseError on nonexistent ↵Simon Charette
tables. All the other backends behave this way and we had to make adjustments to our test suite to account for this discrepancy. This also allows SQLite's get_relations() not to raise on a nonexistent table while making sure the InspectDBTestCase.test_introspection_errors test which ensures an error during introspection is surfaced in generated models files still passes.
2021-11-12Fixed #33279 -- Fixed handling time zones with "-" sign in names.Can Sarigol
Thanks yakimka for the report. Regression in fde9b7d35e4e185903cc14aa587ca870037941b1.
2021-11-10Removed DatabaseIntrospection.get_key_columns().Mariusz Felisiak
Thanks Simon Charette for the report.
2021-11-10Fixed DatabaseIntrospection.get_relations() docstring.Tim Graham
The foreign keys are "in" the given table, not "to" it.
2021-11-02Fixed #33224 -- Removed ↵Hasan Ramezani
DatabaseFeatures.supports_mixed_date_datetime_comparisons.
2021-10-28Fixed #33228 -- Changed value of ↵Chinmoy
BaseDatabaseFeatures.has_case_insensitive_like to False.
2021-10-26Fixed #32672 -- Fixed introspection of primary key constraints on SQLite.Anv3sh
Thanks Simon Charette for the implementation idea.
2021-10-12Fixed #28401 -- Allowed hashlib.md5() calls to work with FIPS kernels.Ade Lee
md5 is not an approved algorithm in FIPS mode, and trying to instantiate a hashlib.md5() will fail when the system is running in FIPS mode. md5 is allowed when in a non-security context. There is a plan to add a keyword parameter (usedforsecurity) to hashlib.md5() to annotate whether or not the instance is being used in a security context. In the case where it is not, the instantiation of md5 will be allowed. See https://bugs.python.org/issue9216 for more details. Some downstream python versions already support this parameter. To support these versions, a new encapsulation of md5() has been added. This encapsulation will pass through the usedforsecurity parameter in the case where the parameter is supported, and strip it if it is not. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
2021-09-16Fixed #32365 -- Made zoneinfo the default timezone implementation.Carlton Gibson
Thanks to Adam Johnson, Aymeric Augustin, David Smith, Mariusz Felisiak, Nick Pope, and Paul Ganssle for reviews.
2021-07-27Fixed #32962 -- Consolidated string concatenations in ↵Chris Jerdonek
BaseDatabaseSchemaEditor.column_sql().
2021-05-25Fixed #32780 -- Made Add/RemoveConstraint operations a noop for ↵Hannes Ljungberg
covering/deferrable unique constraints on SQLite.
2021-04-20Refs #25287 -- Added support for multiplying and dividing DurationField by ↵Tobias Bengfort
scalar values on SQLite.
2021-04-20Refs #25287 -- Added _sqlite_prepare_dtdelta_param() hook.Tobias Bengfort
2021-04-12Fixed #32416 -- Made ThreadedWSGIServer close connections after each thread.Chris Jerdonek
ThreadedWSGIServer is used by LiveServerTestCase.
2021-04-07Fixed #32501 -- Added support for returning fields from INSERT statements on ↵girishsontakke
SQLite 3.35+.
2021-03-29Fixed #31487 -- Added precision argument to Round().Nick Pope
2021-03-25Fixed #32582 -- Removed unnecessary dot in names of cloned test databases on ↵Girish Sontakke
SQLite.
2021-03-23Fixed #32483 -- Fixed QuerySet.values()/values_list() on JSONField key ↵Mariusz Felisiak
transforms with booleans on SQLite. Thanks Matthew Cornell for the report.
2021-02-23Fixed #30916 -- Added support for functional unique constraints.Hannes Ljungberg
Thanks Ian Foote and Mariusz Felisiak for reviews.
generated by cgit v1.3 (git 2.53.0) at 2026-07-12 05:33:52 +0000