Contents

#require 'nexus/nax_ar'

db_connection AppConfig.connections[:shopindb]
resource_path AppConfig.path('../public/images/db/')

import 'shopin_import' do

	importing :Family do
		identity_by :code
		force_downcase
		columns :DESCRIPTION => :name,
						:DBREV => none
	end

	importing :Category do
		identity_by :code
		force_downcase
		columns :DESCRIPTION => :name,
						:DBREV => none
	end
	
	importing :News do
    target :Post
    force_downcase      
	end
	
	importing :User do
		ignore!
	end
	
	importing :Product do
		identity_by :code
		force_downcase
		columns :DBREV => none,
				:DETAIL => :description,
				:PRCVENTA => :price
	end
	
	importing :TarifaVenta do
		target :PriceList
		identity_by :code
		force_downcase
		columns :IDTARIFAV => :code,
			:CODART => lookup( :write_to => :product_id, :table => :Product, :key => :code, :value => :id),
			:FECMAX => :expires_at,
			:PRECIO => :price,
			:TARIFA => :group,
			:UNIDADES => :quantity		
	end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
jcangas-datagateway-1.2.2	lib/datagateway/jobs/shopin_import.rb