import com.labvantage.sapphire.util.groovy.*
import groovy.sql.Sql

// Get connection information stored as comma delimited string from pseudo query definition
def GetSDIStringprops = [sdcid: "Query", keyid1: "GroovySQLConnection", keyid2: "Task", columnid: "whereclause", value: ""]
processAction(GetSDIString.ID, GetSDIStringprops)
connParms = GetSDIStringprops.value.split(',')
def sql = Sql.newInstance(connParms[0], connParms[1], connParms[2], connParms[3])

query = """SELECT TOP 100 smp.s_sampleid FROM s_sample smp
JOIN s_samplefamily sf ON sf.s_samplefamilyid = smp.samplefamilyid
WHERE sf.sstudyid = 'ALSPAC' AND smp.sampletypeid = 'Serum' AND storagestatus <> 'Disposed' """

logger.info("query:" + query)

while (sql.firstRow(query) != null) {
	ArrayList list = []

	sql.eachRow(query) { curRow ->
		list << curRow.s_sampleid
	}

	logger.info(list.join(";"))

	def props = [
		sdcid: "Sample",
		keyid1: list.join(";"),
		sampletypeid: "DNA"
	]
	logger.info("Calling props with properties: " + props.toString())
	processAction(EditSDI.ID, props)
}

sql.close()
return true