def populate_role(conn, data):
db2.execute(conn, '''
INSERT INTO SSO_ROLES(ROLE_KEY, NAME, ENABLED, DESC, TENANT_KEY, CREATE_TIME)
VALUES(?, ?, ?, ?, ?, ?)
''', data, commit=False)
ibm_db.exec_immediate(conn, 'ALTER TABLE SSO_ROLES ALTER COLUMN ROLE_KEY RESTART WITH 4000000')
def populate_user(conn, data):
db2.execute(conn, '''
INSERT INTO SSO_USERS(USER_KEY, PASSWORD, USER_NAME, SALT, TENANT_KEY, CREATE_TIME, MODIFY_TIME)
VALUES(?, ?, ?, ?, ?, ?, ?)
''', data, commit=False)
ibm_db.exec_immediate(conn, 'ALTER TABLE SSO_USERS ALTER COLUMN USER_KEY RESTART WITH 1000')
def populate_metadata(conn, data):
db2.execute(conn, '''
insert into metadatas(metadata_key, metadata_type_code, metadata_type_desc, metadata_code, metadata_desc, disable, parent_key)
values(?, ?, ?, ?, ?, ?, ?)
''', data, False)
def populate_menus(conn, data):
db2.execute(conn, '''
insert into menus(name, parent_key, resource_key) values(?, ?, ?)
''', data, False)
def populate_role_authority(conn, data):
db2.execute(conn, '''
insert into role_authority(role_key, authority_key) values(?, ?)
''', data, False)
def populate_authority_resource(conn, data):
db2.execute(conn, '''
insert into authority_resource(authority_key, resource_key)
values(?, ?)
''', data, commit=False)
def populate_authorities(conn, data):
db2.execute(conn, '''
insert into authorities(code, name, enabled, desc)
values(?, ?, ?, ?)
''', data, commit=False)
def populate_resources(conn, data):
db2.execute(conn, '''
insert into resources(name, enabled, url, app, type, method, desc)
values(?, ?, ?, ?, ?, ?, ?)
''', data, commit=False)
def populate_user_role(conn, data):
db2.execute(conn, '''
INSERT INTO SSO_USER_ROLE(USER_KEY, ROLE_KEY)
VALUES(?, ?)
''', data, commit=False)
def populate_tenant(conn, data):
db2.execute(conn, '''
INSERT INTO SSO_TENANTS(TENANT_KEY, NAME, DESC, ENABLED, CODE, CREATE_TIME, MODIFY_TIME)
VALUES(?, ?, ?, ?, ?, ?, ?)
''', data, commit=False)
