Learn SQLAlchemy

SQLAlchemy Tutorial

SQLAlchemy is a popular SQL toolkit and Object Relational Mapper. It is written in Python and gives full power and flexibility of SQL to an application developer. It is an open source and cross-platform software released under MIT license. SQLAlchemy is famous for its object-relational mapper (ORM), using which classes can be mapped to the database, thereby allowing the object model and database schema to develop in a cleanly decoupled way from the beginning.

Audience

This tutorial is designed for all those Python programmers who would like to understand the ORM framework with SQLAlchemy and its API.

Prerequisites

Before you start proceeding with this tutorial, we assume you have a good understanding of the Python programming language. A basic understanding of relational databases, DB-API, and SQL is desired to understand this tutorial.

SQLAlchemy Tutorial

SQLAlchemy - Home

SQLAlchemy - Introduction

SQLAlchemy Core

Expression Language

Connecting to Database

Creating Table

SQL Expressions

Executing Expression

Selecting Rows

Using Textual SQL

Using Aliases

Using UPDATE Expression

Using DELETE Expression

Using Multiple Tables

Using Multiple Table Updates

Parameter-Ordered Updates

Multiple Table Deletes

Using Joins

Using Conjunctions

Using Functions

Using Set Operations

SQLAlchemy ORM

Declaring Mapping

Creating Session

Adding Objects

Using Query

Updating Objects

Applying Filter

Filter Operators

Returning List and Scalars

Textual SQL

Building Relationship

Working with Related Objects

Working with Joins

Common Relationship Operators

Eager Loading

Deleting Related Objects

Many to Many Relationships

Dialects

SQLAlchemy Useful Resources

SQLAlchemy - Quick Guide

SQLAlchemy - Useful Resources

SQLAlchemy - Discussion