pylon

join SQLAlchemy

Eg : 1

        query = Session.query(Person)
        
        query = query.join(Address, Address.person_id == Person.id)
        
        query = query.filter(Address.city == "abccity")
        
        c.j2 = query.all()

Eg : 2

 

c.jo = Session.query(Address.city, Person.name).filter(Address.person_id==Person.id).all()
By bm on September 12, 2014 | pylon, SQLAlchemy | A comment?

model example SQLAlchemy

"""Person model"""
from sqlalchemy import Column
from sqlalchemy.types import Integer, String

from pylontutor.model.meta import Base

class Person(Base):
    __tablename__ = "person"

    id = Column(Integer, primary_key=True)
    name = Column(String(100))
    email = Column(String(100))

    def __init__(self, name='', email=''):
        self.name = name
        self.email = email

    def __repr__(self):
        return "<Person('%s')" % self.name
By bm on | pylon, SQLAlchemy | A comment?