module Magelex::MagentoMYSQL

Public Class Methods

update_dates(mysqlconf, bills) click to toggle source
# File lib/magelex/magento_mysql.rb, line 5
def self.update_dates mysqlconf, bills
  @client = Mysql2::Client.new(host: mysqlconf["host"],
                               port: mysqlconf["port"],
                               database: mysqlconf["database"],
                               username: mysqlconf["username"],
                               password: mysqlconf["password"])

  in_statement = bills.map{|b| "'#{b.order_nr}'"}.join(',')
  query = "SELECT increment_id, created_at, updated_at, "\
    "invoice_status_id  FROM sales_flat_invoice "\
    "WHERE increment_id IN (#{in_statement});"

  # Build up index TODO rubyfy
  bill_idx = {}
  bills.each {|b| bill_idx[b.order_nr.to_s] = b}
  results = @client.query(query)

  results.each do |row|
    bill_idx[row['increment_id']].date = row['created_at']
  end
end