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"(); src/test/java/com/lunhan/xxx/BasicServiceApplicationTests.java
文件名从 src/test/java/com/lunhan/xxx/host/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; src/test/java/com/lunhan/xxx/DateTimeTest.java
文件名从 src/test/java/com/lunhan/xxx/host/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; src/test/java/com/lunhan/xxx/DemoTest.java
文件名从 src/test/java/com/lunhan/xxx/host/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;
文件名从 src/test/java/com/lunhan/xxx/host/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; src/test/java/com/lunhan/xxx/GaussExportTest.java
文件名从 src/test/java/com/lunhan/xxx/host/GaussExportTest.java 修改 @@ -1,4 +1,4 @@ package com.lunhan.xxx.host; package com.lunhan.xxx; import com.lunhan.xxx.common.util.StringUtil;
文件名从 src/test/java/com/lunhan/xxx/host/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.*; src/test/java/com/lunhan/xxx/GenCodeMysql.java
文件名从 src/test/java/com/lunhan/xxx/host/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.*; src/test/java/com/lunhan/xxx/JenkinsTest.java
文件名从 src/test/java/com/lunhan/xxx/host/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; src/test/java/com/lunhan/xxx/MySqlExportTest.java
文件名从 src/test/java/com/lunhan/xxx/host/MySqlExportTest.java 修改 @@ -1,4 +1,4 @@ package com.lunhan.xxx.host; package com.lunhan.xxx; import com.lunhan.xxx.common.util.StringUtil;
文件名从 src/test/java/com/lunhan/xxx/host/Mysql2Gauss.java 修改 @@ -1,4 +1,4 @@ package com.lunhan.xxx.host; package com.lunhan.xxx; import com.lunhan.xxx.common.util.ListUtil;
文件名从 src/test/java/com/lunhan/xxx/host/SpringConfig.java 修改 @@ -1,4 +1,4 @@ package com.lunhan.xxx.host; package com.lunhan.xxx; import org.springframework.context.annotation.ComponentScan;
文件名从 src/test/java/com/lunhan/xxx/host/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;
