quick test
$ irb
irb(main):001:0> require 'sequel'
=> true
irb(main):003:0> DB = Sequel.connect('postgres://
[email protected]:5432/test')
=> #<Sequel:
ostgres:
atabase: "postgres://
[email protected]:5432/test">
irb(main):006:0> DB.create_table :items do
irb(main):007:1* primary_key :id
irb(main):008:1> String :name
irb(main):009:1> Float
rice
irb(main):010:1> Bytea :mybinary
irb(main):011:1> end
=> []
irb(main):013:0> items = DB[:items]
=> #<Sequel:
ostgres:
ataset: "SELECT * FROM \"items\"">
irb(main):017:0> items.insert
name => 'test',
rice => rand * 100, :mybinary
=> 'djf dfjdslkf fkfhsakfhwe sdaf hdfkhadsf jfasdfj m ^N ^M ')
(irb):17: warning: don't put space before argument parentheses
=> 1
irb(main):022:0> ds = DB[:items]
=> #<Sequel:
ostgres:
ataset: "SELECT * FROM \"items\"">
irb(main):023:0> ds.each do |row|
irb(main):024:1* p row
irb(main):025:1> end
{:mybinary=>"djf dfjdslkf fkfhsakfhwe sdaf hdfkhadsf jfasdfj m \016 \r ",
ric
e=>45.9518099286502, :name=>"test", :id=>1}
=> #<Sequel:
ostgres:
ataset: "SELECT * FROM \"items\"">
irb(main):026:0>