def tenant_add_user(tenant, user, role): # print tenant # print base.getTenantIDByName(tenant) # print base.getTenantOSIDByName(tenant) # print user # print base.getUserIDByName(user) # print base.getUserOSIDByName(user) # print role # print base.getRoleOSIDByID(role) flag = False try: res = keystone.add_tenant_user_role( str(base.getTenantOSIDByName(tenant)), str(base.getUserOSIDByName(user)), str(base.getRoleOSIDByID(role))) except: print 'keystone tenant add user failed.' else: flag = True print 'keystone tenant add user successful.' try: cursor = base.get_cursor() sql = '''INSERT into t_turMap VALUES (NULL,%d,%d,%d,NULL,'%s',NULL)''' % ( int(base.getTenantIDByName(tenant)), int(base.getUserIDByName(user)), int(role), time.strftime('%Y-%m-%d %X', time.localtime())) print sql cursor.execute(sql) except: print 'sql tenant add user failed.' flag = False else: print 'sql tenant add user successful.' flag = True finally: return flag
def tenant_add_user(tenant, user, role): # print tenant # print base.getTenantIDByName(tenant) # print base.getTenantOSIDByName(tenant) # print user # print base.getUserIDByName(user) # print base.getUserOSIDByName(user) # print role # print base.getRoleOSIDByID(role) flag = False try: res = keystone.add_tenant_user_role(str(base.getTenantOSIDByName(tenant)), str(base.getUserOSIDByName(user)), str(base.getRoleOSIDByID(role))) except: print 'keystone tenant add user failed.' else: flag = True print 'keystone tenant add user successful.' try: cursor = base.get_cursor() sql = '''INSERT into t_turMap VALUES (NULL,%d,%d,%d,NULL,'%s',NULL)''' % ( int(base.getTenantIDByName(tenant)), int(base.getUserIDByName(user)), int(role), time.strftime('%Y-%m-%d %X', time.localtime())) print sql cursor.execute(sql) except: print 'sql tenant add user failed.' flag = False else: print 'sql tenant add user successful.' flag = True finally: return flag
def tenant_create2(owner_loginName, tenant_name, tenant_desc): cursor = get_cursor() uuid = '' flag = False try: tenant = keystone.tenant_create(tenant_name, tenant_desc) uuid = keystone.get_baseID(tenant) res = keystone.add_tenant_user_role( uuid, str(getUserIDInOS(owner_loginName)), str(getRoleIDInOS('owner'))) except: logging.getLogger('operate').log( 30, 'tenant create %s %s %s keystone failed.' % (owner_loginName, tenant_name, tenant_desc)) keystone.remove_tenant_user_role(uuid, str(getUserIDInOS(owner_loginName)), str(getRoleIDInOS('owner'))) keystone.tenant_delete(uuid) else: try: sql = '''insert into t_tenant values (null,'%s','%s','%s',%d,'%s',null) ''' % ( uuid, tenant_name, tenant_desc, getUserID(owner_loginName), time.strftime('%Y-%m-%d %X', time.localtime())) cursor.execute(sql) sql2 = '''insert into t_turMap values (null,%d,%d,%d,'%s','%s',null) ''' % ( getTenantID(tenant_name), getUserID(owner_loginName), getRoleID('owner'), tenant_desc, time.strftime('%Y-%m-%d %X', time.localtime())) cursor.execute(sql2) except: logging.getLogger('operate').log( 30, 'tenant create %s %s %s sql failed.' % (owner_loginName, tenant_name, tenant_desc)) flag = False # transcation.rollback() else: logging.getLogger('operate').log( 20, 'tenant create %s %s %s successed.' % (owner_loginName, tenant_name, tenant_desc)) flag = True # transcation.commit() finally: pass finally: pass return flag
def tenant_create2(owner_loginName, tenant_name, tenant_desc): cursor = get_cursor() uuid = '' flag = False try: tenant = keystone.tenant_create(tenant_name, tenant_desc) uuid = keystone.get_baseID(tenant) res = keystone.add_tenant_user_role(uuid, str(getUserIDInOS(owner_loginName)), str(getRoleIDInOS('owner'))) except: logging.getLogger('operate').log(30, 'tenant create %s %s %s keystone failed.' % (owner_loginName, tenant_name, tenant_desc)) keystone.remove_tenant_user_role(uuid, str(getUserIDInOS(owner_loginName)), str(getRoleIDInOS('owner'))) keystone.tenant_delete(uuid) else: try: sql = '''insert into t_tenant values (null,'%s','%s','%s',%d,'%s',null) ''' % ( uuid, tenant_name, tenant_desc, getUserID(owner_loginName), time.strftime('%Y-%m-%d %X', time.localtime())) cursor.execute(sql) sql2 = '''insert into t_turMap values (null,%d,%d,%d,'%s','%s',null) ''' % ( getTenantID(tenant_name), getUserID(owner_loginName), getRoleID('owner'), tenant_desc, time.strftime('%Y-%m-%d %X', time.localtime())) cursor.execute(sql2) except: logging.getLogger('operate').log(30, 'tenant create %s %s %s sql failed.' % ( owner_loginName, tenant_name, tenant_desc)) flag = False # transcation.rollback() else: logging.getLogger('operate').log(20, 'tenant create %s %s %s successed.' % ( owner_loginName, tenant_name, tenant_desc)) flag = True # transcation.commit() finally: pass finally: pass return flag