daydaytalk-fwutils/target/fwutils/develop/function/role.lua

require("fwutils.webapi")
-- CREATE TABLE `fw_role` (
--   `id` int NOT NULL AUTO_INCREMENT,
--   `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
--   `sort` int DEFAULT NULL COMMENT '排序',
--   `desc` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
--   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
--   `default_filepath` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '默认页面',
--   PRIMARY KEY (`id`)
-- ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
local M = {}



function M.list(search,limit,conn)
    return query_model_ex(conn,"fw_role",{},limit.start,limit.length,function(sel)
    end,function(sel_data)
        sel_data:orderby("`sort` DESC")
    end)
end

return M