summaryrefslogtreecommitdiff
path: root/django/db/models/functions
AgeCommit message (Collapse)Author
2020-08-11Fixed #21181 -- Added Collate database function.Tom Carrick
Thanks Simon Charette for reviews.
2020-07-30Bumped minimum isort version to 5.1.0.David Smith
Fixed inner imports per isort 5. isort 5.0.0 to 5.1.0 was unstable.
2020-07-02Fixed #31758 -- Removed unneeded BytesToCharFieldConversionMixin.Sergey Fedoseev
Bug was fixed in mysqlclient 1.3.13.
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-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-02-04Simplified imports from django.db and django.contrib.gis.db.Nick Pope
2019-10-02Removed redundant names in django.db.models.functions.__all__.Mariusz Felisiak
2019-10-02Fixed #30821 -- Added ExtractIsoWeekYear database function and iso_week_day ↵Anatol Ulrich
lookup.
2019-07-12Fixed #30602 -- Made Extract raise ValueError when using unsupported lookups ↵Hasan Ramezani
for DurationField.
2019-06-05Fixed #30542 -- Fixed crash of numerical aggregations with filter.Étienne Beaulé
Filters in annotations crashed when used with numerical-type aggregations (i.e. Avg, StdDev, and Variance). This was caused as the source expressions no not necessarily have an output_field (such as the filter field), which lead to an AttributeError: 'WhereNode' object has no attribute output_field. Thanks to Chuan-Zheng Lee for the report. Regression in c690afb873cac8035a3cb3be7c597a5ff0e4b261 and two following commits.
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-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-02-04Fixed #30156 -- Dropped support for SpatiaLite 4.1 and 4.2.Tim Graham
2019-01-14Refs #28643 -- Extracted DurationField logic for Avg() and Sum() into mixin.Nick Pope
Also addresses Sum() not handling the filter option correctly.
2019-01-14Refs #28643 -- Changed Avg() to use NumericOutputFieldMixin.Nick Pope
Keeps precision instead of forcing DecimalField to FloatField.
2019-01-14Refs #28643 -- Moved db function mixins to a separate module.Nick Pope
2019-01-14Avoided calling as_oracle() for SQLite in Left database function.Nick Pope
2019-01-14Corrected comment in TruncTime database function.Nick Pope
2019-01-14Simplified overriding source expressions in some database functions.Nick Pope
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.
2019-01-08Simplified some imports for database functions.Nick Pope
Used more specific modules to reduce the risk of circular imports.
2018-11-30Refs #28643 -- Skipped ATan2() workaround on SpatiaLite 5+.Nick Pope
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-23Fixed #29048 -- Added **extra_context to database function as_vendor() methods.priyanshsaxena
2018-08-18Fixed #28649 -- Added ExtractIsoYear database function and iso_year lookup.Sigurd Ljødal
2018-08-07Fixed #29648 -- Fixed crash when using subqueries inside datetime truncation ↵Raphael Michel
functions.
2018-07-05Refs #26608 -- Removed unneeded name attribute in window functions.Mads Jensen
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-02-23Refs #28643 -- Added Ord, Chr, Left, and Right database functions.bobort
2018-01-27Fixed #28650 -- Added TruncWeek database function.Sigurd Ljødal
2018-01-17Refs #28643 -- Added Replace database function.Mads Jensen
2018-01-17Fixed #28857 -- Fixed invalid SQL when using Cast with complex expressions ↵hayashi
on PostgreSQL.
2017-12-27Fixed #28967 -- Prevented Cast to FloatField from rounding to integer on MySQL.Sergey Fedoseev
2017-10-13Refs #28643 -- Reorganized database functions.Mariusz Felisiak
Thanks Tim Graham for the review.
2017-09-18Fixed #26608 -- Added support for window expressions (OVER clause).Mads Jensen
Thanks Josh Smeaton, Mariusz Felisiak, Sergey Fedoseev, Simon Charettes, Adam Chainz/Johnson and Tim Graham for comments and reviews and Jamie Cockburn for initial patch.
2017-09-11Fixed #28492 -- Defined default output_field of expressions at the class level.Simon Charette
This wasn't possible when settings were accessed during Field initialization time as our test suite setup script was triggering imports of expressions before settings were configured.
2017-09-07Removed unneeded __init__() methods.Sergey Fedoseev
2017-07-31Removed unneeded TruncBase.arity.Sergey Fedoseev
Uneeded since its introduction in 2a4af0ea43512370764303d35bc5309f8abce666.
2017-07-26Allowed database backends to specify data types for Cast().Mariusz Felisiak
A small refactor ahead of refs #28371.
2017-07-20Fixed #28370 -- Deprecated the context arg of Field.from_db_value() and ↵Tim Graham
Expression.convert_value(). Unused since a0d166306fbdc41f49e6fadf4ec84b17eb147daa.
2017-07-17Fixed #28391 -- Fixed Cast() with CharField and max_length on MySQL.Mariusz Felisiak
Thanks Tim Graham for the review.
2017-07-14Fixed #28394 -- Allowed setting BaseExpression.output_field (renamed from ↵Sergey Fedoseev
_output_field).