Sha256: a8546e11563fc37ad2372409422525f54f98c341b25aa7f667d4874320beb509

Contents?: true

Size: 861 Bytes

Versions: 4

Compression:

Stored size: 861 Bytes

Contents

#!/usr/bin/env ruby

$:.unshift(File.join(File.dirname(__FILE__), "../../lib"))
$:.unshift(File.join(File.dirname(__FILE__), "../../test"))

require 'Assert'
require 'sqlpostgres'

include SqlPostgres
include Assert

Connection.open do |connection|

  connection.exec("create temporary table foo (i int)")
  5.times do |i|
    connection.exec("insert into foo (i) values (#{i})")
  end

  # Example: ../../lib/sqlpostgres/Cursor.rb
  Transaction.new(connection) do
    select = Select.new(connection)
    select.select('i')
    select.from('foo')
    Cursor.new('my_cursor', select, {}, connection) do |cursor|
      while !(rows = cursor.fetch).empty?
        for row in rows
          p row # OUTPUT
                # OUTPUT
                # OUTPUT
                # OUTPUT
                # OUTPUT
          end
      end
    end
  end
  # End example

end

Version data entries

4 entries across 4 versions & 1 rubygems

Version Path
sqlpostgres-1.3.0 doc/examples/cursor.rb
sqlpostgres-1.2.6 doc/examples/cursor.rb
sqlpostgres-1.2.5 doc/examples/cursor.rb
sqlpostgres-1.2.4 doc/examples/cursor.rb