2sql - turn a newline or whitespace-separated list into an SQL set/tuple/list literal

2sql

#!/usr/bin/env ruby

# 112
# 114
# 531
#
# =>
#
# (112,114,531)
#
# Intended for copy-and-paste into SQL statements
# E.g. vim via:  %!2sql

items = STDIN.read.strip.split
if items.all?{|x| x =~ /^[0-9]+$/}
  # they're fine raw, use as integers
else
  # make them string literals
  # um not sure what the single quote escape rule is
  items = items.map{|x| x.gsub("'", "\\'") }
  items = items.map{|x| "'#{x}'" }
end

puts "(" + items.join(",") + ")"