Hi Michael, On Samstag, 8. November 2014, Michael Tautschnig wrote: > Have you considered running a groovy script instead of an external shell > script? This may make things easier not really, as I'm not at all groovy with groovy, IOW, I hardly know what it is :) > /avoid the external script dependency. which dependency? > Here's what I'm doing: > > manager.hudson.class.classLoader.addURL(new > URL("file:///usr/share/java/postgresql-jdbc4.jar")) > > import groovy.sql.Sql; > > def sql = > Sql.newInstance("jdbc:postgresql://public-udd-mirror.xvm.mit.edu:5432/udd" > , "public-udd-mirror", "public-udd-mirror", "org.postgresql.Driver") > > def check_res = \ > sql.firstRow("SELECT count(*) \ > FROM bugs INNER JOIN bugs_usertags USING (id) \ > WHERE bugs_usertags.email = 'mt@debian.org' AND > bugs_usertags.tag = 'goto-cc'") assert check_res.count != null && > check_res.count > 0, 'Could not select any bug reports' > > (and then some more SQL queries) I don't how this is any better than shell, really. (But I'd be glad to learn...) cheers, Holger
Attachment:
signature.asc
Description: This is a digitally signed message part.