■

PHPでSQL直叩きするときにカラム数分いろいろ書くのがうざいので変なものを作ってみました。

# mysql insert generator

if (ARGV.length != 2)
	print "mysql insert generator\n"
	print "usage: [this] [tablename] [number]\n"
	exit
end

tablename = ARGV.shift
count = ARGV.shift.to_i
i = 0

print "\n"

print "INSERT INTO #{tablename} VALUES (NULL"
for i in 1 .. count do
	print ", ?"
end
print ")\n"
print "\n"

# mysql/php post variable generator

if (ARGV.length == 0)
	print "mysql/php post variable generator\n"
	print "usage: [this] [columnname1]...\n"
	exit
end

i = 0
dataout = ""
columnout = ""

print "\n"

columnout += "$column_name = array("
dataout += "$data = array("
while arg = ARGV.shift do
	if i != 0 then
		dataout += ", "
		columnout += ", "
	end
	columnout += "\"#{arg}\""
	dataout += "$_POST[\"#{arg}\"]"
	i += 1
end
columnout += ");\n"
dataout += ");\n"

print columnout + dataout
print "\n"

# php array wrapper

if (ARGV.length == 0)
	print "php array wrapper\n"
	print "usage: [this] [string1]...\n"
	exit
end

i = 0
columnout = ""

print "\n"

columnout += "$array = array("
while arg = ARGV.shift do
	if i != 0 then
		columnout += ", "
	end
	columnout += "\"#{arg}\""
	i += 1
end
columnout += ");\n"

print columnout
print "\n"