-- ----------------------------
|
-- 满意度模块开关(sys_config 参数配置表)
|
-- ----------------------------
|
-- 键名:satisfaction.enabled
|
-- 键值:true = 启用(默认,等价于不配置这一行)
|
-- false = 关闭
|
--
|
-- 关闭后的行为:
|
-- 1) 本模块 17 个满意度端点会被 SatisfactionAvailabilityInterceptor 拦下,
|
-- 返回明确业务错误「满意度功能未启用(参数配置 satisfaction.enabled=false),该接口不可用」,
|
-- 而不是 404;
|
-- 2) 随访导出 / 随访统计 / 登录链路通过 SatisfactionFacade 取数时降级为空值/全零,不受影响;
|
-- 3) 改完立即生效,最多 10 秒(进程内开关缓存 TTL),不需要重启。
|
--
|
-- 注意:本项目用的 MySQL 版本可能不支持 ADD COLUMN IF NOT EXISTS,
|
-- 因此这里用 information_schema 判断后再动态执行,脚本可重复执行。
|
-- ----------------------------
|
|
SET @satisfaction_config_exists = (
|
SELECT COUNT(1) FROM information_schema.COLUMNS
|
WHERE TABLE_SCHEMA = DATABASE()
|
AND TABLE_NAME = 'sys_config'
|
AND COLUMN_NAME = 'config_key'
|
);
|
|
SET @ddl = IF(@satisfaction_config_exists = 0,
|
'SELECT ''sys_config 表不存在,请先执行建表脚本'' AS warning',
|
'INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, remark)
|
SELECT ''满意度模块开关'', ''satisfaction.enabled'', ''true'', ''Y'', ''admin'', SYSDATE(),
|
''满意度模块总开关(运行时读取,改完最多10秒生效):true启用,false关闭;默认true''
|
FROM DUAL
|
WHERE NOT EXISTS (SELECT 1 FROM sys_config WHERE config_key = ''satisfaction.enabled'')');
|
|
PREPARE satisfaction_stmt FROM @ddl;
|
EXECUTE satisfaction_stmt;
|
DEALLOCATE PREPARE satisfaction_stmt;
|
|
-- 查询当前值
|
-- SELECT config_id, config_name, config_key, config_value, remark FROM sys_config WHERE config_key = 'satisfaction.enabled';
|