fork(2) download
copy 
  1. def sqlStr = 'SELECT * FROM mySchema.myTable WHERE id IN ('
  2. def listStr ='1,2 , 3, 50'
  3.  
  4. def executeQuery(String queryInList, String query){
  5. 	def values = queryInList.split(',')*.trim()
  6. 	def listOfQuestions = values?.inject([]){ list, it -> list << '?';list }.join(',')
  7. 	query += listOfQuestions + ')'
  8. 	println "Executing generated query: $query "
  9. 	//def result = sql.rows(query, values)
  10. 	//return result
  11. }
  12. executeQuery(listStr, sqlStr)
Success #stdin #stdout 1.15s 85544KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Executing generated query: SELECT * FROM mySchema.myTable WHERE id IN (?,?,?,?)
https://ideone.com/yWFoAn
language:
Groovy (groovy 2.5.6)
created:
7 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!