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
