dic

#!/usr/bin/env ruby
# -*- coding: utf-8 -*-

# Please add INDEX to speedup the SQL queries which use LIKE clauses:
#
#   sqlite3 "#{DICT_FILE}" 'CREATE INDEX dict_key ON dict (key COLLATE NOCASE);'

SQLITE     = "sqlite3"
DICT_FILE  = "'#{ENV['HOME']}/sys/lib/Dic/EDP/mouseoverdictionary.sqlite'"

word = ARGV.shift
## XXX: sanitizing is required for WORD.
sql   = "SELECT * FROM dict WHERE key COLLATE NOCASE LIKE '#{word}%' LIMIT 100;"

IO.popen "#{SQLITE} #{DICT_FILE} \"#{sql}\"" do |f|
  while line = f.gets
    line.sub!('|', "\n")
    line.gsub!(' \ ', "\n")
    print line
    print "\n"
  end
end