Contents

require_relative 'config'

extract :contacts do
  from :suite
  incrementally_by :created
  query <<-sql
    SELECT *
    FROM contacts
    WHERE created BETWEEN '#{last_extracted_value_of :created, "1970-01-01 00:00:00"}' AND '#{Time.now - 60*10}'
  sql
end

extract :contacts do
  from :suite
  incrementally_by :id
  query "SELECT * FROM akarmi WHERE id > #{last_extracted_value_of :id, 0}"
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
cranium-0.8.1	examples/incremental_extract.rb
cranium-0.8	examples/incremental_extract.rb
cranium-0.7	examples/incremental_extract.rb
cranium-0.6.1	examples/incremental_extract.rb
cranium-0.5	examples/incremental_extract.rb
cranium-0.4.3	examples/incremental_extract.rb
cranium-0.4.2	examples/incremental_extract.rb
cranium-0.4.1	examples/incremental_extract.rb
cranium-0.4	examples/incremental_extract.rb
cranium-0.3.1	examples/incremental_extract.rb
cranium-0.3.0	examples/incremental_extract.rb
cranium-0.2.1	examples/incremental_extract.rb
cranium-0.2.0	examples/incremental_extract.rb