require 'rubygems'
require 'yaml'
require 'tg_sf'

dm_options = YAML.load_file(File.expand_path(File.dirname(__FILE__)+"/../config/database.yml"))['development'].inject({}) do |options, (key, value)|
  options[(key.to_sym rescue key) || key] = value
  options
end

DataMapper.setup(:default, dm_options)
DataMapper.setup(:salesforce, {:adapter  => 'salesforce',
                               :username => 'aobrien@telegeography.com.sandbox',
                               :password => '88andrew99OKVKRopVMMF2OGu8wvoxiVK9f',
                               :path     => File.expand_path(File.dirname(__FILE__)+'/../config/enterprise.wsdl.xml'),
                               :host     => ''})


require File.expand_path(File.dirname(__FILE__)+"/../app/models/local/product")
require File.expand_path(File.dirname(__FILE__)+"/../app/models/local/subscription")
require File.expand_path(File.dirname(__FILE__)+"/../app/models/local/user")

class Sync < Thor
  desc "load", "load everything from SalesForce"
  def load_all
    puts "Load em up!"
    DataMapper.auto_migrate!
    repository(:default).adapter.execute("ALTER TABLE local_users CHANGE salesforce_id salesforce_id VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;")
    repository(:default).adapter.execute("ALTER TABLE local_products CHANGE salesforce_id salesforce_id VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;")
    repository(:default).adapter.execute("ALTER TABLE local_subscriptions CHANGE salesforce_id salesforce_id VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;")
    Local::User.build_from_salesforce!
    Local::Product.build_from_salesforce!
    Local::Subscription.build_from_salesforce!
  end

  desc "load_changes", "load deltas from SalesForce"
  def load_changes
    Local::User.load_changes_from_salesforce!
    Local::Product.load_changes_from_salesforce!
    Local::Subscription.load_changes_from_salesforce!
  end

end