3memo2sqlite.rb

require 'rubygems'
require 'logger'
require 'active_record'

# ActiveRecord::Base.logger = Logger.new(STDERR)
# ActiveRecord::Base.colorize_logging = false

if File.exist?("3memo.sqlite3") then
  File.delete("3memo.sqlite3")
end

ActiveRecord::Base.establish_connection(
  :adapter => 'sqlite3',
  :database => '3memo.sqlite3'
)

ActiveRecord::Schema.define do
  create_table :entries do |table|
    table.column :key, :text
    table.column :url, :text
    table.column :date, :text
    table.column :title, :text
  end
end

class Entry < ActiveRecord::Base
end

File.open("3memo.txt"){ |f|
  f.each { |line|
    line.chomp!
    (key,url,date,title) = line.split(/\t/);
    Entry.create(
                 :key => key,
                 :url => url,
                 :date => date,
                 :title => title
                 )
  }
}

entries = Entry.find(:all)
entries.each { |entry|
  puts entry.title
}