Method SetDatabaseAccess

class/database.py:2272–2304

(self, get)

    # 设置数据库权限
    def SetDatabaseAccess(self, get):
        names = get['name'].split(',')
        set_phpv_successfully = []
        set_phpv_failed = {}
        for name in names:
            try:
                db_find = public.M('databases').where("username=? AND LOWER(type)=LOWER('mysql')", (name,)).find()
                db_name = db_find['name']
                sid = db_find['sid']
                mysql_obj = public.get_mysql_obj(db_name)
                access = get['access'].strip()
                if access in ['']: return public.returnMsg(False, 'IP地址不能为空!')
                password = public.M('databases').where("username=? AND LOWER(type)=LOWER('mysql')", (name,)).getField(
                    'password')
                result = mysql_obj.query("show databases")
                isError = self.IsSqlError(result)
                if isError != None: return isError
                users = mysql_obj.query("select Host from mysql.user where User='" + name + "' AND Host!='localhost'")

                for us in users:
                    mysql_obj.execute("drop user `{name}`@`{host}`".format(name=name, host=us[0]))
                self.__CreateUsers(sid, db_name, name, password, access)
                set_phpv_successfully.append(db_name)
            except Exception as e:
                set_phpv_failed[name] = "操作失败"
                pass

        if len(names) > 1:
            return {'status': True, 'msg': '设置[ {} ]数据库权限成功'.format(','.join(set_phpv_successfully)),
                    'error': set_phpv_failed,
                    'success': set_phpv_successfully}

        return public.returnMsg(True, 'SET_SUCCESS')

    # 获取数据库配置信息
    def GetMySQLInfo(self, get):