def sqlStr = 'SELECT * FROM mySchema.myTable WHERE id IN ('
def listStr ='1,2 , 3, 50'
def executeQuery(String queryInList, String query){
def values = queryInList.split(',')*.trim()
def listOfQuestions = values?.inject([]){ list, it -> list << '?';list }.join(',')
query += listOfQuestions + ')'
println "Executing generated query: $query "
//def result = sql.rows(query, values)
//return result
}
executeQuery(listStr, sqlStr)
ZGVmIHNxbFN0ciA9ICdTRUxFQ1QgKiBGUk9NIG15U2NoZW1hLm15VGFibGUgV0hFUkUgaWQgSU4gKCcKZGVmIGxpc3RTdHIgPScxLDIgLCAzLCA1MCcKCmRlZiBleGVjdXRlUXVlcnkoU3RyaW5nIHF1ZXJ5SW5MaXN0LCBTdHJpbmcgcXVlcnkpewoJZGVmIHZhbHVlcyA9IHF1ZXJ5SW5MaXN0LnNwbGl0KCcsJykqLnRyaW0oKQoJZGVmIGxpc3RPZlF1ZXN0aW9ucyA9IHZhbHVlcz8uaW5qZWN0KFtdKXsgbGlzdCwgaXQgLT4gbGlzdCA8PCAnPyc7bGlzdCB9LmpvaW4oJywnKQoJcXVlcnkgKz0gbGlzdE9mUXVlc3Rpb25zICsgJyknCglwcmludGxuICJFeGVjdXRpbmcgZ2VuZXJhdGVkIHF1ZXJ5OiAkcXVlcnkgIgoJLy9kZWYgcmVzdWx0ID0gc3FsLnJvd3MocXVlcnksIHZhbHVlcykKCS8vcmV0dXJuIHJlc3VsdAp9CmV4ZWN1dGVRdWVyeShsaXN0U3RyLCBzcWxTdHIp