[sonar-db] Sonar Database Scheme

[ivansun]

Hello Everyone,

 

I am working on a project which requires the query of the sonar database. Generally speaking, I need to find out the number of violations per project per day. Does anyone have the idea of how to do this? If no, can someone show me where I can find the sonar database scheme?

 

Many Thanks!!

 

Ivan

 

[benoit.lorant]

Hi Ivan,

 

Did you install a database (mysql, Oracle,…) when installing Sonar?

 

Benoit

 

From: Sun, Ivan [mailto:[hidden email]]
Sent: Wednesday, June 27, 2012 6:33 PM
To: [hidden email]
Subject: [sonar-user] [sonar-db] Sonar Database Scheme

 

Hello Everyone,

 

I am working on a project which requires the query of the sonar database. Generally speaking, I need to find out the number of violations per project per day. Does anyone have the idea of how to do this? If no, can someone show me where I can find the sonar database scheme?

 

Many Thanks!!

 

Ivan

 

[David Racodon-2]

Hi,

Just out of curiosity, what is your use case that you would need to query the Sonar database?

You can also have a look at the Web Services API to retrieve data from the Sonar database: http://docs.codehaus.org/display/SONAR/Web+Service+API

Regards,

David RACODON | SonarSource
Senior Consultant

http://sonarsource.com

On 28 June 2012 11:46, <[hidden email]> wrote:

Hi Ivan,

 

Did you install a database (mysql, Oracle,…) when installing Sonar?

 

Benoit

 

From: Sun, Ivan [mailto:[hidden email]]
Sent: Wednesday, June 27, 2012 6:33 PM
To: [hidden email]
Subject: [sonar-user] [sonar-db] Sonar Database Scheme

 

Hello Everyone,

 

I am working on a project which requires the query of the sonar database. Generally speaking, I need to find out the number of violations per project per day. Does anyone have the idea of how to do this? If no, can someone show me where I can find the sonar database scheme?

 

Many Thanks!!

 

Ivan

 

[Patroklos Papapetrou]

Hi Ivan

What's your case?

I think Sonar gives you all the information you need!

Regards

Patroklos

2012/6/28 <[hidden email]>

Hi Ivan,

 

Did you install a database (mysql, Oracle,…) when installing Sonar?

 

Benoit

 

From: Sun, Ivan [mailto:[hidden email]]
Sent: Wednesday, June 27, 2012 6:33 PM
To: [hidden email]
Subject: [sonar-user] [sonar-db] Sonar Database Scheme

 

Hello Everyone,

 

I am working on a project which requires the query of the sonar database. Generally speaking, I need to find out the number of violations per project per day. Does anyone have the idea of how to do this? If no, can someone show me where I can find the sonar database scheme?

 

Many Thanks!!

 

Ivan