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 |