Module: Magelex::MagentoMYSQL

Defined in:
lib/magelex/magento_mysql.rb

Class Method Summary collapse

Class Method Details

.update_dates(mysqlconf, bills) ⇒ Object 



5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
# 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