diff options
author | 2015-01-10 14:50:15 +0100 | |
---|---|---|
committer | 2015-01-10 14:50:15 +0100 | |
commit | 001b907d02cc15414b396625549c5d09faf1a223 (patch) | |
tree | 2f910e652e1d34ae29e103c2c0a3189dd277131b /3rdparty/lsqlite3/examples/function.lua | |
parent | b8e52b09c37877bf301ca64e76db3131010c5fb6 (diff) |
added lsqlite3 full source
Diffstat (limited to '3rdparty/lsqlite3/examples/function.lua')
-rw-r--r-- | 3rdparty/lsqlite3/examples/function.lua | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/3rdparty/lsqlite3/examples/function.lua b/3rdparty/lsqlite3/examples/function.lua new file mode 100644 index 00000000000..fdafc4e129b --- /dev/null +++ b/3rdparty/lsqlite3/examples/function.lua @@ -0,0 +1,21 @@ + +require("lsqlite3") + + +local db = sqlite3.open_memory() + +assert( db:exec "CREATE TABLE test (col1, col2)" ) +assert( db:exec "INSERT INTO test VALUES (1, 2)" ) +assert( db:exec "INSERT INTO test VALUES (2, 4)" ) +assert( db:exec "INSERT INTO test VALUES (3, 6)" ) +assert( db:exec "INSERT INTO test VALUES (4, 8)" ) +assert( db:exec "INSERT INTO test VALUES (5, 10)" ) + +assert( db:create_function("my_sum", 2, function(ctx, a, b) + ctx:result_number( a + b ) +end)) + + +for col1, col2, sum in db:urows("SELECT *, my_sum(col1, col2) FROM test") do + print(col1, col2, sum) +end |