summaryrefslogtreecommitdiff
path: root/lib/lua/sqlite
diff options
context:
space:
mode:
authormbalmer <mbalmer@NetBSD.org>2011-10-15 13:02:24 +0000
committermbalmer <mbalmer@NetBSD.org>2011-10-15 13:02:24 +0000
commitb59543738a9504eef26f44d61e103fed6c952fc6 (patch)
tree9fd64f74a96df99255402e998de517e875dc5df3 /lib/lua/sqlite
parenta8d29b67ab7c3f57b29b0d45354a2374cba7f9bb (diff)
Remove, has been moved to share/examples/lua.
Diffstat (limited to 'lib/lua/sqlite')
-rw-r--r--lib/lua/sqlite/test-sqlite.lua53
1 files changed, 0 insertions, 53 deletions
diff --git a/lib/lua/sqlite/test-sqlite.lua b/lib/lua/sqlite/test-sqlite.lua
deleted file mode 100644
index b1959211649..00000000000
--- a/lib/lua/sqlite/test-sqlite.lua
+++ /dev/null
@@ -1,53 +0,0 @@
-require 'sqlite'
-
-print('initialize sqlite')
-sqlite.initialize()
-
-print('this is sqlite ' .. sqlite.libversion() .. ' (' ..
- sqlite.libversion_number() .. ')')
-print('sourceid ' .. sqlite.sourceid())
-
-db, state = sqlite.open('db.sqlite',
- sqlite.OPEN_READWRITE + sqlite.OPEN_CREATE)
-
-if state ~= sqlite.OK then
- print('db open failed')
-else
- err = db:exec('create table test (name varchar(32))')
-
- if err ~= sqlite.OK then
- print('table creation failed')
- print('error code ' .. db:errcode() .. ' msg ' .. db:errmsg())
- end
-
- db:exec("insert into test values('Balmer')")
-
- stmt = db:prepare("insert into test values(:name)")
-
- print('statement has ' .. stmt:bind_parameter_count() .. ' parameters')
- print('param 1 name: ' .. stmt:bind_parameter_name(1))
- print('param name is at index ' .. stmt:bind_parameter_index('name'))
-
- stmt:bind(1, 'Hardmeier')
- stmt:step()
- stmt:reset()
- stmt:bind(1, 'Keller')
- stmt:step()
- stmt:finalize()
-
- s2 = db:prepare('select name from test')
-
- while s2:step() == sqlite.ROW do
- print('name = ' .. s2:column(1))
- end
- s2:finalize()
-
- stmt = db:prepare('drop table testx')
- stmt:step()
- stmt:finalize()
- db:close()
-end
-
-print('shutdown sqlite')
-sqlite.shutdown()
-