def start_schema(conn):
cursor = StatementCursor(conn, 'start_schema')
tables, mapping = primary_tables()
map(cursor.create_table, tables)
priorities_table = mapping['priorities']
insert_list(cursor, priorities_table.name, 'priority', PRIORITIES)
insert_list(cursor, 'scriptnames', 'script', SCRIPTS)
cursor.execute(grant_public([x.name for x in tables]))
cursor.execute(grant_public(['current_environment'], 'ALL'))
cursor.execute(grant_public(['partition_workspace'], 'ALL'))
cursor.execute(plpgsql_delete_profile)
cursor.execute(plpgsql_delete_trait)
def start_schema(conn):
cursor = StatementCursor(conn, 'start_schema')
tables, mapping = primary_tables()
map(cursor.create_table, tables)
priorities_table = mapping['priorities']
insert_list(cursor, priorities_table.name, 'priority', PRIORITIES)
insert_list(cursor, 'scriptnames', 'script', SCRIPTS)
cursor.execute(grant_public([x.name for x in tables]))
cursor.execute(grant_public(['current_environment'], 'ALL'))
cursor.execute(grant_public(['partition_workspace'], 'ALL'))
cursor.execute(plpgsql_delete_profile)
cursor.execute(plpgsql_delete_trait)
def start_schema(conn):
cursor = StatementCursor(conn, 'start_schema')
map(cursor.create_sequence, primary_sequences())
tables, mapping = primary_tables()
map(cursor.create_table, tables)
priorities_table = mapping['priorities']
insert_list(cursor, priorities_table.name, 'priority', PRIORITIES)
insert_list(cursor, 'scriptnames', 'script', SCRIPTS)
newscripts = [s for s in MTSCRIPTS if s not in SCRIPTS]
insert_list(cursor, 'scriptnames', 'script', newscripts)
cursor.execute(grant_public([x.name for x in tables]))
cursor.execute(grant_public(['current_environment'], 'ALL'))
cursor.execute(grant_public(['partition_workspace'], 'ALL'))
cursor.execute(plpgsql_delete_trait)
cursor.execute(pgsql_delete_profile())
cursor.execute(pgsql_delete_family())
cursor.execute(pgsql_delete_disk())
cursor.execute(pgsql_delete_mtype())
cursor.execute(pgsql_delete_filesystem())
def start_schema(conn):
cursor = StatementCursor(conn, 'start_schema')
map(cursor.create_sequence, primary_sequences())
tables, mapping = primary_tables()
map(cursor.create_table, tables)
priorities_table = mapping['priorities']
insert_list(cursor, priorities_table.name, 'priority', PRIORITIES)
insert_list(cursor, 'scriptnames', 'script', SCRIPTS)
newscripts = [s for s in MTSCRIPTS if s not in SCRIPTS]
insert_list(cursor, 'scriptnames', 'script', newscripts)
cursor.execute(grant_public([x.name for x in tables]))
cursor.execute(grant_public(['current_environment'], 'ALL'))
cursor.execute(grant_public(['partition_workspace'], 'ALL'))
cursor.execute(plpgsql_delete_trait)
cursor.execute(pgsql_delete_profile())
cursor.execute(pgsql_delete_family())
cursor.execute(pgsql_delete_disk())
cursor.execute(pgsql_delete_mtype())
cursor.execute(pgsql_delete_filesystem())
