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.Comparator[source]

Bases: enum.Enum

An enumeration.

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.Order[source]

Bases: enum.Enum

An enumeration.

asc = 'ASC'
desc = 'DESC'
class pypika.enums.SqlType(name)[source]

Bases: object

get_sql(**kwargs)[source]
class pypika.enums.SqlTypeLength(name, length)[source]

Bases: object

get_sql(**kwargs)[source]
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>
class pypika.enums.UnionType[source]

Bases: enum.Enum

An enumeration.

all = ' ALL'
distinct = ''