clear_eds_data_case9.sql 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146
  1. -- ============================================================================
  2. -- 清空「数据测试」案件(case_info.id = 9)的电子数据业务数据
  3. -- 目标库:案件 DuckDB
  4. -- E:\workspace\zsjz-ai\QingJian\workspace\9\ylzkBGZJ9
  5. -- 执行时机:停止后端 / 退出案件后执行(DuckDB 单文件单写锁)
  6. -- 保留固定数据:eds_tree(旧名 eds_dir_tree,目录树,71 行)、eds_dict(字典,2873 行)
  7. -- 清空:EDS 附属业务表 + 全部 wa_mforensics_* 检材数据表
  8. -- ============================================================================
  9. BEGIN TRANSACTION;
  10. -- ---------------------------- 附属业务表 ----------------------------
  11. -- 检材登记(治理树 EDS 节点由本表动态生成)
  12. DELETE FROM eds_material;
  13. -- 数据包上传 / 解析进度
  14. DELETE FROM eds_material_process;
  15. -- 媒体文件索引(磁盘上的媒体文件不在此脚本删除范围内)
  16. DELETE FROM eds_media_file;
  17. -- 目录树节点数据量统计
  18. DELETE FROM eds_tree_count;
  19. -- ------------------------ 检材数据表(108 张) ------------------------
  20. DELETE FROM wa_mforensics_010100;
  21. DELETE FROM wa_mforensics_010200;
  22. DELETE FROM wa_mforensics_010201;
  23. DELETE FROM wa_mforensics_010202;
  24. DELETE FROM wa_mforensics_010300;
  25. DELETE FROM wa_mforensics_010400;
  26. DELETE FROM wa_mforensics_010500;
  27. DELETE FROM wa_mforensics_010600;
  28. DELETE FROM wa_mforensics_010700;
  29. DELETE FROM wa_mforensics_010800;
  30. DELETE FROM wa_mforensics_010900;
  31. DELETE FROM wa_mforensics_011000;
  32. DELETE FROM wa_mforensics_011100;
  33. DELETE FROM wa_mforensics_011200;
  34. DELETE FROM wa_mforensics_020100;
  35. DELETE FROM wa_mforensics_020200;
  36. DELETE FROM wa_mforensics_020300;
  37. DELETE FROM wa_mforensics_020400;
  38. DELETE FROM wa_mforensics_020500;
  39. DELETE FROM wa_mforensics_020600;
  40. DELETE FROM wa_mforensics_020700;
  41. DELETE FROM wa_mforensics_020800;
  42. DELETE FROM wa_mforensics_030100;
  43. DELETE FROM wa_mforensics_030200;
  44. DELETE FROM wa_mforensics_030300;
  45. DELETE FROM wa_mforensics_030400;
  46. DELETE FROM wa_mforensics_030500;
  47. DELETE FROM wa_mforensics_040100;
  48. DELETE FROM wa_mforensics_040200;
  49. DELETE FROM wa_mforensics_040300;
  50. DELETE FROM wa_mforensics_040400;
  51. DELETE FROM wa_mforensics_040500;
  52. DELETE FROM wa_mforensics_050100;
  53. DELETE FROM wa_mforensics_050200;
  54. DELETE FROM wa_mforensics_050300;
  55. DELETE FROM wa_mforensics_050400;
  56. DELETE FROM wa_mforensics_050500;
  57. DELETE FROM wa_mforensics_050600;
  58. DELETE FROM wa_mforensics_050700;
  59. DELETE FROM wa_mforensics_060100;
  60. DELETE FROM wa_mforensics_060200;
  61. DELETE FROM wa_mforensics_060300;
  62. DELETE FROM wa_mforensics_060400;
  63. DELETE FROM wa_mforensics_060500;
  64. DELETE FROM wa_mforensics_060600;
  65. DELETE FROM wa_mforensics_060700;
  66. DELETE FROM wa_mforensics_060800;
  67. DELETE FROM wa_mforensics_070100;
  68. DELETE FROM wa_mforensics_070200;
  69. DELETE FROM wa_mforensics_070300;
  70. DELETE FROM wa_mforensics_070400;
  71. DELETE FROM wa_mforensics_070500;
  72. DELETE FROM wa_mforensics_070600;
  73. DELETE FROM wa_mforensics_070700;
  74. DELETE FROM wa_mforensics_070800;
  75. DELETE FROM wa_mforensics_080100;
  76. DELETE FROM wa_mforensics_080200;
  77. DELETE FROM wa_mforensics_080300;
  78. DELETE FROM wa_mforensics_080400;
  79. DELETE FROM wa_mforensics_080500;
  80. DELETE FROM wa_mforensics_080600;
  81. DELETE FROM wa_mforensics_080700;
  82. DELETE FROM wa_mforensics_090100;
  83. DELETE FROM wa_mforensics_090200;
  84. DELETE FROM wa_mforensics_090300;
  85. DELETE FROM wa_mforensics_090400;
  86. DELETE FROM wa_mforensics_090500;
  87. DELETE FROM wa_mforensics_090600;
  88. DELETE FROM wa_mforensics_110100;
  89. DELETE FROM wa_mforensics_110200;
  90. DELETE FROM wa_mforensics_110300;
  91. DELETE FROM wa_mforensics_110400;
  92. DELETE FROM wa_mforensics_120100;
  93. DELETE FROM wa_mforensics_120200;
  94. DELETE FROM wa_mforensics_130100;
  95. DELETE FROM wa_mforensics_130200;
  96. DELETE FROM wa_mforensics_140100;
  97. DELETE FROM wa_mforensics_140200;
  98. DELETE FROM wa_mforensics_140300;
  99. DELETE FROM wa_mforensics_140400;
  100. DELETE FROM wa_mforensics_150100;
  101. DELETE FROM wa_mforensics_160100;
  102. DELETE FROM wa_mforensics_160200;
  103. DELETE FROM wa_mforensics_160300;
  104. DELETE FROM wa_mforensics_160400;
  105. DELETE FROM wa_mforensics_160500;
  106. DELETE FROM wa_mforensics_170100;
  107. DELETE FROM wa_mforensics_170200;
  108. DELETE FROM wa_mforensics_170300;
  109. DELETE FROM wa_mforensics_170400;
  110. DELETE FROM wa_mforensics_170500;
  111. DELETE FROM wa_mforensics_170600;
  112. DELETE FROM wa_mforensics_170700;
  113. DELETE FROM wa_mforensics_170800;
  114. DELETE FROM wa_mforensics_170900;
  115. DELETE FROM wa_mforensics_171000;
  116. DELETE FROM wa_mforensics_171100;
  117. DELETE FROM wa_mforensics_171200;
  118. DELETE FROM wa_mforensics_171300;
  119. DELETE FROM wa_mforensics_180100;
  120. DELETE FROM wa_mforensics_180200;
  121. DELETE FROM wa_mforensics_180300;
  122. DELETE FROM wa_mforensics_180400;
  123. DELETE FROM wa_mforensics_ext_616;
  124. DELETE FROM wa_mforensics_ext_621;
  125. DELETE FROM wa_mforensics_ext_625;
  126. DELETE FROM wa_mforensics_ext_625_1;
  127. DELETE FROM wa_mforensics_ext_627;
  128. -- 可选:同步清理「导入文件列表」中的电子数据包记录(本案件当前无此类记录)
  129. -- DELETE FROM file_info WHERE fileType = 'eds';
  130. COMMIT;
  131. -- 把删除结果刷入主库文件,便于随后直接备份 / 拷贝
  132. CHECKPOINT;
  133. -- 校验:eds_tree=71、eds_dict=2873,其余 4 张附属业务表应为 0
  134. SELECT 'eds_tree' AS table_name, count(*) AS row_count FROM eds_tree
  135. UNION ALL SELECT 'eds_dict', count(*) FROM eds_dict
  136. UNION ALL SELECT 'eds_material', count(*) FROM eds_material
  137. UNION ALL SELECT 'eds_material_process', count(*) FROM eds_material_process
  138. UNION ALL SELECT 'eds_media_file', count(*) FROM eds_media_file
  139. UNION ALL SELECT 'eds_tree_count', count(*) FROM eds_tree_count;