This is an automated email from the ASF dual-hosted git repository.
xiaoyu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-shenyu.git
The following commit(s) were added to refs/heads/master by this push:
new f59f43669 refactor shenyu-admin: format SQL to improve code
readability. (#3236)
f59f43669 is described below
commit f59f43669b3f6dae78a069a0483d7a075b72c345
Author: midnight2104 <[email protected]>
AuthorDate: Wed Apr 13 10:34:06 2022 +0800
refactor shenyu-admin: format SQL to improve code readability. (#3236)
---
.../main/resources/mappers/auth-param-sqlmap.xml | 54 +++---
.../main/resources/mappers/auth-path-sqlmap.xml | 32 ++--
.../resources/mappers/dashboard-user-sqlmap.xml | 8 +-
.../resources/mappers/data-permission-sqlmap.xml | 66 ++++----
.../main/resources/mappers/meta-data-sqlmap.xml | 14 +-
.../main/resources/mappers/permission-sqlmap.xml | 74 ++++-----
.../resources/mappers/plugin-handle-sqlmap.xml | 185 +++++++++++----------
7 files changed, 209 insertions(+), 224 deletions(-)
diff --git a/shenyu-admin/src/main/resources/mappers/auth-param-sqlmap.xml
b/shenyu-admin/src/main/resources/mappers/auth-param-sqlmap.xml
index 02e85f9b5..e3fe485fb 100644
--- a/shenyu-admin/src/main/resources/mappers/auth-param-sqlmap.xml
+++ b/shenyu-admin/src/main/resources/mappers/auth-param-sqlmap.xml
@@ -59,37 +59,37 @@
<include refid="Base_Column_List"/>
FROM auth_param
WHERE auth_id = #{authId, jdbcType=VARCHAR}
- AND app_name = #{appName, jdbcType=VARCHAR}
+ AND app_name = #{appName, jdbcType=VARCHAR}
LIMIT 1
</select>
<insert id="save"
parameterType="org.apache.shenyu.admin.model.entity.AuthParamDO">
INSERT INTO auth_param
- (id,
- auth_id,
- app_name,
- app_param,
- date_created,
- date_updated)
- VALUES
- (#{id, jdbcType=VARCHAR},
- #{authId, jdbcType=VARCHAR},
- #{appName, jdbcType=VARCHAR},
- #{appParam, jdbcType=VARCHAR},
- #{dateCreated, jdbcType=TIMESTAMP},
- #{dateUpdated, jdbcType=TIMESTAMP})
+ (id,
+ auth_id,
+ app_name,
+ app_param,
+ date_created,
+ date_updated)
+ VALUES
+ (#{id, jdbcType=VARCHAR},
+ #{authId, jdbcType=VARCHAR},
+ #{appName, jdbcType=VARCHAR},
+ #{appParam, jdbcType=VARCHAR},
+ #{dateCreated, jdbcType=TIMESTAMP},
+ #{dateUpdated, jdbcType=TIMESTAMP})
</insert>
<insert id="batchSave">
INSERT INTO auth_param
- (id,
- auth_id,
- app_name,
- app_param,
- date_created,
- date_updated)
- VALUES
+ (id,
+ auth_id,
+ app_name,
+ app_param,
+ date_created,
+ date_updated)
+ VALUES
<foreach collection="authParamDOList" item="authParamDO" separator=",">
(
#{authParamDO.id, jdbcType=VARCHAR},
@@ -101,31 +101,29 @@
</foreach>
</insert>
-
<update id="update"
parameterType="org.apache.shenyu.admin.model.entity.AuthParamDO">
UPDATE auth_param
- SET app_param = #{appParam, jdbcType=VARCHAR}
- WHERE id = #{id, jdbcType=VARCHAR}
+ SET app_param = #{appParam, jdbcType=VARCHAR}
+ WHERE id = #{id, jdbcType=VARCHAR}
</update>
<delete id="delete" parameterType="java.lang.String">
DELETE FROM auth_param
- WHERE id = #{id, jdbcType=VARCHAR}
+ WHERE id = #{id, jdbcType=VARCHAR}
</delete>
<delete id="deleteByAuthId" parameterType="java.lang.String">
DELETE FROM auth_param
- WHERE auth_id = #{authId, jdbcType=VARCHAR}
+ WHERE auth_id = #{authId, jdbcType=VARCHAR}
</delete>
<delete id="deleteByAuthIds" parameterType="java.util.List">
DELETE FROM auth_param
- WHERE auth_id IN
+ WHERE auth_id IN
<foreach item="authId" collection="list" open="(" separator=","
close=")">
#{authId, jdbcType=VARCHAR}
</foreach>
</delete>
-
</mapper>
diff --git a/shenyu-admin/src/main/resources/mappers/auth-path-sqlmap.xml
b/shenyu-admin/src/main/resources/mappers/auth-path-sqlmap.xml
index f4e82f84f..3d684b2bd 100644
--- a/shenyu-admin/src/main/resources/mappers/auth-path-sqlmap.xml
+++ b/shenyu-admin/src/main/resources/mappers/auth-path-sqlmap.xml
@@ -72,16 +72,12 @@
</select>
<select id="existedByAuthId" resultType="java.lang.Boolean">
- SELECT
- true
- FROM
- auth_path
- WHERE
- auth_id = #{authId}
- LIMIT 1
+ SELECT true
+ FROM auth_path
+ WHERE auth_id = #{authId}
+ LIMIT 1
</select>
-
<insert id="save"
parameterType="org.apache.shenyu.admin.model.entity.AuthParamDO">
INSERT INTO auth_path
(id,
@@ -124,28 +120,24 @@
<update id="update"
parameterType="org.apache.shenyu.admin.model.entity.AuthParamDO">
UPDATE auth_path
- SET
- path = #{path, jdbcType=VARCHAR}
+ SET path = #{path, jdbcType=VARCHAR}
WHERE id = #{id, jdbcType=VARCHAR}
</update>
<delete id="deleteByAuthIdAndAppName">
- DELETE
- FROM auth_path
- WHERE auth_id = #{authId, jdbcType=VARCHAR}
- AND app_name = #{appName, jdbcType=VARCHAR}
+ DELETE FROM auth_path
+ WHERE auth_id = #{authId, jdbcType=VARCHAR}
+ AND app_name = #{appName, jdbcType=VARCHAR}
</delete>
<delete id="deleteByAuthId" parameterType="java.lang.String">
- DELETE
- FROM auth_path
- WHERE auth_id = #{authId, jdbcType=VARCHAR}
+ DELETE FROM auth_path
+ WHERE auth_id = #{authId, jdbcType=VARCHAR}
</delete>
<delete id="deleteByAuthIds" parameterType="java.lang.String">
- DELETE
- FROM auth_path
- WHERE auth_id IN
+ DELETE FROM auth_path
+ WHERE auth_id IN
<foreach item="authId" collection="list" open="(" separator=","
close=")">
#{authId, jdbcType=VARCHAR}
</foreach>
diff --git a/shenyu-admin/src/main/resources/mappers/dashboard-user-sqlmap.xml
b/shenyu-admin/src/main/resources/mappers/dashboard-user-sqlmap.xml
index e1a0291ce..b290263cd 100644
--- a/shenyu-admin/src/main/resources/mappers/dashboard-user-sqlmap.xml
+++ b/shenyu-admin/src/main/resources/mappers/dashboard-user-sqlmap.xml
@@ -56,7 +56,7 @@
<include refid="Base_Column_List"/>
FROM dashboard_user
WHERE user_name = #{userName, jdbcType=VARCHAR}
- AND password = #{password, jdbcType=VARCHAR}
+ AND password = #{password, jdbcType=VARCHAR}
</select>
<select id="selectByQuery"
parameterType="org.apache.shenyu.admin.model.query.DashboardUserQuery"
@@ -158,15 +158,15 @@
</insert>
<update id="update"
parameterType="org.apache.shenyu.admin.model.entity.DashboardUserDO">
- UPDATE dashboard_user
- SET
+ UPDATE dashboard_user
+ SET
date_created = #{dateCreated, jdbcType=TIMESTAMP},
date_updated = #{dateUpdated, jdbcType=TIMESTAMP},
user_name = #{userName, jdbcType=VARCHAR},
password = #{password, jdbcType=VARCHAR},
role = #{role, jdbcType=INTEGER},
enabled = #{enabled, jdbcType=TINYINT}
- WHERE id = #{id, jdbcType=VARCHAR}
+ WHERE id = #{id, jdbcType=VARCHAR}
</update>
<update id="updateSelective"
parameterType="org.apache.shenyu.admin.model.entity.DashboardUserDO">
diff --git a/shenyu-admin/src/main/resources/mappers/data-permission-sqlmap.xml
b/shenyu-admin/src/main/resources/mappers/data-permission-sqlmap.xml
index cbddb7376..b8b7dcedb 100644
--- a/shenyu-admin/src/main/resources/mappers/data-permission-sqlmap.xml
+++ b/shenyu-admin/src/main/resources/mappers/data-permission-sqlmap.xml
@@ -37,54 +37,47 @@
</sql>
<delete id="deleteByUniqueKey">
- DELETE
- FROM data_permission
- WHERE data_id = #{dataId, jdbcType=VARCHAR}
- AND user_id = #{userId,jdbcType=VARCHAR}
- AND data_type = #{dataType,jdbcType=INTEGER}
+ DELETE FROM data_permission
+ WHERE data_id = #{dataId, jdbcType=VARCHAR}
+ AND user_id = #{userId,jdbcType=VARCHAR}
+ AND data_type = #{dataType,jdbcType=INTEGER}
</delete>
<delete id="deleteByDataIdsAndUserId" parameterType="java.util.List">
- DELETE
- FROM data_permission
- WHERE data_id in
- <foreach item="id" collection="list" open="(" separator=","
close=")">
- #{id,jdbcType=VARCHAR}
- </foreach>
- AND user_id = #{userId, jdbcType=VARCHAR}
- AND data_type = #{dataType,jdbcType=VARCHAR}
+ DELETE FROM data_permission
+ WHERE data_id
+ IN <foreach item="id" collection="list" open="("
separator="," close=")">
+ #{id,jdbcType=VARCHAR}
+ </foreach>
+ AND user_id = #{userId, jdbcType=VARCHAR}
+ AND data_type = #{dataType,jdbcType=VARCHAR}
</delete>
<delete id="deleteByUserId">
- DELETE
- FROM data_permission
- WHERE user_id = #{userId,jdbcType=VARCHAR}
+ DELETE FROM data_permission
+ WHERE user_id = #{userId,jdbcType=VARCHAR}
</delete>
<delete id="deleteByUserIdSet">
- DELETE
- FROM data_permission
- WHERE user_id in
- <foreach collection="userIdSet" index="index" item="userId"
- open="(" separator="," close=")">
- #{userId,jdbcType=VARCHAR}
- </foreach>
+ DELETE FROM data_permission
+ WHERE user_id
+ IN <foreach collection="userIdSet" index="index"
item="userId" open="(" separator="," close=")">
+ #{userId,jdbcType=VARCHAR}
+ </foreach>
</delete>
<delete id="deleteByDataId">
- DELETE
- FROM data_permission
- WHERE data_id = #{dataId,jdbcType=VARCHAR}
+ DELETE FROM data_permission
+ WHERE data_id = #{dataId,jdbcType=VARCHAR}
</delete>
<delete id="deleteByDataIdList">
- DELETE
- FROM data_permission
- WHERE data_id in
- <foreach item="dataId" collection="dataIdList" open="("
separator="," close=")">
- #{dataId,jdbcType=VARCHAR}
- </foreach>
+ DELETE FROM data_permission
+ WHERE data_id
+ IN <foreach item="dataId" collection="dataIdList" open="("
separator="," close=")">
+ #{dataId,jdbcType=VARCHAR}
+ </foreach>
</delete>
<select id="listByUserId" resultMap="BaseResultMap">
@@ -101,7 +94,7 @@
FROM data_permission
WHERE user_id = #{userId,jdbcType=VARCHAR}
AND data_type = #{dataType,jdbcType=INTEGER}
- AND data_id in
+ AND data_id IN
<foreach item="id" collection="list" open="(" separator=","
close=")">
#{id,jdbcType=VARCHAR}
</foreach>
@@ -164,9 +157,10 @@
</insert>
<insert id="insertBatch">
- INSERT INTO data_permission (id, user_id,
- data_id,
- data_type)
+ INSERT INTO data_permission (id,
+ user_id,
+ data_id,
+ data_type)
VALUES
<foreach collection="dataPermissionList"
item="dataPermission" separator=",">
(
diff --git a/shenyu-admin/src/main/resources/mappers/meta-data-sqlmap.xml
b/shenyu-admin/src/main/resources/mappers/meta-data-sqlmap.xml
index 458a89810..295d8a497 100644
--- a/shenyu-admin/src/main/resources/mappers/meta-data-sqlmap.xml
+++ b/shenyu-admin/src/main/resources/mappers/meta-data-sqlmap.xml
@@ -183,8 +183,7 @@
<update id="updateEnable"
parameterType="org.apache.shenyu.admin.model.entity.PluginDO">
UPDATE meta_data
- SET
- enabled = #{enabled,jdbcType=TINYINT}
+ SET enabled = #{enabled,jdbcType=TINYINT}
WHERE id = #{id,jdbcType=VARCHAR}
</update>
@@ -199,15 +198,14 @@
<delete id="delete" parameterType="java.lang.String">
DELETE FROM meta_data
- WHERE id = #{id,jdbcType=VARCHAR}
+ WHERE id = #{id,jdbcType=VARCHAR}
</delete>
<delete id="deleteByIdSet" parameterType="java.lang.String">
DELETE FROM meta_data
- WHERE id IN
- <foreach collection="idSet" item="id" index="index" open="("
separator="," close=")">
- #{id,jdbcType=VARCHAR}
- </foreach>
+ WHERE id
+ IN <foreach collection="idSet" item="id" index="index"
open="(" separator="," close=")">
+ #{id,jdbcType=VARCHAR}
+ </foreach>
</delete>
</mapper>
-
diff --git a/shenyu-admin/src/main/resources/mappers/permission-sqlmap.xml
b/shenyu-admin/src/main/resources/mappers/permission-sqlmap.xml
index 24ef2e553..fb621fce4 100644
--- a/shenyu-admin/src/main/resources/mappers/permission-sqlmap.xml
+++ b/shenyu-admin/src/main/resources/mappers/permission-sqlmap.xml
@@ -36,41 +36,41 @@
<select id="selectById" parameterType="java.lang.String"
resultMap="BaseResultMap">
SELECT
- <include refid="Base_Column_List"/>
- FROM permission
- WHERE id = #{id,jdbcType=VARCHAR}
+ <include refid="Base_Column_List"/>
+ FROM permission
+ WHERE id = #{id,jdbcType=VARCHAR}
</select>
<select id="findByObjectId" parameterType="java.lang.String"
resultMap="BaseResultMap">
SELECT
- <include refid="Base_Column_List"/>
- FROM permission
- WHERE object_id = #{objectId,jdbcType=VARCHAR}
+ <include refid="Base_Column_List"/>
+ FROM permission
+ WHERE object_id = #{objectId,jdbcType=VARCHAR}
</select>
<select id="findByObjectIds" parameterType="java.util.List"
resultMap="BaseResultMap">
SELECT
- <include refid="Base_Column_List"/>
- FROM permission
- WHERE object_id in
- <foreach item="objectId" collection="list" open="(" separator=","
close=")">
- #{objectId, jdbcType=VARCHAR}
- </foreach>
+ <include refid="Base_Column_List"/>
+ FROM permission
+ WHERE object_id
+ IN <foreach item="objectId" collection="list" open="("
separator="," close=")">
+ #{objectId, jdbcType=VARCHAR}
+ </foreach>
</select>
<insert id="insert"
parameterType="org.apache.shenyu.admin.model.entity.PermissionDO">
INSERT INTO permission
- (id,
- date_created,
- date_updated,
- object_id,
- resource_id)
- VALUES
- (#{id,jdbcType=VARCHAR},
- #{dateCreated,jdbcType=TIMESTAMP},
- #{dateUpdated,jdbcType=TIMESTAMP},
- #{objectId,jdbcType=VARCHAR},
- #{resourceId,jdbcType=VARCHAR})
+ (id,
+ date_created,
+ date_updated,
+ object_id,
+ resource_id)
+ VALUES
+ (#{id,jdbcType=VARCHAR},
+ #{dateCreated,jdbcType=TIMESTAMP},
+ #{dateUpdated,jdbcType=TIMESTAMP},
+ #{objectId,jdbcType=VARCHAR},
+ #{resourceId,jdbcType=VARCHAR})
</insert>
<insert id="insertSelective"
parameterType="org.apache.shenyu.admin.model.entity.PermissionDO">
@@ -109,10 +109,10 @@
<insert id="insertBatch">
INSERT INTO permission
- (id,
- object_id,
- resource_id)
- VALUES
+ (id,
+ object_id,
+ resource_id)
+ VALUES
<foreach collection="permissionDOList" item="permissionDO"
separator=",">
(#{permissionDO.id,jdbcType=VARCHAR},
#{permissionDO.objectId,jdbcType=VARCHAR},
@@ -121,29 +121,29 @@
</insert>
<delete id="delete" parameterType="java.lang.String">
- DELETE FROM permission
- WHERE id = #{id,jdbcType=VARCHAR}
+ DELETE FROM permission
+ WHERE id = #{id,jdbcType=VARCHAR}
</delete>
<delete id="deleteByObjectIdAndResourceId"
parameterType="org.apache.shenyu.admin.model.query.PermissionQuery">
DELETE FROM permission
- WHERE object_id = #{objectId, jdbcType=VARCHAR}
- and resource_id = #{resourceId, jdbcType=VARCHAR}
+ WHERE object_id = #{objectId, jdbcType=VARCHAR}
+ AND resource_id = #{resourceId, jdbcType=VARCHAR}
</delete>
<delete id="deleteByResourceId" parameterType="java.util.List">
DELETE FROM permission
- WHERE resource_id in
+ WHERE resource_id IN
<foreach item="resourceId" collection="list" open="("
separator="," close=")">
#{resourceId, jdbcType=VARCHAR}
</foreach>
</delete>
<delete id="deleteByObjectIds" parameterType="java.util.List">
- DELETE FROM permission
- WHERE object_id in
- <foreach item="objectId" collection="list" open="(" separator=","
close=")">
- #{objectId, jdbcType=VARCHAR}
- </foreach>
+ DELETE FROM permission
+ WHERE object_id IN
+ <foreach item="objectId" collection="list" open="("
separator="," close=")">
+ #{objectId, jdbcType=VARCHAR}
+ </foreach>
</delete>
</mapper>
diff --git a/shenyu-admin/src/main/resources/mappers/plugin-handle-sqlmap.xml
b/shenyu-admin/src/main/resources/mappers/plugin-handle-sqlmap.xml
index d4e5acda9..24c386475 100644
--- a/shenyu-admin/src/main/resources/mappers/plugin-handle-sqlmap.xml
+++ b/shenyu-admin/src/main/resources/mappers/plugin-handle-sqlmap.xml
@@ -32,73 +32,75 @@
</resultMap>
<sql id="Base_Column_List">
- id, plugin_id, field, label, data_type,type,sort, ext_obj,
date_created, date_updated
+ id,
+ plugin_id,
+ field,
+ label,
+ data_type,
+ type,
+ sort,
+ ext_obj,
+ date_created,
+ date_updated
</sql>
<select id="selectById" parameterType="java.lang.String"
resultMap="BaseResultMap">
SELECT
- <include refid="Base_Column_List"/>
- FROM plugin_handle
- WHERE id = #{id,jdbcType=VARCHAR}
+ <include refid="Base_Column_List"/>
+ FROM plugin_handle
+ WHERE id = #{id, jdbcType=VARCHAR}
</select>
<select id="findByPluginId" parameterType="java.lang.String"
resultMap="BaseResultMap">
SELECT
- <include refid="Base_Column_List"/>
- FROM plugin_handle
- WHERE plugin_id = #{pluginId,jdbcType=VARCHAR}
+ <include refid="Base_Column_List"/>
+ FROM plugin_handle
+ WHERE plugin_id = #{pluginId, jdbcType=VARCHAR}
</select>
<delete id="delete" parameterType="java.lang.String">
- DELETE
- FROM plugin_handle
- WHERE id = #{id,jdbcType=VARCHAR}
+ DELETE FROM plugin_handle
+ WHERE id = #{id, jdbcType=VARCHAR}
</delete>
<delete id="deleteByIdSet">
- DELETE
- FROM plugin_handle
- WHERE id in
- <foreach collection="idSet" item="id"
- open="(" separator="," close=")">
- #{id,jdbcType=VARCHAR}
- </foreach>
+ DELETE FROM plugin_handle
+ WHERE id IN
+ <foreach collection="idSet" item="id" open="("
separator="," close=")">
+ #{id, jdbcType=VARCHAR}
+ </foreach>
</delete>
<delete id="deleteByPluginIds" parameterType="java.util.List">
- DELETE
- FROM plugin_handle
- WHERE plugin_id IN
- <foreach item="pluginId" collection="list" open="(" separator=","
close=")">
- #{pluginId,jdbcType=VARCHAR}
- </foreach>
+ DELETE FROM plugin_handle
+ WHERE plugin_id IN
+ <foreach item="pluginId" collection="list" open="("
separator="," close=")">
+ #{pluginId,jdbcType=VARCHAR}
+ </foreach>
</delete>
<insert id="insert"
parameterType="org.apache.shenyu.admin.model.entity.PluginHandleDO">
- INSERT INTO plugin_handle (
- id,
- plugin_id,
- field,
- label,
- data_type,
- type,
- sort,
- ext_obj,
- date_created,
- date_updated
- )
- VALUES (
- #{id,jdbcType=VARCHAR},
- #{pluginId,jdbcType=VARCHAR},
- #{field,jdbcType=VARCHAR},
- #{label,jdbcType=VARCHAR},
- #{dataType,jdbcType=INTEGER},
- #{type,jdbcType=INTEGER},
- #{sort,jdbcType=INTEGER},
- #{extObj,jdbcType=VARCHAR},
- #{dateCreated,jdbcType=TIMESTAMP},
- #{dateUpdated,jdbcType=TIMESTAMP}
- )
+ INSERT INTO plugin_handle
+ (id,
+ plugin_id,
+ field,
+ label,
+ data_type,
+ type,
+ sort,
+ ext_obj,
+ date_created,
+ date_updated)
+ VALUES (#{id, jdbcType=VARCHAR},
+ #{pluginId, jdbcType=VARCHAR},
+ #{field, jdbcType=VARCHAR},
+ #{label, jdbcType=VARCHAR},
+ #{dataType, jdbcType=INTEGER},
+ #{type, jdbcType=INTEGER},
+ #{sort, jdbcType=INTEGER},
+ #{extObj, jdbcType=VARCHAR},
+ #{dateCreated, jdbcType=TIMESTAMP},
+ #{dateUpdated, jdbcType=TIMESTAMP})
</insert>
<insert id="insertSelective"
parameterType="org.apache.shenyu.admin.model.entity.PluginHandleDO">
@@ -137,34 +139,34 @@
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="id != null">
- #{id,jdbcType=VARCHAR},
+ #{id, jdbcType=VARCHAR},
</if>
<if test="pluginId != null">
- #{pluginId,jdbcType=VARCHAR},
+ #{pluginId, jdbcType=VARCHAR},
</if>
<if test="field != null">
- #{field,jdbcType=VARCHAR},
+ #{field, jdbcType=VARCHAR},
</if>
<if test="label != null">
- #{label,jdbcType=VARCHAR},
+ #{label, jdbcType=VARCHAR},
</if>
<if test="dataType != null">
- #{dataType,jdbcType=INTEGER},
+ #{dataType, jdbcType=INTEGER},
</if>
<if test="type != null">
- #{type,jdbcType=INTEGER},
+ #{type, jdbcType=INTEGER},
</if>
<if test="sort != null">
- #{sort,jdbcType=INTEGER},
+ #{sort, jdbcType=INTEGER},
</if>
<if test="extObj != null">
- #{extObj,jdbcType=VARCHAR},
+ #{extObj, jdbcType=VARCHAR},
</if>
<if test="dateCreated != null">
- #{dateCreated,jdbcType=TIMESTAMP},
+ #{dateCreated, jdbcType=TIMESTAMP},
</if>
<if test="dateUpdated != null">
- #{dateUpdated,jdbcType=TIMESTAMP},
+ #{dateUpdated, jdbcType=TIMESTAMP},
</if>
</trim>
</insert>
@@ -172,61 +174,61 @@
UPDATE plugin_handle
<set>
<if test="pluginId != null">
- plugin_id = #{pluginId,jdbcType=VARCHAR},
+ plugin_id = #{pluginId, jdbcType=VARCHAR},
</if>
<if test="field != null">
- field = #{field,jdbcType=VARCHAR},
+ field = #{field, jdbcType=VARCHAR},
</if>
<if test="label != null">
- label = #{label,jdbcType=VARCHAR},
+ label = #{label, jdbcType=VARCHAR},
</if>
<if test="dataType != null">
- data_type= #{dataType,jdbcType=INTEGER},
+ data_type= #{dataType, jdbcType=INTEGER},
</if>
<if test="type != null">
- type= #{type,jdbcType=INTEGER},
+ type= #{type, jdbcType=INTEGER},
</if>
<if test="sort != null">
- sort= #{sort,jdbcType=INTEGER},
+ sort= #{sort, jdbcType=INTEGER},
</if>
<if test="extObj != null">
- ext_obj= #{extObj,jdbcType=VARCHAR},
+ ext_obj= #{extObj, jdbcType=VARCHAR},
</if>
<if test="dateCreated != null">
- date_created = #{dateCreated,jdbcType=TIMESTAMP},
+ date_created = #{dateCreated, jdbcType=TIMESTAMP},
</if>
<if test="dateUpdated != null">
- date_updated = #{dateUpdated,jdbcType=TIMESTAMP},
+ date_updated = #{dateUpdated, jdbcType=TIMESTAMP},
</if>
</set>
- where id = #{id,jdbcType=VARCHAR}
+ WHERE id = #{id, jdbcType=VARCHAR}
</update>
<update id="updateByPrimaryKey"
parameterType="org.apache.shenyu.admin.model.entity.PluginHandleDO">
- UPDATE plugin_handle
- SET plugin_id = #{pluginId,jdbcType=VARCHAR},
- field = #{field,jdbcType=VARCHAR},
- label = #{label,jdbcType=VARCHAR},
- data_type = #{dataType,jdbcType=INTEGER},
- type = #{type,jdbcType=INTEGER},
- sort = #{sort,jdbcType=INTEGER},
- ext_obj = #{extObj,jdbcType=VARCHAR},
- date_created = #{dateCreated,jdbcType=TIMESTAMP},
- date_updated = #{dateUpdated,jdbcType=TIMESTAMP}
- WHERE id = #{id,jdbcType=VARCHAR}
+ UPDATE plugin_handle
+ SET plugin_id = #{pluginId, jdbcType=VARCHAR},
+ field = #{field, jdbcType=VARCHAR},
+ label = #{label, jdbcType=VARCHAR},
+ data_type = #{dataType, jdbcType=INTEGER},
+ type = #{type, jdbcType=INTEGER},
+ sort = #{sort, jdbcType=INTEGER},
+ ext_obj = #{extObj, jdbcType=VARCHAR},
+ date_created = #{dateCreated, jdbcType=TIMESTAMP},
+ date_updated = #{dateUpdated, jdbcType=TIMESTAMP}
+ WHERE id = #{id, jdbcType=VARCHAR}
</update>
<select id="countByQuery"
parameterType="org.apache.shenyu.admin.model.query.PluginHandleQuery"
resultType="java.lang.Integer">
SELECT count(1)
- FROM plugin_handle
+ FROM plugin_handle
<where>
<if test="pluginId != null and pluginId != ''">
- AND plugin_id = #{pluginId,jdbcType=VARCHAR}
+ AND plugin_id = #{pluginId, jdbcType=VARCHAR}
</if>
<if test="field != null and field != ''">
- AND field = #{field,jdbcType=VARCHAR}
+ AND field = #{field, jdbcType=VARCHAR}
</if>
<if test="type != null">
- AND type = #{type,jdbcType=INTEGER}
+ AND type = #{type, jdbcType=INTEGER}
</if>
</where>
</select>
@@ -234,26 +236,27 @@
<select id="selectByQuery"
parameterType="org.apache.shenyu.admin.model.query.PluginHandleQuery"
resultMap="BaseResultMap">
SELECT
- <include refid="Base_Column_List"/>
- FROM plugin_handle
+ <include refid="Base_Column_List"/>
+ FROM plugin_handle
<where>
<if test="pluginId != null and pluginId != ''">
- AND plugin_id = #{pluginId,jdbcType=VARCHAR}
+ AND plugin_id = #{pluginId, jdbcType=VARCHAR}
</if>
<if test="field != null and field != ''">
<bind name="fieldLike" value="('%' + field + '%')"/>
- AND field like #{fieldLike,jdbcType=VARCHAR}
+ AND field like #{fieldLike, jdbcType=VARCHAR}
</if>
<if test="type != null">
- AND type = #{type,jdbcType=INTEGER}
+ AND type = #{type, jdbcType=INTEGER}
</if>
</where>
- ORDER BY plugin_id,sort
+ ORDER BY plugin_id,sort
</select>
<select id="existed" resultType="java.lang.Boolean">
- SELECT true
- FROM plugin_handle
- WHERE id = #{id} limit 1
+ SELECT true
+ FROM plugin_handle
+ WHERE id = #{id}
+ LIMIT 1
</select>
</mapper>
