summaryrefslogtreecommitdiffstatshomepage
path: root/3rdparty/lsqlite3/examples/tracing.lua
diff options
context:
space:
mode:
Diffstat (limited to '3rdparty/lsqlite3/examples/tracing.lua')
-rw-r--r--3rdparty/lsqlite3/examples/tracing.lua20
1 files changed, 20 insertions, 0 deletions
diff --git a/3rdparty/lsqlite3/examples/tracing.lua b/3rdparty/lsqlite3/examples/tracing.lua
new file mode 100644
index 00000000000..e72e3907b38
--- /dev/null
+++ b/3rdparty/lsqlite3/examples/tracing.lua
@@ -0,0 +1,20 @@
+
+local sqlite3 = require("lsqlite3")
+
+local db = sqlite3.open_memory()
+
+db:trace( function(ud, sql)
+ print("Sqlite Trace:", sql)
+end )
+
+db:exec[[
+ CREATE TABLE test ( id INTEGER PRIMARY KEY, content VARCHAR );
+
+ INSERT INTO test VALUES (NULL, 'Hello World');
+ INSERT INTO test VALUES (NULL, 'Hello Lua');
+ INSERT INTO test VALUES (NULL, 'Hello Sqlite3');
+]]
+
+for row in db:rows("SELECT * FROM test") do
+ -- NOP
+end