Python: SQLAlchemy db access example

db-access-example.py

#!/usr/bin/python

from sqlalchemy.ext.automap import automap_base
from sqlalchemy.orm import Session
from sqlalchemy import create_engine

Base = automap_base()

engine = create_engine('mysql://rmanalyzer:42c718i1@localhost/redmine')

Base.prepare(engine, reflect=True)

session = Session(engine)

q = session.query(Base.classes.issue_statuses)
print(q.count())

# vim: ts=4: sts=4: sw=4: