Full Stack Python

All topics | Blog | Supporter's Edition | @fullstackpython | Facebook | What's new?

sqlalchemy.types TypeEngine Example Code

TypeEngine is a class within the sqlalchemy.types module of the SQLAlchemy project.

BOOLEAN, Boolean, DATE, DATETIME, Date, DateTime, Enum, FLOAT, Float, INTEGER, Integer, Interval, NULLTYPE, NullType, String, TEXT, TIME, Text, Time, UserDefinedType, and to_instance are several other callables with code examples from the same sqlalchemy.types package.

Example 1 from databases

databases (project homepage and PyPI page provides asyncio support with an SQLALchemy Core interface for common relational databases such as MySQL, PostgreSQL and SQLite. This is handy for integrating with asynchronous I/O web frameworks like Sanic. The project is open sourced under the BSD 3-Clause "New" or "Revised" License.

databases / databases / backends / sqlite.py

# sqlite.py
import logging
import typing
import uuid

import aiosqlite
from sqlalchemy.dialects.sqlite import pysqlite
from sqlalchemy.engine.interfaces import Dialect, ExecutionContext
from sqlalchemy.engine.result import ResultMetaData, RowProxy
from sqlalchemy.sql import ClauseElement
from sqlalchemy.types import TypeEngine

from databases.core import LOG_EXTRA, DatabaseURL
from databases.interfaces import ConnectionBackend, DatabaseBackend, TransactionBackend

logger = logging.getLogger("databases")


class SQLiteBackend(DatabaseBackend):
    def __init__(
        self, database_url: typing.Union[DatabaseURL, str], **options: typing.Any
    ) -> None:
        self._database_url = DatabaseURL(database_url)
        self._options = options
        self._dialect = pysqlite.dialect(paramstyle="qmark")
        self._dialect.supports_native_decimal = False
        self._pool = SQLitePool(self._database_url, **self._options)

    async def connect(self) -> None:
        pass

    async def disconnect(self) -> None:
        pass

    def connection(self) -> "SQLiteConnection":


## ... source file continues with no further TypeEngine examples...

Table of Contents

1. Introduction 2. Development Environments 3. Data 4. Web Development 5. Deployment 6. DevOps Changelog What Full Stack Means About the Author Future Directions Page Statuses SQLAlchemy Extensions SQLAlchemy Example Code SQLAlchemy Models sqlalchemy.databases mysql sqlalchemy.dialects mssql sqlalchemy.dialects mysql sqlalchemy.dialects oracle sqlalchemy.schema DDL sqlalchemy.dialects postgresql sqlalchemy.sql.expression Function sqlalchemy.dialects sqlite sqlalchemy.dialects.mysql pymysql sqlalchemy.dialects.postgresql ARRAY sqlalchemy.dialects.postgresql BIGINT sqlalchemy.dialects.postgresql BIT sqlalchemy.dialects.postgresql DOUBLE_PRECISION sqlalchemy.dialects.postgresql ExcludeConstraint sqlalchemy.dialects.postgresql INTEGER sqlalchemy.dialects.postgresql JSON sqlalchemy.dialects.postgresql TSVECTOR sqlalchemy.dialects.postgresql pypostgresql sqlalchemy.dialects.postgresql.base PGCompiler sqlalchemy.dialects.postgresql.base PGIdentifierPreparer sqlalchemy.dialects.postgresql.base PGTypeCompiler sqlalchemy.dialects.postgresql.psycopg2 PGDialect_psycopg2 sqlalchemy.dialects.sqlite pysqlite sqlalchemy.engine Connection sqlalchemy.engine Engine sqlalchemy.engine create_engine sqlalchemy.engine default sqlalchemy.engine url sqlalchemy.engine.default DefaultDialect sqlalchemy.engine.interfaces ExecutionContext sqlalchemy.engine.result ResultMetaData sqlalchemy.engine.result RowProxy sqlalchemy.engine.strategies EngineStrategy sqlalchemy.engine.strategies MockEngineStrategy sqlalchemy.engine.url make_url sqlalchemy.events SchemaEventTarget sqlalchemy.exc ArgumentError sqlalchemy.exc DataError sqlalchemy.exc DatabaseError sqlalchemy.exc IntegrityError sqlalchemy.exc InvalidRequestError sqlalchemy.exc NoInspectionAvailable sqlalchemy.exc NoSuchTableError sqlalchemy.exc OperationalError sqlalchemy.exc ProgrammingError sqlalchemy.exc UnsupportedCompilationError sqlalchemy.ext compiler sqlalchemy.ext.associationproxy AssociationProxy sqlalchemy.ext.automap automap_base sqlalchemy.ext.compiler compiles sqlalchemy.ext.declarative DeclarativeMeta sqlalchemy.ext.declarative declarative_base sqlalchemy.ext.hybrid hybrid_method sqlalchemy.ext.hybrid hybrid_property sqlalchemy.ext.mutable Mutable sqlalchemy.inspection inspect sqlalchemy.orm ColumnProperty sqlalchemy.orm CompositeProperty sqlalchemy.orm Load sqlalchemy.orm Query sqlalchemy.orm RelationshipProperty sqlalchemy.orm SynonymProperty sqlalchemy.orm aliased sqlalchemy.orm attributes sqlalchemy.orm backref sqlalchemy.orm class_mapper sqlalchemy.orm column_property sqlalchemy.orm composite sqlalchemy.orm interfaces sqlalchemy.orm mapper sqlalchemy.orm mapperlib sqlalchemy.orm object_mapper sqlalchemy.orm object_session sqlalchemy.orm relationship sqlalchemy.orm session sqlalchemy.orm sessionmaker sqlalchemy.orm strategies sqlalchemy.orm.attributes InstrumentedAttribute sqlalchemy.orm.attributes QueryableAttribute sqlalchemy.orm.attributes flag_modified sqlalchemy.orm.collections InstrumentedList sqlalchemy.orm.exc NoResultFound sqlalchemy.orm.exc UnmappedClassError sqlalchemy.orm.exc UnmappedInstanceError sqlalchemy.orm.interfaces MapperProperty sqlalchemy.orm.interfaces PropComparator sqlalchemy.orm.mapper Mapper sqlalchemy.orm.properties ColumnProperty sqlalchemy.orm.properties RelationshipProperty sqlalchemy.orm.query Query sqlalchemy.orm.query QueryContext sqlalchemy.orm.relationships RelationshipProperty sqlalchemy.orm.session Session sqlalchemy.orm.session object_session sqlalchemy.orm.util AliasedClass sqlalchemy.orm.util AliasedInsp sqlalchemy.orm.util identity_key sqlalchemy.pool NullPool sqlalchemy.pool StaticPool sqlalchemy.schema CheckConstraint sqlalchemy.schema Column sqlalchemy.schema CreateIndex sqlalchemy.schema CreateTable sqlalchemy.schema DDLElement sqlalchemy.schema ForeignKey sqlalchemy.schema ForeignKeyConstraint sqlalchemy.schema Index sqlalchemy.schema PrimaryKeyConstraint sqlalchemy.schema Table sqlalchemy.sql ClauseElement sqlalchemy.sql column sqlalchemy.sql expression sqlalchemy.sql extract sqlalchemy.sql functions sqlalchemy.sql operators sqlalchemy.sql schema sqlalchemy.sql select sqlalchemy.sql sqltypes sqlalchemy.sql table sqlalchemy.sql.compiler SQLCompiler sqlalchemy.sql.elements ColumnElement sqlalchemy.sql.elements Label sqlalchemy.sql.expression ClauseElement sqlalchemy.sql.expression ColumnClause sqlalchemy.sql.expression ColumnElement sqlalchemy.sql.expression Executable sqlalchemy.sql.expression FunctionElement sqlalchemy.sql.expression UnaryExpression sqlalchemy.sql.functions FunctionElement sqlalchemy.sql.functions GenericFunction sqlalchemy.sql.naming conv sqlalchemy.sql.schema Column sqlalchemy.sql.schema SchemaItem sqlalchemy.sql.sqltypes NullType sqlalchemy.sql.util ClauseAdapter sqlalchemy.sql.visitors traverse sqlalchemy.types Boolean sqlalchemy.types Date sqlalchemy.types DateTime sqlalchemy.types Enum sqlalchemy.types Float sqlalchemy.types Integer sqlalchemy.types Interval sqlalchemy.types NULLTYPE sqlalchemy.types String sqlalchemy.types Text sqlalchemy.types Time sqlalchemy.types TypeEngine sqlalchemy.types UserDefinedType sqlalchemy.types to_instance sqlalchemy.util OrderedDict sqlalchemy.util OrderedSet sqlalchemy.util set_creation_order sqlalchemy.util symbol sqlalchemy.util topological sqlalchemy.util.langhelpers public_factory sqlalchemy.util.langhelpers symbol ...or view the full table of contents.

Full Stack Python

Full Stack Python is an open book that explains concepts in plain language and provides helpful resources for those topics.

Updates via Twitter & Facebook.

Chapters

1. Introduction 2. Development Environments 3. Data 4. Web Development 5. Deployment 6. DevOps Changelog What Full Stack Means About the Author Future Directions Page Statuses » sqlalchemy.types TypeEngine ...or view the full table of contents.

Matt Makai 2012-2022