From f04f35b562760afbac0c477357e2a29f77aec3b9 Mon Sep 17 00:00:00 2001
From: lrj <owen.stl@gmail.com>
Date: 星期四, 02 十月 2025 13:51:47 +0800
Subject: [PATCH] fix: 修复评审次数重复显示问题
---
backend/src/test/java/com/rongyichuang/CheckTableStructureTest.java | 42 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 42 insertions(+), 0 deletions(-)
diff --git a/backend/src/test/java/com/rongyichuang/CheckTableStructureTest.java b/backend/src/test/java/com/rongyichuang/CheckTableStructureTest.java
index db0a1ba..a16a4c2 100644
--- a/backend/src/test/java/com/rongyichuang/CheckTableStructureTest.java
+++ b/backend/src/test/java/com/rongyichuang/CheckTableStructureTest.java
@@ -37,4 +37,46 @@
System.out.println("鏄惁瀛樺湪rating_scheme_id瀛楁: " + hasRatingSchemeId);
}
+
+ @Test
+ public void checkRatingItemTable() {
+ System.out.println("=== 妫�鏌� t_rating_item 琛ㄧ粨鏋� ===");
+
+ try {
+ String sql = "DESCRIBE t_rating_item";
+ List<Map<String, Object>> columns = jdbcTemplate.queryForList(sql);
+
+ for (Map<String, Object> column : columns) {
+ System.out.println("瀛楁: " + column.get("Field") +
+ ", 绫诲瀷: " + column.get("Type") +
+ ", 鏄惁涓虹┖: " + column.get("Null") +
+ ", 閿�: " + column.get("Key") +
+ ", 榛樿鍊�: " + column.get("Default"));
+ }
+
+ System.out.println("\n=== 妫�鏌� t_rating_scheme 琛ㄧ粨鏋� ===");
+ sql = "DESCRIBE t_rating_scheme";
+ columns = jdbcTemplate.queryForList(sql);
+
+ for (Map<String, Object> column : columns) {
+ System.out.println("瀛楁: " + column.get("Field") +
+ ", 绫诲瀷: " + column.get("Type") +
+ ", 鏄惁涓虹┖: " + column.get("Null") +
+ ", 閿�: " + column.get("Key") +
+ ", 榛樿鍊�: " + column.get("Default"));
+ }
+
+ System.out.println("\n=== 妫�鏌ヨ瘎鍒嗛」鏁版嵁 ===");
+ sql = "SELECT * FROM t_rating_item LIMIT 5";
+ List<Map<String, Object>> items = jdbcTemplate.queryForList(sql);
+
+ for (Map<String, Object> item : items) {
+ System.out.println("璇勫垎椤�: " + item);
+ }
+
+ } catch (Exception e) {
+ System.out.println("妫�鏌ヨ〃缁撴瀯澶辫触: " + e.getMessage());
+ e.printStackTrace();
+ }
+ }
}
\ No newline at end of file
--
Gitblit v1.8.0