require "mysql-ironruby.rb"

mysql = Mysql.new("localhost", "root", "mypassword")

mysql.create_db("mysql_ironruby_test")

mysql.select_db("mysql_ironruby_test")

sql = "CREATE TABLE mytable ( "
sql += "mytable_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, "
sql += "mychar CHAR(20), "
sql += "myvarchar VARCHAR(20), "
sql += "mytext TEXT, "
sql += "mydouble DOUBLE, "
sql += "myfloat FLOAT, "
sql += "mytimestamp TIMESTAMP )"

mysql.query(sql)

sql = "INSERT INTO mytable VALUES ("
sql += "NULL, "
sql += "'foo', "
sql += "'bar', "
sql += "'foobar', "
sql += "3.14, "
sql += "9.81, "
sql += "NOW() )"

mysql.query(sql)

puts mysql.insert_id

sql = "INSERT INTO mytable VALUES ("
sql += "NULL, "
sql += "'abc', "
sql += "'def', "
sql += "'abcdef', "
sql += "5.02, "
sql += "6.01, "
sql += "NOW() )"

mysql.query(sql)

res = mysql.query("SELECT * FROM mytable")

while (row = res.fetch_row) != nil
  row.each { |v| puts v }
end

res.free

res = mysql.query("SELECT * FROM mytable")

while (row = res.fetch_hash) != nil
  row.keys.each do |k| 
    puts k
    puts row[k]
  end
end

res.free


mysql.close