codekingpro/portable-devtools
114k
1"""2PyPika is divided into a couple of modules, primarily the ``queries`` and ``terms`` modules.3 4pypika.analytics5----------------6 7Wrappers for SQL analytic functions8 9pypika.dialects10---------------11 12This contains all of the dialect specific implementations of the ``Query`` class.13 14pypika.enums15------------16 17Enumerated values are kept in this package which are used as options for Queries and Terms.18 19pypika.functions20----------------21 22Wrappers for common SQL functions are stored in this package.23 24pypika.pseudocolumns25--------------------26 27Wrappers for common SQL pseudocolumns are stored in this package.28 29pypika.queries30--------------31 32This is where the ``Query`` class can be found which is the core class in PyPika. Also, other top level classes such33as ``Table`` can be found here. ``Query`` is a container that holds all of the ``Term`` types together and also34serializes the builder to a string.35 36pypika.terms37------------38 39This module contains the classes which represent individual parts of queries that extend the ``Term`` base class.40 41pypika.utils42------------43 44This contains all of the utility classes such as exceptions and decorators.45"""46 47# noinspection PyUnresolvedReferences48from pypika.dialects import (49 ClickHouseQuery,50 Dialects,51 JiraQuery,52 MSSQLQuery,53 MySQLQuery,54 OracleQuery,55 PostgreSQLQuery,56 RedshiftQuery,57 SQLLiteQuery,58 VerticaQuery,59)60 61# noinspection PyUnresolvedReferences62from pypika.enums import (63 DatePart,64 JoinType,65 Order,66)67 68# noinspection PyUnresolvedReferences69from pypika.queries import (70 AliasedQuery,71 Column,72 Database,73 Query,74 Schema,75 Table,76)77from pypika.queries import (78 make_columns as Columns,79)80from pypika.queries import (81 make_tables as Tables,82)83 84# noinspection PyUnresolvedReferences85from pypika.terms import (86 JSON,87 Array,88 Bracket,89 Case,90 Criterion,91 CustomFunction,92 EmptyCriterion,93 Field,94 FormatParameter,95 Index,96 Interval,97 NamedParameter,98 Not,99 NullValue,100 NumericParameter,101 Parameter,102 PyformatParameter,103 QmarkParameter,104 Rollup,105 SystemTimeValue,106 Tuple,107)108 109# noinspection PyUnresolvedReferences110from pypika.utils import (111 CaseException,112 FunctionException,113 GroupingException,114 JoinException,115 QueryException,116 RollupException,117 SetOperationException,118)119 120__author__ = "Timothy Heys"121__email__ = "theys@kayak.com"122__version__ = "0.51.1"123 124NULL = NullValue()125SYSTEM_TIME = SystemTimeValue()126 127__all__ = (128 'ClickHouseQuery',129 'Dialects',130 'JiraQuery',131 'MSSQLQuery',132 'MySQLQuery',133 'OracleQuery',134 'PostgreSQLQuery',135 'RedshiftQuery',136 'SQLLiteQuery',137 'VerticaQuery',138 'DatePart',139 'JoinType',140 'Order',141 'AliasedQuery',142 'Query',143 'Schema',144 'Table',145 'Column',146 'Database',147 'Tables',148 'Columns',149 'Array',150 'Bracket',151 'Case',152 'Criterion',153 'EmptyCriterion',154 'Field',155 'Index',156 'Interval',157 'JSON',158 'Not',159 'NullValue',160 'SystemTimeValue',161 'Parameter',162 'QmarkParameter',163 'NumericParameter',164 'NamedParameter',165 'FormatParameter',166 'PyformatParameter',167 'Rollup',168 'Tuple',169 'CustomFunction',170 'CaseException',171 'GroupingException',172 'JiraQuery',173 'JoinException',174 'QueryException',175 'RollupException',176 'SetOperationException',177 'FunctionException',178 'NULL',179 'SYSTEM_TIME',180)181 