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