OracleではIN句に1000件しか入れられないので1000件ごとに切る

gistfile1.coffee

createInQuery = (column, list) ->
  max = 1000
  queries = []
  i = 0
  while i < Math.ceil list.length / max
    end = if list.length < (i + 1) * max then list.length else (i + 1) * max
    val = list
      .slice i * max, end
      .join "','"
    queries.push "#{column} IN('#{val}')"
    i++
  result = queries.join " OR "
  "(#{result})"