summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3/base.py
AgeCommit message (Collapse)Author
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-11-19Fixed #32201 -- Removed obsolete isort:skip's.Seamus Quinn
Obsolete as of isort 5.
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-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-03Removed duplicated sqlite3 converter.Sergey Fedoseev
Converters typenames are case-insensitive. See https://docs.python.org/3/library/sqlite3.html#sqlite3.register_converter.
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-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-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
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-10-29Fixed #30899 -- Lazily compiled import time regular expressions.Hasan Ramezani
2019-10-02Fixed #30821 -- Added ExtractIsoWeekYear database function and iso_week_day ↵Anatol Ulrich
lookup.
2019-08-02Fixed #30661 -- Added models.SmallAutoField.Nick Pope
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
2019-04-08Fixed #28373 -- Used connection timezone instead of UTC when making dates ↵can
timezone-aware on MySQL, SQLite, and Oracle. Thanks vtalpaert for the initial patch. Co-Authored-By: Mariusz Felisiak <felisiak.mariusz@gmail.com>
2019-03-22Fixed #30271 -- Added the Sign database function.Nick Pope
2019-03-20Fixed #30240 -- Added SHA1, SHA224, SHA256, SHA384, and SHA512 database ↵Nick Pope
functions. Thanks Mariusz Felisiak and Tim Graham for reviews.
2019-02-21Refs #28643 -- Added MD5 database function.Mariusz Felisiak
Thanks Tim Graham, Nick Pope and Simon Charette for reviews.
2019-01-28Refs #30055 -- Added a helpful error when SQLite is too old.Tim Graham
2019-01-12Refs #28643 -- Added Reverse database function.Nick Pope
Thanks Mariusz Felisiak for Oracle advice and review.
2018-12-24Fixed #30056 -- Added SQLite support for StdDev and Variance functions.Nick Pope
2018-12-22Refs #29928 -- Added supports_pragma_foreign_key_check SQLite feature flag.Simon Charette
2018-12-22Renamed SQLite3 references to to SQLite.Simon Charette
The version suffix isn't part of the product name.
2018-12-17Refs #29928 -- Implemented fast constraint checking on SQLite 3.20+.Simon Charette
2018-12-15Fixed #30023 -- Prevented SQLite schema alterations while foreign key checks ↵Simon Charette
are enabled. Prior to this change foreign key constraint references could be left pointing at tables dropped during operations simulating unsupported table alterations because of an unexpected failure to disable foreign key constraint checks. SQLite3 does not allow disabling such checks while in a transaction so they must be disabled beforehand. Thanks ezaquarii for the report and Carlton and Tim for the review.
2018-10-25Removed useless check in sqlite's DatabaseWrapper._savepoint_allowed().Tim Graham
Obsolete since 27193aea0088b238e3ee0f0f235364a34a09265c.
2018-09-26Refs #29784 -- Switched to https:// links where available.Jon Dufresne
2018-09-10Fixed #29500 -- Fixed SQLite function crashes on null values.Srinivas Reddy Thatiparthy
Co-authored-by: Srinivas Reddy Thatiparthy <thatiparthysreenivas@gmail.com> Co-authored-by: Nick Pope <nick.pope@flightdataservices.com>
2018-09-10Combined two identical SQLite functions.Nick Pope
2018-09-10Made some date parsing in SQLite functions more DRY.Nick Pope
2018-08-18Fixed #28649 -- Added ExtractIsoYear database function and iso_year lookup.Sigurd Ljødal
2018-07-05Refs #28643 -- Added math database functions.Junyi Jiao
Thanks Nick Pope for much review.
2018-07-02Simplified SQLite's Decimal adapter.Sergey Fedoseev
2018-06-25Fixed #29517 -- Added support for SQLite column check constraints on ↵Tim Graham
positive integer fields.
2018-04-03Refs #28643 -- Added Repeat database function.Mariusz Felisiak
Thanks Tim Graham and Nick Pope for reviews.
2018-03-19Refs #28643 -- Added LPad and RPad database functions.Mariusz Felisiak
Thanks Tim Graham for the review.
2018-01-31Removed uneeded comment in DatabaseWrapper.check_constraints() on ↵Mariusz Felisiak
SQLite/MySQL backends.
2018-01-27Fixed #28650 -- Added TruncWeek database function.Sigurd Ljødal
2018-01-04Refs #28459 -- Improved performance of duration expressions on SQLite.Sergey Fedoseev
2017-12-29Refs #28459 -- Used default date converter on SQLite for better performance.Sergey Fedoseev
See https://docs.python.org/3/library/sqlite3.html#default-adapters-and-converters.
2017-12-28Fixed #28926 -- Fixed loss of precision of big DurationField values on ↵Sergey Fedoseev
SQLite and MySQL.
2017-12-26Refs #28459 -- Improved performance of loading DecimalField on SQLite.Sergey Fedoseev
2017-12-12Simplified SQLite converter for bool type.Sergey Fedoseev
2017-12-11Fixed #28909 -- Simplified code using tuple/list/set/dict unpacking.Nick Pope
2017-11-28Fixed #28853 -- Updated connection.cursor() uses to use a context manager.Jon Dufresne
generated by cgit v1.3 (git 2.53.0) at 2026-07-08 18:52:34 +0000