Re: Jenkins with a DB?

[Yogesh Harsh]

Hello Michael,

I am looking out for this solution as well, will you be able to help ? I 
want to get Jenkins jobs' data exported to a DB and then run some analytics 
through R.

Thank you in advance, please let me know.

Yogesh

On Tuesday, February 19, 2019 at 9:56:46 AM UTC+5:30, Michael Barbine wrote:
>
> I have some solutions to this depending on what you are trying to do and 
> would be happy to help. Feel free to send me an email with "Jenkins 
> Question" in the subject and I we can chat. 
>
> barbine...@gmail.com  
>
> On Friday, June 28, 2013 at 4:14:46 PM UTC-4, Michael Barbine wrote:
>>
>> Hello! 
>>
>> I'm looking for some input on a proven way to put all of the data 
>> contained in the Jenkins XML or API into a RDBMS. Doesn't matter which 
>> one... I can move it around later. 
>>
>> I found some plugins on the Jenkins site - any input on which is the 
>> best? 
>>
>> I have some ideas on developing my own way by using the MSSXML schema and 
>> dropping the config.xml, build.xml and job.xml into a repo for consumption. 
>> Early tests have been successful, but it's not as clean or secure as I'd 
>> like. 
>>
>>
>> THANK YOU IN ADVANCE for your input 
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/6580291a-70e9-4634-b2d8-25fca5be24cfo%40googlegroups.com.

Re: Jenkins with a DB?

[Michael Barbine]

I have some solutions to this depending on what you are trying to do and 
would be happy to help. Feel free to send me an email with "Jenkins 
Question" in the subject and I we can chat. 

barbine.mich...@gmail.com 

On Friday, June 28, 2013 at 4:14:46 PM UTC-4, Michael Barbine wrote:
>
> Hello! 
>
> I'm looking for some input on a proven way to put all of the data 
> contained in the Jenkins XML or API into a RDBMS. Doesn't matter which 
> one... I can move it around later. 
>
> I found some plugins on the Jenkins site - any input on which is the best? 
>
> I have some ideas on developing my own way by using the MSSXML schema and 
> dropping the config.xml, build.xml and job.xml into a repo for consumption. 
> Early tests have been successful, but it's not as clean or secure as I'd 
> like. 
>
>
> THANK YOU IN ADVANCE for your input 
>

-- 
You received this message because you are subscribed to the Google Groups 
"Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/5c707d79-8cf6-45bb-b28c-d8bf91216325%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins with a DB?

[David Karr]

On Tue, Jan 10, 2017 at 9:00 PM, Gauthami Thyagrajan
 wrote:
> HI Veena,
>
> Even i am trying to do the same. Have you got any solution for this?
>
> If you got can u please let me know.
>
> Thanks,
> Gauthami T
>
> On Monday, October 12, 2015 at 8:29:06 PM UTC+5:30, MV wrote:
>>
>>
 Hi Jonathan,
>>
>>
>> I am looking for ways to extract code coverage details from the jenkins
>> jobs latest build information (recent 10-15 builds) and export this data
>> into MySql database to use in various tasks. Your work resembles quite
>> similar to me. Could you please give some insight on this?
>>
>> Thank you,
>> Veena


>>>
>>> What do you mean by "all the data"? More importantly, what is the
>>> ultimate goal? I wrote a script which extracts job and build information via
>>> the Jenkins API and inserts/updates a PostgreSQL database so I could analyze
>>> it more easily. Is that similar to what you're trying to do?

This is basically what SonarQube provides.  Have you looked into that?

-- 
You received this message because you are subscribed to the Google Groups 
"Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/CAA5t8VrCzV-yuuUoX%2BVoB-NLw9YHA_Jf3XuWq5eid0FXzgeDCQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins with a DB?

[Gauthami Thyagrajan]

HI Veena,

Even i am trying to do the same. Have you got any solution for this?

If you got can u please let me know. 

Thanks,
Gauthami T

On Monday, October 12, 2015 at 8:29:06 PM UTC+5:30, MV wrote:
>
>
> Hi Jonathan,
>>>
>>
> I am looking for ways to extract code coverage details from the jenkins 
> jobs latest build information (recent 10-15 builds) and export this data 
> into MySql database to use in various tasks. Your work resembles quite 
> similar to me. Could you please give some insight on this?
>
> Thank you,
> Veena  
>
>>
>>>
>> What do you mean by "all the data"? More importantly, what is the 
>> ultimate goal? I wrote a script which extracts job and build information 
>> via the Jenkins API and inserts/updates a PostgreSQL database so I could 
>> analyze it more easily. Is that similar to what you're trying to do? 
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/e488aad6-2140-4b31-8f3b-126ec7ab7546%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins working with DB

[Виталий Фёдоров]

Greetings again,
Thank you for your answer, it is really helpful. I didnt get only 1 thing:
what code should I get from git and where to deploy it?
I mean, what should be in the git repo, some sort of sql files?
I need to create the simplest job, at least, for the beginning. Also, I
need to understand the workflow: git repo with (some sql files or I can use
any, rest api, for example) --> Jenkins take files, execute shell to use
sqitch (what commands should I execute?)--> where to deploy it? To database?
Hope, you will help me in this question,
Best regards,
Vitali

2016-09-02 21:06 GMT+03:00 Rachel :

> Hi,
>
> I evaluated Sqitch months ago and I think you can try to update databases
> from Jenkins, because of these reasons:
>
>- Jenkins includes Git Plugin to download code from Git repository.
>- Sqitch is based on shell commands and Jenkins includes possibility
>of writing them: Build > Execute shell. An option to execute Sqitch
>commands in Jenkins is to install Sqitch client with the same user you
>installed Jenkins (evaluate another options according to your environment).
>
> Finally, ensure database connection from Jenkins server.
>
> Please, tell me if you get it.
>
> Best regards,
> Rachel
>
>
> El miércoles, 31 de agosto de 2016, 15:13:54 (UTC+2), Виталий Фёдоров
> escribió:
>>
>> Greetings, post my question here, because no information found at all in
>> the net:
>> I have next workflow:
>> 1. User commit code to the git.
>> 2. User use tool sqitch (http://sqitch.org/) (not advertisement) for
>> helping commit sql files. Also this sqitch tracks which sql files need to
>> run before the other
>> 3. After it jenkins should deploy sql files from git in production and
>> update database
>> Is it real to update DB with Jenkins? I have some experience in working
>> with Jenkins, but have no idea, where to start in this task.
>> Best regards!
>>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Jenkins Users" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/jenkinsci-users/S-_nJYmLZdE/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> jenkinsci-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/jenkinsci-users/848c4fa7-1efc-4946-ae44-3d1c267d7f5d%40googlegroups.
> com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/CAJgSsbSYE2MQx90d_Z2cSFXCma5%3D1VjazFQ3rMT-YTrQu33bAQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins working with DB

[Rachel]

Hi, 

I evaluated Sqitch months ago and I think you can try to update databases 
from Jenkins, because of these reasons:

   - Jenkins includes Git Plugin to download code from Git repository.
   - Sqitch is based on shell commands and Jenkins includes possibility of 
   writing them: Build > Execute shell. An option to execute Sqitch commands 
   in Jenkins is to install Sqitch client with the same user you installed 
   Jenkins (evaluate another options according to your environment).
   
Finally, ensure database connection from Jenkins server.

Please, tell me if you get it.

Best regards,
Rachel


El miércoles, 31 de agosto de 2016, 15:13:54 (UTC+2), Виталий Фёдоров 
escribió:
>
> Greetings, post my question here, because no information found at all in 
> the net:
> I have next workflow:
> 1. User commit code to the git.
> 2. User use tool sqitch (http://sqitch.org/) (not advertisement) for 
> helping commit sql files. Also this sqitch tracks which sql files need to 
> run before the other
> 3. After it jenkins should deploy sql files from git in production and 
> update database
> Is it real to update DB with Jenkins? I have some experience in working 
> with Jenkins, but have no idea, where to start in this task. 
> Best regards!
>

-- 
You received this message because you are subscribed to the Google Groups 
"Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/848c4fa7-1efc-4946-ae44-3d1c267d7f5d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins with a DB?

[barbine.michael]

Hello!
Happy to help with that. Do you use Google hangouts or Skype? I'm at the office 
currently but one evening this week I can hop on and chat with you on that. 
I'm currently in central time. 





Sent on the new Sprint Network from my Samsung Galaxy S®4

 Original message 
From: MV <manasa.rap...@gmail.com> 
Date: 10/12/2015  9:59 AM  (GMT-06:00) 
To: Jenkins Users <jenkinsci-users@googlegroups.com> 
Subject: Re: Jenkins with a DB? 


Hi Jonathan,

I am looking for ways to extract code coverage details from the jenkins jobs 
latest build information (recent 10-15 builds) and export this data into MySql 
database to use in various tasks. Your work resembles quite similar to me. 
Could you please give some insight on this?
Thank you,Veena  

What do you mean by "all the data"? More importantly, what is the ultimate 
goal? I wrote a script which extracts job and build information via the Jenkins 
API and inserts/updates a PostgreSQL database so I could analyze it more 
easily. Is that similar to what you're trying to do? 




-- 

You received this message because you are subscribed to a topic in the Google 
Groups "Jenkins Users" group.

To unsubscribe from this topic, visit 
https://groups.google.com/d/topic/jenkinsci-users/wHxZ9dm-JE4/unsubscribe.

To unsubscribe from this group and all its topics, send an email to 
jenkinsci-users+unsubscr...@googlegroups.com.

To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/4c09e746-0c55-4ec2-a88e-1c735d3b547f%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/3jf0h32i9seugigyxdh1qpsf.1444664991969%40email.android.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins with a DB?

[MV]

> Hi Jonathan,
>>
>
I am looking for ways to extract code coverage details from the jenkins 
jobs latest build information (recent 10-15 builds) and export this data 
into MySql database to use in various tasks. Your work resembles quite 
similar to me. Could you please give some insight on this?

Thank you,
Veena  

>
>>
> What do you mean by "all the data"? More importantly, what is the ultimate 
> goal? I wrote a script which extracts job and build information via the 
> Jenkins API and inserts/updates a PostgreSQL database so I could analyze it 
> more easily. Is that similar to what you're trying to do? 
>

-- 
You received this message because you are subscribed to the Google Groups 
"Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/4c09e746-0c55-4ec2-a88e-1c735d3b547f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins with a DB?

[barbine.michael]

What time zone are you in? I'm free this evening east coast time and tomorrow 
in the afternoon. I can give you a walk through and the source code. 


Sent on the new Sprint Network from my Samsung Galaxy S®4

 Original message 
From: ankit chandak ankki...@gmail.com 
Date: 07/17/2015  6:59 AM  (GMT-05:00) 
To: jenkinsci-users@googlegroups.com 
Subject: Re: Jenkins with a DB? 

Michael,Thank you so much.Let me know when you get time.

On Thursday, 16 July 2015 20:41:08 UTC+5:30, Michael Barbine  wrote:

I've done this and can help thus weekend 


Sent on the new Sprint Network from my Samsung Galaxy S®4

 Original message 
From: Ankit Kumar leelma...@gmail.com 
Date: 07/16/2015  11:07 AM  (GMT-05:00) 
To: jenkins...@googlegroups.com 
Subject: Re: Jenkins with a DB? 

I want to extract Data from Jenkins for Builds and Job.Is there any way plugin 
or way from which I can build Database Schema by extracting jenkins data?

On Thursday, July 11, 2013 at 2:59:05 AM UTC+5:30, JonathanRRogers wrote:

On Friday, June 28, 2013 4:14:46 PM UTC-4, Michael Barbine wrote:Hello! 

I'm looking for some input on a proven way to put all of the data contained in 
the Jenkins XML or API into a RDBMS. Doesn't matter which one... I can move it 
around later. 


What do you mean by all the data? More importantly, what is the ultimate 
goal? I wrote a script which extracts job and build information via the Jenkins 
API and inserts/updates a PostgreSQL database so I could analyze it more 
easily. Is that similar to what you're trying to do? 




-- 

You received this message because you are subscribed to a topic in the Google 
Groups Jenkins Users group.

To unsubscribe from this topic, visit 
https://groups.google.com/d/topic/jenkinsci-users/wHxZ9dm-JE4/unsubscribe.

To unsubscribe from this group and all its topics, send an email to 
jenkinsci-use...@googlegroups.com.

To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/5000701a-3c77-4383-9871-8bbab89ff986%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.





-- 

You received this message because you are subscribed to a topic in the Google 
Groups Jenkins Users group.

To unsubscribe from this topic, visit 
https://groups.google.com/d/topic/jenkinsci-users/wHxZ9dm-JE4/unsubscribe.

To unsubscribe from this group and all its topics, send an email to 
jenkinsci-users+unsubscr...@googlegroups.com.

To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/c6e886e4-8640-4e2d-bdf8-daf3ce530dd3%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
Jenkins Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/5pytnimv7xg4203e11a01q9r.1437138411498%40email.android.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins with a DB?

[ankit chandak]

Michael,
Thank you so much.
Let me know when you get time.

On Thursday, 16 July 2015 20:41:08 UTC+5:30, Michael Barbine wrote:

 I've done this and can help thus weekend 



 Sent on the new Sprint Network from my Samsung Galaxy S®4


  Original message 
 From: Ankit Kumar leelma...@gmail.com javascript: 
 Date: 07/16/2015 11:07 AM (GMT-05:00) 
 To: jenkins...@googlegroups.com javascript: 
 Subject: Re: Jenkins with a DB? 

 I want to extract Data from Jenkins for Builds and Job.Is there any way 
 plugin or way from which I can build Database Schema by extracting jenkins 
 data?

 On Thursday, July 11, 2013 at 2:59:05 AM UTC+5:30, JonathanRRogers wrote:



 On Friday, June 28, 2013 4:14:46 PM UTC-4, Michael Barbine wrote:

 Hello! 

 I'm looking for some input on a proven way to put all of the data 
 contained in the Jenkins XML or API into a RDBMS. Doesn't matter which 
 one... I can move it around later. 


 What do you mean by all the data? More importantly, what is the 
 ultimate goal? I wrote a script which extracts job and build information 
 via the Jenkins API and inserts/updates a PostgreSQL database so I could 
 analyze it more easily. Is that similar to what you're trying to do? 

  -- 
 You received this message because you are subscribed to a topic in the 
 Google Groups Jenkins Users group.
 To unsubscribe from this topic, visit 
 https://groups.google.com/d/topic/jenkinsci-users/wHxZ9dm-JE4/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to 
 jenkinsci-use...@googlegroups.com javascript:.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/jenkinsci-users/5000701a-3c77-4383-9871-8bbab89ff986%40googlegroups.com
  
 https://groups.google.com/d/msgid/jenkinsci-users/5000701a-3c77-4383-9871-8bbab89ff986%40googlegroups.com?utm_medium=emailutm_source=footer
 .
 For more options, visit https://groups.google.com/d/optout.


-- 
You received this message because you are subscribed to the Google Groups 
Jenkins Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/c6e886e4-8640-4e2d-bdf8-daf3ce530dd3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins with a DB?

[Ankit Kumar]

I am from India. Indian Standard Time is 9 hours and 30 minutes ahead of 
Eastern Time. 
I will be available tomorrow morning your time,just let me know what is the 
best time suited for you. 

-- 
You received this message because you are subscribed to the Google Groups 
Jenkins Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/8240332f-5712-4429-a10c-2200b2cadb19%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins with a DB?

[Ankit Kumar]

I want to extract Data from Jenkins for Builds and Job.Is there any way 
plugin or way from which I can build Database Schema by extracting jenkins 
data?

On Thursday, July 11, 2013 at 2:59:05 AM UTC+5:30, JonathanRRogers wrote:



 On Friday, June 28, 2013 4:14:46 PM UTC-4, Michael Barbine wrote:

 Hello! 

 I'm looking for some input on a proven way to put all of the data 
 contained in the Jenkins XML or API into a RDBMS. Doesn't matter which 
 one... I can move it around later. 


 What do you mean by all the data? More importantly, what is the ultimate 
 goal? I wrote a script which extracts job and build information via the 
 Jenkins API and inserts/updates a PostgreSQL database so I could analyze it 
 more easily. Is that similar to what you're trying to do? 


-- 
You received this message because you are subscribed to the Google Groups 
Jenkins Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/5000701a-3c77-4383-9871-8bbab89ff986%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins with a DB?

[barbine.michael]

I've done this and can help thus weekend 


Sent on the new Sprint Network from my Samsung Galaxy S®4

 Original message 
From: Ankit Kumar leelma.an...@gmail.com 
Date: 07/16/2015  11:07 AM  (GMT-05:00) 
To: jenkinsci-users@googlegroups.com 
Subject: Re: Jenkins with a DB? 

I want to extract Data from Jenkins for Builds and Job.Is there any way plugin 
or way from which I can build Database Schema by extracting jenkins data?

On Thursday, July 11, 2013 at 2:59:05 AM UTC+5:30, JonathanRRogers wrote:

On Friday, June 28, 2013 4:14:46 PM UTC-4, Michael Barbine wrote:Hello! 

I'm looking for some input on a proven way to put all of the data contained in 
the Jenkins XML or API into a RDBMS. Doesn't matter which one... I can move it 
around later. 


What do you mean by all the data? More importantly, what is the ultimate 
goal? I wrote a script which extracts job and build information via the Jenkins 
API and inserts/updates a PostgreSQL database so I could analyze it more 
easily. Is that similar to what you're trying to do? 




-- 

You received this message because you are subscribed to a topic in the Google 
Groups Jenkins Users group.

To unsubscribe from this topic, visit 
https://groups.google.com/d/topic/jenkinsci-users/wHxZ9dm-JE4/unsubscribe.

To unsubscribe from this group and all its topics, send an email to 
jenkinsci-users+unsubscr...@googlegroups.com.

To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/5000701a-3c77-4383-9871-8bbab89ff986%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
Jenkins Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jenkinsci-users/im0ysm1scs7pde2lw6vf5t5m.1437059450653%40email.android.com.
For more options, visit https://groups.google.com/d/optout.

Re: Jenkins with a DB?

[JonathanRRogers]

On Friday, June 28, 2013 4:14:46 PM UTC-4, Michael Barbine wrote:

 Hello! 

 I'm looking for some input on a proven way to put all of the data 
 contained in the Jenkins XML or API into a RDBMS. Doesn't matter which 
 one... I can move it around later. 


What do you mean by all the data? More importantly, what is the ultimate 
goal? I wrote a script which extracts job and build information via the 
Jenkins API and inserts/updates a PostgreSQL database so I could analyze it 
more easily. Is that similar to what you're trying to do? 

-- 
You received this message because you are subscribed to the Google Groups 
Jenkins Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Jenkins with a DB?

[JonathanRRogers]

On Sunday, June 30, 2013 5:57:30 PM UTC-4, R Tyler Croy wrote:


 On Fri, 28 Jun 2013, Michael Barbine wrote: 

  Hello! 
  
  I'm looking for some input on a proven way to put all of the data 
 contained 
  in the Jenkins XML or API into a RDBMS. Doesn't matter which one... I 
 can 
  move it around later. 
  
  I found some plugins on the Jenkins site - any input on which is the 
 best? 
  
  I have some ideas on developing my own way by using the MSSXML schema 
 and 
  dropping the config.xml, build.xml and job.xml into a repo for 
 consumption. 
  Early tests have been successful, but it's not as clean or secure as I'd 
  like. 



 Have you considered looking at some of the recent database plugins that 
 have 
 been developed instead? That way Jenkins would be storing its information 
 in 
 the DB from the beginning. 

 See: 

  * https://wiki.jenkins-ci.org/display/JENKINS/MySQL+Database+Plugin 
  * https://wiki.jenkins-ci.org/display/JENKINS/PostgreSQL+Database+Plugin 



 I'm not sure how well used/supported these are however. 


The Database Plugin, which depends on the MySQL or Postgres or some other 
Database Plugin, does not change anything about how existing Jenkins data 
is stored. It looks like it mainly provides a configuration framework for 
other plugins which need to use an RDBMS for their own data. Such a plugin 
could use the Database Plugin to implement the data export or 
synchronization Michael Barbine wants but I don't know if such a plugin 
exists yet.

-- 
You received this message because you are subscribed to the Google Groups 
Jenkins Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Jenkins with a DB?

[Ballantyne, Bob]

This sounds remarkably similar to a task on my current 'to-do' list. Even the 
PostgresQL db and the analysts use case.  I had intended using Groovy.

Any chance if posting this somewhere on the Jenkins plugin site, or on 
Scriptler? I'm sure there are probably many others who would be VERY interested.


On Jul 10, 2013, at 5:29 PM, JonathanRRogers 
jonathanrrog...@gmail.commailto:jonathanrrog...@gmail.com wrote:



On Friday, June 28, 2013 4:14:46 PM UTC-4, Michael Barbine wrote:
Hello!

I'm looking for some input on a proven way to put all of the data contained in 
the Jenkins XML or API into a RDBMS. Doesn't matter which one... I can move it 
around later.


What do you mean by all the data? More importantly, what is the ultimate 
goal? I wrote a script which extracts job and build information via the Jenkins 
API and inserts/updates a PostgreSQL database so I could analyze it more 
easily. Is that similar to what you're trying to do?

--
You received this message because you are subscribed to the Google Groups 
Jenkins Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
jenkinsci-users+unsubscr...@googlegroups.commailto:jenkinsci-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


-- 
You received this message because you are subscribed to the Google Groups 
Jenkins Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Jenkins with a DB?

[Jonathan Rogers]

Yes, I'm quite willing to share the simple script I wrote. Keep in mind
that it is not a general solution, but addressed my needs in a very
specific Jenkins setup. The Python script relies on the psycopg2 library
to talk to Postgres and the jenkinsapi package to talk to Jenkins.

Put all attached files in the same directory. First, you will need to
create your Postgres database. The SQL statements in jenkins_schema.sql
should do this for you if you run it via psql. You will certainly want
to modify TEST_JOB_RE to match the job names you're interested in or
simply remove the job name check to get all of them.

You will need to modify the Postgres username and password hard coded in
update_build_db.py and the Jenkins URL and credentials in jenkins.ini.
Then, you should be able to run update_build_db.py as a script to update
your Postgres db with job and build information from Jenkins.


Ballantyne, Bob wrote:
 This sounds remarkably similar to a task on my current 'to-do' list.
 Even the PostgresQL db and the analysts use case.  I had intended
 using Groovy. 

 Any chance if posting this somewhere on the Jenkins plugin site, or on
 Scriptler? I'm sure there are probably many others who would be VERY
 interested. 


 On Jul 10, 2013, at 5:29 PM, JonathanRRogers
 jonathanrrog...@gmail.com mailto:jonathanrrog...@gmail.com wrote:



 On Friday, June 28, 2013 4:14:46 PM UTC-4, Michael Barbine wrote:

 Hello!

 I'm looking for some input on a proven way to put all of the data
 contained in the Jenkins XML or API into a RDBMS. Doesn't matter
 which one... I can move it around later.


 What do you mean by all the data? More importantly, what is the
 ultimate goal? I wrote a script which extracts job and build
 information via the Jenkins API and inserts/updates a PostgreSQL
 database so I could analyze it more easily. Is that similar to what
 you're trying to do?
 -- 
 You received this message because you are subscribed to the Google
 Groups Jenkins Users group.
 To unsubscribe from this group and stop receiving emails from it,
 send an email to jenkinsci-users+unsubscr...@googlegroups.com
 mailto:jenkinsci-users+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.
  
  
 -- 
 You received this message because you are subscribed to a topic in the
 Google Groups Jenkins Users group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/jenkinsci-users/wHxZ9dm-JE4/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 jenkinsci-users+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.
  
  


-- 
Jonathan Rogers

-- 
You received this message because you are subscribed to the Google Groups 
Jenkins Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jenkinsci-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: build; Type: TABLE; Schema: public; Owner: social; Tablespace: 
--

CREATE TABLE build (
job text NOT NULL,
id bigint NOT NULL,
duration interval NOT NULL,
began timestamp with time zone NOT NULL,
status text NOT NULL,
node_name text NOT NULL
);


ALTER TABLE public.build OWNER TO social;

--
-- Name: job; Type: TABLE; Schema: public; Owner: social; Tablespace: 
--

CREATE TABLE job (
job text NOT NULL,
branch text NOT NULL
);


ALTER TABLE public.job OWNER TO social;

--
-- Name: test; Type: TABLE; Schema: public; Owner: social; Tablespace: 
--

CREATE TABLE test (
id bigint NOT NULL,
job text NOT NULL,
build_id bigint,
classname text NOT NULL,
name text NOT NULL,
duration interval NOT NULL,
errordetails text,
errorstacktrace text,
status text NOT NULL,
stdout text,
stderr text
);


ALTER TABLE public.test OWNER TO social;

--
-- Name: test_id_seq; Type: SEQUENCE; Schema: public; Owner: social
--

CREATE SEQUENCE test_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;


ALTER TABLE public.test_id_seq OWNER TO social;

--
-- Name: test_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: social
--

ALTER SEQUENCE test_id_seq OWNED BY test.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: social
--

ALTER TABLE ONLY test ALTER COLUMN id SET DEFAULT 

Re: Jenkins with a DB?

[R. Tyler Croy]

On Fri, 28 Jun 2013, Michael Barbine wrote:

 Hello! 
 
 I'm looking for some input on a proven way to put all of the data contained 
 in the Jenkins XML or API into a RDBMS. Doesn't matter which one... I can 
 move it around later. 
 
 I found some plugins on the Jenkins site - any input on which is the best? 
 
 I have some ideas on developing my own way by using the MSSXML schema and 
 dropping the config.xml, build.xml and job.xml into a repo for consumption. 
 Early tests have been successful, but it's not as clean or secure as I'd 
 like. 



Have you considered looking at some of the recent database plugins that have
been developed instead? That way Jenkins would be storing its information in
the DB from the beginning.

See:

 * https://wiki.jenkins-ci.org/display/JENKINS/MySQL+Database+Plugin
 * https://wiki.jenkins-ci.org/display/JENKINS/PostgreSQL+Database+Plugin


I'm not sure how well used/supported these are however.

- R. Tyler Croy
--
Code: https://github.com/rtyler
 Chatter: https://twitter.com/agentdero


signature.asc
Description: Digital signature