def init_db():
''' Inititalizes the database '''
with app.app_context():
db = get_db()
with app.open_resource('schema.sql', mode='r') as f:
db.cursor().executescript(f.read())
db.commit()
def _init_db(sql_file):
"""Initializes the database."""
try:
with get_conn().cursor() as cursor:
# execute schema sql file
with app.open_resource(sql_file, mode='r') as f:
sql = f.read()
print sql
result = cursor.execute(sql)
print result
finally:
print get_conn().close()
def _execute_sql_file(sql_file):
"""Initializes the database."""
try:
with get_conn().cursor() as cursor:
# execute schema sql file
with app.open_resource(sql_file, mode='r') as f:
sql = f.read()
print sql
result = cursor.execute(sql)
print result
finally:
print get_conn().close()
def init_db():
"""Initializes the database."""
try:
with _get_conn().cursor() as cursor:
# execute schema sql file
with app.open_resource('db/schema/0001/user.sql', mode='r') as f:
sql = f.read()
print sql
result = cursor.execute(sql)
print result
finally:
print _get_conn().close()
def init_db():
with app.app_context():
db = get_db()
with app.open_resource('schema.sql', mode='r') as f:
db.cursor().executescript(f.read())
db.commit()
from server import app, get_db
with app.app_context():
db = get_db()
with app.open_resource('schema.sql', mode='r') as f:
db.cursor().executescript(f.read())
db.commit()
print('Initialized the database.')
def _init(database):
app.logger.info('Creating database schema')
with app.open_resource(schema_path, 'r') as f:
database.executescript(f.read())
def init_db():
with app.app_context():
db = get_db()
with app.open_resource('database.schema', mode='r') as f:
db.cursor().executescript(f.read())
db.commit()
