pypika.enums module¶
-
class
pypika.enums.
Arithmetic
[source]¶ Bases:
enum.Enum
An enumeration.
-
add
= '+'¶
-
div
= '/'¶
-
mul
= '*'¶
-
sub
= '-'¶
-
-
class
pypika.enums.
Boolean
[source]¶ Bases:
pypika.enums.Comparator
An enumeration.
-
and_
= 'AND'¶
-
false
= 'FALSE'¶
-
or_
= 'OR'¶
-
true
= 'TRUE'¶
-
xor_
= 'XOR'¶
-
-
class
pypika.enums.
DatePart
[source]¶ Bases:
enum.Enum
An enumeration.
-
day
= 'DAY'¶
-
hour
= 'HOUR'¶
-
microsecond
= 'MICROSECOND'¶
-
minute
= 'MINUTE'¶
-
month
= 'MONTH'¶
-
quarter
= 'QUARTER'¶
-
second
= 'SECOND'¶
-
week
= 'WEEK'¶
-
year
= 'YEAR'¶
-
-
class
pypika.enums.
Dialects
[source]¶ Bases:
enum.Enum
An enumeration.
-
CLICKHOUSE
= 'clickhouse'¶
-
MSSQL
= 'mssql'¶
-
MYSQL
= 'mysql'¶
-
ORACLE
= 'oracle'¶
-
POSTGRESQL
= 'postgressql'¶
-
REDSHIFT
= 'redshift'¶
-
SNOWFLAKE
= 'snowflake'¶
-
SQLLITE
= 'sqllite'¶
-
VERTICA
= 'vertica'¶
-
-
class
pypika.enums.
Equality
[source]¶ Bases:
pypika.enums.Comparator
An enumeration.
-
eq
= '='¶
-
gt
= '>'¶
-
gte
= '>='¶
-
lt
= '<'¶
-
lte
= '<='¶
-
ne
= '<>'¶
-
-
class
pypika.enums.
JSONOperators
[source]¶ Bases:
enum.Enum
An enumeration.
-
CONTAINED_BY
= '<@'¶
-
CONTAINS
= '@>'¶
-
GET_JSON_VALUE
= '->'¶
-
GET_PATH_JSON_VALUE
= '#>'¶
-
GET_PATH_TEXT_VALUE
= '#>>'¶
-
GET_TEXT_VALUE
= '->>'¶
-
HAS_ANY_KEYS
= '?|'¶
-
HAS_KEY
= '?'¶
-
HAS_KEYS
= '?&'¶
-
-
class
pypika.enums.
JoinType
[source]¶ Bases:
enum.Enum
An enumeration.
-
cross
= 'CROSS'¶
-
full_outer
= 'FULL OUTER'¶
-
inner
= ''¶
-
left
= 'LEFT'¶
-
left_outer
= 'LEFT OUTER'¶
-
outer
= 'FULL OUTER'¶
-
right
= 'RIGHT'¶
-
right_outer
= 'RIGHT OUTER'¶
-
-
class
pypika.enums.
Matching
[source]¶ Bases:
pypika.enums.Comparator
An enumeration.
-
bin_regex
= ' REGEX BINARY '¶
-
ilike
= ' ILIKE '¶
-
like
= ' LIKE '¶
-
not_ilike
= ' NOT ILIKE '¶
-
not_like
= ' NOT LIKE '¶
-
regex
= ' REGEX '¶
-
-
class
pypika.enums.
SqlTypes
[source]¶ Bases:
object
-
BINARY
= <pypika.enums.SqlType object>¶
-
BOOLEAN
= 'BOOLEAN'¶
-
CHAR
= <pypika.enums.SqlType object>¶
-
DATE
= 'DATE'¶
-
FLOAT
= 'FLOAT'¶
-
INTEGER
= 'INTEGER'¶
-
LONG_VARBINARY
= <pypika.enums.SqlType object>¶
-
LONG_VARCHAR
= <pypika.enums.SqlType object>¶
-
NUMERIC
= 'NUMERIC'¶
-
SIGNED
= 'SIGNED'¶
-
TIME
= 'TIME'¶
-
TIMESTAMP
= 'TIMESTAMP'¶
-
UNSIGNED
= 'UNSIGNED'¶
-
VARBINARY
= <pypika.enums.SqlType object>¶
-
VARCHAR
= <pypika.enums.SqlType object>¶
-