diff options
| author | mbalmer <mbalmer@NetBSD.org> | 2011-10-15 13:02:24 +0000 |
|---|---|---|
| committer | mbalmer <mbalmer@NetBSD.org> | 2011-10-15 13:02:24 +0000 |
| commit | b59543738a9504eef26f44d61e103fed6c952fc6 (patch) | |
| tree | 9fd64f74a96df99255402e998de517e875dc5df3 /lib/lua/sqlite | |
| parent | a8d29b67ab7c3f57b29b0d45354a2374cba7f9bb (diff) | |
Remove, has been moved to share/examples/lua.
Diffstat (limited to 'lib/lua/sqlite')
| -rw-r--r-- | lib/lua/sqlite/test-sqlite.lua | 53 |
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() - |
