1# __init__.py
2# Copyright (C) 2005-2025 the SQLAlchemy authors and contributors
3# <see AUTHORS file>
4#
5# This module is part of SQLAlchemy and is released under
6# the MIT License: https://www.opensource.org/licenses/mit-license.php
7
8from __future__ import annotations
9
10from typing import Any
11
12from . import util as _util
13from .engine import AdaptedConnection as AdaptedConnection
14from .engine import BaseRow as BaseRow
15from .engine import BindTyping as BindTyping
16from .engine import ChunkedIteratorResult as ChunkedIteratorResult
17from .engine import Compiled as Compiled
18from .engine import Connection as Connection
19from .engine import create_engine as create_engine
20from .engine import create_mock_engine as create_mock_engine
21from .engine import create_pool_from_url as create_pool_from_url
22from .engine import CreateEnginePlugin as CreateEnginePlugin
23from .engine import CursorResult as CursorResult
24from .engine import Dialect as Dialect
25from .engine import Engine as Engine
26from .engine import engine_from_config as engine_from_config
27from .engine import ExceptionContext as ExceptionContext
28from .engine import ExecutionContext as ExecutionContext
29from .engine import FrozenResult as FrozenResult
30from .engine import Inspector as Inspector
31from .engine import IteratorResult as IteratorResult
32from .engine import make_url as make_url
33from .engine import MappingResult as MappingResult
34from .engine import MergedResult as MergedResult
35from .engine import NestedTransaction as NestedTransaction
36from .engine import Result as Result
37from .engine import result_tuple as result_tuple
38from .engine import ResultProxy as ResultProxy
39from .engine import RootTransaction as RootTransaction
40from .engine import Row as Row
41from .engine import RowMapping as RowMapping
42from .engine import ScalarResult as ScalarResult
43from .engine import Transaction as Transaction
44from .engine import TwoPhaseTransaction as TwoPhaseTransaction
45from .engine import TypeCompiler as TypeCompiler
46from .engine import URL as URL
47from .inspection import inspect as inspect
48from .pool import AssertionPool as AssertionPool
49from .pool import AsyncAdaptedQueuePool as AsyncAdaptedQueuePool
50from .pool import NullPool as NullPool
51from .pool import Pool as Pool
52from .pool import PoolProxiedConnection as PoolProxiedConnection
53from .pool import PoolResetState as PoolResetState
54from .pool import QueuePool as QueuePool
55from .pool import SingletonThreadPool as SingletonThreadPool
56from .pool import StaticPool as StaticPool
57from .schema import BaseDDLElement as BaseDDLElement
58from .schema import BLANK_SCHEMA as BLANK_SCHEMA
59from .schema import CheckConstraint as CheckConstraint
60from .schema import Column as Column
61from .schema import ColumnDefault as ColumnDefault
62from .schema import Computed as Computed
63from .schema import Constraint as Constraint
64from .schema import DDL as DDL
65from .schema import DDLElement as DDLElement
66from .schema import DefaultClause as DefaultClause
67from .schema import ExecutableDDLElement as ExecutableDDLElement
68from .schema import FetchedValue as FetchedValue
69from .schema import ForeignKey as ForeignKey
70from .schema import ForeignKeyConstraint as ForeignKeyConstraint
71from .schema import Identity as Identity
72from .schema import Index as Index
73from .schema import insert_sentinel as insert_sentinel
74from .schema import MetaData as MetaData
75from .schema import PrimaryKeyConstraint as PrimaryKeyConstraint
76from .schema import Sequence as Sequence
77from .schema import Table as Table
78from .schema import UniqueConstraint as UniqueConstraint
79from .sql import ColumnExpressionArgument as ColumnExpressionArgument
80from .sql import NotNullable as NotNullable
81from .sql import Nullable as Nullable
82from .sql import SelectLabelStyle as SelectLabelStyle
83from .sql.expression import Alias as Alias
84from .sql.expression import alias as alias
85from .sql.expression import AliasedReturnsRows as AliasedReturnsRows
86from .sql.expression import all_ as all_
87from .sql.expression import and_ as and_
88from .sql.expression import any_ as any_
89from .sql.expression import asc as asc
90from .sql.expression import between as between
91from .sql.expression import BinaryExpression as BinaryExpression
92from .sql.expression import bindparam as bindparam
93from .sql.expression import BindParameter as BindParameter
94from .sql.expression import bitwise_not as bitwise_not
95from .sql.expression import BooleanClauseList as BooleanClauseList
96from .sql.expression import CacheKey as CacheKey
97from .sql.expression import Case as Case
98from .sql.expression import case as case
99from .sql.expression import Cast as Cast
100from .sql.expression import cast as cast
101from .sql.expression import ClauseElement as ClauseElement
102from .sql.expression import ClauseList as ClauseList
103from .sql.expression import collate as collate
104from .sql.expression import CollectionAggregate as CollectionAggregate
105from .sql.expression import column as column
106from .sql.expression import ColumnClause as ColumnClause
107from .sql.expression import ColumnCollection as ColumnCollection
108from .sql.expression import ColumnElement as ColumnElement
109from .sql.expression import ColumnOperators as ColumnOperators
110from .sql.expression import CompoundSelect as CompoundSelect
111from .sql.expression import CTE as CTE
112from .sql.expression import cte as cte
113from .sql.expression import custom_op as custom_op
114from .sql.expression import Delete as Delete
115from .sql.expression import delete as delete
116from .sql.expression import desc as desc
117from .sql.expression import distinct as distinct
118from .sql.expression import except_ as except_
119from .sql.expression import except_all as except_all
120from .sql.expression import Executable as Executable
121from .sql.expression import Exists as Exists
122from .sql.expression import exists as exists
123from .sql.expression import Extract as Extract
124from .sql.expression import extract as extract
125from .sql.expression import false as false
126from .sql.expression import False_ as False_
127from .sql.expression import from_dml_column as from_dml_column
128from .sql.expression import FromClause as FromClause
129from .sql.expression import FromGrouping as FromGrouping
130from .sql.expression import func as func
131from .sql.expression import funcfilter as funcfilter
132from .sql.expression import Function as Function
133from .sql.expression import FunctionElement as FunctionElement
134from .sql.expression import FunctionFilter as FunctionFilter
135from .sql.expression import GenerativeSelect as GenerativeSelect
136from .sql.expression import Grouping as Grouping
137from .sql.expression import HasCTE as HasCTE
138from .sql.expression import HasPrefixes as HasPrefixes
139from .sql.expression import HasSuffixes as HasSuffixes
140from .sql.expression import Insert as Insert
141from .sql.expression import insert as insert
142from .sql.expression import intersect as intersect
143from .sql.expression import intersect_all as intersect_all
144from .sql.expression import Join as Join
145from .sql.expression import join as join
146from .sql.expression import Label as Label
147from .sql.expression import label as label
148from .sql.expression import LABEL_STYLE_DEFAULT as LABEL_STYLE_DEFAULT
149from .sql.expression import (
150 LABEL_STYLE_DISAMBIGUATE_ONLY as LABEL_STYLE_DISAMBIGUATE_ONLY,
151)
152from .sql.expression import LABEL_STYLE_NONE as LABEL_STYLE_NONE
153from .sql.expression import (
154 LABEL_STYLE_TABLENAME_PLUS_COL as LABEL_STYLE_TABLENAME_PLUS_COL,
155)
156from .sql.expression import lambda_stmt as lambda_stmt
157from .sql.expression import LambdaElement as LambdaElement
158from .sql.expression import Lateral as Lateral
159from .sql.expression import lateral as lateral
160from .sql.expression import literal as literal
161from .sql.expression import literal_column as literal_column
162from .sql.expression import modifier as modifier
163from .sql.expression import not_ as not_
164from .sql.expression import Null as Null
165from .sql.expression import null as null
166from .sql.expression import nulls_first as nulls_first
167from .sql.expression import nulls_last as nulls_last
168from .sql.expression import nullsfirst as nullsfirst
169from .sql.expression import nullslast as nullslast
170from .sql.expression import Operators as Operators
171from .sql.expression import or_ as or_
172from .sql.expression import OrderByList as OrderByList
173from .sql.expression import outerjoin as outerjoin
174from .sql.expression import outparam as outparam
175from .sql.expression import Over as Over
176from .sql.expression import over as over
177from .sql.expression import quoted_name as quoted_name
178from .sql.expression import ReleaseSavepointClause as ReleaseSavepointClause
179from .sql.expression import ReturnsRows as ReturnsRows
180from .sql.expression import (
181 RollbackToSavepointClause as RollbackToSavepointClause,
182)
183from .sql.expression import SavepointClause as SavepointClause
184from .sql.expression import ScalarSelect as ScalarSelect
185from .sql.expression import Select as Select
186from .sql.expression import select as select
187from .sql.expression import Selectable as Selectable
188from .sql.expression import SelectBase as SelectBase
189from .sql.expression import SQLColumnExpression as SQLColumnExpression
190from .sql.expression import StatementLambdaElement as StatementLambdaElement
191from .sql.expression import Subquery as Subquery
192from .sql.expression import table as table
193from .sql.expression import TableClause as TableClause
194from .sql.expression import TableSample as TableSample
195from .sql.expression import tablesample as tablesample
196from .sql.expression import TableValuedAlias as TableValuedAlias
197from .sql.expression import text as text
198from .sql.expression import TextAsFrom as TextAsFrom
199from .sql.expression import TextClause as TextClause
200from .sql.expression import TextualSelect as TextualSelect
201from .sql.expression import true as true
202from .sql.expression import True_ as True_
203from .sql.expression import try_cast as try_cast
204from .sql.expression import TryCast as TryCast
205from .sql.expression import Tuple as Tuple
206from .sql.expression import tuple_ as tuple_
207from .sql.expression import type_coerce as type_coerce
208from .sql.expression import TypeClause as TypeClause
209from .sql.expression import TypeCoerce as TypeCoerce
210from .sql.expression import UnaryExpression as UnaryExpression
211from .sql.expression import union as union
212from .sql.expression import union_all as union_all
213from .sql.expression import Update as Update
214from .sql.expression import update as update
215from .sql.expression import UpdateBase as UpdateBase
216from .sql.expression import Values as Values
217from .sql.expression import values as values
218from .sql.expression import ValuesBase as ValuesBase
219from .sql.expression import Visitable as Visitable
220from .sql.expression import within_group as within_group
221from .sql.expression import WithinGroup as WithinGroup
222from .types import ARRAY as ARRAY
223from .types import BIGINT as BIGINT
224from .types import BigInteger as BigInteger
225from .types import BINARY as BINARY
226from .types import BLOB as BLOB
227from .types import BOOLEAN as BOOLEAN
228from .types import Boolean as Boolean
229from .types import CHAR as CHAR
230from .types import CLOB as CLOB
231from .types import DATE as DATE
232from .types import Date as Date
233from .types import DATETIME as DATETIME
234from .types import DateTime as DateTime
235from .types import DECIMAL as DECIMAL
236from .types import DOUBLE as DOUBLE
237from .types import Double as Double
238from .types import DOUBLE_PRECISION as DOUBLE_PRECISION
239from .types import Enum as Enum
240from .types import FLOAT as FLOAT
241from .types import Float as Float
242from .types import INT as INT
243from .types import INTEGER as INTEGER
244from .types import Integer as Integer
245from .types import Interval as Interval
246from .types import JSON as JSON
247from .types import LargeBinary as LargeBinary
248from .types import NCHAR as NCHAR
249from .types import NUMERIC as NUMERIC
250from .types import Numeric as Numeric
251from .types import NumericCommon as NumericCommon
252from .types import NVARCHAR as NVARCHAR
253from .types import PickleType as PickleType
254from .types import REAL as REAL
255from .types import SMALLINT as SMALLINT
256from .types import SmallInteger as SmallInteger
257from .types import String as String
258from .types import TEXT as TEXT
259from .types import Text as Text
260from .types import TIME as TIME
261from .types import Time as Time
262from .types import TIMESTAMP as TIMESTAMP
263from .types import TupleType as TupleType
264from .types import TypeDecorator as TypeDecorator
265from .types import Unicode as Unicode
266from .types import UnicodeText as UnicodeText
267from .types import UUID as UUID
268from .types import Uuid as Uuid
269from .types import VARBINARY as VARBINARY
270from .types import VARCHAR as VARCHAR
271
272__version__ = "2.1.0b1"
273
274
275def __go(lcls: Any) -> None:
276 _util.preloaded.import_prefix("sqlalchemy")
277
278 from . import exc
279
280 exc._version_token = "".join(__version__.split(".")[0:2])
281
282
283__go(locals())