def main():
config_name = os.environ.get('APP_SETTINGS',
'service.config.DevelopmentConfig')
config = Config.create(config_name)
app = create_app(config)
init_basic_auth(app)
init_db()
app.run(use_reloader=False)
SQL_CREATE_USER = '''
INSERT INTO users (
name,
password,
is_admin
)
VALUES (%(name)s, %(password)s, %(is_admin)s);
'''
class InitDBError(Exception):
pass
config = Config.create()
def _open_admin_connection() -> connection:
# User and DB should be created by Postgres admin
connection = connect_with(
host=config.DB_HOST,
port=config.DB_PORT,
dbname=None,
user=config.DB_ADMIN_USER,
password=config.DB_ADMIN_PASSWORD,
)
# CREATE DB statement should be done outside of transaction block
connection.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)
