resend_callback

def transactions_royalcc
  sql_filter = <<-END_OF_TEXT
    client_id = :client_id AND
    (
      callback_status_code != 200 OR
      callback_status_code IS NULL
    )
  END_OF_TEXT

  Transaction.where(sql_filter, client_id: 7)
end

def transactions_20bet
  sql_filter = <<-END_OF_TEXT
    client_id = :client_id AND
    (
      callback_status_code != 200 OR
      callback_status_code IS NULL
    ) AND status != 0
  END_OF_TEXT

  Transaction.where(sql_filter, client_id: 4)
end

def resend_callback(transactions = [])
  affected_rows = 0

  Rails.logger.info("processing #{transactions.count} transaction")
  Rails.logger.info("--------------------------------------------")

  transactions.each do |transaction|
    Rails.logger.info("transaction: #{transaction.id} -- resending callback data")

    Interactors::Transaction::SendCallbackData.call(id: transaction.id)

    Rails.logger.info("transaction: #{transaction.id} -- sending status #{transaction.status}")
    Rails.logger.info("--------------------------------------------")

    affected_rows += 1
  end

  Rails.logger.info("affected transaction: #{affected_rows}")
end

while true
  resend_callback(transactions_royalcc + transactions_20bet)
  sleep 60
end