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 (
51 FallbackAsyncAdaptedQueuePool as FallbackAsyncAdaptedQueuePool,
52)
53from .pool import NullPool as NullPool
54from .pool import Pool as Pool
55from .pool import PoolProxiedConnection as PoolProxiedConnection
56from .pool import PoolResetState as PoolResetState
57from .pool import QueuePool as QueuePool
58from .pool import SingletonThreadPool as SingletonThreadPool
59from .pool import StaticPool as StaticPool
60from .schema import BaseDDLElement as BaseDDLElement
61from .schema import BLANK_SCHEMA as BLANK_SCHEMA
62from .schema import CheckConstraint as CheckConstraint
63from .schema import Column as Column
64from .schema import ColumnDefault as ColumnDefault
65from .schema import Computed as Computed
66from .schema import Constraint as Constraint
67from .schema import DDL as DDL
68from .schema import DDLElement as DDLElement
69from .schema import DefaultClause as DefaultClause
70from .schema import ExecutableDDLElement as ExecutableDDLElement
71from .schema import FetchedValue as FetchedValue
72from .schema import ForeignKey as ForeignKey
73from .schema import ForeignKeyConstraint as ForeignKeyConstraint
74from .schema import Identity as Identity
75from .schema import Index as Index
76from .schema import insert_sentinel as insert_sentinel
77from .schema import MetaData as MetaData
78from .schema import PrimaryKeyConstraint as PrimaryKeyConstraint
79from .schema import Sequence as Sequence
80from .schema import Table as Table
81from .schema import UniqueConstraint as UniqueConstraint
82from .sql import ColumnExpressionArgument as ColumnExpressionArgument
83from .sql import NotNullable as NotNullable
84from .sql import Nullable as Nullable
85from .sql import SelectLabelStyle as SelectLabelStyle
86from .sql.expression import Alias as Alias
87from .sql.expression import alias as alias
88from .sql.expression import AliasedReturnsRows as AliasedReturnsRows
89from .sql.expression import all_ as all_
90from .sql.expression import and_ as and_
91from .sql.expression import any_ as any_
92from .sql.expression import asc as asc
93from .sql.expression import between as between
94from .sql.expression import BinaryExpression as BinaryExpression
95from .sql.expression import bindparam as bindparam
96from .sql.expression import BindParameter as BindParameter
97from .sql.expression import bitwise_not as bitwise_not
98from .sql.expression import BooleanClauseList as BooleanClauseList
99from .sql.expression import CacheKey as CacheKey
100from .sql.expression import Case as Case
101from .sql.expression import case as case
102from .sql.expression import Cast as Cast
103from .sql.expression import cast as cast
104from .sql.expression import ClauseElement as ClauseElement
105from .sql.expression import ClauseList as ClauseList
106from .sql.expression import collate as collate
107from .sql.expression import CollectionAggregate as CollectionAggregate
108from .sql.expression import column as column
109from .sql.expression import ColumnClause as ColumnClause
110from .sql.expression import ColumnCollection as ColumnCollection
111from .sql.expression import ColumnElement as ColumnElement
112from .sql.expression import ColumnOperators as ColumnOperators
113from .sql.expression import CompoundSelect as CompoundSelect
114from .sql.expression import CTE as CTE
115from .sql.expression import cte as cte
116from .sql.expression import custom_op as custom_op
117from .sql.expression import Delete as Delete
118from .sql.expression import delete as delete
119from .sql.expression import desc as desc
120from .sql.expression import distinct as distinct
121from .sql.expression import except_ as except_
122from .sql.expression import except_all as except_all
123from .sql.expression import Executable as Executable
124from .sql.expression import Exists as Exists
125from .sql.expression import exists as exists
126from .sql.expression import Extract as Extract
127from .sql.expression import extract as extract
128from .sql.expression import false as false
129from .sql.expression import False_ as False_
130from .sql.expression import FromClause as FromClause
131from .sql.expression import FromGrouping as FromGrouping
132from .sql.expression import func as func
133from .sql.expression import funcfilter as funcfilter
134from .sql.expression import Function as Function
135from .sql.expression import FunctionElement as FunctionElement
136from .sql.expression import FunctionFilter as FunctionFilter
137from .sql.expression import GenerativeSelect as GenerativeSelect
138from .sql.expression import Grouping as Grouping
139from .sql.expression import HasCTE as HasCTE
140from .sql.expression import HasPrefixes as HasPrefixes
141from .sql.expression import HasSuffixes as HasSuffixes
142from .sql.expression import Insert as Insert
143from .sql.expression import insert as insert
144from .sql.expression import intersect as intersect
145from .sql.expression import intersect_all as intersect_all
146from .sql.expression import Join as Join
147from .sql.expression import join as join
148from .sql.expression import Label as Label
149from .sql.expression import label as label
150from .sql.expression import LABEL_STYLE_DEFAULT as LABEL_STYLE_DEFAULT
151from .sql.expression import (
152 LABEL_STYLE_DISAMBIGUATE_ONLY as LABEL_STYLE_DISAMBIGUATE_ONLY,
153)
154from .sql.expression import LABEL_STYLE_NONE as LABEL_STYLE_NONE
155from .sql.expression import (
156 LABEL_STYLE_TABLENAME_PLUS_COL as LABEL_STYLE_TABLENAME_PLUS_COL,
157)
158from .sql.expression import lambda_stmt as lambda_stmt
159from .sql.expression import LambdaElement as LambdaElement
160from .sql.expression import Lateral as Lateral
161from .sql.expression import lateral as lateral
162from .sql.expression import literal as literal
163from .sql.expression import literal_column as literal_column
164from .sql.expression import modifier as modifier
165from .sql.expression import not_ as not_
166from .sql.expression import Null as Null
167from .sql.expression import null as null
168from .sql.expression import nulls_first as nulls_first
169from .sql.expression import nulls_last as nulls_last
170from .sql.expression import nullsfirst as nullsfirst
171from .sql.expression import nullslast as nullslast
172from .sql.expression import Operators as Operators
173from .sql.expression import or_ as or_
174from .sql.expression import outerjoin as outerjoin
175from .sql.expression import outparam as outparam
176from .sql.expression import Over as Over
177from .sql.expression import over as over
178from .sql.expression import quoted_name as quoted_name
179from .sql.expression import ReleaseSavepointClause as ReleaseSavepointClause
180from .sql.expression import ReturnsRows as ReturnsRows
181from .sql.expression import (
182 RollbackToSavepointClause as RollbackToSavepointClause,
183)
184from .sql.expression import SavepointClause as SavepointClause
185from .sql.expression import ScalarSelect as ScalarSelect
186from .sql.expression import Select as Select
187from .sql.expression import select as select
188from .sql.expression import Selectable as Selectable
189from .sql.expression import SelectBase as SelectBase
190from .sql.expression import SQLColumnExpression as SQLColumnExpression
191from .sql.expression import StatementLambdaElement as StatementLambdaElement
192from .sql.expression import Subquery as Subquery
193from .sql.expression import table as table
194from .sql.expression import TableClause as TableClause
195from .sql.expression import TableSample as TableSample
196from .sql.expression import tablesample as tablesample
197from .sql.expression import TableValuedAlias as TableValuedAlias
198from .sql.expression import text as text
199from .sql.expression import TextAsFrom as TextAsFrom
200from .sql.expression import TextClause as TextClause
201from .sql.expression import TextualSelect as TextualSelect
202from .sql.expression import true as true
203from .sql.expression import True_ as True_
204from .sql.expression import try_cast as try_cast
205from .sql.expression import TryCast as TryCast
206from .sql.expression import Tuple as Tuple
207from .sql.expression import tuple_ as tuple_
208from .sql.expression import type_coerce as type_coerce
209from .sql.expression import TypeClause as TypeClause
210from .sql.expression import TypeCoerce as TypeCoerce
211from .sql.expression import UnaryExpression as UnaryExpression
212from .sql.expression import union as union
213from .sql.expression import union_all as union_all
214from .sql.expression import Update as Update
215from .sql.expression import update as update
216from .sql.expression import UpdateBase as UpdateBase
217from .sql.expression import Values as Values
218from .sql.expression import values as values
219from .sql.expression import ValuesBase as ValuesBase
220from .sql.expression import Visitable as Visitable
221from .sql.expression import within_group as within_group
222from .sql.expression import WithinGroup as WithinGroup
223from .types import ARRAY as ARRAY
224from .types import BIGINT as BIGINT
225from .types import BigInteger as BigInteger
226from .types import BINARY as BINARY
227from .types import BLOB as BLOB
228from .types import BOOLEAN as BOOLEAN
229from .types import Boolean as Boolean
230from .types import CHAR as CHAR
231from .types import CLOB as CLOB
232from .types import DATE as DATE
233from .types import Date as Date
234from .types import DATETIME as DATETIME
235from .types import DateTime as DateTime
236from .types import DECIMAL as DECIMAL
237from .types import DOUBLE as DOUBLE
238from .types import Double as Double
239from .types import DOUBLE_PRECISION as DOUBLE_PRECISION
240from .types import Enum as Enum
241from .types import FLOAT as FLOAT
242from .types import Float as Float
243from .types import INT as INT
244from .types import INTEGER as INTEGER
245from .types import Integer as Integer
246from .types import Interval as Interval
247from .types import JSON as JSON
248from .types import LargeBinary as LargeBinary
249from .types import NCHAR as NCHAR
250from .types import NUMERIC as NUMERIC
251from .types import Numeric as Numeric
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.0.41"
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())