sqlalchemy jenkins metrics db query

get-metrics.py

#!/usr/bin/env python

import datetime

from sqlalchemy import create_engine, MetaData, Table
from sqlalchemy.orm import sessionmaker

engine = create_engine('postgres://meow:[email protected]/jenkins_meow')
meta = MetaData(bind=engine)
jenkins_runs = Table("jenkins_details_run", meta, autoload=True, autoload_with=engine)

Session = sessionmaker(bind=engine)

session = Session()

today = datetime.date.today()
yesterday = today - datetime.timedelta(1)

for jr in session.query(jenkins_runs).filter_by(startdate=yesterday):
    print(jr.jobname)