SONAR数据库重点表说明

SONAR数据库重点表说明
 
SONAR数据库很少泄密，直接去研究了一下。经过一天反复实践，把重点的几个表来说明一下。  www.zzzyk.com  
说明一下，SONAR提供删除项目的功能，但大量数据并没有删除掉。
 
select * from projects where scope='PRJ' AND qualifier='TRK' order by name;
delete  from resource_index where root_project_id in (37641,37902,38053,37456,38204,38355,38506);
delete from sonar.snapshot_sources where snapshot_id
in
(
select id from sonar.snapshots where root_project_id in (37641,37902,38053,37456,38204,38355)
);
delete from sonar.project_measures where snapshot_id
in
(select id from snapshots where root_project_id in (37641,37902,38053,37456,38204,38355));
delete from projects where root_id in (37641,37902,38053,37456,38204,38355);
delete from projects where id in (37641,37902,38053,37456,38204,38355);
delete from sonar.snapshots where root_project_id in (37641,37902,38053,37456,38204,38355);
delete from rule_failures
where snapshot_id not in
(
select id from snapshots );
 

上一个：无法获得对数据库的独占访问权的问题
下一个：PostgreSQL使用with一例