pypika.enums module¶
-
class
pypika.enums.Arithmetic(*args, **kwds)[source]¶ Bases:
aenum.Enum-
add= <Arithmetic.add: '+'>¶
-
div= <Arithmetic.div: '/'>¶
-
mul= <Arithmetic.mul: '*'>¶
-
sub= <Arithmetic.sub: '-'>¶
-
-
class
pypika.enums.Boolean(*args, **kwds)[source]¶ Bases:
pypika.enums.Comparator-
and_= <Boolean.and_: 'AND'>¶
-
or_= <Boolean.or_: 'OR'>¶
-
xor_= <Boolean.xor_: 'XOR'>¶
-
-
class
pypika.enums.DatePart(*args, **kwds)[source]¶ Bases:
aenum.Enum-
day= <DatePart.day: 'DAY'>¶
-
hour= <DatePart.hour: 'HOUR'>¶
-
microsecond= <DatePart.microsecond: 'MICROSECOND'>¶
-
minute= <DatePart.minute: 'MINUTE'>¶
-
month= <DatePart.month: 'MONTH'>¶
-
quarter= <DatePart.quarter: 'QUARTER'>¶
-
second= <DatePart.second: 'SECOND'>¶
-
week= <DatePart.week: 'WEEK'>¶
-
year= <DatePart.year: 'YEAR'>¶
-
-
class
pypika.enums.Dialects(*args, **kwds)[source]¶ Bases:
aenum.Enum-
MSSQL= <Dialects.MSSQL: 'mssql'>¶
-
MYSQL= <Dialects.MYSQL: 'mysql'>¶
-
ORACLE= <Dialects.ORACLE: 'oracle'>¶
-
POSTGRESQL= <Dialects.POSTGRESQL: 'postgressql'>¶
-
REDSHIFT= <Dialects.REDSHIFT: 'redshift'>¶
-
VERTICA= <Dialects.VERTICA: 'vertica'>¶
-
-
class
pypika.enums.Equality(*args, **kwds)[source]¶ Bases:
pypika.enums.Comparator-
eq= <Equality.eq: '='>¶
-
gt= <Equality.gt: '>'>¶
-
gte= <Equality.gte: '>='>¶
-
lt= <Equality.lt: '<'>¶
-
lte= <Equality.lte: '<='>¶
-
ne= <Equality.ne: '<>'>¶
-
-
class
pypika.enums.JoinType(*args, **kwds)[source]¶ Bases:
aenum.Enum-
inner= <JoinType.inner: ''>¶
-
left= <JoinType.left: 'LEFT'>¶
-
outer= <JoinType.outer: 'OUTER'>¶
-
right= <JoinType.right: 'RIGHT'>¶
-
-
class
pypika.enums.Matching(*args, **kwds)[source]¶ Bases:
pypika.enums.Comparator-
bin_regex= <Matching.bin_regex: ' REGEX BINARY '>¶
-
like= <Matching.like: ' LIKE '>¶
-
regex= <Matching.regex: ' REGEX '>¶
-
-
class
pypika.enums.Order(*args, **kwds)[source]¶ Bases:
aenum.Enum-
asc= <Order.asc: 'ASC'>¶
-
desc= <Order.desc: 'DESC'>¶
-
-
class
pypika.enums.SqlTypes(*args, **kwds)[source]¶ Bases:
aenum.Enum-
DATE= <SqlTypes.DATE: 'DATE'>¶
-
SIGNED= <SqlTypes.SIGNED: 'SIGNED'>¶
-
TIMESTAMP= <SqlTypes.TIMESTAMP: 'TIMESTAMP'>¶
-
UNSIGNED= <SqlTypes.UNSIGNED: 'UNSIGNED'>¶
-
VARCHAR= <SqlTypes.VARCHAR: 'VARCHAR'>¶
-
utf8= <SqlTypes.utf8: 'utf8'>¶
-