From 01f4e7f1ac47968bab5a5c4aec7595ecfc2d4df5 Mon Sep 17 00:00:00 2001 From: liulin <lin.liu@aliyun.com> Date: 星期一, 12 八月 2024 23:28:17 +0800 Subject: [PATCH] gauss导入导出 --- src/test/java/com/lunhan/xxx/host/GenCodeGauss.java | 11 ++++++++--- 1 files changed, 8 insertions(+), 3 deletions(-) diff --git a/src/test/java/com/lunhan/xxx/host/GenCodeGauss.java b/src/test/java/com/lunhan/xxx/host/GenCodeGauss.java index 89ff2a8..97cbbb3 100644 --- a/src/test/java/com/lunhan/xxx/host/GenCodeGauss.java +++ b/src/test/java/com/lunhan/xxx/host/GenCodeGauss.java @@ -1602,7 +1602,7 @@ Map<String, String> mapColumnDesc = new HashMap<>(); int idx = 0; - list.add("-- \"" + tableName + "\" - \"" + tableDesc + "\"\nDROP TABLE IF EXISTS \"public\".\"" + tableName + "\";\n"); + list.add("-- " + tableName + " - " + tableDesc + "\nDROP TABLE IF EXISTS \"public\".\"" + tableName + "\";\n"); // 遍历列,构建sql for (Map<String, Object> column : listColumn) { @@ -1619,8 +1619,10 @@ case "char": case "varchar": case "nvarchar": - String length = column.get("length").toString(); - sql += "(" + length + ")"; + if (Objects.nonNull(column.get("length"))) { + String length = column.get("length").toString(); + sql += "(" + length + ")"; + } if ("1".equals(isNullable)) { sql += " NULL DEFAULT NULL"; } else { @@ -1956,4 +1958,7 @@ } return listTable; } + public static List<String> export(Connection connect, String dbSchema) { + return GenCodeGauss.export(connect, dbSchema, Boolean.TRUE, Boolean.TRUE); + } } -- Gitblit v1.9.3