From fbd5dd71092439ea2ca636cb0d6600da85b1c090 Mon Sep 17 00:00:00 2001 From: liulin <lin.liu@aliyun.com> Date: 星期二, 03 九月 2024 23:44:22 +0800 Subject: [PATCH] 移动jar包 --- src/test/java/com/lunhan/xxx/GaussExportTest.java | 2 +- src/test/java/com/lunhan/xxx/Mysql2Gauss.java | 2 +- sql/init.sql | 24 +++++++++++++----------- src/test/java/com/lunhan/xxx/BasicServiceApplicationTests.java | 2 +- src/test/java/com/lunhan/xxx/Gauss2Gauss.java | 2 +- src/test/java/com/lunhan/xxx/GenCodeGauss.java | 2 +- src/test/java/com/lunhan/xxx/SpringConfig.java | 2 +- src/test/java/com/lunhan/xxx/JenkinsTest.java | 2 +- src/test/java/com/lunhan/xxx/GenCodeMysql.java | 2 +- src/test/java/com/lunhan/xxx/StringUtilTest.java | 2 +- src/test/java/com/lunhan/xxx/MySqlExportTest.java | 2 +- src/test/java/com/lunhan/xxx/DateTimeTest.java | 2 +- src/test/java/com/lunhan/xxx/DemoTest.java | 11 +---------- 13 files changed, 25 insertions(+), 32 deletions(-) diff --git a/sql/init.sql b/sql/init.sql index 70b33fa..9150eac 100644 --- a/sql/init.sql +++ b/sql/init.sql @@ -1,3 +1,4 @@ +-- 函数 - 设置表的最后更新时间 CREATE OR REPLACE FUNCTION "public"."update_timestamp_column"() RETURNS "pg_catalog"."trigger" AS $BODY$ BEGIN @@ -6,7 +7,7 @@ END; $BODY$ LANGUAGE plpgsql VOLATILE - COST 100 + COST 100; -- test_info - 测试信息表 DROP TABLE IF EXISTS "public"."test_info"; @@ -26,8 +27,17 @@ "is_delete" int2 NOT NULL DEFAULT 0 ) ; +-- 设置主键 +ALTER TABLE "public"."test_info" ADD CONSTRAINT "PK_test_info_pkey" PRIMARY KEY ("id"); +-- 索引 +CREATE INDEX "IDX_test_info_create_time" ON "public"."test_info"("create_time"); +-- 触发器:自动赋值最后更新时间 +CREATE TRIGGER "TG_test_info" BEFORE INSERT OR UPDATE OF "update_time" ON "public"."test_info" +FOR EACH ROW +EXECUTE PROCEDURE "public"."update_timestamp_column"(); +-- 添加描述 COMMENT ON TABLE "public"."test_info" IS '测试信息表'; -COMMENT ON COLUMN "public"."test_info"."id" IS '主键id'; +COMMENT ON COLUMN "public"."test_info"."id" IS '主键'; COMMENT ON COLUMN "public"."test_info"."name" IS '名称'; COMMENT ON COLUMN "public"."test_info"."user_id" IS '用户id'; COMMENT ON COLUMN "public"."test_info"."phone" IS '电话'; @@ -35,16 +45,8 @@ COMMENT ON COLUMN "public"."test_info"."sex" IS '性别 男=1,女=2,其他=3'; COMMENT ON COLUMN "public"."test_info"."birthday" IS '生日'; COMMENT ON COLUMN "public"."test_info"."sort" IS '排序值'; -COMMENT ON COLUMN "public"."test_info"."status" IS '状态 正常=200,停用=300,删除=400'; +COMMENT ON COLUMN "public"."test_info"."status" IS '状态 EState'; COMMENT ON COLUMN "public"."test_info"."comment" IS '备注'; COMMENT ON COLUMN "public"."test_info"."create_time" IS '数据创建时间'; COMMENT ON COLUMN "public"."test_info"."update_time" IS '最后更新时间'; COMMENT ON COLUMN "public"."test_info"."is_delete" IS '是否删除(逻辑删除)'; --- 设置主键 -ALTER TABLE "public"."test_info" ADD CONSTRAINT "PK_test_info" PRIMARY KEY ("id"); --- 索引 -CREATE INDEX "IDX_test_info_create_time" ON "public"."test_info"("create_time"); --- 触发器:自动赋值最后更新时间 -CREATE TRIGGER "TG_test_info" BEFORE INSERT OR UPDATE OF "update_time" ON "public"."test_info" -FOR EACH ROW -EXECUTE PROCEDURE "public"."update_timestamp_column"(); diff --git a/src/test/java/com/lunhan/xxx/host/BasicServiceApplicationTests.java b/src/test/java/com/lunhan/xxx/BasicServiceApplicationTests.java similarity index 98% rename from src/test/java/com/lunhan/xxx/host/BasicServiceApplicationTests.java rename to src/test/java/com/lunhan/xxx/BasicServiceApplicationTests.java index 1512eb3..2227823 100644 --- a/src/test/java/com/lunhan/xxx/host/BasicServiceApplicationTests.java +++ b/src/test/java/com/lunhan/xxx/BasicServiceApplicationTests.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import com.baomidou.dynamic.datasource.toolkit.DynamicDataSourceContextHolder; import com.lunhan.xxx.po.UserPO; diff --git a/src/test/java/com/lunhan/xxx/host/DateTimeTest.java b/src/test/java/com/lunhan/xxx/DateTimeTest.java similarity index 93% rename from src/test/java/com/lunhan/xxx/host/DateTimeTest.java rename to src/test/java/com/lunhan/xxx/DateTimeTest.java index 319049b..aa33759 100644 --- a/src/test/java/com/lunhan/xxx/host/DateTimeTest.java +++ b/src/test/java/com/lunhan/xxx/DateTimeTest.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import com.lunhan.xxx.common.util.LocalDateTimeUtil; import org.junit.Test; diff --git a/src/test/java/com/lunhan/xxx/host/DemoTest.java b/src/test/java/com/lunhan/xxx/DemoTest.java similarity index 95% rename from src/test/java/com/lunhan/xxx/host/DemoTest.java rename to src/test/java/com/lunhan/xxx/DemoTest.java index e60621e..7e5aa87 100644 --- a/src/test/java/com/lunhan/xxx/host/DemoTest.java +++ b/src/test/java/com/lunhan/xxx/DemoTest.java @@ -1,19 +1,10 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; -import com.lunhan.xxx.common.config.SysConfig; -import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; -import java.io.BufferedReader; -import java.io.IOException; -import java.io.InputStream; -import java.io.InputStreamReader; import java.math.BigInteger; -import java.net.HttpURLConnection; -import java.net.MalformedURLException; -import java.net.URL; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; diff --git a/src/test/java/com/lunhan/xxx/host/Gauss2Gauss.java b/src/test/java/com/lunhan/xxx/Gauss2Gauss.java similarity index 99% rename from src/test/java/com/lunhan/xxx/host/Gauss2Gauss.java rename to src/test/java/com/lunhan/xxx/Gauss2Gauss.java index 3376194..74747ea 100644 --- a/src/test/java/com/lunhan/xxx/host/Gauss2Gauss.java +++ b/src/test/java/com/lunhan/xxx/Gauss2Gauss.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import com.lunhan.xxx.common.util.ListUtil; import com.lunhan.xxx.common.util.StringUtil; diff --git a/src/test/java/com/lunhan/xxx/host/GaussExportTest.java b/src/test/java/com/lunhan/xxx/GaussExportTest.java similarity index 96% rename from src/test/java/com/lunhan/xxx/host/GaussExportTest.java rename to src/test/java/com/lunhan/xxx/GaussExportTest.java index 150575d..6140221 100644 --- a/src/test/java/com/lunhan/xxx/host/GaussExportTest.java +++ b/src/test/java/com/lunhan/xxx/GaussExportTest.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import com.lunhan.xxx.common.util.StringUtil; diff --git a/src/test/java/com/lunhan/xxx/host/GenCodeGauss.java b/src/test/java/com/lunhan/xxx/GenCodeGauss.java similarity index 99% rename from src/test/java/com/lunhan/xxx/host/GenCodeGauss.java rename to src/test/java/com/lunhan/xxx/GenCodeGauss.java index 8b089c9..2b2b4f9 100644 --- a/src/test/java/com/lunhan/xxx/host/GenCodeGauss.java +++ b/src/test/java/com/lunhan/xxx/GenCodeGauss.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import com.lunhan.xxx.common.ConstantFactory; import com.lunhan.xxx.common.util.*; diff --git a/src/test/java/com/lunhan/xxx/host/GenCodeMysql.java b/src/test/java/com/lunhan/xxx/GenCodeMysql.java similarity index 99% rename from src/test/java/com/lunhan/xxx/host/GenCodeMysql.java rename to src/test/java/com/lunhan/xxx/GenCodeMysql.java index 1ba1923..2a0c725 100644 --- a/src/test/java/com/lunhan/xxx/host/GenCodeMysql.java +++ b/src/test/java/com/lunhan/xxx/GenCodeMysql.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import com.lunhan.xxx.common.ConstantFactory; import com.lunhan.xxx.common.util.*; diff --git a/src/test/java/com/lunhan/xxx/host/JenkinsTest.java b/src/test/java/com/lunhan/xxx/JenkinsTest.java similarity index 97% rename from src/test/java/com/lunhan/xxx/host/JenkinsTest.java rename to src/test/java/com/lunhan/xxx/JenkinsTest.java index 06fa34b..0461f64 100644 --- a/src/test/java/com/lunhan/xxx/host/JenkinsTest.java +++ b/src/test/java/com/lunhan/xxx/JenkinsTest.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import com.cdancy.jenkins.rest.JenkinsClient; import com.cdancy.jenkins.rest.domain.job.Job; diff --git a/src/test/java/com/lunhan/xxx/host/MySqlExportTest.java b/src/test/java/com/lunhan/xxx/MySqlExportTest.java similarity index 96% rename from src/test/java/com/lunhan/xxx/host/MySqlExportTest.java rename to src/test/java/com/lunhan/xxx/MySqlExportTest.java index c21a629..315487f 100644 --- a/src/test/java/com/lunhan/xxx/host/MySqlExportTest.java +++ b/src/test/java/com/lunhan/xxx/MySqlExportTest.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import com.lunhan.xxx.common.util.StringUtil; diff --git a/src/test/java/com/lunhan/xxx/host/Mysql2Gauss.java b/src/test/java/com/lunhan/xxx/Mysql2Gauss.java similarity index 99% rename from src/test/java/com/lunhan/xxx/host/Mysql2Gauss.java rename to src/test/java/com/lunhan/xxx/Mysql2Gauss.java index 24ea4cf..d480669 100644 --- a/src/test/java/com/lunhan/xxx/host/Mysql2Gauss.java +++ b/src/test/java/com/lunhan/xxx/Mysql2Gauss.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import com.lunhan.xxx.common.util.ListUtil; diff --git a/src/test/java/com/lunhan/xxx/host/SpringConfig.java b/src/test/java/com/lunhan/xxx/SpringConfig.java similarity index 84% rename from src/test/java/com/lunhan/xxx/host/SpringConfig.java rename to src/test/java/com/lunhan/xxx/SpringConfig.java index d553226..4a4d865 100644 --- a/src/test/java/com/lunhan/xxx/host/SpringConfig.java +++ b/src/test/java/com/lunhan/xxx/SpringConfig.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import org.springframework.context.annotation.ComponentScan; diff --git a/src/test/java/com/lunhan/xxx/host/StringUtilTest.java b/src/test/java/com/lunhan/xxx/StringUtilTest.java similarity index 94% rename from src/test/java/com/lunhan/xxx/host/StringUtilTest.java rename to src/test/java/com/lunhan/xxx/StringUtilTest.java index 4bfbb5a..b04dc64 100644 --- a/src/test/java/com/lunhan/xxx/host/StringUtilTest.java +++ b/src/test/java/com/lunhan/xxx/StringUtilTest.java @@ -1,4 +1,4 @@ -package com.lunhan.xxx.host; +package com.lunhan.xxx; import com.baomidou.mybatisplus.core.toolkit.StringUtils; import com.lunhan.xxx.repository.po.TestInfoPO; -- Gitblit v1.9.3