Class: Lexicon

Inherits:

Object

• Object
• Lexicon

Defined in:

lib/segments_lexicon/lexicon.rb

Instance Method Summary

• #initialize(sqlite_db_path, table_name) ⇒ Lexicon constructor

  Opens a connection to the db.

• #search(query_term) ⇒ Object

Constructor Details

#initialize(sqlite_db_path, table_name) ⇒ Lexicon

Opens a connection to the db

param sqlite_db_path [String] Path to the sqlite3 db file

# File 'lib/segments_lexicon/lexicon.rb', line 8

def initialize(sqlite_db_path, table_name)
  @db = SQLite3::Database.new(sqlite_db_path)
  @db.results_as_hash = true
  @table = table_name
  self
end

Instance Method Details

#search(query_term) ⇒ Object

# File 'lib/segments_lexicon/lexicon.rb', line 15

def search(query_term)
  results = @db.execute "select * from #{@table} WHERE word LIKE \"#{query_term.downcase}\" COLLATE NOCASE"
end