Sha256: 51eb4de0d728da9cc5733e73c14a0b2096aec1ead8ee57db7ee20185d519ffa2

Contents?: true

Size: 702 Bytes

Versions: 4

Compression:

Stored size: 702 Bytes

Contents

#!/usr/bin/env ruby

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

# Example: ../../lib/sqlpostgres.rb
require "sqlpostgres"

include SqlPostgres

Connection.open do |connection|
  connection.exec("create temporary table foo (t text)")
  
  insert = Insert.new('foo', connection)
  insert.insert('t', 'Smith')
  insert.exec
  
  insert = Insert.new('foo', connection)
  insert.insert('t', 'Jones')
  insert.exec
  
  update = Update.new('foo', connection)
  update.set('t', "O'Brien")
  update.where(["t = %s", "Smith"])
  update.exec  
  
  select = Select.new(connection)
  select.select('t')
  select.from('foo')
  select.order_by('t')
  p select.exec  # OUTPUT
  
end
# End example

Version data entries

4 entries across 4 versions & 1 rubygems

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