From f217961040614ba7de36b41b5fd01f4a96d8d6fe Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 17 三月 2023 15:36:25 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 28 +++++++++++++++++++++-------
src/main/resources/application.yml | 2 +-
2 files changed, 22 insertions(+), 8 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index ff6fac5..35155b7 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -16,25 +16,39 @@
(423, '鍦伴潰灞�', 'fushun_site', 'tileset/o/39HBFG/tileset.json', 2, 3, 5, 0, 1, 'Tileset', '宸ョ▼娴嬮噺妯″瀷', 1200);
update lf.sys_layer set elev=118,cn_name='鍦伴潰灞�' where id=427;
-update bd.b_hy20w_d21 set ann = concat(gb, '_', name) where 1 = 1;
select concat(gb, '_', name) from bd.dlg_agnp limit 10;
select a.*, fn_uname(create_user) createName, fn_uname(update_user) updateName from lf.sys_dict a limit 10
-update lf.sys_dict set create_user=1,create_time=now()
-
select * from lf.sys_meta where 1=1 and type in ('ifc', 'fbx', 'rvt') order by id desc;
select * from lf.sys_meta where id in (1521) and type in ('ifc', 'fbx', 'rvt') order by id;
select * from bd.dlg_100w_hyda where eventid='f60b9ef6-9a00-4825-a3a4-130f5118cf2c' --dlg_100w_hyda.877
select * from lf.sys_meta where id in (1526,1527) and type in ('tif', 'tiff', 'img') order by id;
select b.ns, a.* from lf.sys_layer a left join lf.sys_dict b on a.en_name = b.tab where b.field = 'gid' order by id;
-select * from lf.sys_layer order by id;
-select * from bs.th_strategic_channel
select * from lf.sys_download where position('绠￠亾鍩虹澶ф暟鎹钩鍙�' in descr)>0 order by id desc;
select * from lf.sys_meta where 1=1 and type in ('mpt', '3dml')
-
-select * from lf.sys_menu;
select * from bs.u_sectionline;
+select * from lf.sys_meta_pub;
+select * from lf.sys_publish;
+
+delete from lf.sys_meta_pub;
+insert into lf.sys_meta_pub (metaid, pubid) values (1, 1);
+insert into lf.sys_meta_pub (metaid, pubid) select 1, 1 from (select 1) temp where not exists (select 1 from lf.sys_meta_pub where metaid = 1 and pubid = 1);
+
+insert into lf.sys_publish(name, url, path, type, status, dirid, depid, min, max, json, create_user, geom, bak) values (@name, @url, @path, @type, @status, @dirid, @depid, @min, @max, @json, @create_user, @geom, @bak);
+select * from lf.sys_dict where field='gid' --482
+
+select ns, tab, tab_desc, fn_get_entity(tab) entity, tableType, bak
+from lf.sys_dict a WHERE field = 'gid' and status = 0 order by id limit 500 offset 1
+
+select count(gid) from bd.b_rg20w_anna where 1=1
+select count(1) from bd.b_rg20w_anna where 1=1
+select * from bd.b_rg20w_anna where 1=1 limit 10;
+
+select fn_tab_count('bd', 'b_rg20w_anna', '1=1') "rows"
+
+
+
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index 352e52a..ee74c40 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -15,7 +15,7 @@
host: 127.0.0.1
port: 6369
password: rediS_5L#F4_Server
- timeout: 6000 # 杩炴帴瓒呮椂鏃堕暱锛堟绉掞級
+ timeout: 30000 # 杩炴帴瓒呮椂鏃堕暱锛堟绉掞級
pool:
max-active: 1000 # 杩炴帴姹犳渶澶ц繛鎺ユ暟锛堜娇鐢ㄨ礋鍊艰〃绀烘病鏈夐檺鍒讹級
max-wait: -1 # 杩炴帴姹犳渶澶ч樆濉炵瓑寰呮椂闂达紙浣跨敤璐熷�艰〃绀烘病鏈夐檺鍒讹級
--
Gitblit v1.9.3