turbogears.py

# -*- coding: utf-8 -*-
"""
An example to show how to use turbogears sqlalchemy session and model
outside of turbogears.
"""

from fileupload.model import DBSession, metadata, init_model
from fileupload.model.userfile import UserFile
from sqlalchemy import create_engine, sql

engine = create_engine("sqlite:////home/mengu/projects/turbogears/fileupload/devdata.db")
init_model(engine)

result = DBSession.query(UserFile).all()

print result

that "sql" import is not needed :)