summaryrefslogtreecommitdiff
path: root/tests/db_functions
AgeCommit message (Collapse)Author
2021-01-29[3.2.x] Fixed #32392 -- Fixed ExclusionConstraint crash with Cast() in ↵Tilman Koschnick
expressions. Backport of fdfbc66331292def201c9344e3cd29fbcbcd076a from master
2021-01-19[3.2.x] Refs #32365 -- Allowed use of non-pytz timezone implementations.Paul Ganssle
Backport of 10d126198434810529e0220b0c6896ed64ca0e88 from master
2020-12-10Fixed #32178 -- Allowed database backends to skip tests and mark expected ↵Hasan Ramezani
failures. Co-authored-by: Tim Graham <timograham@gmail.com>
2020-12-02Fixed #32179 -- Added JSONObject database function.Artur Beltsov
2020-10-14Fixed #31640 -- Made Trunc() truncate datetimes to Date/TimeField in a ↵David-Wobrock
specific timezone.
2020-10-14Removed redundant tests in test_extract_trunc.David-Wobrock
tzinfo is ignored for DateFields and TimeFields, and it's already covered by DateFunctionTests.test_trunc_func().
2020-10-14Refs #31640 -- Made Extract raise ValueError when using tzinfo with ↵David-Wobrock
Date/TimeField.
2020-10-02Fixed #32060 -- Added Random database function.Nick Pope
2020-09-18Refs #21181 -- Corrected DatabaseFeatures.test_collations for Swedish collation.Tom Carrick
Previously, backends used different keys "swedish-ci" or "swedish_ci".
2020-09-09Fixed #31987 -- Fixed Cast() with DurationField on MySQL.Petr Čermák
2020-09-02Fixed #31948 -- Added tzinfo parameter to TruncDate() and TruncTime().Joe Jackson
2020-08-11Fixed #21181 -- Added Collate database function.Tom Carrick
Thanks Simon Charette for reviews.
2020-06-16Refs #30446 -- Defined default output_field of text database functions.Simon Charette
This prevented the default behavior of BaseExpression._resolve_output_field from error'ing out when such functions accepted both expressions from mixed types (e.g. SubStr(CharField, IntegerField, IntegerField)).
2020-04-30Removed unused __str__() methods in tests models.Mariusz Felisiak
Follow up to 6461583b6cc257d25880ef9a9fd7e2125ac53ce1.
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-19Removed unnecessary numeric indexes in format strings.Jon Dufresne
2019-10-29Used more specific unittest assertions in tests.Nick Pope
* assertIsNone()/assertIsNotNone() instead of comparing to None. * assertLess() for < comparisons. * assertIs() for 'is' expressions. * assertIsInstance() for isinstance() expressions. * rounding of assertAlmostEqual() for round() expressions. * assertIs(..., True/False) instead of comparing to True/False. * assertIs()/assertIsNot() for ==/!= comparisons. * assertNotEqual() for == comparisons. * assertTrue()/assertFalse() instead of comparing to True/False.
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-07-12Fixed #30602 -- Made Extract raise ValueError when using unsupported lookups ↵Hasan Ramezani
for DurationField.
2019-06-13Fixed #30128 -- Fixed handling timedelta timezone in database functions.can
2019-05-21Fixed #29396 -- Added indirect values support to __year lookups.Simon Charette
Thanks Windson Yang for the initial patch.
2019-05-21Fixed #30494 -- Disabled __year lookup optimization for indirect values.Simon Charette
The previous heuristics were naively enabling the BETWEEN optimization on successful cast of the first rhs SQL params to an integer while it was not appropriate for a lot of database resolved expressions. Thanks Alexey Chernov for the report.
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-03-14Simplified test_transform()s in db_functions.math.Mariusz Felisiak
2019-03-07Fixed #29754 -- Added is_dst parameter to Trunc database functions.ahbk
2019-02-21Refs #28643 -- Added MD5 database function.Mariusz Felisiak
Thanks Tim Graham, Nick Pope and Simon Charette for reviews.
2019-01-12Refs #28643 -- Added Reverse database function.Nick Pope
Thanks Mariusz Felisiak for Oracle advice and review.
2019-01-10Refs #28643 -- Added NullIf database function.Mads Jensen
Thanks Nick Pope, Mariusz Felisiak, and Tim Graham for reviews.
2018-10-15Fixed #29845 -- Fixed Cast crash on MySQL when casting to DecimalField.Mariusz Felisiak
2018-10-01Fixed #29767 -- Made date-related casts work on SQLiteClaude Paroz
Thanks Rémy Hubscher for the report and Tim Graham and Simon Charette for the reviews.
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-08-21Fixed #29658 -- Registered model lookups in tests with a context manager.Srinivas Reddy Thatiparthy (శ్రీనివాస్ రెడ్డి తాటిపర్తి)
2018-08-18Fixed #28649 -- Added ExtractIsoYear database function and iso_year lookup.Sigurd Ljødal
2018-08-16Reorganized datetime db function tests.Nick Pope
2018-08-16Reorganized comparison db function tests.Nick Pope
2018-08-16Reorganized text db function tests.Nick Pope
2018-08-16Reorganized window db function tests.Nick Pope
2018-08-07Fixed #29648 -- Fixed crash when using subqueries inside datetime truncation ↵Raphael Michel
functions.
2018-07-25Fixed #29569 -- Fixed Cast() with AutoField and BigAutoField.Mariusz Felisiak
2018-07-05Refs #28643 -- Added math database functions.Junyi Jiao
Thanks Nick Pope for much review.
2018-04-03Refs #28643 -- Added Repeat database function.Mariusz Felisiak
Thanks Tim Graham and Nick Pope for reviews.
2018-04-03Fixed #29251 -- Added bytes to str conversion in LPad/RPad database ↵Mariusz Felisiak
functions on MySQL. Thanks Tim Graham for the review.
2018-03-19Refs #28643 -- Added LPad and RPad database functions.Mariusz Felisiak
Thanks Tim Graham for the review.
2018-03-15Refs #28643 -- Added LTrim, RTrim, and Trim database functions.Mariusz Felisiak
Thanks Tim Graham and Mads Jensen for reviews.
2018-03-12Fixed #29209 -- Fixed Cast() with TextField on MySQL and Oracle.Sergey Fedoseev
2018-02-23Refs #28643 -- Added Ord, Chr, Left, and Right database functions.bobort
2018-02-19Removed redundant lookup name in register_lookup() calls.Tim Graham