Contents

require "dbi"

dbh = DBI.connect("dbi:Oracle:oracle.neumann", "scott", "tiger", 'AutoCommit' => false)

dbh.do("DROP TABLE MYTEST")
dbh.do("CREATE TABLE MYTEST (a INT, b VARCHAR2(256), c FLOAT, d VARCHAR2(256))")

sth = dbh.prepare("INSERT INTO MYTEST VALUES (:1, :2, :3, :4)")

1.upto(10000) do |i|
  sth.execute(i.to_s, "Michael der #{i}. von Neumann", (5.6 * i).to_s, "HALLO LEUTE WIE GEHTS DENN SO?")
  #print i, "\n"
end

sth.finish

dbh.commit

dbh.disconnect

Version data entries

20 entries across 20 versions & 3 rubygems

Version	Path
ydbi-0.6.0	examples/test1.rb
ydbi-0.5.9	examples/test1.rb
ydbi-0.5.8	examples/test1.rb
ydbi-0.5.7	examples/test1.rb
ydbi-0.5.6	examples/test1.rb
ydbi-0.5.5	examples/test1.rb
ydbi-0.5.4	examples/test1.rb
ydbi-0.5.3	examples/test1.rb
ydbi-0.5.2	examples/test1.rb
ydbi-0.5.1	examples/test1.rb
ydbi-0.5.0	examples/test1.rb
rails-dbi-0.1.2	examples/test1.rb
rails-dbi-0.1.1	examples/test1.rb
rails-dbi-0.1.0	examples/test1.rb
dbi-0.4.5	examples/test1.rb
dbi-0.4.4	examples/test1.rb
dbi-0.4.3	examples/test1.rb
dbi-0.4.2	examples/test1.rb
dbi-0.4.1	examples/test1.rb
dbi-0.4.0	examples/test1.rb