addons/DBI/samples/queryOne.io

   1 #!/usr/bin/env io
   2
   3 doFile("dummydata.io")
   4
   5 c := DBI with("sqlite3")
   6 c optionPut("dbname", "test.db")
   7 c optionPut("sqlite3_dbdir", ".")
   8 c connect
   9
  10 createDummyData(c)
  11
  12 r := c queryOne("SELECT * FROM people")
  13 r at("first") println
  14 r done
  15
  16 // See Person.io for Person object definition
  17 p := c queryOne(Person, "SELECT * FROM people WHERE id=?", 2)
  18 p fullName println
  19
  20 dropDummyData(c)
  21
  22 c close