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.

$ gem install USPS-intelligent-barcode

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

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

This library works with Postgres 1.8 and Postgres 1.9.

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

Wayne Conrad <wconrad@yagni.com>

Sam Kellogg <sam@nickstoys.com>