Method get_table_info

class/databaseModel/sqliteModel.py:206–268

@name 获取表信息 @param args['path'] 数据库路径 @param args['table'] 表名 @return list

(self,args)

        return result

    def get_table_info(self,args):
        """
        @name 获取表信息
        @param args['path'] 数据库路径
        @param args['table'] 表名
        @return list
        """

        path = args.path
        table = args.table
        if not os.path.exists(path):
            return public.returnMsg(False,'数据库不存在.')

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

        db = self.get_db_info(path)
        if not db:
            return public.returnMsg(False,'数据库文件错误.')

        sql = db['sql'].table(table) #获取表对象
        order = ""
        if hasattr(args,'order'):
            order = args.order

        where = '1=1'
        limit = 10
        if hasattr(args,'limit'):
            limit = int(args.limit)

        if hasattr(args,'search') and args.search:

            w_list = []
            slist = sql.query('PRAGMA table_info({})'.format(table))
            for val in slist:
                w_list.append("`{}` like '%{}%'".format(val[1],args.search))
            where = ' or '.join(w_list)

        import page
        #实例化分页类
        page = page.Page()

        info = {}
        info['count'] = sql.where(where,()).count()
        info['row']   = limit
        info['uri']   = args
        info['p'] = 1
        if hasattr(args,'p'):
            info['p'] = int(args['p'])

        info['return_js'] = ''
        if hasattr(args,'tojs'):
            info['return_js']   = args.tojs

        data['where'] = where
        data['page'] = page.GetPage(info,'1,2,3,4,5,8')    #获取分页数据
        data['data'] = sql.where(where,()).order(order).limit(str(page.SHIFT)+','+str(page.ROW)).select()      #取出数据