SQLAlchemy ORM – Eager Loading Eager load reduces the number of queries. SQLAlchemy offers eager loading functions invoked via query options which give additional instructions to the Query. These options determine how to load various attributes via the Query.options() method. Subquery Load We want that Customer.invoices should load eagerly. The orm.subqueryload() option gives a second […]
Category Archives: sqlalchemy
SQLAlchemy – Dialects SQLAlchemy uses system of dialects to communicate with various types of databases. Each database has a corresponding DBAPI wrapper. All dialects require that an appropriate DBAPI driver is installed. Following dialects are included in SQLAlchemy API − Firebird Microsoft SQL Server MySQL Oracle PostgreSQL SQL Sybase An Engine object based on a […]
Many to Many Relationships Many to Many relationship between two tables is achieved by adding an association table such that it has two foreign keys – one from each table’s primary key. Moreover, classes mapping to the two tables have an attribute with a collection of objects of other association tables assigned as secondary attribute […]