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()