From bc1cff79a3da9fd14866e89e09fb48fb8bc4b9ff Mon Sep 17 00:00:00 2001
From: wuww <252740454@qq.com>
Date: 星期二, 15 四月 2025 15:44:10 +0800
Subject: [PATCH] 添加初始化sql
---
.gitignore | 1
src/main/java/com/se/nsl/service/TestService.java | 2 +
data/init.sql | 83 +++++++++++++++++++++++++++++++++++++++++
src/main/java/com/se/nsl/domain/dto/LayerDto.java | 20 ++++++++++
4 files changed, 105 insertions(+), 1 deletions(-)
diff --git a/.gitignore b/.gitignore
index 9ecb131..35c966a 100644
--- a/.gitignore
+++ b/.gitignore
@@ -31,6 +31,5 @@
### VS Code ###
.vscode/
-/data
/logs
/Test.txt
diff --git a/data/init.sql b/data/init.sql
new file mode 100644
index 0000000..1022e0c
--- /dev/null
+++ b/data/init.sql
@@ -0,0 +1,83 @@
+---------------------------------------------- 0.鍒濆鍖�
+create extension if not exists postgis cascade;
+
+create extension if not exists "uuid-ossp";
+
+create schema if not exists nsl;
+---------------------------------------------- 1.鎺ㄦ紨妯℃嫙
+-- drop table if exists nsl.simu;
+create table nsl.simu (
+ id serial primary key,
+ name varchar(200),
+ service_name varchar(200),
+ type smallint default 1,
+ area_type smallint default 0,
+ data varchar(8000),
+ status smallint default 0,
+ result varchar(8000),
+ create_time timestamp(6) without time zone default now(),
+ create_user varchar(50),
+ update_time timestamp(6) without time zone,
+ update_user varchar(50),
+ bak varchar(2000),
+ geom geometry(MultiPolygon, 4490)
+);
+-- drop index nsl.idx_nsl_simu_geom;
+create index idx_nsl_simu_geom on nsl.simu using GIST (geom);
+
+comment on table nsl.simu is '鎺ㄦ紨妯℃嫙琛�';
+comment on column nsl.simu.id is '涓婚敭ID';
+comment on column nsl.simu.name is '鍚嶇О';
+comment on column nsl.simu.service_name is '鏈嶅姟鍚嶇О';
+comment on column nsl.simu.type is '绫诲埆锛�1-棰勬祴妯℃嫙锛�2-瀹炴椂妯℃嫙锛�3-鍘嗗彶妯℃嫙';
+comment on column nsl.simu.area_type is '鍖哄煙绫诲埆锛�0-鑷畾涔夛紝1-琛屾斂鍖哄垝锛�2-閲嶇偣鍖哄煙锛�3-閲嶇偣娌�';
+comment on column nsl.simu.data is '鏁版嵁';
+comment on column nsl.simu.status is '鐘舵�侊細0-鍒涘缓浠跨湡锛�1-棰勫鐞嗭紝2-鍒嗘瀽涓紝10-瀹屾垚锛�20-鍑洪敊';
+comment on column nsl.simu.result is '缁撴灉';
+comment on column nsl.simu.create_time is '鍒涘缓鏃堕棿';
+comment on column nsl.simu.create_user is '鍒涘缓浜�';
+comment on column nsl.simu.update_time is '鏇存柊鏃堕棿';
+comment on column nsl.simu.update_user is '鏇存柊浜�';
+comment on column nsl.simu.bak is '澶囨敞';
+comment on column nsl.simu.geom is '绌洪棿浣嶇疆';
+
+select * from nsl.simu;
+---------------------------------------------- 2.鎺ㄦ紨鍖哄煙
+-- drop table if exists nsl.region;
+create table nsl.region (
+ id serial primary key,
+ name varchar(200),
+ type smallint default 1,
+ geom geometry(MultiPolygon, 4490)
+);
+-- drop index nsl.idx_nsl_region_geom;
+create index idx_nsl_region_geom on nsl.region using GIST (geom);
+
+comment on table nsl.region is '鎺ㄦ紨鍖哄煙琛�';
+comment on column nsl.region.id is '涓婚敭ID';
+comment on column nsl.region.name is '鍚嶇О';
+comment on column nsl.region.type is '绫诲埆锛�1-琛屾斂鍖哄垝锛�2-閲嶇偣鍖哄煙锛�3-閲嶇偣娌�';
+comment on column nsl.region.geom is '绌洪棿浣嶇疆';
+
+select * from nsl.region;
+---------------------------------------------- 3.闆ㄩ噺璁� *
+-- drop table if exists nsl.udometer;
+create table nsl.udometer (
+ id serial primary key,
+ name varchar(200),
+ rainfall numeric(15, 3) default 0.0, -- 鎬讳綅鏁�/灏忔暟浣嶆暟
+ geom geometry(Point, 4490)
+);
+-- drop index nsl.idx_nsl_udometer_geom;
+create index idx_nsl_udometer_geom on nsl.udometer using GIST (geom);
+
+comment on table nsl.udometer is '闆ㄩ噺璁¤〃';
+comment on column nsl.udometer.id is '涓婚敭ID';
+comment on column nsl.udometer.name is '鍚嶇О';
+comment on column nsl.udometer.rainfall is '闄嶉洦閲�(绫�)';
+comment on column nsl.udometer.geom is '绌洪棿浣嶇疆';
+
+select * from nsl.udometer;
+----------------------------------------------
+
+
diff --git a/src/main/java/com/se/nsl/domain/dto/LayerDto.java b/src/main/java/com/se/nsl/domain/dto/LayerDto.java
index 95dc087..ac0d4b1 100644
--- a/src/main/java/com/se/nsl/domain/dto/LayerDto.java
+++ b/src/main/java/com/se/nsl/domain/dto/LayerDto.java
@@ -14,6 +14,10 @@
private WaterDto waters;
+ private String waterUrl;
+
+ private String flowUrl;
+
public LayerDto() {
}
@@ -64,4 +68,20 @@
public void setWaters(WaterDto waters) {
this.waters = waters;
}
+
+ public String getWaterUrl() {
+ return waterUrl;
+ }
+
+ public void setWaterUrl(String waterUrl) {
+ this.waterUrl = waterUrl;
+ }
+
+ public String getFlowUrl() {
+ return flowUrl;
+ }
+
+ public void setFlowUrl(String flowUrl) {
+ this.flowUrl = flowUrl;
+ }
}
diff --git a/src/main/java/com/se/nsl/service/TestService.java b/src/main/java/com/se/nsl/service/TestService.java
index c381cf7..2389cb6 100644
--- a/src/main/java/com/se/nsl/service/TestService.java
+++ b/src/main/java/com/se/nsl/service/TestService.java
@@ -561,6 +561,8 @@
layer.getWaters().setFiles(null);
layer.getTerrain().setEpsg(null);
layer.getExtension().setDiffer(null);
+ layer.setWaterUrl("/hls/w" + config.getOutPath() + ".m3u8");
+ layer.setFlowUrl("//hls/f" + config.getOutPath() + ".m3u8");
String json = JSON.toJSONString(layer);
// String json = JSONUtil.toJsonPrettyStr(layer);
--
Gitblit v1.9.3