Sha256: e501150d136e5fdb39beb33a4a1f8979087f9bb6748287cd8e413ea695ad52c3

Contents?: true

Size: 398 Bytes

Versions: 13

Compression:

Stored size: 398 Bytes

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