![](\"http:\/\/1.bp.blogspot.com\/-cCSx6eM-mFw\/UpkFEf3c-zI\/AAAAAAAAAss\/mbQ7xWuvcUg\/s1600\/sonar3.jpg\")
<\/a><\/div>\nYou have created a PMD rule, now you need to move it to PMD Unit Tests group. Connect to Sonar’s MySQL database. Search for your rule by key:<\/p>\n
mysql> select id, plugin_rule_key, plugin_name, parent_id, status from rules where plugin_rule_key='XPathRule_1385721910';\r\n+-----+----------------------+----------------+-----------+-------------+\r\n| id | plugin_rule_key | plugin_name | parent_id | status |\r\n+-----+----------------------+----------------+-----------+-------------+\r\n| 903 | XPathRule_1385721910 | pmd | NULL | DEPRECATED |\r\n+-----+----------------------+----------------+-----------+-------------+\r\n1 row in set (0.00 sec)<\/pre>\nUpdate plugin_name<\/code> and status<\/code> (remember to use appropiate primary key for id<\/code> column):<\/p>\nmysql> update rules set plugin_name='pmd-unit-tests', status='READY' where id=903;\r\nQuery OK, 1 row affected (0.00 sec)\r\nRows matched: 1 Changed: 1 Warnings: 0<\/pre>\nThere is one step left. Sonar will change this rule’s status to REMOVED<\/code> on restart due to his boot checks. You need to trick him and change parent_id<\/code> to other’s PMD Unit Tests rule. List all these rules and choose one’s identifier.<\/p>\nmysql> select id, plugin_name, status from rules where plugin_name='pmd-unit-tests';\r\n+-----+----------------+---------+\r\n| id | plugin_name | status |\r\n+-----+----------------+---------+\r\n| 775 | pmd-unit-tests | READY |\r\n| 776 | pmd-unit-tests | READY |\r\n| 777 | pmd-unit-tests | READY |\r\n| 778 | pmd-unit-tests | READY |\r\n| 779 | pmd-unit-tests | READY |\r\n| 780 | pmd-unit-tests | READY |\r\n| 781 | pmd-unit-tests | READY |\r\n| 782 | pmd-unit-tests | READY |\r\n| 783 | pmd-unit-tests | READY |\r\n| 784 | pmd-unit-tests | READY |\r\n| 903 | pmd-unit-tests | READY |\r\n+-----+----------------+---------+\r\n11 rows in set (0.00 sec)\\<\/pre>\nChoose any id<\/code> you like, let’s say 775 and apply it as parent_id<\/code> to your newly created rule:<\/p>\nmysql> update rules set parent_id=775 where id=903;\r\nQuery OK, 1 row affected (0.00 sec)\r\nRows matched: 1 Changed: 1 Warnings: 0<\/pre>\nGo to your Quality profile and make sure your rule is active! Check it twice, it’s easy to forget that step. It’s all set up, enjoy your analysis!<\/p>\n","protected":false},"excerpt":{"rendered":"It’s a tutorial about creating new rules for SonarQube analysis to be applied to Unit Tests. It is not trivial and involves a few tricky database steps, so I want to share my tutorial about it.It’s a tutorial about creating new rules for SonarQube analysis to be applied to Unit Tests. It is not trivial and involves a few tricky database steps, so I want to share my tutorial about it.\n","protected":false},"author":37,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[353,68,482,30],"class_list":{"0":"post-11713","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-development-design","7":"tag-code-review","8":"tag-java","9":"tag-quality","10":"tag-testing"},"_links":{"self":[{"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/posts\/11713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/comments?post=11713"}],"version-history":[{"count":7,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/posts\/11713\/revisions"}],"predecessor-version":[{"id":14705,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/posts\/11713\/revisions\/14705"}],"wp:attachment":[{"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/media?parent=11713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/categories?post=11713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/touk.pl\/blog\/wp-json\/wp\/v2\/tags?post=11713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![](\"http:\/\/2.bp.blogspot.com\/-fIyiv77Yv3E\/UpxBMk5HqvI\/AAAAAAAAAtA\/C6ODvfURZ1c\/s1600\/sonar.png\")
<\/a> (formely Sonar) to manage our code quality. It is a great tool and I recommend everyone to set it up and read its reports.<\/p>\n![](\"http:\/\/1.bp.blogspot.com\/-JQ-N0Dr7kvY\/UpizTMua-II\/AAAAAAAAAsc\/cJkodS8J1tQ\/s1600\/sonar1.jpg\")
<\/a><\/div>\n