Tutorial by Examples

First the setup for the example: import datetime as dt from sqlalchemy import Column, Date, Integer, Text, create_engine, inspect from sqlalchemy.orm import sessionmaker from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() Session = sessionmaker() class User(B...

Given the following model class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) name = Column(Text, nullable=False) birthday = Column(Date) You can filter columns in the query: import datetime as dt session.query(User).filter(User.name == 'Bob')...

Given a basic model: class SpreadsheetCells(Base): __tablename__ = 'spreadsheet_cells' id = Column(Integer, primary_key=True) y_index = Column(Integer) x_index = Column(Integer) You can retrieve an ordered list by chaining the order_by method. query = session.query(Spreads...

Once you have a query, you can do more with it than just iterating the results in a for loop. Setup: from datetime import date class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) name = Column(Text, nullable=False) birthday = Column(Date) # ...