Kouhei Sutou
null+****@clear*****
Sun May 17 18:04:27 JST 2015
Kouhei Sutou 2015-05-17 18:04:27 +0900 (Sun, 17 May 2015) New Revision: c2a8d4e6086e43df8eda1b22a4adadacc5f9f9c2 https://github.com/droonga/wikipedia-search/commit/c2a8d4e6086e43df8eda1b22a4adadacc5f9f9c2 Message: Fix converted SQL Modified files: lib/wikipedia-search/sql-converter.rb Modified: lib/wikipedia-search/sql-converter.rb (+5 -3) =================================================================== --- lib/wikipedia-search/sql-converter.rb 2015-05-17 18:03:18 +0900 (19353a4) +++ lib/wikipedia-search/sql-converter.rb 2015-05-17 18:04:27 +0900 (59ff70b) @@ -10,7 +10,7 @@ module WikipediaSearch class SQLListener < Listener private def on_start - @output.puts("INSERT INTO pages VALUES (id, title, text)") + @output.puts("INSERT INTO wikipedia (id, title, text) VALUES") end def on_finish @@ -29,15 +29,17 @@ module WikipediaSearch end def escape_string(string) - escaped_content = string.gsub(/["\\\n]/) do |special_character| + escaped_content = string.gsub(/['\\\n]/) do |special_character| case special_character when "\n" "\\n" + when "'" + "''" else "\\#{special_character}" end end - "\"#{escaped_content}\"" + "'#{escaped_content}'" end end end -------------- next part -------------- HTML����������������������������...Download