SQL query for a Projects coverage metrics

SonarQube
1

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
  • what are you trying to achieve
  • what have you tried so far to achieve this

SonarQube v. 6.7.5
I’m trying to get the SQL query for the coverage metrics for a project. So far I have the data from the following tables Projects, Project_Measures, and Metrics.

But I’m not getting the same data from the query that I see for a project in sonarqube.

2

We don’t recommend querying the database directly, and don’t provide any advice on queries. Why not use the Web API (documentation linked in the footer of your instance)? Happy to answer any questions about pulling info using that means.

3

We are using grafana to aggregate and display data using queries. Do you provide the schema mapping for this version of sonar, just in case I still need to go into this direction because unfortunately, Grafana doesn’t support API calls.

4

We don’t publicly document the schema. It should be treated as a blackbox.

That said, our Web API is very well documented and follows consistent deprecation strategies when we make changes.

A quick google search showed me the following: https://community.grafana.com/t/how-to-import-rest-api-data/5772/2 / https://grafana.com/plugins/grafana-simple-json-datasource

5

hi Colin
there is a chart to see how many unit test cases were added recently. i need that data but also broken by user. so how many new test cases each contributor add during a week.
can i do it through regular UI, can i query Sonar DB or that is not possible?
thank you
Mike