create the table : postgres « Database « Ruby

1. Ruby
2. Database
3. postgres

create the table

require 'dbi'
DBI.connect('dbi:Pg:rdg', 'matz', '123',
            'AutoCommit' => true) {|dbh|
  dbh.do "CREATE TABLE Lang (
    id      INTEGER NOT NULL PRIMARY KEY,
    name    VARCHAR(10) NOT NULL,
    creator VARCHAR(10) NOT NULL,
    age     INTEGER
    )"
}
dbh.do "INSERT INTO Lang VALUES (1, 'C', 'Dennis', 28)"
sql = "INSERT INTO Lang VALUES (?, ?, ?, ?)"
dbh.do( sql, 2, 'Python', 'Guido', 10 )
dbh.do( sql, 3, 'Tcl',    'John',  12 )
sql = "UPDATE Lang SET age=age+? WHERE age IS NOT NULL"
rpc = dbh.do( sql, 1 )
puts "#{ rpc } row(s) updated"

 

Related examples in the same category