pypika.functions module¶
Package for SQL functions wrappers
-
class
pypika.functions.
Ascii
(term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Bin
(term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Cast
(term, as_type, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Coalesce
(term, default_value, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Concat
(*terms, **kwargs)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Convert
(term, encoding, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Count
(param, alias=None)[source]¶ Bases:
pypika.terms.AggregateFunction
-
distinct
(*args, **kwargs)¶
-
-
class
pypika.functions.
CurDate
(alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
CurTime
(alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Date
(term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
DateAdd
(date_part, interval, term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
DateDiff
(interval, start_date, end_date, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Extract
(date_part, field, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Insert
(term, start, stop, subterm, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Length
(term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Lower
(term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Now
(alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
NullIf
(term, criterion, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
RegexpLike
(term, pattern, modifiers, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
RegexpMatches
(term, pattern, modifiers, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Reverse
(term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Signed
(term, alias=None)[source]¶ Bases:
pypika.functions.Cast
-
class
pypika.functions.
SplitPart
(term, delimiter, index, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Substring
(term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Timestamp
(term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
TimestampAdd
(date_part, interval, term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
ToChar
(term, as_type, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Trim
(term, alias=None)[source]¶ Bases:
pypika.terms.Function
-
class
pypika.functions.
Unsigned
(term, alias=None)[source]¶ Bases:
pypika.functions.Cast
-
class
pypika.functions.
Upper
(term, alias=None)[source]¶ Bases:
pypika.terms.Function