import java.sql.Connection
import java.sql.DriverManager
import javax.sql.DataSource
import groovy.sql.Sql
import solid.jdbc.SolidDriver

class queryWCS {

	static void main(args) {
		Class.forName("solid.jdbc.SolidDriver");
	    Connection conn = DriverManager.getConnection('jdbc:solid://wcs:1315/lala/lala');


		Sql sql = new Sql(conn);
	    		String sQuery = "SELECT lrad.lradname as name,lradif.channelnumber as channel,lradif.previouschannelnumber as prevchannel,lradif.powerlevel as power,lradif.lastchannelupdatetime as lastchannelupdatetime " +
				" FROM LRADIF,lrad where lradif.macaddress=lrad.macaddress and lradif.iftype=2 " +
				"order by lradif.lastchannelupdatetime";
	     sql.eachRow(sQuery){ row |
	        println row.name + " " + row.channel + " " + row.prevchannel
	     }
	}
}