[src/trunk]: src/share/examples/lua Correct mistakes in the sqlite.lua example

[kamil <kamil%NetBSD.org@localhost>]

details:   https://anonhg.NetBSD.org/src/rev/45dd5e32ef39
branches:  trunk
changeset: 342146:45dd5e32ef39
user:      kamil <kamil%NetBSD.org@localhost>
date:      Tue Dec 08 23:04:40 2015 +0000

description:
Correct mistakes in the sqlite.lua example

Changes:
- The open flag: sqlite.OPEN_CREATE will open the DB for reading and
  writing, adding sqlite.OPEN_READWRITE to sqlite.OPEN_CREATE will cause
  the DB to not be created and prevent the script from continuing
- When using stmt:bind_parameter_index() the parameter needs to be
  prefixed with ':' if that was used in the prepared statement,
  otherwise the incorrect index of 0 is returned.
- The drop table statement has an "x" appended to the table name, looks
  like a typo.

Patch by Travis Paul

Closes PR misc/50493

diffstat:

 share/examples/lua/sqlite.lua |  10 ++++------
 1 files changed, 4 insertions(+), 6 deletions(-)

diffs (42 lines):

diff -r 99ab59d4058a -r 45dd5e32ef39 share/examples/lua/sqlite.lua
--- a/share/examples/lua/sqlite.lua     Tue Dec 08 22:16:01 2015 +0000
+++ b/share/examples/lua/sqlite.lua     Tue Dec 08 23:04:40 2015 +0000
@@ -1,4 +1,4 @@
--- $NetBSD: sqlite.lua,v 1.2 2014/07/19 18:38:34 lneto Exp $
+-- $NetBSD: sqlite.lua,v 1.3 2015/12/08 23:04:40 kamil Exp $
 
 local sqlite = require 'sqlite'
 
@@ -13,8 +13,7 @@
     sqlite.libversion_number() .. ')')
 print('sourceid ' .. sqlite.sourceid())
 
-db, state = sqlite.open('/tmp/db.sqlite',
-    sqlite.OPEN_READWRITE + sqlite.OPEN_CREATE)
+db, state = sqlite.open('/tmp/db.sqlite', sqlite.OPEN_CREATE)
 
 if state ~= sqlite.OK then
        print('db open failed')
@@ -33,7 +32,7 @@
 
        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'))
+       print('param name is at index ' .. stmt:bind_parameter_index(':name'))
 
        stmt:bind(1, 'Hardmeier')
        stmt:step()
@@ -49,7 +48,7 @@
        end
        s2:finalize()
 
-       stmt = db:prepare('drop table testx')
+       stmt = db:prepare('drop table test')
        stmt:step()
        stmt:finalize()
        db:close()
@@ -57,4 +56,3 @@
 
 print('shutdown sqlite')
 sqlite.shutdown()
-