test/sql_test.lua

   1 require 'qtcore'
   2 require 'qtsql'
   3
   4 local db = QSqlDatabase.addDatabase("QSQLITE", "conn1")
   5 db:setDatabaseName("numbers.db")
   6 if not db:open() then
   7         local err = db:lastError()
   8         print('!!!', err:text():toLocal8Bit())
   9 end
  10 print('ok', db)
  11
  12 db:exec("CREATE TABLE IF NOT EXISTS tab (n INT)")
  13
  14 local q = QSqlQuery(db)
  15 q:prepare("INSERT INTO tab VALUES (:n)")
  16
  17 for i=1,10 do
  18         q:bindValue("n", QVariant(i))
  19         q:exec()
  20 end
  21
  22 local q2 = QSqlQuery(db)
  23 q2:exec("SELECT * FROM tab")
  24 while q2:next() do
  25         local v = q2:value(0)
  26         print(v:toInt())
  27 end