页面

12114

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
  `pageFile` varchar(255) DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `sort` varchar(255) DEFAULT NULL,
  `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 DEFAULT CHARSET = utf8mb4 COMMENT = '页面表; 软删除未启用;'

帮助

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	dynamicInMenu	helpV4	0	undefined

登陆

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
登陆	login	null	loginV4	null	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	login	passwordLogin	null	service	{"service": "user", "serviceFunction": "passwordLogin"}			231	update	2023-02-25T00:23:04+08:00

同步表管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
同步表管理	tableSyncConfig	showInMenu	null	1	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅数据库管理页-查询源数据库列表	tableSyncConfig	selectSourceDatabase	null	service	{"service": "tableSync", "serviceFunction": "selectSourceDatabase"}			468	update	2023-02-25T00:23:05+08:00
✅数据库管理页-查询源数据库中的table列表	tableSyncConfig	selectSourceTable	null	service	{"service": "tableSync", "serviceFunction": "selectSourceTable"}			469	update	2023-02-24T23:46:25+08:00
✅数据库管理页-删除同步表	tableSyncConfig	deleteTable	null	service	{"service": "tableSync", "serviceFunction": "deleteTableSyncConfig"}			470	update	2022-08-31T10:07:07+08:00
✅数据库管理页-查询同步表	tableSyncConfig	selectItemList	null	sql	{"table": "_table_sync_config", "operation": "select"}			471	update	2023-02-25T00:23:05+08:00
✅数据库管理页-手动同步表	tableSyncConfig	syncTable	null	service	{"service": "tableSync", "serviceFunction": "syncTable"}			472	update	2023-02-24T23:50:38+08:00
✅数据库管理页-创建同步表	tableSyncConfig	insertTable	null	sql	{"table": "_table_sync_config", "operation": "insert"}			474	update	2022-12-09T13:47:05+08:00
✅数据库管理页-更新同步表	tableSyncConfig	updateTable	null	sql	{"table": "_table_sync_config", "operation": "update"}			475	update	2022-09-10T14:19:10+08:00

合并表管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
合并表管理	tableMergeConfig	showInMenu	null	2	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅数据库管理页-查询源数据库列表	tableMergeConfig	selectSourceDatabase	null	service	{"service": "tableSync", "serviceFunction": "selectSourceDatabase"}			476	update	2023-02-25T00:23:05+08:00
✅数据库管理页-查询源数据库中的table列表	tableMergeConfig	selectSourceTable	null	service	{"service": "tableSync", "serviceFunction": "selectSourceTable"}			477	update	2023-02-24T23:46:25+08:00
✅数据库管理页-删除同步表	tableMergeConfig	deleteTable	null	service	{"service": "tableMergeAll", "serviceFunction": "deleteTableMergeAllConfig"}			478	update	2022-08-31T10:07:07+08:00
✅数据库管理页-查询同步表	tableMergeConfig	selectItemList	null	sql	{"table": "_table_merge_config", "operation": "select"}			479	update	2023-02-25T00:23:05+08:00
✅数据库管理页-手动同步表	tableMergeConfig	doTableMerge	null	service	{"service": "tableMerge", "serviceFunction": "doTableMerge"}			480	update	2023-02-24T23:50:38+08:00
✅数据库管理页-创建同步表	tableMergeConfig	insertTable	null	sql	{"table": "_table_merge_config", "operation": "insert"}			481	update	2022-12-09T13:47:05+08:00
✅数据库管理页-更新同步表	tableMergeConfig	updateTable	null	sql	{"table": "_table_merge_config", "operation": "update"}			482	update	2022-09-10T14:19:10+08:00

同步日志

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
同步日志	tableSyncLog	showInMenu	null	3	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅获取同步日志	tableSyncLog	selectItemList	null	sql	{"table": "_table_sync_log", "operation": "select"}			473	update	2023-02-25T00:22:59+08:00

MYSQL触发器

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
MYSQL触发器	mysqlTrigger	showInMenu	null	4	undefined

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅mysql触发器-查询列表	mysqlTrigger	selectItemList	null	sql	{"table": "information_schema.triggers", "operation": "select"}			483	update	2023-02-25T00:23:05+08:00

_page语句

INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', 'helpV4', 'dynamicInMenu', '0', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', 'loginV4', NULL, NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'tableSyncConfig', '同步表管理', NULL, 'showInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'tableMergeConfig', '合并表管理', NULL, 'showInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'tableSyncLog', '同步日志', NULL, 'showInMenu', '3', 'update', 'vscode', 'vscode', '2022-06-06T23:46:28+08:00');
INSERT INTO _page (id, pageId, pageName, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'mysqlTrigger', 'MYSQL触发器', NULL, 'showInMenu', '4', 'update', 'vscode', 'vscode', '2022-06-06T23:46:28+08:00');