50 lines
2.5 KiB
SQL
50 lines
2.5 KiB
SQL
-- UniSOA 生产库(unis_oa_prod)流程监控测试数据清理
|
||
-- 对象:流程监控页面上的三张「关联带出校验」测试单
|
||
-- 关联带出校验 1110122804 目标 job 113f46b92835411ca21d8f71a4f3aaf8 serial 20261110000001 (running)
|
||
-- 关联带出校验 1110122634 源二 job 0b19cd7ffe2a4dceb4eef98b0703f966 serial 20261110000002 (completed)
|
||
-- 关联带出校验 1110122634 源一 job 2d647d6888704c2caa7b8f12b2d5fb87 serial 20261110000001 (completed)
|
||
-- 来源:backend/scripts/check_link_fill_submit.py 于 2026-11-10 12:26~12:28 连生产库跑校验,
|
||
-- 流程定义与表单已被脚本 _cleanup 删掉,单据侧成了孤儿数据。
|
||
-- 共 7 张表 11 行。执行前请先备份,建议在事务里跑。
|
||
|
||
-- oa_work: 1 行
|
||
DELETE FROM `oa_work` WHERE id IN (
|
||
'69393d4a906b479fa7fd022ee15aafa8');
|
||
|
||
-- oa_work_completed: 2 行
|
||
DELETE FROM `oa_work_completed` WHERE id IN (
|
||
'54a30545544749978bbc39ceff54b065',
|
||
'd318ae4c721b46459d8ab800ebedd62b');
|
||
|
||
-- oa_task: 1 行
|
||
DELETE FROM `oa_task` WHERE id IN (
|
||
'297fa080c2ed49018950f55ae71dfabd');
|
||
|
||
-- oa_work_log: 1 行
|
||
DELETE FROM `oa_work_log` WHERE id IN (
|
||
'cd79ddb0b35d4ba9ba264f715641d2f7');
|
||
|
||
-- oa_notification: 3 行
|
||
DELETE FROM `oa_notification` WHERE id IN (
|
||
'bd82f5ae1b51425f93ff89382945deee',
|
||
'80b4065823584ab2b71589897cb01028',
|
||
'f4781f34347442e7a5255122d2c44ca4');
|
||
|
||
-- oa_notify_delivery: 1 行
|
||
DELETE FROM `oa_notify_delivery` WHERE id IN (
|
||
'20261110122808967641ea049b087cdb');
|
||
|
||
-- oa_serial_number: 2 行
|
||
DELETE FROM `oa_serial_number` WHERE id IN (
|
||
'8650b0e0206745bda90ce716e1f8ef87',
|
||
'f52d9f23d2564f7088286e89caf315c2');
|
||
|
||
-- 校验:执行后以下查询应全部为 0
|
||
SELECT 'oa_work' t, COUNT(*) n FROM `oa_work` WHERE id IN ('69393d4a906b479fa7fd022ee15aafa8');
|
||
SELECT 'oa_work_completed' t, COUNT(*) n FROM `oa_work_completed` WHERE id IN ('54a30545544749978bbc39ceff54b065', 'd318ae4c721b46459d8ab800ebedd62b');
|
||
SELECT 'oa_task' t, COUNT(*) n FROM `oa_task` WHERE id IN ('297fa080c2ed49018950f55ae71dfabd');
|
||
SELECT 'oa_work_log' t, COUNT(*) n FROM `oa_work_log` WHERE id IN ('cd79ddb0b35d4ba9ba264f715641d2f7');
|
||
SELECT 'oa_notification' t, COUNT(*) n FROM `oa_notification` WHERE id IN ('bd82f5ae1b51425f93ff89382945deee', '80b4065823584ab2b71589897cb01028', 'f4781f34347442e7a5255122d2c44ca4');
|
||
SELECT 'oa_notify_delivery' t, COUNT(*) n FROM `oa_notify_delivery` WHERE id IN ('20261110122808967641ea049b087cdb');
|
||
SELECT 'oa_serial_number' t, COUNT(*) n FROM `oa_serial_number` WHERE id IN ('8650b0e0206745bda90ce716e1f8ef87', 'f52d9f23d2564f7088286e89caf315c2');
|