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 <[email protected]>
Sam Kellogg <[email protected]>