data.rb

class GetData
  @@logger = Logger.new('log.log')

  def initialize
    @yesterday = Date.today.prev_day
    @token = xxx
    
  end
  
  def get_actions
    
    # GET actions of all companies from previous day
    response = RestClient.get("https://XXX/index.php?token_auth=#{@token}&format=json&date=#{@yesterday}&period=day&idSite=3&module=API&method=CustomVariables.getCustomVariablesValuesFromNameId&idSubtable=2")

    json = JSON.parse(response)

    # Open a database
    db = SQLite3::Database.new "database.db"

    
    json.each do |company|
      name = company['label']
      actions = company['nb_actions']

      
      # Execute inserts with parameter markers
      db.execute("INSERT INTO data (date, name, actions) 
    VALUES (?, ?, ?)", [@yesterday.to_s, name, actions])

      puts "Saved #{@yesterday} action data of #{name}"
      
    end
    

    @@logger.info "Saved #{@yesterday} action data"
    
    rescue => e
      retry
    else
      @@logger.fatal "Error occured in GetData.get_actions: #{e.class} - #{e.message}"
      
  end
  
  def first_day
    if Date.today.day == 1
      @@logger.info "Today is first day of month."
      true
    end
  end
  
end