diff options
Diffstat (limited to '3rdparty/lsqlite3/examples/smart.lua')
-rw-r--r-- | 3rdparty/lsqlite3/examples/smart.lua | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/3rdparty/lsqlite3/examples/smart.lua b/3rdparty/lsqlite3/examples/smart.lua new file mode 100644 index 00000000000..db56c1c1b5c --- /dev/null +++ b/3rdparty/lsqlite3/examples/smart.lua @@ -0,0 +1,22 @@ + +local sqlite3 = require("lsqlite3") + +local db = sqlite3.open_memory() + +db:exec[[ CREATE TABLE test (id INTEGER PRIMARY KEY, content) ]] + +local stmt = db:prepare[[ INSERT INTO test VALUES (:key, :value) ]] + +stmt:bind_names{ key = 1, value = "Hello World" } +stmt:step() +stmt:reset() +stmt:bind_names{ key = 2, value = "Hello Lua" } +stmt:step() +stmt:reset() +stmt:bind_names{ key = 3, value = "Hello Sqlite3" } +stmt:step() +stmt:finalize() + +for row in db:nrows("SELECT * FROM test") do + print(row.id, row.content) +end |