unis-oa/sql/cleanup/20261113_linkfill_checkdata...

50 lines
2.5 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

-- 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');