Sonar 查询数据库

最新推荐文章于 2022-09-08 15:18:43 发布

hello老杜

最新推荐文章于 2022-09-08 15:18:43 发布

阅读量449

点赞数

文章标签： java

本文链接：https://blog.csdn.net/weixin_41291118/article/details/126392355

版权

SELECT 
'CLS' as  '项目',
CASE
when i.issue_type='1' THEN '异味' 
when i.issue_type='2' THEN 'bug' 
when i.issue_type='3' THEN '漏洞' 
when i.issue_type='4' THEN '安全热点' 
END  '类型',

CASE
when i.severity='BLOCKER' THEN '阻断' 
when i.severity='CRITICAL' THEN '严重' 
when i.severity='MAJOR' THEN '主要' 
END  '问题等级',

r.name '问题名称',
r.description '问题描述',
p.kee '路径',
i.line '问题所在行',
r.plugin_name '规则插件',
r.plugin_rule_key '规则关键字'
FROM issues i 
left join rules r on i.rule_id = r.id
LEFT JOIN projects p on i.component_uuid = p.uuid
WHERE i.project_uuid = (SELECT p.project_uuid FROM projects p WHERE  p.`scope` ='PRJ' and p.name = 'cls') 
and i.severity in ('BLOCKER','CRITICAL')
and i.status ='OPEN';