コード例 #1
0
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
コード例 #2
0
ファイル: daozo.py プロジェクト: honj51/dataservice2
def getTenantCountOfUser(user_name):
    sql = '''select count(*) from t_turMap 
        where t_turMap.user = %d and t_turMap.delete_at is NULL''' % (base.getUserIDByName(user_name))
    cursor = base.get_cursor()
    cursor.execute(sql)
    res = cursor.fetchall()
    return res[0][0]
コード例 #3
0
ファイル: daozo.py プロジェクト: honj51/dataservice2
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
コード例 #4
0
def getTenantCountOfUser(user_name):
    sql = '''select count(*) from t_turMap 
        where t_turMap.user = %d and t_turMap.delete_at is NULL''' % (
        base.getUserIDByName(user_name))
    cursor = base.get_cursor()
    cursor.execute(sql)
    res = cursor.fetchall()
    return res[0][0]
コード例 #5
0
ファイル: daozo.py プロジェクト: honj51/dataservice2
def getUserCountOfTenant(tenant_name):
    sql = '''select count(*) from t_turMap 
        where t_turMap.tenant = %d 
        and t_turMap.role != 2
        and t_turMap.delete_at is NULL''' % (base.getTenantIDByName(tenant_name))
    cursor = base.get_cursor()
    cursor.execute(sql)
    res = cursor.fetchall()
    return res[0][0]
コード例 #6
0
def getUserCountOfTenant(tenant_name):
    sql = '''select count(*) from t_turMap 
        where t_turMap.tenant = %d 
        and t_turMap.role != 2
        and t_turMap.delete_at is NULL''' % (
        base.getTenantIDByName(tenant_name))
    cursor = base.get_cursor()
    cursor.execute(sql)
    res = cursor.fetchall()
    return res[0][0]
コード例 #7
0
def tenant_del_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.remove_tenant_user_role(
            str(base.getTenantOSIDByName(tenant)),
            str(base.getUserOSIDByName(user)),
            str(base.getRoleOSIDByName(role)))
    except:
        print 'keystone tenant del user failed.'
    else:
        flag = True
        print 'keystone tenant del user successful.'
        try:
            cursor = base.get_cursor()
            sql = '''UPDATE t_turMap set delete_at='%s'
                where tenant=%d 
                and user=%d 
                and role=%d 
                and delete_at is NULL ''' % (time.strftime(
                '%Y-%m-%d %X',
                time.localtime()), int(base.getTenantIDByName(tenant)),
                                             int(base.getUserIDByName(user)),
                                             int(base.getRoleIDByName(role)))
            print sql
            cursor.execute(sql)
        except:
            print 'sql tenant del user failed.'
            flag = False
        else:
            print 'sql tenant del user successful.'
            flag = True
    finally:
        return flag
コード例 #8
0
ファイル: daozo.py プロジェクト: honj51/dataservice2
def tenant_del_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.remove_tenant_user_role(str(base.getTenantOSIDByName(tenant)),
            str(base.getUserOSIDByName(user)), str(base.getRoleOSIDByName(role)))
    except:
        print 'keystone tenant del user failed.'
    else:
        flag = True
        print 'keystone tenant del user successful.'
        try:
            cursor = base.get_cursor()
            sql = '''UPDATE t_turMap set delete_at='%s'
                where tenant=%d 
                and user=%d 
                and role=%d 
                and delete_at is NULL ''' % (time.strftime('%Y-%m-%d %X', time.localtime()),
                    int(base.getTenantIDByName(tenant)), int(base.getUserIDByName(user)), int(base.getRoleIDByName(role)))
            print sql
            cursor.execute(sql)
        except:
            print 'sql tenant del user failed.'
            flag = False
        else:
            print 'sql tenant del user successful.'
            flag = True
    finally:
        return flag