Method: SQL#guess_base

Defined in:
lib/DrbDB/MyMultiSQL.rb

#guess_base(query) ⇒ Object



94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
# File 'lib/DrbDB/MyMultiSQL.rb', line 94

def guess_base(query)
	sql=String.new(query)
	sql=sql+" \r\n"
	llength=sql.length
	while (sql.gsub!("`"," ")) and sql.length != llength do llength=sql.length end
	while (sql.gsub!("\r\n"," ")) and sql.length != llength do llength=sql.length end
	while (sql.gsub!("\n"," ")) and sql.length != llength do llength=sql.length end
	while (sql.gsub!("  "," ")) and sql.length != llength do llength=sql.length end

	if fi=top_level(sql,"from")
		fi=sql.index(" ",fi+"from".length)+1
		ret=sql[fi .. sql.index(" ",fi)-1]
		else
		ret=nil
	end
	ret
end