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/DatabaseSchemaTest.java | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/backend/src/test/java/com/rongyichuang/DatabaseSchemaTest.java b/backend/src/test/java/com/rongyichuang/DatabaseSchemaTest.java
index 74d8b40..39b5ef9 100644
--- a/backend/src/test/java/com/rongyichuang/DatabaseSchemaTest.java
+++ b/backend/src/test/java/com/rongyichuang/DatabaseSchemaTest.java
@@ -58,4 +58,20 @@
System.out.println(table);
}
}
+
+ @Test
+ public void testForeignKeyConstraints() {
+ try {
+ String sql = "SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME " +
+ "FROM information_schema.KEY_COLUMN_USAGE " +
+ "WHERE TABLE_SCHEMA = 'ryc' AND REFERENCED_TABLE_NAME IS NOT NULL";
+ List<Map<String, Object>> result = jdbcTemplate.queryForList(sql);
+ System.out.println("=== 澶栭敭绾︽潫 ===");
+ for (Map<String, Object> row : result) {
+ System.out.println(row);
+ }
+ } catch (Exception e) {
+ System.out.println("鏌ヨ澶栭敭绾︽潫澶辫触: " + e.getMessage());
+ }
+ }
}
\ No newline at end of file
--
Gitblit v1.8.0