class TripAdvisor::TranslationDBAccess
Public Instance Methods
connect()
click to toggle source
Create the connection instance.
# File lib/trip_advisor/db_access.rb, line 7 def connect @conn = PG.connect( :host => 'rivendell.tripadvisor.com', :dbname => 'tripmaster', :user => 'tripmaster_ro') end
disconnect()
click to toggle source
Disconnect the back-end connection.
# File lib/trip_advisor/db_access.rb, line 15 def disconnect @conn.close end
getTranslation(key_name) { |row| ... }
click to toggle source
Get translation for a single key
# File lib/trip_advisor/db_access.rb, line 35 def getTranslation(key_name) queryString = "SELECT v.locale, k.name, v.value, k.status, k.note FROM t_translationkeys k INNER JOIN t_translationvalues v ON (k.id = v.translationid) WHERE k.name = '#{key_name}' ORDER BY v.locale DESC;" @conn.exec(queryString) do |result| result.each do |row| yield row if block_given? end end end
getTranslations(key_names) { |row| ... }
click to toggle source
Get translations for keys in array
# File lib/trip_advisor/db_access.rb, line 20 def getTranslations(key_names) queryString = "SELECT v.locale, k.name, v.value, k.status, k.note FROM t_translationkeys k INNER JOIN t_translationvalues v ON (k.id = v.translationid) WHERE k.name IN ('#{key_names.join("', '")}') ORDER BY v.locale DESC;" @conn.exec(queryString) do |result| result.each do |row| yield row if block_given? end end end