require 'active_record'
require 'mysql2'

ActiveRecord::Base.establish_connection(
  adapter:  'mysql2',
  host:     'host-address',
  database: 'database-name',
  username: 'username',
  password: 'password',
  sslca: '/path/to/file.pem'
)

class ExternalRepresentationJobs < ActiveRecord::Base
end

while true
  latest_tvs_xrep_job = ExternalRepresentationJobs.where(name: 'tvs').order("created_at").last

  if latest_tvs_xrep_job.status == 'done'
    puts "Job ##{latest_tvs_xrep_job.id}'s status is DONE"
    latest_tvs_xrep_job.update(status: 'pending')
    puts "Updated job ##{latest_tvs_xrep_job.id}'s status to PENDING"
    puts "-------------------------------------------------------"
  end
  puts latest_tvs_xrep_job.inspect
  sleep 600
end