Struggling with SQL!

* Struggling with SQL!
@ 2021-06-03 10:51 Gerard Verhaag
  2021-06-03 18:43 ` Hans Hagen
  0 siblings, 1 reply; 4+ messages in thread
From: Gerard Verhaag @ 2021-06-03 10:51 UTC (permalink / raw)
  To: ntg-context

[-- Attachment #1.1: Type: text/plain, Size: 2365 bytes --]

Hi,

I'm trying to get MySQL data access working but can't solve the issues I'm encountering. Part of my code looks like:

\startluacode
productsheet = productsheet or {}
function productsheet.sqldatabase(database,user,password)
   productsheet:sql(database,user,password)
end
function productsheet:sql(db,us,pw)
print("SQLDATABASE: database: " .. db)
print("SQLDATABASE: username: " .. us)
print("SQLDATABASE: password: " .. pw)
local sql = require("util-sql")
local presets = {database = db,username = us,password = pw,host= "localhost",port= 3306}
local template = [[SELECT `nom`, `name_alias` FROM `llx_societe` WHERE `nom` = '%nom%' ;]]
presets.id = "mysql"
local data, keys = utilities.sql.execute {presets=presets,template=template,variables={nom = "Life"}}
...

This generates the following issues:

sql > start loading method 'library'
lua error > lua error on line 153 in file /home/gverhaag/Stock/ProductSheet/productsheet_KG594.tex:
/usr/share/texmf/tex/context/base/mkiv/l-sandbox.lua:180: module 'luasql.mysql' not found:
no field package.preload['luasql.mysql']
no file '/usr/local/share/lua/5.2/luasql/mysql.lua'
no file '/usr/local/share/lua/5.2/luasql/mysql/init.lua'
no file '/usr/local/lib/lua/5.2/luasql/mysql.lua'
no file '/usr/local/lib/lua/5.2/luasql/mysql/init.lua'
no file './luasql/mysql.lua'
no file '/usr/local/lib/lua/5.2/luasql/mysql.so'
no file '/usr/local/lib/lua/5.2/loadall.so'
no file './luasql/mysql.so'
no file '/usr/local/lib/lua/5.2/luasql.so'
no file '/usr/local/lib/lua/5.2/loadall.so'
no file './luasql.so'
stack traceback:
[C]: in function 'requiem'
/usr/share/texmf/tex/context/base/mkiv/l-sandbox.lua:180: in function </usr/share/texmf/tex/context/base/mkiv/l-sandbox.lua:165>
(...tail calls...)
...are/texmf/tex/context/base/mkiv/util-sql-imp-library.lua:74: in main chunk
[C]: in function 'requiem'
/usr/share/texmf/tex/context/base/mkiv/l-sandbox.lua:180: in function </usr/share/texmf/tex/context/base/mkiv/l-sandbox.lua:165>
(...tail calls...)
/usr/share/texmf/tex/context/base/mkiv/util-sql.lua:114: in function '__index'
/usr/share/texmf/tex/context/base/mkiv/util-sql.lua:288: in function 'execute'
[ctxlua]:21: in function 'sql'
[ctxlua]:5: in function 'sqldatabase'
[ctxlua]:1: in main chunk

Must be something basic, I guess! I use the TexLive 2017 version of ConTeXt.

Any idea what I'm doing wrong here?

[-- Attachment #1.2: Type: text/html, Size: 6340 bytes --]

[-- Attachment #2: Type: text/plain, Size: 493 bytes --]

___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://context.aanhet.net
archive  : https://bitbucket.org/phg/context-mirror/commits/
wiki     : http://contextgarden.net
___________________________________________________________________________________

^ permalink raw reply	[flat|nested] 4+ messages in thread