diff options
Diffstat (limited to '3rdparty/lsqlite3/examples/tracing.lua')
-rw-r--r-- | 3rdparty/lsqlite3/examples/tracing.lua | 20 |
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 |