Работа с базой данных SQlite на lua


#!/usr/bin/lua

local m = require "luasql.sqlite3"

env = assert(m.sqlite3())

con = assert(env:connect("x.db"))

cur = assert(con:execute "SELECT * FROM test")

row = cur:fetch ({}, "a")
while row do
  print(string.format("Name: %s", row.name))
  row = cur:fetch (row, "a")
end

cur:close()

res = assert(con:execute(
  string.format([[INSERT INTO test (name)  VALUES ('%s')]], 'asdasd')
))

con:close()
env:close()