summaryrefslogtreecommitdiffstatshomepage
path: root/3rdparty/lsqlite3/examples/smart.lua
diff options
context:
space:
mode:
Diffstat (limited to '3rdparty/lsqlite3/examples/smart.lua')
-rw-r--r--3rdparty/lsqlite3/examples/smart.lua22
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