import os from types import ModuleType from sqlalchemy import create_engine from sqlalchemy.orm import scoped_session, sessionmaker from sqlalchemy.ext.declarative import declarative_base db = ModuleType('db') db.engine = create_engine('sqlite:///{path}/pastes.db'.format(path=os.path.abspath(os.curdir)), convert_unicode=True) db.session = scoped_session(sessionmaker(autocommit=False, autoflush=False, bind=db.engine)) db.Base = declarative_base() db.Base.query = db.session.query_property() def init(): import ControlPaste.models db.Base.metadata.create_all(bind=db.engine)