Sha256: 5e87c3a6efc5c24958d619cc0613de97e2b7cf5eda0ad654e8347ef04ce16894

Contents?: true

Size: 683 Bytes

Versions: 4

Compression:

Stored size: 683 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 integer)")

  insert = Insert.new('foo', connection)
  insert.insert('i', 1)
  insert.exec

  # Example: ../../lib/sqlpostgres/Update.rb
  update = Update.new('foo', connection)
  update.set('i', 2)
  p update.statement    # OUTPUT
  update.exec
  # End example

  select = Select.new(connection)
  select.select('i')
  select.from('foo')
  assertEquals(select.exec, [{'i'=>2}])

end

Version data entries

4 entries across 4 versions & 1 rubygems

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