1 from sqlalchemy import create_engine
2 from pecan import conf # noqa
3 from .db import Session, Base
6 def create_from_conf():
7 configs = dict(conf.sqlalchemy)
8 url = configs.pop('url')
9 return create_engine(url, **configs)
12 engine = create_from_conf()
13 conf.sqlalchemy.engine = engine
15 #create the tables if not existing
16 Base.metadata.create_all(engine)
19 Session.bind = conf.sqlalchemy.engine