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