From de5c10c0c692dc3cad552821ca78f7ddb4074491 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 28 二月 2023 16:41:56 +0800
Subject: [PATCH] 1
---
data/update.sql | 23 ++++++++++++++++++++++-
1 files changed, 22 insertions(+), 1 deletions(-)
diff --git a/data/update.sql b/data/update.sql
index cb81795..d2cce58 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -205,6 +205,10 @@
order by c.id limit 1;
select * from lf.sys_role;
+--------------------------------------------------------- 09 lf.sys_dict 1810琛�
+select * from lf.sys_dict where field in ('geom', 'gid', 'eventid', 'parentid');
+
+update lf.sys_dict set showtype = 0 where field in ('geom', 'gid', 'eventid', 'parentid');
--------------------------------------------------------- 09 娴嬭瘯SQL
with rs as (select code from lf.sys_dir where name='瑗挎皵涓滆緭鍥涚嚎澶╃劧姘旂閬撳伐绋嬶紙鍚愰瞾鐣�-涓崼锛夛紙00116DT02锛�')
select fn_rec_query(a.dirid,'dir'),a.* from lf.sys_meta a where dirid = ANY(fn_rec_array((select id from rs), 'dir'));
@@ -286,6 +290,22 @@
from bs.m_pipeline a
group by medium;
-- select * from lf.sys_domain where dom_name='dsg0016';
+
+-- 鎵�鏈夐」鐩殑涓嬭浇涓暟銆佷笅杞芥鏁板拰鏁版嵁鎬婚噺
+with rs as (
+ select a.dircode, c.dcount, c.sizes
+ from lf.sys_meta a
+ inner join lf.sys_meta_down b on a.id = b.metaid
+ inner join lf.sys_download c on b.downid = c.id
+)
+select
+ d.name "椤圭洰鍚嶇О",
+ (select count(*) from rs where rs.dircode like d.code || '%') "涓嬭浇涓暟",
+ (select coalesce(sum(rs.dcount), 0) from rs where rs.dircode like d.code || '%') "涓嬭浇鏁伴噺",
+ (select round(coalesce(sum(rs.dcount * rs.sizes), 0)::numeric, 3) from rs where rs.dircode like d.code || '%') "鏁伴噺鎬婚噺(MB)"
+from lf.sys_dir d
+where pid = 0
+order by d.code;
---------------------------------------------------------
select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value"
from lf.sys_dir a
@@ -305,7 +325,8 @@
select * from lf.sys_user order by id desc
select * from lf.sys_dep where id=36
-
+select * from lf.sys_dict where tab='bs_project'
+select * from bs.bs_project
--
Gitblit v1.9.3