relationDB

package
v0.6.2 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Sep 20, 2023 License: AGPL-3.0 Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
var (
	MigrateUserInfo = []SysUserInfo{
		{UserID: 1740358057038188544, UserName: sql.NullString{String: "administrator", Valid: true}, Password: "4f0fded4a38abe7a3ea32f898bb82298", Role: 1, NickName: "iThings管理员"},
	}
	MigrateRoleInfo = []SysRoleInfo{{ID: 1, Name: "admin"}}
	MigrateRoleMenu []SysRoleMenu
	MigrateMenuInfo = []SysMenuInfo{
		{ID: 2, ParentID: 1, Type: 0, Order: 2, Name: "设备管理", Path: "/deviceMangers", Component: "./deviceMangers/index.tsx", Icon: "icon_data_01", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 3, ParentID: 1, Type: 0, Order: 9, Name: "系统管理", Path: "/systemManagers", Component: "./systemManagers/index.tsx", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 4, ParentID: 1, Type: 0, Order: 4, Name: "运维监控", Path: "/operationsMonitorings", Component: "./operationsMonitorings/index.tsx", Icon: "icon_hvac", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 6, ParentID: 2, Type: 2, Order: 1, Name: "产品", Path: "/deviceMangers/product/index", Component: "./deviceMangers/product/index", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 7, ParentID: 2, Type: 0, Order: 1, Name: "产品详情", Path: "/deviceMangers/product/detail/:id", Component: "./deviceMangers/product/detail/index", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 1},
		{ID: 8, ParentID: 2, Type: 0, Order: 2, Name: "设备", Path: "/deviceMangers/device/index", Component: "./deviceMangers/device/index", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 9, ParentID: 2, Type: 0, Order: 2, Name: "设备详情", Path: "/deviceMangers/device/detail/:id/:name", Component: "./deviceMangers/device/detail/index", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 1},
		{ID: 10, ParentID: 3, Type: 0, Order: 1, Name: "用户管理", Path: "/systemMangers/user/index", Component: "./systemMangers/user/index", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 11, ParentID: 3, Type: 2, Order: 2, Name: "角色管理", Path: "/systemMangers/role/index", Component: "./systemMangers/role/index", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 12, ParentID: 3, Type: 2, Order: 3, Name: "菜单列表", Path: "/systemMangers/menu/index", Component: "./systemMangers/menu/index", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 13, ParentID: 4, Type: 0, Order: 1, Name: "固件升级", Path: "/operationsMonitorings/firmwareUpgrades/index", Component: "./operationsMonitorings/firmwareUpgrades/index.tsx", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 15, ParentID: 4, Type: 0, Order: 3, Name: "资源管理", Path: "/operationsMonitorings/resourceManagements/index", Component: "./operationsMonitorings/resourceManagements/index.tsx", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 16, ParentID: 4, Type: 0, Order: 4, Name: "远程配置", Path: "/operationsMonitorings/remoteConfiguration/index", Component: "./operationsMonitorings/remoteConfiguration/index.tsx", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 18, ParentID: 4, Type: 2, Order: 6, Name: "在线调试", Path: "/operationsMonitorings/onlineDebugs/index", Component: "./operationsMonitorings/onlineDebugs/index.tsx", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 23, ParentID: 2, Type: 0, Order: 3, Name: "分组", Path: "/deviceMangers/group/index", Component: "./deviceMangers/group/index.tsx", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 24, ParentID: 2, Type: 0, Order: 3, Name: "分组详情", Path: "/deviceMangers/group/detail/:id", Component: "./deviceMangers/group/detail/index.tsx", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 1},
		{ID: 25, ParentID: 4, Type: 0, Order: 7, Name: "日志服务", Path: "/operationsMonitorings/logService/index", Component: "./operationsMonitorings/logService/index.tsx", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 35, ParentID: 1, Type: 1, Order: 1, Name: "首页", Path: "/home", Component: "./home/index.tsx", Icon: "icon_dosing", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 38, ParentID: 3, Type: 1, Order: 5, Name: "日志管理", Path: "/systemManagers/log/index", Component: "./systemManagers/log/index.tsx", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 39, ParentID: 38, Type: 1, Order: 1, Name: "操作日志", Path: "/systemMangers/log/operationLog/index", Component: "./systemMangers/log/operationLog/index.tsx", Icon: "icon_dosing", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 41, ParentID: 38, Type: 1, Order: 2, Name: "登录日志", Path: "/systemMangers/log/loginLog/index", Component: "./systemMangers/log/loginLog/index", Icon: "icon_heat", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 42, ParentID: 3, Type: 1, Order: 4, Name: "接口管理", Path: "/systemMangers/api/index", Component: "./systemMangers/api/index", Icon: "icon_system", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 43, ParentID: 1, Type: 1, Order: 5, Name: "告警管理", Path: "/alarmMangers", Component: "./alarmMangers/index", Icon: "icon_ap", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 44, ParentID: 43, Type: 1, Order: 1, Name: "告警配置", Path: "/alarmMangers/alarmConfiguration/index", Component: "./alarmMangers/alarmConfiguration/index", Icon: "icon_ap", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 53, ParentID: 43, Type: 1, Order: 5, Name: "新增告警配置", Path: "/alarmMangers/alarmConfiguration/save", Component: "./alarmMangers/alarmConfiguration/addAlarmConfig/index", Icon: "icon_ap", Redirect: "", BackgroundUrl: "", HideInMenu: 1},
		{ID: 54, ParentID: 43, Type: 1, Order: 5, Name: "告警日志", Path: "/alarmMangers/alarmConfiguration/log/detail/:id/:level", Component: "./alarmMangers/alarmLog/index", Icon: "icon_ap", Redirect: "", BackgroundUrl: "", HideInMenu: 1},
		{ID: 62, ParentID: 43, Type: 1, Order: 5, Name: "告警记录", Path: "/alarmMangers/alarmConfiguration/log", Component: "./alarmMangers/alarmRecord/index", Icon: "icon_ap", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 50, ParentID: 1, Type: 1, Order: 5, Name: "规则引擎", Path: "/ruleEngine", Component: "./ruleEngine/index.tsx", Icon: "icon_dosing", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
		{ID: 51, ParentID: 50, Type: 1, Order: 1, Name: "场景联动", Path: "/ruleEngine/scene/index", Component: "./ruleEngine/scene/index.tsx", Icon: "icon_device", Redirect: "", BackgroundUrl: "", HideInMenu: 2},
	}
	MigrateApiInfo = []SysApiInfo{
		{Route: "/api/v1/things/product/info/update", Method: 2, Name: "更新产品", BusinessType: 2, Desc: "", Group: "产品管理"},
		{Route: "/api/v1/things/product/info/create", Method: 2, Name: "新增产品", BusinessType: 1, Desc: "", Group: "产品管理"},
		{Route: "/api/v1/things/product/info/read", Method: 2, Name: "获取产品详情", BusinessType: 4, Desc: "", Group: "产品管理"},
		{Route: "/api/v1/things/product/info/delete", Method: 2, Name: "删除产品", BusinessType: 3, Desc: "", Group: "产品管理"},
		{Route: "/api/v1/things/product/info/index", Method: 2, Name: "获取产品列表", BusinessType: 4, Desc: "", Group: "产品管理"},
		{Route: "/api/v1/things/product/custom/read", Method: 2, Name: "获取产品自定义信息", BusinessType: 4, Desc: "", Group: "产品自定义信息"},
		{Route: "/api/v1/things/product/custom/update", Method: 2, Name: "更新产品自定义信息", BusinessType: 2, Desc: "", Group: "产品自定义信息"},
		{Route: "/api/v1/things/product/schema/index", Method: 2, Name: "获取产品物模型列表", BusinessType: 4, Desc: "", Group: "物模型"},
		{Route: "/api/v1/things/product/schema/tsl-import", Method: 2, Name: "导入物模型tsl", BusinessType: 1, Desc: "", Group: "物模型"},
		{Route: "/api/v1/things/product/schema/tsl-read", Method: 2, Name: "获取产品物模型tsl", BusinessType: 4, Desc: "", Group: "物模型"},
		{Route: "/api/v1/things/product/schema/create", Method: 2, Name: "新增物模型功能", BusinessType: 1, Desc: "", Group: "物模型"},
		{Route: "/api/v1/things/product/schema/update", Method: 2, Name: "更新物模型功能", BusinessType: 2, Desc: "", Group: "物模型"},
		{Route: "/api/v1/things/product/schema/delete", Method: 2, Name: "删除物模型功能", BusinessType: 3, Desc: "", Group: "物模型"},
		{Route: "/api/v1/things/product/remote-config/create", Method: 2, Name: "创建配置", BusinessType: 1, Desc: "", Group: "产品远程配置"},
		{Route: "/api/v1/things/product/remote-config/index", Method: 2, Name: "获取配置列表", BusinessType: 4, Desc: "", Group: "产品远程配置"},
		{Route: "/api/v1/things/product/remote-config/push-all", Method: 2, Name: "推送配置", BusinessType: 5, Desc: "", Group: "产品远程配置"},
		{Route: "/api/v1/things/product/remote-config/lastest-read", Method: 2, Name: "获取最新配置", BusinessType: 4, Desc: "", Group: "产品远程配置"},
		{Route: "/api/v1/things/group/info/create", Method: 2, Name: "创建分组", BusinessType: 1, Desc: "", Group: "设备分组"},
		{Route: "/api/v1/things/group/info/index", Method: 2, Name: "获取分组列表", BusinessType: 4, Desc: "", Group: "设备分组"},
		{Route: "/api/v1/things/group/info/read", Method: 2, Name: "获取分组详情信息", BusinessType: 4, Desc: "", Group: "设备分组"},
		{Route: "/api/v1/things/group/info/update", Method: 2, Name: "更新分组信息", BusinessType: 2, Desc: "", Group: "设备分组"},
		{Route: "/api/v1/things/group/info/delete", Method: 2, Name: "删除分组", BusinessType: 3, Desc: "", Group: "设备分组"},
		{Route: "/api/v1/things/group/device/index", Method: 2, Name: "获取分组设备列表", BusinessType: 4, Desc: "", Group: "设备分组"},
		{Route: "/api/v1/things/group/device/multi-create", Method: 2, Name: "添加分组设备(支持批量)", BusinessType: 1, Desc: "", Group: "设备分组"},
		{Route: "/api/v1/things/group/device/multi-delete", Method: 2, Name: "删除分组设备(支持批量)", BusinessType: 3, Desc: "", Group: "设备分组"},
		{Route: "/api/v1/things/device/info/index", Method: 2, Name: "获取设备列表", BusinessType: 4, Desc: "", Group: "设备管理"},
		{Route: "/api/v1/things/device/info/read", Method: 2, Name: "获取设备详情", BusinessType: 4, Desc: "", Group: "设备管理"},
		{Route: "/api/v1/things/device/info/create", Method: 2, Name: "新增设备", BusinessType: 1, Desc: "", Group: "设备管理"},
		{Route: "/api/v1/things/device/info/delete", Method: 2, Name: "删除设备", BusinessType: 3, Desc: "", Group: "设备管理"},
		{Route: "/api/v1/things/device/info/update", Method: 2, Name: "更新设备", BusinessType: 2, Desc: "", Group: "设备管理"},
		{Route: "/api/v1/things/device/info/count", Method: 2, Name: "设备统计详情", BusinessType: 4, Desc: "", Group: "设备管理"},
		{Route: "/api/v1/things/device/info/multi-import", Method: 2, Name: "批量导入设备", BusinessType: 1, Desc: "", Group: "设备管理"},
		{Route: "/api/v1/things/device/auth/login", Method: 2, Name: "设备登录认证", BusinessType: 5, Desc: "", Group: "设备鉴权"},
		{Route: "/api/v1/things/device/auth/root-check", Method: 2, Name: "鉴定mqtt账号root权限", BusinessType: 5, Desc: "", Group: "设备鉴权"},
		{Route: "/api/v1/things/device/auth/access", Method: 2, Name: "设备操作认证", BusinessType: 5, Desc: "", Group: "设备鉴权"},
		{Route: "/api/v1/things/device/msg/property-log/index", Method: 2, Name: "获取单个id属性历史记录", BusinessType: 4, Desc: "", Group: "设备消息"},
		{Route: "/api/v1/things/device/msg/sdk-log/index", Method: 2, Name: "获取设备本地日志", BusinessType: 4, Desc: "", Group: "设备消息"},
		{Route: "/api/v1/things/device/msg/hub-log/index", Method: 2, Name: "获取云端诊断日志", BusinessType: 4, Desc: "", Group: "设备消息"},
		{Route: "/api/v1/things/device/msg/property-latest/index", Method: 2, Name: "获取最新属性", BusinessType: 4, Desc: "", Group: "设备消息"},
		{Route: "/api/v1/things/device/msg/event-log/index", Method: 2, Name: "获取物模型事件历史记录", BusinessType: 4, Desc: "", Group: "设备消息"},
		{Route: "/api/v1/things/device/interact/send-action", Method: 2, Name: "同步调用设备行为", BusinessType: 5, Desc: "", Group: "设备交互"},
		{Route: "/api/v1/things/device/interact/send-property", Method: 2, Name: "同步调用设备属性", BusinessType: 5, Desc: "", Group: "设备交互"},
		{Route: "/api/v1/things/device/interact/multi-send-property", Method: 2, Name: "批量调用设备属性", BusinessType: 5, Desc: "", Group: "设备交互"},
		{Route: "/api/v1/things/device/interact/get-property-reply", Method: 2, Name: "请求设备获取设备最新属性", BusinessType: 4, Desc: "", Group: "设备交互"},
		{Route: "/api/v1/things/device/interact/send-msg", Method: 2, Name: "发送消息给设备", BusinessType: 5, Desc: "", Group: "设备交互"},
		{Route: "/api/v1/things/device/gateway/multi-create", Method: 2, Name: "批量添加网关子设备", BusinessType: 1, Desc: "", Group: "网关子设备管理"},
		{Route: "/api/v1/things/device/gateway/multi-delete", Method: 2, Name: "批量解绑网关子设备", BusinessType: 3, Desc: "", Group: "网关子设备管理"},
		{Route: "/api/v1/things/device/gateway/index", Method: 2, Name: "获取子设备列表", BusinessType: 4, Desc: "", Group: "网关子设备管理"},
		{Route: "/api/v1/system/log/login/index", Method: 2, Name: "获取登录日志列表", BusinessType: 4, Desc: "", Group: "日志管理"},
		{Route: "/api/v1/system/log/oper/index", Method: 2, Name: "获取操作日志列表", BusinessType: 4, Desc: "", Group: "日志管理"},
		{Route: "/api/v1/system/role/create", Method: 2, Name: "添加角色", BusinessType: 1, Desc: "", Group: "角色管理"},
		{Route: "/api/v1/system/role/index", Method: 2, Name: "获取角色列表", BusinessType: 4, Desc: "", Group: "角色管理"},
		{Route: "/api/v1/system/role/update", Method: 2, Name: "更新角色", BusinessType: 2, Desc: "", Group: "角色管理"},
		{Route: "/api/v1/system/role/delete", Method: 2, Name: "删除角色", BusinessType: 3, Desc: "", Group: "角色管理"},
		{Route: "/api/v1/system/role/role-menu/update", Method: 2, Name: "更新角色对应菜单列表", BusinessType: 2, Desc: "", Group: "角色管理"},
		{Route: "/api/v1/system/menu/create", Method: 2, Name: "添加菜单", BusinessType: 1, Desc: "", Group: "菜单管理"},
		{Route: "/api/v1/system/menu/index", Method: 2, Name: "获取菜单列表", BusinessType: 4, Desc: "", Group: "菜单管理"},
		{Route: "/api/v1/system/menu/update", Method: 2, Name: "更新菜单", BusinessType: 2, Desc: "", Group: "菜单管理"},
		{Route: "/api/v1/system/menu/delete", Method: 2, Name: "删除菜单", BusinessType: 3, Desc: "", Group: "菜单管理"},
		{Route: "/api/v1/system/user/create", Method: 2, Name: "创建用户信息", BusinessType: 1, Desc: "", Group: "用户管理"},
		{Route: "/api/v1/system/user/captcha", Method: 2, Name: "获取验证码", BusinessType: 5, Desc: "", Group: "用户管理"},
		{Route: "/api/v1/system/user/login", Method: 2, Name: "登录", BusinessType: 5, Desc: "", Group: "用户管理"},
		{Route: "/api/v1/system/user/delete", Method: 2, Name: "删除用户", BusinessType: 3, Desc: "", Group: "用户管理"},
		{Route: "/api/v1/system/user/read", Method: 2, Name: "获取用户信息", BusinessType: 4, Desc: "", Group: "用户管理"},
		{Route: "/api/v1/system/user/update", Method: 2, Name: "更新用户基本数据", BusinessType: 2, Desc: "", Group: "用户管理"},
		{Route: "/api/v1/system/user/index", Method: 2, Name: "获取用户信息列表", BusinessType: 4, Desc: "", Group: "用户管理"},
		{Route: "/api/v1/system/user/resource-read", Method: 2, Name: "获取用户资源", BusinessType: 4, Desc: "", Group: "用户管理"},
		{Route: "/api/v1/system/common/config", Method: 2, Name: "获取系统配置", BusinessType: 4, Desc: "", Group: "系统配置"},
		{Route: "/api/v1/system/api/create", Method: 2, Name: "添加接口", BusinessType: 1, Desc: "", Group: "接口管理"},
		{Route: "/api/v1/system/api/index", Method: 2, Name: "获取接口列表", BusinessType: 4, Desc: "", Group: "接口管理"},
		{Route: "/api/v1/system/api/update", Method: 2, Name: "更新接口", BusinessType: 2, Desc: "", Group: "接口管理"},
		{Route: "/api/v1/system/api/delete", Method: 2, Name: "删除接口", BusinessType: 3, Desc: "", Group: "接口管理"},
		{Route: "/api/v1/system/auth/api/index", Method: 2, Name: "获取API权限列表", BusinessType: 4, Desc: "", Group: "权限管理"},
		{Route: "/api/v1/system/auth/api/multiUpdate", Method: 2, Name: "更新API权限", BusinessType: 2, Desc: "", Group: "权限管理"},
		{Route: "/api/v1/things/rule/scene/info/read", Method: 2, Name: "获取场景信息", BusinessType: 4, Desc: "", Group: "场景联动"},
		{Route: "/api/v1/things/rule/scene/info/index", Method: 2, Name: "获取场景列表", BusinessType: 4, Desc: "", Group: "场景联动"},
		{Route: "/api/v1/things/rule/scene/info/create", Method: 2, Name: "创建场景信息", BusinessType: 1, Desc: "", Group: "场景联动"},
		{Route: "/api/v1/things/rule/scene/info/update", Method: 2, Name: "更新场景信息", BusinessType: 2, Desc: "", Group: "场景联动"},
		{Route: "/api/v1/things/rule/scene/info/delete", Method: 2, Name: "删除场景信息", BusinessType: 3, Desc: "", Group: "场景联动"},
		{Route: "/api/v1/things/rule/flow/info/index", Method: 2, Name: "获取流列表", BusinessType: 4, Desc: "", Group: "流"},
		{Route: "/api/v1/things/rule/flow/info/create", Method: 2, Name: "创建流", BusinessType: 1, Desc: "", Group: "流"},
		{Route: "/api/v1/things/rule/flow/info/update", Method: 2, Name: "修改流", BusinessType: 2, Desc: "", Group: "流"},
		{Route: "/api/v1/things/rule/flow/info/delete", Method: 2, Name: "删除流", BusinessType: 3, Desc: "", Group: "流"},
		{Route: "/api/v1/things/rule/alarm/info/create", Method: 2, Name: "新增告警", BusinessType: 1, Desc: "", Group: "告警管理"},
		{Route: "/api/v1/things/rule/alarm/info/update", Method: 2, Name: "更新告警", BusinessType: 2, Desc: "", Group: "告警管理"},
		{Route: "/api/v1/things/rule/alarm/info/delete", Method: 2, Name: "删除告警", BusinessType: 3, Desc: "", Group: "告警管理"},
		{Route: "/api/v1/things/rule/alarm/info/index", Method: 2, Name: "获取告警信息列表", BusinessType: 4, Desc: "", Group: "告警管理"},
		{Route: "/api/v1/things/rule/alarm/info/read", Method: 2, Name: "获取告警详情", BusinessType: 4, Desc: "", Group: "告警管理"},
		{Route: "/api/v1/things/rule/alarm/scene/delete", Method: 2, Name: "删除告警和场景的关联", BusinessType: 3, Desc: "", Group: "场景联动"},
		{Route: "/api/v1/things/rule/alarm/log/index", Method: 2, Name: "获取告警流水日志记录列表", BusinessType: 4, Desc: "", Group: "告警日志"},
		{Route: "/api/v1/things/rule/alarm/record/index", Method: 2, Name: "获取告警记录列表", BusinessType: 4, Desc: "", Group: "告警记录"},
		{Route: "/api/v1/things/rule/alarm/deal-record/create", Method: 2, Name: "新增告警处理记录", BusinessType: 1, Desc: "", Group: "处理记录"},
		{Route: "/api/v1/things/rule/alarm/deal-record/index", Method: 2, Name: "获取告警处理记录列表", BusinessType: 4, Desc: "", Group: "处理记录"},
		{Route: "/api/v1/things/rule/alarm/scene/multi-update", Method: 2, Name: "更新告警和场景的关联", BusinessType: 2, Desc: "", Group: "场景联动"},
	}
	MigrateApiAuth = []SysApiAuth{
		{PType: "p", V0: "1", V1: "/api/v1/things/product/info/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/info/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/info/read", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/info/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/info/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/schema/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/schema/tsl-import", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/schema/tsl-read", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/schema/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/schema/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/schema/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/remote-config/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/remote-config/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/remote-config/push-all", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/remote-config/lastest-read", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/custom/read", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/product/custom/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/group/info/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/group/info/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/group/info/read", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/group/info/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/group/info/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/group/device/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/group/device/multi-create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/group/device/multi-delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/info/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/info/read", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/info/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/info/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/info/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/info/count", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/auth/login", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/auth/root-check", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/auth/access", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/msg/property-log/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/msg/sdk-log/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/msg/hub-log/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/msg/property-latest/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/msg/event-log/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/interact/send-action", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/interact/send-property", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/interact/multi-send-property", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/interact/send-msg", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/gateway/multi-create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/gateway/multi-delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/device/gateway/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/log/login/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/log/oper/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/role/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/role/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/role/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/role/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/role/role-menu/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/menu/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/menu/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/menu/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/menu/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/user/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/user/captcha", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/user/login", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/user/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/user/read", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/user/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/user/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/user/resource-read", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/common/config", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/api/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/api/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/api/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/api/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/auth/api/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/system/auth/api/multiUpdate", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/scene/info/read", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/scene/info/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/scene/info/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/scene/info/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/scene/info/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/flow/info/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/flow/info/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/flow/info/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/flow/info/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/info/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/info/update", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/info/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/info/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/info/read", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/scene/delete", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/log/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/record/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/deal-record/create", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/deal-record/index", V2: "2", V3: "", V4: "", V5: ""},
		{PType: "p", V0: "1", V1: "/api/v1/things/rule/alarm/scene/multi-update", V2: "2", V3: "", V4: "", V5: ""},
	}
)

Functions

func Migrate

func Migrate() error

Types

type ApiAuthRepo

type ApiAuthRepo struct {
	// contains filtered or unexported fields
}

func NewApiAuthRepo

func NewApiAuthRepo(in any) *ApiAuthRepo

type ApiInfoFilter

type ApiInfoFilter struct {
	Route  string
	Method int64
	Group  string
	Name   string
}

type ApiInfoRepo

type ApiInfoRepo struct {
	// contains filtered or unexported fields
}

func NewApiInfoRepo

func NewApiInfoRepo(in any) *ApiInfoRepo

func (ApiInfoRepo) CountByFilter

func (p ApiInfoRepo) CountByFilter(ctx context.Context, f ApiInfoFilter) (size int64, err error)

func (ApiInfoRepo) Delete

func (p ApiInfoRepo) Delete(ctx context.Context, id int64) error

func (ApiInfoRepo) DeleteByFilter

func (p ApiInfoRepo) DeleteByFilter(ctx context.Context, f ApiInfoFilter) error

func (ApiInfoRepo) FindByFilter

func (p ApiInfoRepo) FindByFilter(ctx context.Context, f ApiInfoFilter, page *def.PageInfo) ([]*SysApiInfo, error)

func (ApiInfoRepo) FindOne

func (p ApiInfoRepo) FindOne(ctx context.Context, id int64) (*SysApiInfo, error)

func (ApiInfoRepo) FindOneByFilter

func (p ApiInfoRepo) FindOneByFilter(ctx context.Context, f ApiInfoFilter) (*SysApiInfo, error)

func (ApiInfoRepo) Insert

func (p ApiInfoRepo) Insert(ctx context.Context, data *SysApiInfo) error

func (ApiInfoRepo) Update

func (p ApiInfoRepo) Update(ctx context.Context, data *SysApiInfo) error

type DateRange

type DateRange struct {
	Start string
	End   string
}

type ExampleFilter

type ExampleFilter struct {
}

type ExampleRepo

type ExampleRepo struct {
	// contains filtered or unexported fields
}

func NewExampleRepo

func NewExampleRepo(in any) *ExampleRepo

func (ExampleRepo) CountByFilter

func (p ExampleRepo) CountByFilter(ctx context.Context, f ExampleFilter) (size int64, err error)

func (ExampleRepo) Delete

func (p ExampleRepo) Delete(ctx context.Context, id int64) error

func (ExampleRepo) DeleteByFilter

func (p ExampleRepo) DeleteByFilter(ctx context.Context, f ExampleFilter) error

func (ExampleRepo) FindByFilter

func (p ExampleRepo) FindByFilter(ctx context.Context, f ExampleFilter, page *def.PageInfo) ([]*SysExample, error)

func (ExampleRepo) FindOne

func (p ExampleRepo) FindOne(ctx context.Context, id int64) (*SysExample, error)

func (ExampleRepo) FindOneByFilter

func (p ExampleRepo) FindOneByFilter(ctx context.Context, f ExampleFilter) (*SysExample, error)

func (ExampleRepo) Insert

func (p ExampleRepo) Insert(ctx context.Context, data *SysExample) error

func (ExampleRepo) MultiInsert

func (p ExampleRepo) MultiInsert(ctx context.Context, data []*SysExample) error

批量插入 LightStrategyDevice 记录

func (ExampleRepo) Update

func (p ExampleRepo) Update(ctx context.Context, data *SysExample) error

type LoginLogFilter

type LoginLogFilter struct {
	IpAddr        string
	LoginLocation string
	Data          *DateRange
}

type LoginLogRepo

type LoginLogRepo struct {
	// contains filtered or unexported fields
}

func NewLoginLogRepo

func NewLoginLogRepo(in any) *LoginLogRepo

func (LoginLogRepo) CountByFilter

func (p LoginLogRepo) CountByFilter(ctx context.Context, f LoginLogFilter) (size int64, err error)

func (LoginLogRepo) Delete

func (p LoginLogRepo) Delete(ctx context.Context, id int64) error

func (LoginLogRepo) DeleteByFilter

func (p LoginLogRepo) DeleteByFilter(ctx context.Context, f LoginLogFilter) error

func (LoginLogRepo) FindByFilter

func (p LoginLogRepo) FindByFilter(ctx context.Context, f LoginLogFilter, page *def.PageInfo) ([]*SysLoginLog, error)

func (LoginLogRepo) FindOne

func (p LoginLogRepo) FindOne(ctx context.Context, id int64) (*SysLoginLog, error)

func (LoginLogRepo) FindOneByFilter

func (p LoginLogRepo) FindOneByFilter(ctx context.Context, f LoginLogFilter) (*SysLoginLog, error)

func (LoginLogRepo) Insert

func (p LoginLogRepo) Insert(ctx context.Context, data *SysLoginLog) error

func (LoginLogRepo) Update

func (p LoginLogRepo) Update(ctx context.Context, data *SysLoginLog) error
type MenuInfoFilter struct {
	Role    int64
	Name    string
	Path    string
	MenuIds []int64
}
type MenuInfoRepo struct {
	// contains filtered or unexported fields
}

func NewMenuInfoRepo

func NewMenuInfoRepo(in any) *MenuInfoRepo
func (p MenuInfoRepo) CountByFilter(ctx context.Context, f MenuInfoFilter) (size int64, err error)
func (p MenuInfoRepo) Delete(ctx context.Context, id int64) error
func (p MenuInfoRepo) DeleteByFilter(ctx context.Context, f MenuInfoFilter) error
func (p MenuInfoRepo) FindByFilter(ctx context.Context, f MenuInfoFilter, page *def.PageInfo) ([]*SysMenuInfo, error)
func (p MenuInfoRepo) FindOne(ctx context.Context, id int64) (*SysMenuInfo, error)
func (p MenuInfoRepo) FindOneByFilter(ctx context.Context, f MenuInfoFilter) (*SysMenuInfo, error)
func (p MenuInfoRepo) Insert(ctx context.Context, data *SysMenuInfo) error
func (p MenuInfoRepo) Update(ctx context.Context, data *SysMenuInfo) error

type OperLogFilter

type OperLogFilter struct {
	OperName     string
	OperUserName string
	BusinessType int64
}

type OperLogRepo

type OperLogRepo struct {
	// contains filtered or unexported fields
}

func NewOperLogRepo

func NewOperLogRepo(in any) *OperLogRepo

func (OperLogRepo) CountByFilter

func (p OperLogRepo) CountByFilter(ctx context.Context, f OperLogFilter) (size int64, err error)

func (OperLogRepo) Delete

func (p OperLogRepo) Delete(ctx context.Context, id int64) error

func (OperLogRepo) DeleteByFilter

func (p OperLogRepo) DeleteByFilter(ctx context.Context, f OperLogFilter) error

func (OperLogRepo) FindByFilter

func (p OperLogRepo) FindByFilter(ctx context.Context, f OperLogFilter, page *def.PageInfo) ([]*SysOperLog, error)

func (OperLogRepo) FindOne

func (p OperLogRepo) FindOne(ctx context.Context, id int64) (*SysOperLog, error)

func (OperLogRepo) FindOneByFilter

func (p OperLogRepo) FindOneByFilter(ctx context.Context, f OperLogFilter) (*SysOperLog, error)

func (OperLogRepo) Insert

func (p OperLogRepo) Insert(ctx context.Context, data *SysOperLog) error

func (OperLogRepo) Update

func (p OperLogRepo) Update(ctx context.Context, data *SysOperLog) error

type RoleInfoFilter

type RoleInfoFilter struct {
	Name   string
	Status int64
	*RoleInfoWith
}

type RoleInfoRepo

type RoleInfoRepo struct {
	// contains filtered or unexported fields
}

func NewRoleInfoRepo

func NewRoleInfoRepo(in any) *RoleInfoRepo

func (RoleInfoRepo) CountByFilter

func (p RoleInfoRepo) CountByFilter(ctx context.Context, f RoleInfoFilter) (size int64, err error)

func (RoleInfoRepo) Delete

func (p RoleInfoRepo) Delete(ctx context.Context, id int64) error

func (RoleInfoRepo) DeleteByFilter

func (p RoleInfoRepo) DeleteByFilter(ctx context.Context, f RoleInfoFilter) error

func (RoleInfoRepo) FindByFilter

func (p RoleInfoRepo) FindByFilter(ctx context.Context, f RoleInfoFilter, page *def.PageInfo) ([]*SysRoleInfo, error)

func (RoleInfoRepo) FindOne

func (p RoleInfoRepo) FindOne(ctx context.Context, id int64, with *RoleInfoWith) (*SysRoleInfo, error)

func (RoleInfoRepo) FindOneByFilter

func (p RoleInfoRepo) FindOneByFilter(ctx context.Context, f RoleInfoFilter) (*SysRoleInfo, error)

func (RoleInfoRepo) Insert

func (p RoleInfoRepo) Insert(ctx context.Context, data *SysRoleInfo) error

func (RoleInfoRepo) Update

func (p RoleInfoRepo) Update(ctx context.Context, data *SysRoleInfo) error

type RoleInfoWith

type RoleInfoWith struct {
	WithMenus bool
}

type RoleMenuFilter

type RoleMenuFilter struct {
	RoleIDs []int64
}

type RoleMenuRepo

type RoleMenuRepo struct {
	// contains filtered or unexported fields
}

func NewRoleMenuRepo

func NewRoleMenuRepo(in any) *RoleMenuRepo

func (RoleMenuRepo) CountByFilter

func (p RoleMenuRepo) CountByFilter(ctx context.Context, f RoleMenuFilter) (size int64, err error)

func (RoleMenuRepo) Delete

func (p RoleMenuRepo) Delete(ctx context.Context, id int64) error

func (RoleMenuRepo) DeleteByFilter

func (p RoleMenuRepo) DeleteByFilter(ctx context.Context, f RoleMenuFilter) error

func (RoleMenuRepo) FindByFilter

func (p RoleMenuRepo) FindByFilter(ctx context.Context, f RoleMenuFilter, page *def.PageInfo) ([]*SysRoleMenu, error)

func (RoleMenuRepo) FindOne

func (p RoleMenuRepo) FindOne(ctx context.Context, id int64) (*SysRoleMenu, error)

func (RoleMenuRepo) FindOneByFilter

func (p RoleMenuRepo) FindOneByFilter(ctx context.Context, f RoleMenuFilter) (*SysRoleMenu, error)

func (RoleMenuRepo) Insert

func (p RoleMenuRepo) Insert(ctx context.Context, data *SysRoleMenu) error

func (RoleMenuRepo) MultiInsert

func (p RoleMenuRepo) MultiInsert(ctx context.Context, data []*SysRoleMenu) error

批量插入 LightStrategyDevice 记录

func (RoleMenuRepo) MultiUpdate

func (p RoleMenuRepo) MultiUpdate(ctx context.Context, roleID int64, menuIDs []int64) error

func (RoleMenuRepo) Update

func (p RoleMenuRepo) Update(ctx context.Context, data *SysRoleMenu) error

type SysApiAuth

type SysApiAuth struct {
	ID    int64  `gorm:"column:id;type:BIGINT;primary_key;AUTO_INCREMENT"` // 编号
	PType string `gorm:"column:p_type;type:VARCHAR(255);NOT NULL"`         // 策略类型,即策略的分类,例如"p"表示主体(provider)访问资源(resource)的许可权,"g"表示主体(provider)之间的关系访问控制
	V0    string `gorm:"column:v0;type:VARCHAR(255);NOT NULL"`             // 策略中的第一个参数,通常用于表示资源的归属范围(即限制访问的对象),例如资源所属的机构、部门、业务线、地域等
	V1    string `gorm:"column:v1;type:VARCHAR(255);NOT NULL"`             // 策略中的第二个参数,通常用于表示主体(provider),即需要访问资源的用户或者服务
	V2    string `gorm:"column:v2;type:VARCHAR(255);NOT NULL"`             // 策略中的第三个参数,通常用于表示资源(resource),即需要进行访问的对象
	V3    string `gorm:"column:v3;type:VARCHAR(255);NOT NULL"`             // 策略中的第四个参数,通常用于表示访问操作(permission),例如 “read”, “write”, “execute” 等
	V4    string `gorm:"column:v4;type:VARCHAR(255);NOT NULL"`             // 策略中的第五个参数,通常用于表示资源的类型(object type),例如表示是文件或者数据库表等
	V5    string `gorm:"column:v5;type:VARCHAR(255);NOT NULL"`             // 策略中的第六个参数,通常用于表示扩展信息,例如 IP 地址、端口号等
}

api权限管理

func (*SysApiAuth) TableName

func (m *SysApiAuth) TableName() string

type SysApiInfo

type SysApiInfo struct {
	ID           int64  `gorm:"column:id;type:BIGINT;primary_key;AUTO_INCREMENT"`    // 编号
	Route        string `gorm:"column:route;uniqueIndex;type:VARCHAR(100);NOT NULL"` // 路由
	Method       int64  `gorm:"column:method;type:BIGINT;NOT NULL"`                  // 请求方式(1 GET 2 POST 3 HEAD 4 OPTIONS 5 PUT 6 DELETE 7 TRACE 8 CONNECT 9 其它)
	Name         string `gorm:"column:name;type:VARCHAR(100);NOT NULL"`              // 请求名称
	BusinessType int64  `gorm:"column:business_type;type:BIGINT;NOT NULL"`           // 业务类型(1新增 2修改 3删除 4查询 5其它)
	Group        string `gorm:"column:group;type:VARCHAR(100);NOT NULL"`             // 接口组
	Desc         string `gorm:"column:desc;type:VARCHAR(100);NOT NULL"`              // 备注
	stores.Time
}

接口管理

func (*SysApiInfo) TableName

func (m *SysApiInfo) TableName() string

type SysExample

type SysExample struct {
	ID int64 `gorm:"column:id;type:bigint;primary_key;AUTO_INCREMENT"` // id编号
}

示例

type SysLoginLog

type SysLoginLog struct {
	ID            int64     `gorm:"column:id;type:BIGINT;primary_key;AUTO_INCREMENT"`       // 编号
	UserID        int64     `gorm:"column:user_id;type:BIGINT;NOT NULL"`                    // 用户id
	UserName      string    `gorm:"column:user_name;type:VARCHAR(50)"`                      // 登录账号
	IpAddr        string    `gorm:"column:ip_addr;type:VARCHAR(50)"`                        // 登录IP地址
	LoginLocation string    `gorm:"column:login_location;type:VARCHAR(100)"`                // 登录地点
	Browser       string    `gorm:"column:browser;type:VARCHAR(50)"`                        // 浏览器类型
	Os            string    `gorm:"column:os;type:VARCHAR(50)"`                             // 操作系统
	Code          int64     `gorm:"column:code;type:BIGINT;default:200;NOT NULL"`           // 登录状态(200成功 其它失败)
	Msg           string    `gorm:"column:msg;type:VARCHAR(255)"`                           // 提示消息
	CreatedTime   time.Time `gorm:"column:created_time;default:CURRENT_TIMESTAMP;NOT NULL"` // 登录时间
}

登录日志管理

func (*SysLoginLog) TableName

func (m *SysLoginLog) TableName() string

type SysMenuInfo

type SysMenuInfo struct {
	ID            int64  `gorm:"column:id;type:BIGINT;primary_key;AUTO_INCREMENT"`   // 编号
	ParentID      int64  `gorm:"column:parent_id;type:BIGINT;default:1;NOT NULL"`    // 父菜单ID,一级菜单为1
	Type          int64  `gorm:"column:type;type:BIGINT;default:1;NOT NULL"`         // 类型   1:目录   2:菜单   3:按钮
	Order         int64  `gorm:"column:order_num;type:BIGINT;default:1;NOT NULL"`    // 左侧table排序序号
	Name          string `gorm:"column:name;type:VARCHAR(50);NOT NULL"`              // 菜单名称
	Path          string `gorm:"column:path;type:VARCHAR(64);NOT NULL"`              // 系统的path
	Component     string `gorm:"column:component;type:VARCHAR(64);NOT NULL"`         // 页面
	Icon          string `gorm:"column:icon;type:VARCHAR(64);NOT NULL"`              // 图标
	Redirect      string `gorm:"column:redirect;type:VARCHAR(64);NOT NULL"`          // 路由重定向
	BackgroundUrl string `gorm:"column:background_url;type:VARCHAR(128);NOT NULL"`   // 后台地址
	HideInMenu    int64  `gorm:"column:hide_in_menu;type:BIGINT;default:2;NOT NULL"` // 是否隐藏菜单 1-是 2-否
	stores.Time
}

菜单管理表

func (*SysMenuInfo) TableName

func (m *SysMenuInfo) TableName() string

type SysOperLog

type SysOperLog struct {
	ID           int64          `gorm:"column:id;type:BIGINT;primary_key;AUTO_INCREMENT"`       // 编号
	OperUserID   int64          `gorm:"column:oper_user_id;type:BIGINT;NOT NULL"`               // 用户id
	OperUserName string         `gorm:"column:oper_user_name;type:VARCHAR(50)"`                 // 操作人员名称
	OperName     string         `gorm:"column:oper_name;type:VARCHAR(50)"`                      // 操作名称
	BusinessType int64          `gorm:"column:business_type;type:BIGINT;NOT NULL"`              // 业务类型(1新增 2修改 3删除 4查询 5其它)
	Uri          string         `gorm:"column:uri;type:VARCHAR(100)"`                           // 请求地址
	OperIpAddr   string         `gorm:"column:oper_ip_addr;type:VARCHAR(50)"`                   // 主机地址
	OperLocation string         `gorm:"column:oper_location;type:VARCHAR(255)"`                 // 操作地点
	Req          sql.NullString `gorm:"column:req;type:TEXT"`                                   // 请求参数
	Resp         sql.NullString `gorm:"column:resp;type:TEXT"`                                  // 返回参数
	Code         int64          `gorm:"column:code;type:BIGINT;default:200;NOT NULL"`           // 返回状态(200成功 其它失败)
	Msg          string         `gorm:"column:msg;type:VARCHAR(255)"`                           // 提示消息
	CreatedTime  time.Time      `gorm:"column:created_time;default:CURRENT_TIMESTAMP;NOT NULL"` // 操作时间
}

操作日志管理

func (*SysOperLog) TableName

func (m *SysOperLog) TableName() string

type SysRoleInfo

type SysRoleInfo struct {
	ID     int64  `gorm:"column:id;type:BIGINT;primary_key;AUTO_INCREMENT"`   // id编号
	Name   string `gorm:"column:name;uniqueIndex;type:VARCHAR(100);NOT NULL"` // 角色名称
	Remark string `gorm:"column:remark;type:VARCHAR(100);NOT NULL"`           // 备注
	stores.Time
	Status int64          `gorm:"column:status;type:SMALLINT;default:1"` // 状态  1:启用,2:禁用
	Menus  []*SysRoleMenu `gorm:"foreignKey:role_id;references:id"`
}

角色管理表

func (*SysRoleInfo) TableName

func (m *SysRoleInfo) TableName() string

type SysRoleMenu

type SysRoleMenu struct {
	ID     int64 `gorm:"column:id;type:BIGINT;primary_key;AUTO_INCREMENT"`      // id编号
	RoleID int64 `gorm:"column:role_id;uniqueIndex:ri_mi;NOT NULL;type:BIGINT"` // 角色ID
	MenuID int64 `gorm:"column:menu_id;uniqueIndex:ri_mi;NOT NULL;type:BIGINT"` // 菜单ID
	stores.Time
}

角色菜单关联表

func (*SysRoleMenu) TableName

func (m *SysRoleMenu) TableName() string

type SysUserInfo

type SysUserInfo struct {
	UserID     int64          `gorm:"column:user_id;primary_key;AUTO_INCREMENT;type:BIGINT;NOT NULL"` // 用户id
	UserName   sql.NullString `gorm:"column:user_name;uniqueIndex;type:VARCHAR(20)"`                  // 登录用户名
	Password   string         `gorm:"column:password;type:CHAR(32);NOT NULL"`                         // 登录密码
	Email      sql.NullString `gorm:"column:email;uniqueIndex;type:VARCHAR(255)"`                     // 邮箱
	Phone      sql.NullString `gorm:"column:phone;uniqueIndex;type:VARCHAR(20)"`                      // 手机号
	Wechat     sql.NullString `gorm:"column:wechat;uniqueIndex;type:VARCHAR(20)"`                     // 微信union id
	LastIP     string         `gorm:"column:last_ip;type:VARCHAR(40);NOT NULL"`                       // 最后登录ip
	RegIP      string         `gorm:"column:reg_ip;type:VARCHAR(40);NOT NULL"`                        // 注册ip
	NickName   string         `gorm:"column:nick_name;type:VARCHAR(60);NOT NULL"`                     // 用户的昵称
	Sex        int64          `gorm:"column:sex;type:SMALLINT;default:3;NOT NULL"`                    // 用户的性别,值为1时是男性,值为2时是女性,其他值为未知
	City       string         `gorm:"column:city;type:VARCHAR(50);NOT NULL"`                          // 用户所在城市
	Country    string         `gorm:"column:country;type:VARCHAR(50);NOT NULL"`                       // 用户所在国家
	Province   string         `gorm:"column:province;type:VARCHAR(50);NOT NULL"`                      // 用户所在省份
	Language   string         `gorm:"column:language;type:VARCHAR(50);NOT NULL"`                      // 用户的语言,简体中文为zh_CN
	HeadImgUrl string         `gorm:"column:head_img_url;type:VARCHAR(256);NOT NULL"`                 // 用户头像
	Role       int64          `gorm:"column:role;type:BIGINT;NOT NULL"`                               // 用户角色
	IsAllData  int64          `gorm:"column:is_all_data;type:SMALLINT;default:2;NOT NULL"`            // 是否所有数据权限(1是,2否)
	stores.Time
}

用户登录信息表

func (*SysUserInfo) TableName

func (m *SysUserInfo) TableName() string

type UserInfoFilter

type UserInfoFilter struct {
	UserNames []string
	UserName  string
	Phone     string
	Email     string
	Accounts  []string //账号查询 非模糊查询
	Wechat    string
}

type UserInfoRepo

type UserInfoRepo struct {
	// contains filtered or unexported fields
}

func NewUserInfoRepo

func NewUserInfoRepo(in any) *UserInfoRepo

func (UserInfoRepo) CountByFilter

func (p UserInfoRepo) CountByFilter(ctx context.Context, f UserInfoFilter) (size int64, err error)

func (UserInfoRepo) Delete

func (p UserInfoRepo) Delete(ctx context.Context, userID int64) error

func (UserInfoRepo) DeleteByFilter

func (p UserInfoRepo) DeleteByFilter(ctx context.Context, f UserInfoFilter) error

func (UserInfoRepo) FindByFilter

func (p UserInfoRepo) FindByFilter(ctx context.Context, f UserInfoFilter, page *def.PageInfo) ([]*SysUserInfo, error)

func (UserInfoRepo) FindOne

func (p UserInfoRepo) FindOne(ctx context.Context, userID int64) (*SysUserInfo, error)

func (UserInfoRepo) FindOneByFilter

func (p UserInfoRepo) FindOneByFilter(ctx context.Context, f UserInfoFilter) (*SysUserInfo, error)

func (UserInfoRepo) Insert

func (p UserInfoRepo) Insert(ctx context.Context, data *SysUserInfo) error

func (UserInfoRepo) Update

func (p UserInfoRepo) Update(ctx context.Context, data *SysUserInfo) error

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL