Full Stack Python

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

sqlalchemy.types DateTime Example Code

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

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

Example 1 from SQLAthanor

SQLAthanor (PyPI package information and project documentation) is a SQLAlchemy extension that provides serialization and deserialization support for JSON, CSV, YAML and Python dictionaries. This project is similar to Marshmallow with one major difference: SQLAthanor works through SQLAlchemy models while Marshmallow is less coupled to SQLAlchemy because it requires separate representations of the serialization objects. Both libraries have their uses depending on whether the project plans to use SQLAlchemy for object representations or would prefer to avoid that couping. SQLAthanor is open sourced under the MIT license.

SQLAthanor / sqlathanor / default_deserializers.py

# default_deserializers.py


import datetime
import io

from validator_collection import validators, checkers

from sqlathanor._compat import json
from sqlathanor.utilities import format_to_tuple, get_class_type_key, \
    raise_UnsupportedSerializationError, raise_UnsupportedDeserializationError
from sqlathanor.errors import UnsupportedValueTypeError

from sqlalchemy.types import Boolean, Date, DateTime, Float, Integer, Text, Time, Interval

DEFAULT_PYTHON_SQL_TYPE_MAPPING = {
    'bool': Boolean,
    'str': Text,
    'int': Integer,
    'float': Float,
    'datetime': DateTime,
    'date': Date,
    'time': Time,
    'timedelta': Interval
}

def get_default_deserializer(class_attribute = None,
                             format = None):
    format_to_tuple(format)
    format = format.lower()

    class_type_key = get_class_type_key(class_attribute, None)

    deserializer_dict = DEFAULT_DESERIALIZERS.get(class_type_key, None)

    if deserializer_dict is None:
        return None



## ... source file continues with no further DateTime 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 DateTime ...or view the full table of contents.

Matt Makai 2012-2022