class StringToArpa::Phonetic

Attributes

arpabet[RW]
id[R]
word[RW]

Public Class Methods

find(s_id) click to toggle source
# File lib/string_to_arpa.rb, line 50
def self.find(s_id)
  result = DATABASE.execute("SELECT * FROM phonetics WHERE id = #{s_id}")[0]

  self.new(result)
end
new(options) click to toggle source
# File lib/string_to_arpa.rb, line 14
def initialize(options)
  @word = options["word"]
  @arpabet = options["arpabet"]
  @id = options["id"]
end

Public Instance Methods

delete() click to toggle source
# File lib/string_to_arpa.rb, line 45
def delete
  DATABASE.execute("DELETE FROM phonetics WHERE id = #{@id}")
end
insert() click to toggle source
# File lib/string_to_arpa.rb, line 20
def insert
  DATABASE.execute("INSERT INTO phonetics (word, arpabet) VALUES (?, ?)", @word, @arpabet)
  @id = DATABASE.last_insert_row_id
end
save() click to toggle source
# File lib/string_to_arpa.rb, line 25
def save      
  attributes = []
                                                                             
  instance_variables.each do |i|                                               
    attributes << i.to_s.delete("@")                                           
  end     
                                                                     
                                                                             
  query_hash = {}                                                 
                                                                             
  attributes.each do |a|        #each with object
    value = self.send(a)
    query_hash[a] = value                                                       
  end                                                                

  query_hash.each do |key, value|
    DATABASE.execute("UPDATE phonetics SET #{key} = ? WHERE id = #{@id}", value)
  end                                                                          
end