summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3/base.py
AgeCommit message (Collapse)Author
2018-12-17[2.1.x] Fixed #30023 -- Prevented SQLite schema alterations while foreign ↵Simon Charette
key checks 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. Backport of 315357ad25a6590e7f4564ec2e56a22132b09001 from master.
2018-10-09[2.1.x] Refs #29784 -- Switched to https:// links where available.Jon Dufresne
Backport of 82f286cf6f198d37850d3c5df637b5665566a66b from master.
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
2017-10-03Refs #28584 -- Removed unused DatabaseFeatures.can_share_in_memory_db.Tim Graham
2017-08-11Replaced typecast_decimal() with decimal.Decimal().Sergey Fedoseev
2017-08-09Simplified SQLite converter for bool type.Sergey Fedoseev
2017-07-11Fixed #14204 -- Enforced SQLite foreign key constraints.Claude Paroz
Thanks Tim Graham for contributing to the patch and Simon Charette for advice and review.
2017-06-08Fixed #28103 -- Added quarter extract, truncation, and lookup.Mads Jensen
Thanks Mariusz Felisiak, Tim Graham, and Adam Johnson for review.
2017-05-23Refs #27859 -- Added DatabaseWrapper.display_name.Mariusz Felisiak
Thanks Tim Graham for the review.
2017-04-27Refs #27795 -- Replaced many force_text() with str()Claude Paroz
Thanks Tim Graham for the review.
2017-02-28Refs #27656 -- Updated django.db docstring verbs according to PEP 257.Anton Samarchyan
2017-02-09Refs #23919 -- Removed default 'utf-8' argument for str.encode()/decode().Tim Graham
2017-01-20Refs #23919 -- Removed pysqlite support (it's Python 2 only).Tim Graham
2017-01-20Refs #23919 -- Removed unneeded str() callsClaude Paroz
2017-01-18Refs #23919 -- Removed six.<various>_types usageClaude Paroz
Thanks Tim Graham and Simon Charette for the reviews.
2017-01-18Refs #23919 -- Removed six.PY2/PY3 usageClaude Paroz
Thanks Tim Graham for the review.
2017-01-18Refs #23919 -- Removed encoding preambles and future importsClaude Paroz
2017-01-17Refs #26154 -- Removed deprecated CommaSeparatedIntegerField.Tim Graham
2017-01-17Refs #19738 -- Removed timezone conversion in SQL queries executed outside ↵Tim Graham
of the ORM. Per deprecation timeline.
2017-01-16Moved unneeded ImproperlyConfigured inner imports.Tim Graham
2017-01-11Refs #16614 -- Made QuerySet.iterator() use server-side cursors on PostgreSQL.François Freitag
Thanks to Josh Smeaton for the idea of implementing server-side cursors in PostgreSQL from the iterator method, and Anssi Kääriäinen and Kevin Turner for their previous work. Also Simon Charette and Tim Graham for review.
2016-11-14Fixed E305 flake8 warnings.Ramin Farajpour Cami
2016-11-11Fixed #25240 -- Added ExtractWeek and exposed it through the __week lookup.Mads Jensen
Thanks to Mariusz Felisiak and Tim Graham for review.
2016-10-27Fixed #27327 -- Simplified time zone handling by requiring pytz.Tim Graham
2016-09-26Removed DatabaseError and IntegrityError declarations from database backends.Adam Chainz
Unused since 11ee9746a0530ec38f523fb4de44950d9b783877.
2016-09-08Fixed #27170 -- Added DatabaseWrapper class attributes to ease subclassing.Chris Jerdonek
2016-08-17Fixed #27077 -- Made SQLite's in-memory database checks DRYer.Chris Jerdonek
2016-07-08Fixed #26348 -- Added TruncTime and exposed it through the __time lookup.Simon Charette
Thanks Tim for the review.
2016-07-08Refs #25774, #26348 -- Allowed Trunc functions to operate with time fields.Simon Charette
Thanks Josh for the amazing testing setup and Tim for the review.
2016-04-08Fixed E128 flake8 warnings in django/.Tim Graham
2016-02-26Fixed #24793 -- Unified temporal difference support.Simon Charette
2015-12-25Fixed #14286 -- Added models.BigAutoField.Alexander Sosnovskiy
2015-06-24Renamed RemovedInDjangoXYWarnings for new roadmap.Tim Graham
Forwardport of ae1d663b7913f6da233c55409c4973248372d302 from stable/1.8.x plus more.
2015-06-04Fixed #22316 -- Added time filters to TimeField on SQLite.Matthew Somerville
This was implemented for non-SQLite backends in 1.7 (as a side effect of #16187).
2015-06-02Fixed #9596 -- Added date transform for DateTimeField.Jon Dufresne
2015-05-17Fixed #23820 -- Supported per-database time zone.Aymeric Augustin
The primary use case is to interact with a third-party database (not primarily managed by Django) that doesn't support time zones and where datetimes are stored in local time when USE_TZ is True. Configuring a PostgreSQL database with the TIME_ZONE option while USE_TZ is False used to result in silent data corruption. Now this is an error.
2015-05-17Removed global timezone-aware datetime adapters.Aymeric Augustin
Refs #23820. Fixed #19738. Refs #17755. In order not to introduce a regression for raw queries, parameters are passed through the connection.ops.value_to_db_* methods, depending on their type.
2015-05-17Removed global timezone-aware datetime converters.Aymeric Augustin
Refs #23820.
2015-02-17Refs #24324 -- Fixed UnicodeEncodeError in SQLite backend while testing.Tim Graham
If 'name' contained non-ASCII characters, the comparison raised a UnicodeEncodeError on Python 2.
2015-02-06Sorted imports with isort; refs #23860.Tim Graham