require 'mysql2'

class Report < ActiveRecord::Base

  @conn = Mysql2::Client.new( :host => POSTAL_CONFIG['host'], :port => POSTAL_CONFIG['port'], :username => POSTAL_CONFIG['username'], :password => POSTAL_CONFIG['password'], :database => POSTAL_CONFIG['database'])
  #@search_query = "SELECT id,mail_from,rcpt_to,subject,timestamp,last_delivery_attempt,status FROM messages"
  @search_query = "SELECT DISTINCT messages.id,messages.message_id,messages.token,messages.mail_from,messages.rcpt_to,messages.subject,messages.timestamp,messages.last_delivery_attempt,messages.size,messages.status,deliveries.details FROM messages INNER JOIN deliveries ON messages.id=deliveries.message_id"

  def self.find(search_term)
    p @search_query
    if search_term.empty?
      reports = @conn.query(@search_query)
    else
      reports = @conn.query("#{@search_query} WHERE #{search_term} ORDER BY messages.id DESC")
    end
    return reports
  end

  def self.all()
    reports = @conn.query("#{@search_query}")
    return reports
  end
end