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 <[email protected]>: > 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 > [email protected]. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/jenkinsci-users/848c4fa7-1efc-4946-ae44-3d1c267d7f5d%40googlegroups. > com > <https://groups.google.com/d/msgid/jenkinsci-users/848c4fa7-1efc-4946-ae44-3d1c267d7f5d%40googlegroups.com?utm_medium=email&utm_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 [email protected]. 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.
