txl
/
ylrz_saas_his_scrm


			
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
							# -*- coding: utf-8 -*-
from pathlib import Path

BASE = Path(__file__).resolve().parent

ADMIN_SYS_MENU_JOB = (
    "-- =====================================================\n"
    "-- adminUI \u603b\u540e\u53f0 sys_menu\uff1a\u5b9a\u65f6\u4efb\u52a1\u83dc\u5355\uff08\u5f52\u5c5e\u300c\u7cfb\u7edf\u914d\u7f6e\u300d\u5206\u7ec4\uff09\n"
    "-- \u524d\u63d0\uff1a\u5df2\u6267\u884c admin_menu_init.sql\uff08\u7cfb\u7edf\u914d\u7f6e menu_id=2600\uff09\n"
    "-- \u53ef\u91cd\u590d\u6267\u884c\uff1b\u56fa\u5b9a menu_id \u533a\u95f4 2613-2620\n"
    "-- =====================================================\n\n"
    "-- 1. \u5b9a\u65f6\u4efb\u52a1\uff08\u9875\u9762\uff09\n"
    "INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, icon, visible, status, is_frame, is_cache, perms, create_by, create_time, remark)\n"
    "SELECT 2613, '\u5b9a\u65f6\u4efb\u52a1', m.menu_id, 13, 'job', 'monitor/job/index', 'C', 'job', '0', '0', 0, 0, 'monitor:job:list', 'admin', NOW(), 'Quartz \u8c03\u5ea6\u4efb\u52a1\u7ba1\u7406'\n"
    "FROM sys_menu m\n"
    "WHERE (m.menu_id = 2600 OR (m.menu_name = '\u7cfb\u7edf\u914d\u7f6e' AND m.parent_id = 2000))\n"
    "  AND NOT EXISTS (SELECT 1 FROM sys_menu x WHERE x.menu_id = 2613);\n\n"
    "-- 2. \u8c03\u5ea6\u65e5\u5fd7\uff08\u9875\u9762\uff09\n"
    "INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, icon, visible, status, is_frame, is_cache, perms, create_by, create_time, remark)\n"
    "SELECT 2614, '\u8c03\u5ea6\u65e5\u5fd7', m.menu_id, 14, 'jobLog', 'monitor/job/log', 'C', 'log', '0', '0', 0, 0, 'monitor:job:list', 'admin', NOW(), 'Quartz \u8c03\u5ea6\u65e5\u5fd7'\n"
    "FROM sys_menu m\n"
    "WHERE (m.menu_id = 2600 OR (m.menu_name = '\u7cfb\u7edf\u914d\u7f6e' AND m.parent_id = 2000))\n"
    "  AND NOT EXISTS (SELECT 1 FROM sys_menu x WHERE x.menu_id = 2614);\n\n"
    "-- 3. \u6309\u94ae\u6743\u9650\uff08\u6302\u5728\u5b9a\u65f6\u4efb\u52a1\u9875\u9762\u4e0b\uff09\n"
    "INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, is_frame, is_cache, perms, create_by, create_time)\n"
    "SELECT 2615, '\u4efb\u52a1\u67e5\u8be2', 2613, 1, '#', '', 'F', '0', '0', 0, 0, 'monitor:job:query', 'admin', NOW()\n"
    "FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE menu_id = 2615);\n\n"
    "INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, is_frame, is_cache, perms, create_by, create_time)\n"
    "SELECT 2616, '\u4efb\u52a1\u65b0\u589e', 2613, 2, '#', '', 'F', '0', '0', 0, 0, 'monitor:job:add', 'admin', NOW()\n"
    "FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE menu_id = 2616);\n\n"
    "INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, is_frame, is_cache, perms, create_by, create_time)\n"
    "SELECT 2617, '\u4efb\u52a1\u4fee\u6539', 2613, 3, '#', '', 'F', '0', '0', 0, 0, 'monitor:job:edit', 'admin', NOW()\n"
    "FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE menu_id = 2617);\n\n"
    "INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, is_frame, is_cache, perms, create_by, create_time)\n"
    "SELECT 2618, '\u4efb\u52a1\u5220\u9664', 2613, 4, '#', '', 'F', '0', '0', 0, 0, 'monitor:job:remove', 'admin', NOW()\n"
    "FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE menu_id = 2618);\n\n"
    "INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, is_frame, is_cache, perms, create_by, create_time)\n"
    "SELECT 2619, '\u72b6\u6001\u4fee\u6539', 2613, 5, '#', '', 'F', '0', '0', 0, 0, 'monitor:job:changeStatus', 'admin', NOW()\n"
    "FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE menu_id = 2619);\n\n"
    "INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, is_frame, is_cache, perms, create_by, create_time)\n"
    "SELECT 2620, '\u4efb\u52a1\u5bfc\u51fa', 2613, 6, '#', '', 'F', '0', '0', 0, 0, 'monitor:job:export', 'admin', NOW()\n"
    "FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE menu_id = 2620);\n\n"
    "-- 4. \u4e3a\u8d85\u7ea7\u7ba1\u7406\u5458\u89d2\u8272\uff08role_id=1\uff09\u6388\u6743\uff1b\u82e5\u89d2\u8272 ID \u4e0d\u540c\u8bf7\u81ea\u884c\u8c03\u6574\n"
    "INSERT INTO sys_role_menu (role_id, menu_id)\n"
    "SELECT 1, m.menu_id\n"
    "FROM sys_menu m\n"
    "WHERE m.menu_id BETWEEN 2613 AND 2620\n"
    "  AND NOT EXISTS (\n"
    "    SELECT 1 FROM sys_role_menu rm WHERE rm.role_id = 1 AND rm.menu_id = m.menu_id\n"
    "  );\n"
)

FS_TASK_SYS_JOB_SEED = (
    "-- fs-task \u8fc1\u79fb\u540e sys_job \u793a\u4f8b\u6570\u636e\uff08status=0 \u542f\u7528\uff0cstatus=1 \u6682\u505c\uff09\n"
    "-- invoke_target \u987b\u4e0e fs-task / fs-service \u4e2d Spring Bean \u65b9\u6cd5\u4e00\u81f4\n\n"
    "INSERT INTO sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, remark)\n"
    "SELECT '\u79df\u6237\u6a21\u5757\u4f7f\u7528\u7edf\u8ba1', 'DEFAULT', 'lobsterBridgeDataSyncService.executeModuleUsageStatistics()', '0 0 2 * * ?', '3', '1', '1', 'admin', NOW(), '\u539f LobsterBridge @Scheduled\uff0c\u6bcf\u65e5\u51cc\u66682\u70b9'\n"
    "WHERE NOT EXISTS (SELECT 1 FROM sys_job WHERE invoke_target = 'lobsterBridgeDataSyncService.executeModuleUsageStatistics()');\n\n"
    "INSERT INTO sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, remark)\n"
    "SELECT '\u9f99\u867e\u6865\u63a5\u6570\u636e\u540c\u6b65', 'DEFAULT', 'lobsterBridgeDataSyncService.syncLobsterBridgeData()', '0 0/10 * * * ?', '3', '1', '1', 'admin', NOW(), '\u539f fixedDelay 10\u5206\u949f\uff0c\u7528 cron \u8fd1\u4f3c'\n"
    "WHERE NOT EXISTS (SELECT 1 FROM sys_job WHERE invoke_target = 'lobsterBridgeDataSyncService.syncLobsterBridgeData()');\n\n"
    "INSERT INTO sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, remark)\n"
    "SELECT '\u5e73\u53f0\u7edf\u8ba1-\u6bcf\u5c0f\u65f6', 'DEFAULT', 'platformStatisticsServiceImpl.executeHourlyStats()', '0 0 * * * ?', '3', '1', '1', 'admin', NOW(), '\u539f fs-service @Scheduled'\n"
    "WHERE NOT EXISTS (SELECT 1 FROM sys_job WHERE invoke_target = 'platformStatisticsServiceImpl.executeHourlyStats()');\n\n"
    "INSERT INTO sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, remark)\n"
    "SELECT '\u5e73\u53f0\u7edf\u8ba1-\u6bcf\u65e5', 'DEFAULT', 'platformStatisticsServiceImpl.executeDailySummary()', '0 0 1 * * ?', '3', '1', '1', 'admin', NOW(), '\u539f fs-service @Scheduled'\n"
    "WHERE NOT EXISTS (SELECT 1 FROM sys_job WHERE invoke_target = 'platformStatisticsServiceImpl.executeDailySummary()');\n\n"
    "INSERT INTO sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, remark)\n"
    "SELECT '\u805a\u6c34\u6f6dToken\u5237\u65b0', 'DEFAULT', 'jstTokenService.scheduleTokenRefresh()', '0 0 3 */28 * ?', '3', '1', '1', 'admin', NOW(), '\u539f fs-service @Scheduled'\n"
    "WHERE NOT EXISTS (SELECT 1 FROM sys_job WHERE invoke_target = 'jstTokenService.scheduleTokenRefresh()');\n"
)


def write(name, content):
    path = BASE / name
    path.write_text(content, encoding="utf-8")
    print("OK", path.name)


if __name__ == "__main__":
    write("admin_sys_menu_job.sql", ADMIN_SYS_MENU_JOB)
    write("fs_task_sys_job_seed.sql", FS_TASK_SYS_JOB_SEED)