aboutsummaryrefslogtreecommitdiffstats
path: root/server/sonar-db-dao/src/test/resources
diff options
context:
space:
mode:
authorJanos Gyerik <janos.gyerik@sonarsource.com>2018-06-13 08:15:23 +0200
committersonartech <sonartech@sonarsource.com>2018-07-04 09:31:03 +0200
commit376544a07a2259a0399d7f2d179c3c1c42a443a9 (patch)
tree25b082117b1ca4b5980667bd222f208e2d08a7f6 /server/sonar-db-dao/src/test/resources
parentef533dd5609985d418c932d93c726646aa9fae43 (diff)
downloadsonarqube-376544a07a2259a0399d7f2d179c3c1c42a443a9.tar.gz
sonarqube-376544a07a2259a0399d7f2d179c3c1c42a443a9.zip
Rewrite dbunit test using dbtester
Diffstat (limited to 'server/sonar-db-dao/src/test/resources')
-rw-r--r--server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/close_issues_clean_index_and_files_sources_of_specified_components-result.xml271
-rw-r--r--server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/close_issues_clean_index_and_files_sources_of_specified_components.xml304
-rw-r--r--server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_all_closed_issues-result.xml164
-rw-r--r--server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_all_closed_issues.xml234
-rw-r--r--server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_old_closed_issues-result.xml184
-rw-r--r--server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_old_closed_issues.xml232
6 files changed, 0 insertions, 1389 deletions
diff --git a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/close_issues_clean_index_and_files_sources_of_specified_components-result.xml b/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/close_issues_clean_index_and_files_sources_of_specified_components-result.xml
deleted file mode 100644
index 287f41e23de..00000000000
--- a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/close_issues_clean_index_and_files_sources_of_specified_components-result.xml
+++ /dev/null
@@ -1,271 +0,0 @@
-<!--
-
-What has been changed :
-* enabled=false on projects
-* purge_status=1 on snapshots
-* resolve not already resolved issues on all components
-
--->
-<dataset>
-
- <!-- the project -->
- <projects organization_uuid="org1"
- uuid="P1"
- uuid_path="NOT_USED"
- project_uuid="P1"
- module_uuid="[null]"
- module_uuid_path="."
- main_branch_project_uuid="[null]"
- created_at="[null]"
- long_name="[null]"
- scope="PRJ"
- qualifier="TRK"
- kee="project"
- name="project"
- description="[null]"
- private="[false]"
- tags="[null]"
- language="java"
- copy_component_uuid="[null]"
- developer_uuid="[null]"
- path="[null]"
- deprecated_kee="[null]"
- authorization_updated_at="[null]"
- id="1"
- enabled="[false]"
- root_uuid="P1"
- b_changed="[false]"
- b_copy_component_uuid="[null]"
- b_description="[null]"
- b_enabled="[false]"
- b_uuid_path="[null]"
- b_language="[null]"
- b_long_name="[null]"
- b_module_uuid="[null]"
- b_module_uuid_path="[null]"
- b_name="[null]"
- b_path="[null]"
- b_qualifier="[null]"/>
-
- <!-- the directory -->
- <projects organization_uuid="org1"
- uuid="EFGH"
- uuid_path="NOT_USED"
- project_uuid="P1"
- module_uuid="P1"
- module_uuid_path="."
- main_branch_project_uuid="[null]"
- created_at="[null]"
- long_name="[null]"
- scope="DIR"
- qualifier="DIR"
- kee="project:my/dir"
- name="my/dir"
- description="[null]"
- private="[false]"
- tags="[null]"
- language="java"
- copy_component_uuid="[null]"
- developer_uuid="[null]"
- path="[null]"
- deprecated_kee="[null]"
- authorization_updated_at="[null]"
- id="2"
- enabled="[false]"
- root_uuid="P1"
- b_changed="[false]"
- b_copy_component_uuid="[null]"
- b_description="[null]"
- b_enabled="[false]"
- b_uuid_path="[null]"
- b_language="[null]"
- b_long_name="[null]"
- b_module_uuid="[null]"
- b_module_uuid_path="[null]"
- b_name="[null]"
- b_path="[null]"
- b_qualifier="[null]"/>
-
- <!-- the file -->
- <projects organization_uuid="org1"
- uuid="GHIJ"
- uuid_path="NOT_USED"
- project_uuid="P1"
- module_uuid="P1"
- module_uuid_path=".P1."
- main_branch_project_uuid="[null]"
- created_at="[null]"
- long_name="[null]"
- scope="FIL"
- qualifier="FIL"
- kee="project:my/dir/File.java"
- name="my/dir/File.java"
- description="[null]"
- private="[false]"
- tags="[null]"
- language="java"
- copy_component_uuid="[null]"
- developer_uuid="[null]"
- path="[null]"
- deprecated_kee="[null]"
- authorization_updated_at="[null]"
- id="3"
- enabled="[false]"
- root_uuid="P1"
- b_changed="[false]"
- b_copy_component_uuid="[null]"
- b_description="[null]"
- b_enabled="[false]"
- b_uuid_path="[null]"
- b_language="[null]"
- b_long_name="[null]"
- b_module_uuid="[null]"
- b_module_uuid_path="[null]"
- b_name="[null]"
- b_path="[null]"
- b_qualifier="[null]"/>
-
- <snapshots id="1"
- uuid="u1"
- component_uuid="P1"
- status="P"
- islast="[false]"
- purge_status="1"
- period1_mode="[null]"
- period1_param="[null]"
- period1_date="[null]"
- period2_mode="[null]"
- period2_param="[null]"
- period2_date="[null]"
- period3_mode="[null]"
- period3_param="[null]"
- period3_date="[null]"
- period4_mode="[null]"
- period4_param="[null]"
- period4_date="[null]"
- period5_mode="[null]"
- period5_param="[null]"
- period5_date="[null]"
- created_at="1228222680000"
- build_date="1228222680000"
- version="[null]"
- />
-
- <!-- Open issue on file -->
- <issues id="1"
- kee="ISSUE-1"
- component_uuid="GHIJ"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1396994400000"
- resolution="REMOVED"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="1450000000000"
- issue_creation_date="1366063200000"
- issue_update_date="1396994400000"
- created_at="1450000000000"
- tags="[null]"
- locations="[null]"
- issue_type="[null]"
- />
-
- <!-- Open issue on directory -->
- <issues id="2"
- kee="ISSUE-2"
- component_uuid="EFGH"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1396994400000"
- resolution="REMOVED"
- line="[null]"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="1450000000000"
- issue_creation_date="1366063200000"
- issue_update_date="1396994400000"
- created_at="1450000000000"
- tags="[null]"
- locations="[null]"
- issue_type="[null]"/>
-
- <!-- Open issue on project -->
- <issues id="3"
- kee="ISSUE-3"
- component_uuid="P1"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1396994400000"
- resolution="REMOVED"
- line="[null]"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="1450000000000"
- issue_creation_date="1366063200000"
- issue_update_date="1396994400000"
- created_at="1450000000000"
- tags="[null]"
- locations="[null]"
- issue_type="[null]"/>
-
- <!-- Resolved issue on file -> not to be updated -->
- <issues id="4"
- kee="ISSUE-4"
- component_uuid="GHIJ"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1449529200000"
- resolution="FIXED"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="1450000000000"
- issue_creation_date="1366063200000"
- issue_update_date="1396908000000"
- created_at="1450000000000"
- tags="[null]"
- locations="[null]"
- issue_type="[null]"/>
-
-</dataset>
diff --git a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/close_issues_clean_index_and_files_sources_of_specified_components.xml b/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/close_issues_clean_index_and_files_sources_of_specified_components.xml
deleted file mode 100644
index d371b7cd955..00000000000
--- a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/close_issues_clean_index_and_files_sources_of_specified_components.xml
+++ /dev/null
@@ -1,304 +0,0 @@
-<dataset>
-
- <!-- the project -->
- <projects organization_uuid="org1"
- uuid="P1"
- uuid_path="NOT_USED"
- project_uuid="P1"
- module_uuid="[null]"
- module_uuid_path="."
- main_branch_project_uuid="[null]"
- created_at="[null]"
- long_name="[null]"
- scope="PRJ"
- qualifier="TRK"
- kee="project"
- name="project"
- description="[null]"
- private="[false]"
- language="java"
- copy_component_uuid="[null]"
- developer_uuid="[null]"
- path="[null]"
- deprecated_kee="[null]"
- authorization_updated_at="[null]"
- id="1"
- enabled="[false]"
- root_uuid="P1"
- b_changed="[false]"
- b_copy_component_uuid="[null]"
- b_description="[null]"
- b_enabled="[false]"
- b_uuid_path="[null]"
- b_language="[null]"
- b_long_name="[null]"
- b_module_uuid="[null]"
- b_module_uuid_path="[null]"
- b_name="[null]"
- b_path="[null]"
- b_qualifier="[null]"/>
-
- <!-- the directory -->
- <projects organization_uuid="org1"
- uuid="EFGH"
- uuid_path="NOT_USED"
- project_uuid="P1"
- module_uuid="P1"
- module_uuid_path="."
- main_branch_project_uuid="[null]"
- created_at="[null]"
- long_name="[null]"
- scope="DIR"
- qualifier="DIR"
- kee="project:my/dir"
- name="my/dir"
- description="[null]"
- private="[false]"
- language="java"
- copy_component_uuid="[null]"
- developer_uuid="[null]"
- path="[null]"
- deprecated_kee="[null]"
- authorization_updated_at="[null]"
- id="2"
- enabled="[false]"
- root_uuid="P1"
- b_changed="[false]"
- b_copy_component_uuid="[null]"
- b_description="[null]"
- b_enabled="[false]"
- b_uuid_path="[null]"
- b_language="[null]"
- b_long_name="[null]"
- b_module_uuid="[null]"
- b_module_uuid_path="[null]"
- b_name="[null]"
- b_path="[null]"
- b_qualifier="[null]"/>
-
- <!-- the file -->
- <projects organization_uuid="org1"
- uuid="GHIJ"
- uuid_path="NOT_USED"
- project_uuid="P1"
- module_uuid="P1"
- module_uuid_path=".P1."
- main_branch_project_uuid="[null]"
- created_at="[null]"
- long_name="[null]"
- scope="FIL"
- qualifier="FIL"
- kee="project:my/dir/File.java"
- name="my/dir/File.java"
- description="[null]"
- private="[false]"
- language="java"
- copy_component_uuid="[null]"
- developer_uuid="[null]"
- path="[null]"
- deprecated_kee="[null]"
- authorization_updated_at="[null]"
- id="3"
- enabled="[false]"
- root_uuid="P1"
- b_changed="[false]"
- b_copy_component_uuid="[null]"
- b_description="[null]"
- b_enabled="[false]"
- b_uuid_path="[null]"
- b_language="[null]"
- b_long_name="[null]"
- b_module_uuid="[null]"
- b_module_uuid_path="[null]"
- b_name="[null]"
- b_path="[null]"
- b_qualifier="[null]"/>
-
- <snapshots id="1"
- uuid="u1"
- component_uuid="P1"
- status="P"
- islast="[false]"
- purge_status="[null]"
- period1_mode="[null]"
- period1_param="[null]"
- period1_date="[null]"
- period2_mode="[null]"
- period2_param="[null]"
- period2_date="[null]"
- period3_mode="[null]"
- period3_param="[null]"
- period3_date="[null]"
- period4_mode="[null]"
- period4_param="[null]"
- period4_date="[null]"
- period5_mode="[null]"
- period5_param="[null]"
- period5_date="[null]"
- created_at="1228222680000"
- build_date="1228222680000"
- version="[null]"
- />
-
- <!-- Open issue on file -->
- <issues id="1"
- kee="ISSUE-1"
- component_uuid="GHIJ"
- project_uuid="P1"
- status="OPEN"
- issue_close_date="[null]"
- resolution="[null]"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1450000000000"
- locations="[null]"
- issue_type="[null]"/>
-
- <!-- Open issue on directory -->
- <issues id="2"
- kee="ISSUE-2"
- component_uuid="EFGH"
- project_uuid="P1"
- status="OPEN"
- issue_close_date="[null]"
- resolution="[null]"
- line="[null]"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1450000000000"
- locations="[null]"
- issue_type="[null]"/>
-
- <!-- Open issue on project -->
- <issues id="3"
- kee="ISSUE-3"
- component_uuid="P1"
- project_uuid="P1"
- status="CONFIRM"
- issue_close_date="[null]"
- resolution="[null]"
- line="[null]"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1450000000000"
- locations="[null]"
- issue_type="[null]"/>
-
- <!-- Resolved issue on file -> not to be updated -->
- <issues id="4"
- kee="ISSUE-4"
- component_uuid="GHIJ"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1449529200000"
- resolution="FIXED"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="1450000000000"
- issue_creation_date="1366063200000"
- issue_update_date="1396908000000"
- created_at="1450000000000"
- locations="[null]"
- issue_type="[null]"/>
-
- <file_sources id="1"
- project_uuid="P1"
- file_uuid="GHIJ"
- binary_data="[null]"
- line_hashes="[null]"
- line_count="0"
- data_hash="321654987"
- revision="123456789"
- created_at="123456789"
- updated_at="123456789"
- src_hash="12345"
- data_type="SOURCE"/>
- <file_sources id="2"
- project_uuid="P1"
- file_uuid="KLMN"
- binary_data="[null]"
- line_hashes="[null]"
- line_count="0"
- data_hash="321654988"
- revision="123456789"
- created_at="123456789"
- updated_at="123456789"
- src_hash="123456"
- data_type="SOURCE"/>
- <file_sources id="3"
- project_uuid="P1"
- file_uuid="GHIJ"
- binary_data="[null]"
- line_hashes="[null]"
- line_count="0"
- data_hash="321654987"
- revision="123456789"
- created_at="123456789"
- updated_at="123456789"
- src_hash="12345"
- data_type="TEST"/>
- <file_sources id="4"
- project_uuid="P1"
- file_uuid="KLMN"
- binary_data="[null]"
- line_hashes="[null]"
- line_count="0"
- data_hash="321654988"
- revision="123456789"
- created_at="123456789"
- updated_at="123456789"
- src_hash="123456"
- data_type="TEST"/>
-
-</dataset>
diff --git a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_all_closed_issues-result.xml b/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_all_closed_issues-result.xml
deleted file mode 100644
index 0722a360744..00000000000
--- a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_all_closed_issues-result.xml
+++ /dev/null
@@ -1,164 +0,0 @@
-<!--
-
- EXACTLY THE SAME FILE. NO ROWS HAVE BEEN DELETED.
-
--->
-<dataset>
-
- <projects organization_uuid="org1"
- uuid="1"
- uuid_path="NOT_USED"
- enabled="[true]"
- root_id="[null]"
- created_at="[null]"
- long_name="[null]"
- scope="PRJ"
- qualifier="TRK"
- kee="project"
- name="project"
- description="[null]"
- private="[false]"
- language="java"
- copy_component_uuid="[null]"
- developer_uuid="[null]"
- authorization_updated_at="[null]"
- id="1"/>
-
- <snapshots id="1"
- uuid="u1"
- status="P"
- islast="[true]"
- purge_status="[null]"
- period1_mode="[null]"
- period1_param="[null]"
- period1_date="[null]"
- period2_mode="[null]"
- period2_param="[null]"
- period2_date="[null]"
- period3_mode="[null]"
- period3_param="[null]"
- period3_date="[null]"
- period4_mode="[null]"
- period4_param="[null]"
- period4_date="[null]"
- period5_mode="[null]"
- period5_param="[null]"
- period5_date="[null]"
- created_at="1228222680000"
- build_date="1228222680000"
- version="[null]"
- />
-
-
- <!-- old closed issues on file and project -->
- <!--
- <issues id="1" kee="ISSUE-1"
- component_uuid="100"
- project_uuid="1"
- status="CLOSED"
- issue_close_date="1262300400000"
- resolution="FIXED" line="200" severity="BLOCKER" reporter="[null]" assignee="arthur" rule_id="500" manual_severity="[false]"
- message="[null]" action_plan_key="[null]" gap="[null]" effort="[null]" issue_attributes="[null]" checksum="[null]" author_login="[null]"
- updated_at="[null]" issue_creation_date="1366063200000" issue_update_date="1366063200000" created_at="2013-04-16"
- locations="[null]" />
- <issue_changes id="1" kee="[null]" issue_key="ISSUE-1" created_at="[null]" updated_at="[null]" user_login="admin" change_type="comment" change_data="abc" issue_change_creation_date="[null]"/>
-
- <issues id="2" kee="ISSUE-2"
- component_uuid="1"
- project_uuid="1"
- status="CLOSED"
- issue_close_date="1262300400000"
- resolution="FIXED" line="200" severity="BLOCKER" reporter="[null]" assignee="arthur" rule_id="500" manual_severity="[false]"
- message="[null]" action_plan_key="[null]" gap="[null]" effort="[null]" issue_attributes="[null]" checksum="[null]" author_login="[null]"
- updated_at="[null]" issue_creation_date="1366063200000" issue_update_date="1366063200000" created_at="2013-04-16" locations="[null]" locations="[null]"/>
- <issue_changes id="2" kee="[null]" issue_key="ISSUE-2" created_at="[null]" updated_at="[null]" user_login="admin" change_type="comment" change_data="abc" issue_change_creation_date="[null]"/>
- -->
-
- <!-- old open issues -->
- <issues id="3"
- kee="ISSUE-3"
- component_uuid="1"
- project_uuid="1"
- status="OPEN"
- issue_close_date="[null]"
- resolution="[null]"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- tags="[null]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="3"
- kee="[null]"
- issue_key="ISSUE-3"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
- <!-- recent open and closed issues -->
- <issues id="4"
- kee="ISSUE-4"
- component_uuid="100"
- project_uuid="1"
- status="OPEN"
- issue_close_date="[null]"
- resolution="[null]"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- tags="[null]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="4"
- kee="[null]"
- issue_key="ISSUE-4"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
- <!--
- <issues id="5" kee="ISSUE-5"
- component_uuid="100"
- project_uuid="1"
- status="CLOSED"
- issue_close_date="1735686000000"
- resolution="FIXED" line="200" severity="BLOCKER" reporter="[null]" assignee="arthur" rule_id="500" manual_severity="[false]"
- message="[null]" action_plan_key="[null]" gap="[null]" effort="[null]" issue_attributes="[null]" checksum="[null]" author_login="[null]"
- updated_at="[null]" issue_creation_date="1366063200000" issue_update_date="1366063200000" created_at="2013-04-16" locations="[null]"/>
- <issue_changes id="5" kee="[null]" issue_key="ISSUE-5" created_at="[null]" updated_at="[null]" user_login="admin" change_type="comment" change_data="abc" issue_change_creation_date="[null]"/>
- -->
-</dataset>
diff --git a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_all_closed_issues.xml b/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_all_closed_issues.xml
deleted file mode 100644
index cdb04fe8e7d..00000000000
--- a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_all_closed_issues.xml
+++ /dev/null
@@ -1,234 +0,0 @@
-<dataset>
-
- <projects organization_uuid="org1"
- uuid="1"
- uuid_path="NOT_USED"
- enabled="[true]"
- root_uuid="1"
- project_uuid="1"
- created_at="[null]"
- long_name="[null]"
- scope="PRJ"
- qualifier="TRK"
- kee="project"
- name="project"
- description="[null]"
- private="[false]"
- language="java"
- copy_component_uuid="[null]"
- developer_uuid="[null]"
- authorization_updated_at="[null]"
- id="1"/>
-
- <snapshots id="1"
- uuid="u1"
- component_uuid="1"
- status="P"
- islast="[true]"
- purge_status="[null]"
- period1_mode="[null]"
- period1_param="[null]"
- period1_date="[null]"
- period2_mode="[null]"
- period2_param="[null]"
- period2_date="[null]"
- period3_mode="[null]"
- period3_param="[null]"
- period3_date="[null]"
- period4_mode="[null]"
- period4_param="[null]"
- period4_date="[null]"
- period5_mode="[null]"
- period5_param="[null]"
- period5_date="[null]"
- created_at="1228222680000"
- build_date="1228222680000"
- version="[null]"
- />
-
-
- <!-- old closed issues on file and project -->
- <issues id="1"
- kee="ISSUE-1"
- component_uuid="100"
- project_uuid="1"
- status="CLOSED"
- issue_close_date="1262300400000"
- resolution="FIXED"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="1"
- kee="[null]"
- issue_key="ISSUE-1"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
- <issues id="2"
- kee="ISSUE-2"
- component_uuid="1"
- project_uuid="1"
- status="CLOSED"
- issue_close_date="1262300400000"
- resolution="FIXED"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="2"
- kee="[null]"
- issue_key="ISSUE-2"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
-
- <!-- old open issues -->
- <issues id="3"
- kee="ISSUE-3"
- component_uuid="1"
- project_uuid="1"
- status="OPEN"
- issue_close_date="[null]"
- resolution="[null]"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="3"
- kee="[null]"
- issue_key="ISSUE-3"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
- <!-- recent open and closed issues -->
- <issues id="4"
- kee="ISSUE-4"
- component_uuid="100"
- project_uuid="1"
- status="OPEN"
- issue_close_date="[null]"
- resolution="[null]"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="4"
- kee="[null]"
- issue_key="ISSUE-4"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
- <issues id="5"
- kee="ISSUE-5"
- component_uuid="100"
- project_uuid="1"
- status="CLOSED"
- issue_close_date="1735686000000"
- resolution="FIXED"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="5"
- kee="[null]"
- issue_key="ISSUE-5"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
-</dataset>
diff --git a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_old_closed_issues-result.xml b/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_old_closed_issues-result.xml
deleted file mode 100644
index d7c45fc5c19..00000000000
--- a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_old_closed_issues-result.xml
+++ /dev/null
@@ -1,184 +0,0 @@
-<dataset>
-
- <projects organization_uuid="org1"
- uuid="P1"
- uuid_path="NOT_USED"
- enabled="[true]"
- root_id="[null]"
- created_at="[null]"
- long_name="[null]"
- scope="PRJ"
- qualifier="TRK"
- kee="project"
- name="project"
- description="[null]"
- private="[false]"
- language="java"
- copy_component_uuid="[null]"
- developer_uuid="[null]"
- authorization_updated_at="[null]"
- id="1"/>
-
- <snapshots id="1"
- uuid="u1"
- project_id="1"
- status="P"
- islast="[true]"
- purge_status="[null]"
- period1_mode="[null]"
- period1_param="[null]"
- period1_date="[null]"
- period2_mode="[null]"
- period2_param="[null]"
- period2_date="[null]"
- period3_mode="[null]"
- period3_param="[null]"
- period3_date="[null]"
- period4_mode="[null]"
- period4_param="[null]"
- period4_date="[null]"
- period5_mode="[null]"
- period5_param="[null]"
- period5_date="[null]"
- created_at="1228222680000"
- build_date="1228222680000"
- version="[null]"
- />
-
- <!-- old closed issues on file and project -> to be purged -->
- <!--
- <issues id="1" kee="ISSUE-1"
- component_uuid="100"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1262300400000"
- resolution="FIXED" line="200" severity="BLOCKER" reporter="[null]" assignee="arthur" rule_id="500" manual_severity="[false]"
- message="[null]" action_plan_key="[null]" gap="[null]" effort="[null]" issue_attributes="[null]" checksum="[null]" author_login="[null]"
- updated_at="[null]" issue_creation_date="1366063200000" issue_update_date="1366063200000" created_at="2013-04-16" locations="[null]"/>
- <issue_changes id="1" kee="[null]" issue_key="ISSUE-1" created_at="[null]" updated_at="[null]" user_login="admin" change_type="comment" change_data="abc" issue_change_creation_date="[null]"/>
-
- <issues id="2" kee="ISSUE-2"
- component_uuid="1"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1262300400000"
- resolution="FIXED" line="200" severity="BLOCKER" reporter="[null]" assignee="arthur" rule_id="500" manual_severity="[false]"
- message="[null]" action_plan_key="[null]" gap="[null]" effort="[null]" issue_attributes="[null]" checksum="[null]" author_login="[null]"
- updated_at="[null]" issue_creation_date="1366063200000" issue_update_date="1366063200000" created_at="2013-04-16" locations="[null]"/>
- <issue_changes id="2" kee="[null]" issue_key="ISSUE-2" created_at="[null]" updated_at="[null]" user_login="admin" change_type="comment" change_data="abc" issue_change_creation_date="[null]"/>
- -->
-
- <!-- old open issues -> do not purge -->
- <issues id="3"
- kee="ISSUE-3"
- component_uuid="1"
- project_uuid="P1"
- status="OPEN"
- issue_close_date="[null]"
- resolution="[null]"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- tags="[null]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="3"
- kee="[null]"
- issue_key="ISSUE-3"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
- <!-- recent open and closed issues -> do not purge -->
- <issues id="4"
- kee="ISSUE-4"
- component_uuid="100"
- project_uuid="P1"
- status="OPEN"
- issue_close_date="[null]"
- resolution="[null]"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- tags="[null]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="4"
- kee="[null]"
- issue_key="ISSUE-4"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
- <issues id="5"
- kee="ISSUE-5"
- component_uuid="100"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1735686000000"
- resolution="FIXED"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- tags="[null]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="5"
- kee="[null]"
- issue_key="ISSUE-5"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
-</dataset>
diff --git a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_old_closed_issues.xml b/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_old_closed_issues.xml
deleted file mode 100644
index 2d6ceed1865..00000000000
--- a/server/sonar-db-dao/src/test/resources/org/sonar/db/purge/PurgeDaoTest/should_delete_old_closed_issues.xml
+++ /dev/null
@@ -1,232 +0,0 @@
-<dataset>
-
- <projects organization_uuid="org1"
- uuid="P1"
- uuid_path="NOT_USED"
- enabled="[true]"
- root_uuid="P1"
- project_uuid="P1"
- created_at="[null]"
- long_name="[null]"
- scope="PRJ"
- qualifier="TRK"
- kee="project"
- name="project"
- description="[null]"
- private="[false]"
- language="java"
- copy_component_uuid="[null]"
- developer_uuid="[null]"
- authorization_updated_at="[null]"
- id="1"/>
-
- <snapshots id="1"
- uuid="u1"
- component_uuid="P1"
- status="P"
- islast="[true]"
- purge_status="[null]"
- period1_mode="[null]"
- period1_param="[null]"
- period1_date="[null]"
- period2_mode="[null]"
- period2_param="[null]"
- period2_date="[null]"
- period3_mode="[null]"
- period3_param="[null]"
- period3_date="[null]"
- period4_mode="[null]"
- period4_param="[null]"
- period4_date="[null]"
- period5_mode="[null]"
- period5_param="[null]"
- period5_date="[null]"
- created_at="1228222680000"
- build_date="1228222680000"
- version="[null]"
- />
-
- <!-- old closed issues on file and project -> to be purged -->
- <issues id="1"
- kee="ISSUE-1"
- component_uuid="100"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1262300400000"
- resolution="FIXED"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="1"
- kee="[null]"
- issue_key="ISSUE-1"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
- <issues id="2"
- kee="ISSUE-2"
- component_uuid="1"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1262300400000"
- resolution="FIXED"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"/>
- <issue_changes id="2"
- kee="[null]"
- issue_key="ISSUE-2"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
-
- <!-- old open issues -> do not purge -->
- <issues id="3"
- kee="ISSUE-3"
- component_uuid="1"
- project_uuid="P1"
- status="OPEN"
- issue_close_date="[null]"
- resolution="[null]"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="3"
- kee="[null]"
- issue_key="ISSUE-3"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
- <!-- recent open and closed issues -> do not purge -->
- <issues id="4"
- kee="ISSUE-4"
- component_uuid="100"
- project_uuid="P1"
- status="OPEN"
- issue_close_date="[null]"
- resolution="[null]"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="4"
- kee="[null]"
- issue_key="ISSUE-4"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
- <issues id="5"
- kee="ISSUE-5"
- component_uuid="100"
- project_uuid="P1"
- status="CLOSED"
- issue_close_date="1735686000000"
- resolution="FIXED"
- line="200"
- severity="BLOCKER"
- reporter="[null]"
- assignee="arthur"
- rule_id="500"
- manual_severity="[false]"
- message="[null]"
- action_plan_key="[null]"
- gap="[null]"
- effort="[null]"
- issue_attributes="[null]"
- checksum="[null]"
- author_login="[null]"
- updated_at="[null]"
- issue_creation_date="1366063200000"
- issue_update_date="1366063200000"
- created_at="1400000000000"
- locations="[null]"
- issue_type="[null]"/>
- <issue_changes id="5"
- kee="[null]"
- issue_key="ISSUE-5"
- created_at="[null]"
- updated_at="[null]"
- user_login="admin_uuid"
- change_type="comment"
- change_data="abc"
- issue_change_creation_date="[null]"/>
-
-</dataset>