pypika.enums module

class pypika.enums.Arithmetic

Bases: enum.Enum

An enumeration.

add = '+'

div = '/'

mul = '*'

sub = '-'

class pypika.enums.Boolean

Bases: pypika.enums.Comparator

An enumeration.

and_ = 'AND'

false = 'FALSE'

or_ = 'OR'

true = 'TRUE'

xor_ = 'XOR'

class pypika.enums.Comparator

Bases: enum.Enum

An enumeration.

class pypika.enums.DatePart

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

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

Bases: pypika.enums.Comparator

An enumeration.

eq = '='

gt = '>'

gte = '>='

lt = '<'

lte = '<='

ne = '<>'

class pypika.enums.JSONOperators

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

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

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

Bases: enum.Enum

An enumeration.

asc = 'ASC'

desc = 'DESC'

class pypika.enums.SqlType(name)

Bases: object

get_sql(**kwargs)

class pypika.enums.SqlTypeLength(name, length)

Bases: object

get_sql(**kwargs)

class pypika.enums.SqlTypes

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

Bases: enum.Enum

An enumeration.

all = ' ALL'

distinct = ''