File: test1.rb

package info (click to toggle)
ruby-dbi 0.4.5-1
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 596 kB
  • sloc: ruby: 2,800; perl: 12; makefile: 10
file content (20 lines) | stat: -rw-r--r-- 467 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
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