addons/DBI/samples/fetchobj.io

   1 doFile("dummydata.io")
   2
   3 c := DBI with("sqlite3")
   4 c optionPut("dbname", "test.db")
   5 c optionPut("sqlite3_dbdir", ".")
   6 c connect
   7
   8 createDummyData(c)
   9
  10 r := c query("SELECT * FROM people")
  11 r foreach(Person, p, // See Person.io for Person object definition
  12         ("Fullname: " .. p fullName alignLeft(12)) print
  13         (     "Dob: " .. p dob asString("%A, %B %d, %Y") alignLeft(30)) print
  14         (     "Age: " .. p age) println
  15 )
  16 r done
  17
  18 dropDummyData(c)
  19
  20 c close