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 |