cboard连接mysql库_CBoard数据集页面增加【索引名称】字段的过程

SELECT DISTINCT(category_name) category FROM dashboard_dataset order by category

SELECT

dataset_id AS id,

s.user_id AS userId,

dataset_name AS name,

data_json AS data,

category_name AS categoryName,

u.user_name AS userName,

u.login_name AS loginName,

create_time AS createTime,

update_time AS updateTime,

index_name AS indexName

FROM dashboard_dataset s

LEFT JOIN dashboard_user u ON u.user_id = s.user_id

SELECT

dataset_id AS id,

s.user_id AS userId,

dataset_name AS name,

data_json AS data,

category_name AS categoryName,

u.user_name AS userName,

u.login_name AS loginName,

create_time AS createTime,

update_time AS updateTime,

index_name AS indexName

FROM dashboard_dataset s

LEFT JOIN dashboard_user u ON u.user_id = s.user_id

WHERE #{0} = ‘${admin_user_id}‘ OR s.user_id = #{0} OR dataset_id IN (

SELECT res_id

FROM dashboard_user_role ur

LEFT JOIN dashboard_role_res rr ON ur.role_id = rr.role_id

WHERE ur.user_id = #{0} AND rr.res_type = ‘dataset‘

)

ORDER BY dataset_name

SELECT

dataset_id AS id,

s.user_id AS userId,

dataset_name AS name,

data_json AS data,

category_name AS categoryName,

u.user_name AS userName,

u.login_name AS loginName,

create_time AS createTime,

update_time AS updateTime,

index_name AS indexName

FROM dashboard_dataset s

LEFT JOIN dashboard_user u ON u.user_id = s.user_id

WHERE #{0} = ‘${admin_user_id}‘ OR s.user_id = #{0}

OR s.user_id = #{0}

OR dataset_id IN (

SELECT res_id

FROM dashboard_role r

LEFT JOIN dashboard_role_res rr ON r.role_id = rr.role_id

WHERE r.user_id = #{0} AND rr.res_type = ‘dataset‘

)

ORDER BY dataset_name

SELECT dataset_id id,user_id userId,dataset_name name,data_json data,category_name categoryName,create_time createTime,update_time updateTime,index_name indexName FROM dashboard_dataset WHERE dataset_id = #{0}

SELECT count(1)

FROM dashboard_dataset

WHERE 1=1

#{dataset_id}]]>

AND dataset_name = #{dataset_name}

AND category_name = #{category_name}

delete from dashboard_dataset where dataset_id = #{0}

SELECT count(1) FROM dashboard_dataset WHERE dataset_id = #{1} and (#{0} = ‘${admin_user_id}‘ OR user_id = #{0} OR dataset_id IN (SELECT res_id FROM dashboard_user_role ur LEFT JOIN dashboard_role_res rr ON ur.role_id = rr.role_id WHERE ur.user_id = #{0} AND rr.res_type = ‘dataset‘ AND rr.permission LIKE #{2}))