diff --git a/mycgi/gomi.rb b/mycgi/gomi.rb index 31914cd..b26a3ee 100755 --- a/mycgi/gomi.rb +++ b/mycgi/gomi.rb @@ -7,7 +7,7 @@ require 'sqlite3' c = CGI.new(:accept_charset => "UTF-8") csv = CSV.read("gomi.csv", headers:true) -db = SQLite3::Database.new("gomi.sq3") +db = SQLite3::Database.new("tmpdb/gomi.sq3") db.execute_batch(<<~EOF) DROP TABLE IF EXISTS gomi; CREATE TABLE IF NOT EXISTS gomi(name text,type text,remark text,kana text,kata text,roma text); @@ -32,6 +32,6 @@ result.each{|row| printf("
品名 : 「%s」
ごみ区分 : 「%s」

備考 : %s
-------------------------------------------------------------------------------",row["name"], row["type"], row["remark"])} print "\n" -print "" +print "" end db.execute("END;") \ No newline at end of file diff --git a/mycgi/gomi.sq3 b/mycgi/gomi.sq3 index 75e4ea0..c3b8df9 100644 --- a/mycgi/gomi.sq3 +++ b/mycgi/gomi.sq3 Binary files differ diff --git a/mycgi/tmpdb/gomi.sq3 b/mycgi/tmpdb/gomi.sq3 index 0b9015f..2651adb 100644 --- a/mycgi/tmpdb/gomi.sq3 +++ b/mycgi/tmpdb/gomi.sq3 Binary files differ