def init_db(path='eta.db'):
"""Initialze database
"""
engine = create_engine("sqlite:///%s" % path)
Base.metadata.create_all(engine)
DBSession.configure(bind=engine)
log.info("Initialized database %s", path)
def main(global_config, **settings):
config = Configurator(settings=settings)
config.add_route('article_list', '/')
config.add_route('show_article', '/article/{article}')
config.add_route('add_article', '/add_article')
config.scan()
# SQL Alchemy stuff.
engine = engine_from_config(settings, 'sqlalchemy.')
DBSession.configure(bind=engine)
try:
Base.metadata.create_all(engine)
with transaction.manager:
article = Article(title='Test article', body="Test test test")
DBSession.add(article)
except IntegrityError:
print "Skipping creating, integrity error was thrown"
return config.make_wsgi_app()
def init_db(config):
settings = config.get_settings()
path = settings.get('db.path', 'var/eta.db')
engine = create_engine("sqlite:///%s" % path)
Base.metadata.create_all(engine)
DBSession.configure(bind=engine)
