Try again John. Should be good to go. And thanks for testing this for me!
On 28/10/2014 10:06 PM, John McKown wrote:
Installation error - likely due to your fix of upper casing input. Relevant
portion of install output:
Enter PATH directory in which to create command symlinks or 'none'
(/usr/local/bin)
/HM/bin
link_dir (/HM/BIN) is not a valid path.
realpath() failed: realpath: EDC5129I No such file or directory.
On Tue, Oct 28, 2014 at 8:47 AM, David Crayford <[email protected]> wrote:
On 28/10/2014 9:31 PM, John McKown wrote:
I've got a new build for Lua4z which includes sqlite3 as part of LuaSQL
https://github.com/keplerproject/luasql. I'm going to release it soon
with the regex extensions for POSIX and PCRE.
​Wonderful. Thanks. I will now just wait. I'm__good__ at just waiting.
I've uploaded a new build with sqlite3. You will have to install the whole
package again (we don't have a package installaer)
Test case:
-- load driver
luasql = require "luasql.sqlite3"
-- create environment object
env = assert (luasql.sqlite3())
-- connect to data source
con = assert (env:connect("luasql-test"))
-- reset our table
res = con:execute"DROP TABLE people"
res = assert (con:execute[[
CREATE TABLE people(
name varchar(50),
email varchar(50)
)
]])
-- add a few elements
list = {
{ name="Jose das Couves", email="[email protected]", },
{ name="Manoel Joaquim", email="[email protected]", },
{ name="Maria das Dores", email="[email protected]", },
}
con:setautocommit(false)
for i = 1, 10 do
for _, p in pairs (list) do
res = assert (con:execute(string.format([[
INSERT INTO people
VALUES ('%s', '%s')]], p.name .. i, p.email..i)
))
end
end
con:commit()
-- retrieve a cursor
cur = assert (con:execute"SELECT name, email from people")
-- print all rows, the rows will be indexed by field names
row = cur:fetch ({}, "a")
while row do
print(string.format("Name: %s, E-mail: %s", row.name, row.email))
-- reusing the table of results
row = cur:fetch (row, "a")
end
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
