Method query_sql

class/databaseModel/sqliteModel.py:369–398

@name 查询sql @param args['path'] 数据库路径 @param args['sql_shell'] sql语句

(self,args)

        return public.returnMsg(False,'执行失败,{}'.format(result))

    def query_sql(self,args):
        """
        @name 查询sql
        @param args['path'] 数据库路径
        @param args['sql_shell'] sql语句
        """
        path = args.path
        if not os.path.exists(path):
            return public.returnMsg(False,'数据库不存在.')

        data = self.get_database_list()
        if not path in data:
            return public.returnMsg(False,'数据库不存在.')

        sql_shell = args.sql_shell
        db = self.get_db_info(path)
        if not db:
            return public.returnMsg(False,'数据库文件错误.')
        sql = db['sql']
        res = sql.query(sql_shell)

        result = {}
        if type(res) == list:
            result['status'] = True
            result['list'] = res

        else:
            result['status'] = False
            result['msg'] = res
        return result