module ForstokTrigger::Validity::Repository::ValidityRepository

This TriggerRepository is class for connect to database

Public Class Methods

configuration() click to toggle source
# File lib/forstok_trigger/validity/repository/validity_repository.rb, line 31
def self.configuration
  @configuration ||= ForstokTrigger::Validity.configuration
end
now() click to toggle source
# File lib/forstok_trigger/validity/repository/validity_repository.rb, line 27
def self.now
  @now = Time.now.strftime('%Y-%m-%d %H:%M:%S')
end
validity_insert_pending(l_id, a_id, c_id, mode) click to toggle source
# File lib/forstok_trigger/validity/repository/validity_repository.rb, line 21
def self.validity_insert_pending(l_id, a_id, c_id, mode)
  sql = validity_insert_query
  sql += validity_insert_value(l_id, a_id, c_id, mode)
  ForstokTrigger::Validity::Repository.client.query(sql)
end
validity_insert_query() click to toggle source
# File lib/forstok_trigger/validity/repository/validity_repository.rb, line 8
def self.validity_insert_query
  sql = 'INSERT INTO ' + configuration.db + '.'
  sql += configuration.buffer_table
  sql += '(listing_id, account_id, channel_id, mode, created_at'
  sql += ', updated_at) VALUES '
  sql
end
validity_insert_value(listing_id, account_id, channel_id, mode) click to toggle source
# File lib/forstok_trigger/validity/repository/validity_repository.rb, line 16
def self.validity_insert_value(listing_id, account_id, channel_id, mode)
  "(#{listing_id}, #{account_id}, #{channel_id}, " \
  "'#{mode}', '#{now}', '#{now}')"
end