Full Stack Python

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

sqlalchemy.orm RelationshipProperty Example Code

RelationshipProperty is a class within the sqlalchemy.orm module of the SQLAlchemy project.

ColumnProperty, CompositeProperty, Load, Mapper, Query, Session, SynonymProperty, aliased, attributes, backref, class_mapper, column_property, composite, interfaces, mapper, mapperlib, object_mapper, object_session, query, relationship, session, sessionmaker, and strategies are several other callables with code examples from the same sqlalchemy.orm package.

Example 1 from SQLAlchemy Mixins

SQLAlchemy Mixins (PyPI package information) is a collection of mixins useful for extending SQLAlchemy and simplifying your database-interacting code for some common use cases. SQLAlchemy Mixins is open sourced under the MIT license.

SQLAlchemy Mixins / sqlalchemy_mixins / inspection.py

# inspection.py
from sqlalchemy import inspect
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.ext.hybrid import hybrid_property, hybrid_method
from sqlalchemy.orm import RelationshipProperty

from .utils import classproperty


Base = declarative_base()


class InspectionMixin(Base):
    __abstract__ = True

    @classproperty
    def columns(cls):
        return inspect(cls).columns.keys()

    @classproperty
    def primary_keys_full(cls):
        mapper = cls.__mapper__
        return [
            mapper.get_property_by_column(column)
            for column in mapper.primary_key
        ]

    @classproperty
    def primary_keys(cls):


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

Matt Makai 2012-2022