Is there a Jenkins Plug In for this Or Can I Create My Own Or ...

[ABostonGal ABostonGal]

Hi all - wondering if there is or if I could create a Jenkins plugin that could do database admin tasks such as restore, backup and archive databases? Right now this is a semi-automated process that depends on the user having a Eclipse workspace with the test source code. Also the current script in the source code only allows alteration of one database at a time; I want to be able to run this process from Jenkins and also do restores, backups and archives on multiple databases...

Thanks!

[ABostonGal ABostonGal]

I should clarify that when the tests run in Jenkins there is a script that restores the databases when the tests are done using their specific database; however I want something in Jenkins users can use to trigger a batch restore process AND  a batch backup and archive process...

[ABostonGal ABostonGal]

I see I can add a freestyle project and add a windows batch file command... looking into but welcome ideas!

On Thursday, December 7, 2017 at 8:38:39 PM UTC-5, ABostonGal ABostonGal wrote:

[Stephen Connolly]

On Fri 8 Dec 2017 at 12:36, ABostonGal ABostonGal <abost...@gmail.com> wrote:

I see I can add a freestyle project and add a windows batch file command... looking into but welcome ideas!

So how can you best test/debug the backup/restore/archive functionality?

If you use a Jenkins specific step, the only way to test is to run Jenkins jobs.

If you have a script you can run on your own machine, test/debug becomes easier.

To my mind, a Jenkins specific plugin should be about *reporting* what your build has done...

For example, you should not have a Jenkins plugin to *run* junit tests, but rather a plugin that *reports* the test results... oh look, that’s what there is.

So the question is really, what do you need to report about this restore/backup/archive of databases, and *if* anything other than success/failure *then* go looking for a plugin to assist (eg html publisher plugin could publish a report of the execution if the results can be formatted as html, etc)

Do not think “just running a shell script/batch file” is a failed Jenkins integration of your business requirements... it is enhancing your testability and debugability... Jenkins then provides the traceability by recording the actual use of those scripts as well as the coordination by orchestrating the execution within a larger sequence of tasks

On Thursday, December 7, 2017 at 8:38:39 PM UTC-5, ABostonGal ABostonGal wrote:

Hi all - wondering if there is or if I could create a Jenkins plugin that could do database admin tasks such as restore, backup and archive databases? Right now this is a semi-automated process that depends on the user having a Eclipse workspace with the test source code. Also the current script in the source code only allows alteration of one database at a time; I want to be able to run this process from Jenkins and also do restores, backups and archives on multiple databases...

Thanks!

--
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-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/2b63a005-7a6b-465d-80ac-d584a45220df%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Sent from my phone