You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by ca...@apache.org on 2022/05/18 03:33:13 UTC

[dolphinscheduler] branch dev updated: [Fix-10082]Resource userName is null and udf function manager add a username (#10064)

This is an automated email from the ASF dual-hosted git repository.

caishunfeng pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git


The following commit(s) were added to refs/heads/dev by this push:
     new 701b535ae6 [Fix-10082]Resource userName is null and udf function manager add a username (#10064)
701b535ae6 is described below

commit 701b535ae6a9fdd7c67797528fb9ff8f650db514
Author: hstdream <33...@users.noreply.github.com>
AuthorDate: Wed May 18 11:33:08 2022 +0800

    [Fix-10082]Resource userName is null and udf function manager add a username (#10064)
    
    * Resource userName is null
    
    * [Fix-10082]Resource userName is null and udf function manager add a username
    
    * [Fix-10082]Resource userName is null and udf function manager add a username
    
    * [Fix-10082]Resource userName is null and udf function manager add a username
    
    Co-authored-by: houshitao <sh...@163.com>
---
 .../apache/dolphinscheduler/dao/entity/Resource.java    | 17 +++++++++++++++++
 .../org/apache/dolphinscheduler/dao/entity/UdfFunc.java | 14 ++++++++++++++
 .../dolphinscheduler/dao/mapper/ResourceMapper.xml      |  5 +++--
 .../dolphinscheduler/dao/mapper/UdfFuncMapper.xml       |  5 +++--
 .../apache/dolphinscheduler/dao/entity/UdfFuncTest.java |  2 +-
 5 files changed, 38 insertions(+), 5 deletions(-)

diff --git a/dolphinscheduler-dao/src/main/java/org/apache/dolphinscheduler/dao/entity/Resource.java b/dolphinscheduler-dao/src/main/java/org/apache/dolphinscheduler/dao/entity/Resource.java
index 750fbb4e05..1cafe09291 100644
--- a/dolphinscheduler-dao/src/main/java/org/apache/dolphinscheduler/dao/entity/Resource.java
+++ b/dolphinscheduler-dao/src/main/java/org/apache/dolphinscheduler/dao/entity/Resource.java
@@ -17,6 +17,7 @@
 
 package org.apache.dolphinscheduler.dao.entity;
 
+import com.baomidou.mybatisplus.annotation.TableField;
 import org.apache.dolphinscheduler.spi.enums.ResourceType;
 
 import java.util.Date;
@@ -88,6 +89,13 @@ public class Resource {
      */
     private Date updateTime;
 
+    /**
+     * user name
+     */
+    @TableField(exist = false)
+    private String userName;
+
+
     public Resource() {
     }
 
@@ -224,6 +232,14 @@ public class Resource {
         this.updateTime = updateTime;
     }
 
+    public String getUserName() {
+        return userName;
+    }
+
+    public void setUserName(String userName) {
+        this.userName = userName;
+    }
+
     @Override
     public String toString() {
         return "Resource{" +
@@ -239,6 +255,7 @@ public class Resource {
             ", size=" + size +
             ", createTime=" + createTime +
             ", updateTime=" + updateTime +
+            ",userName=" + userName +
             '}';
     }
 
diff --git a/dolphinscheduler-dao/src/main/java/org/apache/dolphinscheduler/dao/entity/UdfFunc.java b/dolphinscheduler-dao/src/main/java/org/apache/dolphinscheduler/dao/entity/UdfFunc.java
index 949499d1e8..fb6e23b678 100644
--- a/dolphinscheduler-dao/src/main/java/org/apache/dolphinscheduler/dao/entity/UdfFunc.java
+++ b/dolphinscheduler-dao/src/main/java/org/apache/dolphinscheduler/dao/entity/UdfFunc.java
@@ -105,6 +105,12 @@ public class UdfFunc {
      */
     private Date updateTime;
 
+    /**
+     * user name
+     */
+    @TableField(exist = false)
+    private String userName;
+
     public int getId() {
         return id;
     }
@@ -202,6 +208,14 @@ public class UdfFunc {
         this.updateTime = updateTime;
     }
 
+    public String getUserName() {
+        return userName;
+    }
+
+    public void setUserName(String userName) {
+        this.userName = userName;
+    }
+
     @Override
     public boolean equals(Object o) {
         if (this == o) {
diff --git a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ResourceMapper.xml b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ResourceMapper.xml
index 79e5d4cdb8..95620abb72 100644
--- a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ResourceMapper.xml
+++ b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ResourceMapper.xml
@@ -58,8 +58,9 @@
         <include refid="baseSqlV2">
             <property name="alias" value="d"/>
         </include>
-        from t_ds_resources d
-        where d.type=#{type} and d.pid=#{id}
+        ,u.user_name
+        from t_ds_resources d,t_ds_user u
+        where d.type=#{type} and d.pid=#{id} and d.user_id=u.id
         <if test="userId != 0">
             and (
                     d.user_id=#{userId}
diff --git a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/UdfFuncMapper.xml b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/UdfFuncMapper.xml
index 25cdfdd642..1f9e09e4d0 100644
--- a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/UdfFuncMapper.xml
+++ b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/UdfFuncMapper.xml
@@ -56,8 +56,9 @@
         <include refid="baseSql">
             <property name="alias" value="udf"/>
         </include>
-        from t_ds_udfs udf
-        where 1=1
+        ,u.user_name
+        from t_ds_udfs udf,t_ds_user u
+        where 1=1 and udf.user_id=u.id
         <if test="searchVal!= null and searchVal != ''">
             and udf.func_name like concat('%', #{searchVal}, '%')
         </if>
diff --git a/dolphinscheduler-dao/src/test/java/org/apache/dolphinscheduler/dao/entity/UdfFuncTest.java b/dolphinscheduler-dao/src/test/java/org/apache/dolphinscheduler/dao/entity/UdfFuncTest.java
index 4231ba35f6..38479e9849 100644
--- a/dolphinscheduler-dao/src/test/java/org/apache/dolphinscheduler/dao/entity/UdfFuncTest.java
+++ b/dolphinscheduler-dao/src/test/java/org/apache/dolphinscheduler/dao/entity/UdfFuncTest.java
@@ -37,7 +37,7 @@ public class UdfFuncTest {
     udfFunc.setClassName("org.apache.dolphinscheduler.test.mrUpdate");
 
     Assert.assertEquals("{\"id\":0,\"userId\":0,\"resourceType\":\"UDF\",\"funcName\":null,\"className\":\"org.apache.dolphinscheduler.test.mrUpdate\",\"argTypes\":null,\"database\":null,"
-                    + "\"description\":null,\"resourceId\":2,\"resourceName\":\"dolphin_resource_update\",\"type\":null,\"createTime\":null,\"updateTime\":null}"
+                    + "\"description\":null,\"resourceId\":2,\"resourceName\":\"dolphin_resource_update\",\"type\":null,\"createTime\":null,\"updateTime\":null,\"userName\":null}"
             , udfFunc.toString());
   }