gauss导入导出

liulin

2024-08-12 01f4e7f1ac47968bab5a5c4aec7595ecfc2d4df5

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