from sqlalchemy import create_engine
from pecan import conf  # noqa
from .db import Session, Base
import sys

def create_from_conf():
    configs = dict(conf.sqlalchemy)
    url = configs.pop('url')
    return create_engine(url, **configs)

def init_model():
    engine = create_from_conf()
    conf.sqlalchemy.engine = engine
    engine.connect()
    #create the tables if not existing
    Base.metadata.create_all(engine)

def start():
    Session.bind = conf.sqlalchemy.engine

def commit():
    Session.commit()

def rollback():
    Session.rollback()

def clear():
    Session.remove()