sqlpostgres

sqlpostgres is a mini-language for building and execting SQL statements against a postgresql database.

This is a very old library, pre-dating active record and lacking many of its refinements. New projects will probably not want to use this.

INSTALL

$ gem install USPS-intelligent-barcode

EXAMPLE

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
  # [{"t"=>"Jones"}, {"t"=>"O'Brien"}]
  
end

RUBY VERSIONS

The tests are known to pass in MRI 1.8.7 and MRI 1.9.3

POSTGRES VERSIONS

This library works with Postgres 1.8 and Postgres 1.9.

ENCODINGS

This library only works properly with the SQL-ASCII encoding.

WHOAMI

Wayne Conrad wconrad@yagni.com

CONTRIBUTORS

Sam Kellogg sam@nickstoys.com