1 files changed, 173 insertions, 29 deletions
diff --git a/django/db/models/functions/__init__.py b/django/db/models/functions/__init__.py
index d687af135d..cd7c801894 100644
--- a/django/db/models/functions/__init__.py
+++ b/django/db/models/functions/__init__.py
@@ -1,46 +1,190 @@
-from .comparison import (
-    Cast, Coalesce, Collate, Greatest, JSONObject, Least, NullIf,
-)
+from .comparison import Cast, Coalesce, Collate, Greatest, JSONObject, Least, NullIf
 from .datetime import (
-    Extract, ExtractDay, ExtractHour, ExtractIsoWeekDay, ExtractIsoYear,
-    ExtractMinute, ExtractMonth, ExtractQuarter, ExtractSecond, ExtractWeek,
-    ExtractWeekDay, ExtractYear, Now, Trunc, TruncDate, TruncDay, TruncHour,
-    TruncMinute, TruncMonth, TruncQuarter, TruncSecond, TruncTime, TruncWeek,
+    Extract,
+    ExtractDay,
+    ExtractHour,
+    ExtractIsoWeekDay,
+    ExtractIsoYear,
+    ExtractMinute,
+    ExtractMonth,
+    ExtractQuarter,
+    ExtractSecond,
+    ExtractWeek,
+    ExtractWeekDay,
+    ExtractYear,
+    Now,
+    Trunc,
+    TruncDate,
+    TruncDay,
+    TruncHour,
+    TruncMinute,
+    TruncMonth,
+    TruncQuarter,
+    TruncSecond,
+    TruncTime,
+    TruncWeek,
     TruncYear,
 )
 from .math import (
-    Abs, ACos, ASin, ATan, ATan2, Ceil, Cos, Cot, Degrees, Exp, Floor, Ln, Log,
-    Mod, Pi, Power, Radians, Random, Round, Sign, Sin, Sqrt, Tan,
+    Abs,
+    ACos,
+    ASin,
+    ATan,
+    ATan2,
+    Ceil,
+    Cos,
+    Cot,
+    Degrees,
+    Exp,
+    Floor,
+    Ln,
+    Log,
+    Mod,
+    Pi,
+    Power,
+    Radians,
+    Random,
+    Round,
+    Sign,
+    Sin,
+    Sqrt,
+    Tan,
 )
 from .text import (
-    MD5, SHA1, SHA224, SHA256, SHA384, SHA512, Chr, Concat, ConcatPair, Left,
-    Length, Lower, LPad, LTrim, Ord, Repeat, Replace, Reverse, Right, RPad,
-    RTrim, StrIndex, Substr, Trim, Upper,
+    MD5,
+    SHA1,
+    SHA224,
+    SHA256,
+    SHA384,
+    SHA512,
+    Chr,
+    Concat,
+    ConcatPair,
+    Left,
+    Length,
+    Lower,
+    LPad,
+    LTrim,
+    Ord,
+    Repeat,
+    Replace,
+    Reverse,
+    Right,
+    RPad,
+    RTrim,
+    StrIndex,
+    Substr,
+    Trim,
+    Upper,
 )
 from .window import (
-    CumeDist, DenseRank, FirstValue, Lag, LastValue, Lead, NthValue, Ntile,
-    PercentRank, Rank, RowNumber,
+    CumeDist,
+    DenseRank,
+    FirstValue,
+    Lag,
+    LastValue,
+    Lead,
+    NthValue,
+    Ntile,
+    PercentRank,
+    Rank,
+    RowNumber,
 )
 
 __all__ = [
     # comparison and conversion
-    'Cast', 'Coalesce', 'Collate', 'Greatest', 'JSONObject', 'Least', 'NullIf',
+    "Cast",
+    "Coalesce",
+    "Collate",
+    "Greatest",
+    "JSONObject",
+    "Least",
+    "NullIf",
     # datetime
-    'Extract', 'ExtractDay', 'ExtractHour', 'ExtractMinute', 'ExtractMonth',
-    'ExtractQuarter', 'ExtractSecond', 'ExtractWeek', 'ExtractIsoWeekDay',
-    'ExtractWeekDay', 'ExtractIsoYear', 'ExtractYear', 'Now', 'Trunc',
-    'TruncDate', 'TruncDay', 'TruncHour', 'TruncMinute', 'TruncMonth',
-    'TruncQuarter', 'TruncSecond', 'TruncTime', 'TruncWeek', 'TruncYear',
+    "Extract",
+    "ExtractDay",
+    "ExtractHour",
+    "ExtractMinute",
+    "ExtractMonth",
+    "ExtractQuarter",
+    "ExtractSecond",
+    "ExtractWeek",
+    "ExtractIsoWeekDay",
+    "ExtractWeekDay",
+    "ExtractIsoYear",
+    "ExtractYear",
+    "Now",
+    "Trunc",
+    "TruncDate",
+    "TruncDay",
+    "TruncHour",
+    "TruncMinute",
+    "TruncMonth",
+    "TruncQuarter",
+    "TruncSecond",
+    "TruncTime",
+    "TruncWeek",
+    "TruncYear",
     # math
-    'Abs', 'ACos', 'ASin', 'ATan', 'ATan2', 'Ceil', 'Cos', 'Cot', 'Degrees',
-    'Exp', 'Floor', 'Ln', 'Log', 'Mod', 'Pi', 'Power', 'Radians', 'Random',
-    'Round', 'Sign', 'Sin', 'Sqrt', 'Tan',
+    "Abs",
+    "ACos",
+    "ASin",
+    "ATan",
+    "ATan2",
+    "Ceil",
+    "Cos",
+    "Cot",
+    "Degrees",
+    "Exp",
+    "Floor",
+    "Ln",
+    "Log",
+    "Mod",
+    "Pi",
+    "Power",
+    "Radians",
+    "Random",
+    "Round",
+    "Sign",
+    "Sin",
+    "Sqrt",
+    "Tan",
     # text
-    'MD5', 'SHA1', 'SHA224', 'SHA256', 'SHA384', 'SHA512', 'Chr', 'Concat',
-    'ConcatPair', 'Left', 'Length', 'Lower', 'LPad', 'LTrim', 'Ord', 'Repeat',
-    'Replace', 'Reverse', 'Right', 'RPad', 'RTrim', 'StrIndex', 'Substr',
-    'Trim', 'Upper',
+    "MD5",
+    "SHA1",
+    "SHA224",
+    "SHA256",
+    "SHA384",
+    "SHA512",
+    "Chr",
+    "Concat",
+    "ConcatPair",
+    "Left",
+    "Length",
+    "Lower",
+    "LPad",
+    "LTrim",
+    "Ord",
+    "Repeat",
+    "Replace",
+    "Reverse",
+    "Right",
+    "RPad",
+    "RTrim",
+    "StrIndex",
+    "Substr",
+    "Trim",
+    "Upper",
     # window
-    'CumeDist', 'DenseRank', 'FirstValue', 'Lag', 'LastValue', 'Lead',
-    'NthValue', 'Ntile', 'PercentRank', 'Rank', 'RowNumber',
+    "CumeDist",
+    "DenseRank",
+    "FirstValue",
+    "Lag",
+    "LastValue",
+    "Lead",
+    "NthValue",
+    "Ntile",
+    "PercentRank",
+    "Rank",
+    "RowNumber",
 ]