#!/usr/bin/env ruby

$KCODE = 'e'

require 'rubygems'
gem 'dbi'
require 'dbi'
require 'pg'

name = "西村まどか"
wday = "火"
hr = 2
sem = "前期"
sub = "基礎プログラミングIC"
cls = "101"

pghost = "localhost"
pgport = 5432
pgoptions = nil
pgtty = nil
dbname = "ta05001"
dbuser = "ta05001"
passwd = nil

conn = PGconn.connect(:dbname=>'ta05001',:user=>'ta05001')

sql = "INSERT INTO practice (name, wday, hr, sem, sub, cls) 
      VALUES
      (\'#{name}\',\'#{wday}\',#{hr},\'#{sem}\',\'#{sub}\',\'#{cls}\')
      "

tuple = conn.exec(
      sql
      )

tuple.each{|line|
  for comp in line
    printf("%s,",comp[1])
  end
  print("\n")
}