- ntg-context - Mailing Lists

Struggling with SQL!
by Gerard Verhaag 05 Jun '21

05 Jun '21

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?

3 3

different prefixsegments for \in
by Pablo Rodriguez 04 Jun '21

04 Jun '21

Dear list, I have the following sample: \setupreferencestructureprefix [default] [prefixsegments=*:*] \starttext \section{One Section} \subsection[sec0]{Subsection} As told in \in[sec0] and \in[sec1]… \section{Another Section} \subsection[sec1]{Subsection} … \stoptext The output reads: As told in 1.1 and 2.1… I would like to be able to supress the section number in the reference, if the current section is the same as the referenced one. I mean, I would like that the output reads: As told in 1 and 2.1… Which would be the way to do it automatically? BTW, in my real--world document, I need to remove part and chapter numbers from the reference when in the same part and chapter (when compiling XML sources). Many thanks for your help, Pablo -- http://www.ousia.tk

1 0

new upload
by Hans Hagen 04 Jun '21

04 Jun '21

Hi, I uploaded a new version of lmtx: a next step in this matrix and such graphic part ... (also bTABLE done). The matrix bit has a high level MP interface, also because it's a nice example of implementing one (not much code needed actually). Support in bTABLE .. eTABLE is kind of interesting as it separates the ornamental part from the text part. The sxample only shows some simple stuff. I'll probably also add this to the other table mechanisms. (Not hard but I don't want to impact performance when it's not used.) The \startoverlayMPgraphic{mp:whatever-6} is new and automatically defines the overlay so that saves some code. \startMPoverlaydata is just a collector that can be flushed in-line (which wilkl also reset it). All this is probably mostly useful in an educational setting. We'll see. Hans ------------------------------------------------------------ examples ------------------------------------------------------------ \starttext \startoverlayMPgraphic{mp:whatever-6} fill OverlayBox withcolor "darkgray" ; draw matrixbox (1, 1) (2, 1) enlarged OverlayOffset shifted paired(OverlayOffset) withpen pencircle scaled 1pt withcolor "blue" ; draw matrixbox (2, 2) (4, 4) enlarged OverlayOffset shifted paired(OverlayOffset) withpen pencircle scaled 1pt withcolor "red" ; \stopoverlayMPgraphic \framed [synchronize=background, align=normal, frame=off, background=mp:whatever-6, backgroundoffset=.5ex, foregroundcolor=white] {\setmathmatrixanchoring[yes]% left|right|both|yes \startmathmatrix \NC a_1 \NC a \NC b \NC c\NR \NC a_2 \NC a \NC b \NC c\NR \NC a_3 \NC a^2 \NC b \NC c\NR \NC a_4 \NC a \NC b_2 \NC c\NR \NC a_5 \NC a \NC b \NC c\NR \NC a_6 \NC a \NC b \NC c\NR \stopmathmatrix} % \blank % This can also be done by Alans node module. \startoverlayMPgraphic{mp:whatever-7} fill OverlayBox withcolor "darkgray" ; draw lmt_matrix [ from = (1, 1), to = (5, 4), connect = { "bottom", "left" }, color = "blue", linewidth = 1pt, arrowoffset = 2pt, label = [ text = "$\white \scriptscriptstyle x =1$", offset = ExHeight/2, anchor = "lft", fraction = .25 ], ] ; draw lmt_matrix [ from = (4, 1), to = (1, 5), connect = { "bottom", "right" } colors = { "green", "magenta" }, arrowcolor = "white", linewidth = 1pt, ] ; draw lmt_matrix [ cell = (2, 2), shape = "circle" color = "red", linewidth = 1pt, ] ; draw lmt_matrix [ cell = (4, 6), shape = "round", radius = ExHeight/2, color = "red", linewidth = 1pt, ] ; draw lmt_matrix [ cell = (2, 6), shape = "path", path = fulldiamond xscaled 3EmWidth yscaled 4ExHeight, color = "red", linewidth = 1pt, ] ; draw lmt_matrix [ cell = (2, 6), shape = "scaledpath", offset = .5ExHeight, path = fulldiamond, color = "yellow", linewidth = 1pt, ] ; \stopoverlayMPgraphic \blank \framed [synchronize=background, align=normal, frame=off, offset=overlay, background=mp:whatever-7, foregroundcolor=white] {\setmathmatrixanchoring[both]% \startmathmatrix \NC a \NC \NC \quad \NC b \NC \NR \NC \NC c \NC \quad \NC \NC \NR \NC \NC \NC \quad \NC \NC \NR \NC \NC \NC \quad \NC \NC d \NR \NC e \NC \NC \quad \NC \NC \NR \NC \NC f \NC \quad \NC g \NC \NR \stopmathmatrix} \blank \startoverlayMPgraphic{whatever-9} fill anchorspan (1, 1) (1, 3) withcolor "blue" ; fill anchorspan (2, 1) (3, 3) withcolor "yellow" ; fill anchorspan (3, 1) (3, 3) withcolor "green" ; path p ; p := anchorcell (2, 2) ; fill p withcolor "red" ; % now some weird stuff: picture q ; q := externalfigure "t:/sources/cow.pdf" ; q := q xysized (bbwidth(p), bbheight(p)) ; draw q shifted - center q shifted center p ; % and some even weirder stuff: \includeMPoverlaydata \stopoverlayMPgraphic \enabletrackers[localanchor] \bTABLE[frame=off,synchronize=background,background=whatever-9] \bTR \bTD[foregroundcolor=white] \startMPoverlaydata fill anchorcell (\xanchor,\yanchor) enlarged -.25ExHeight withcolor "darkgray" ; \stopMPoverlaydata test \eTD \bTD test test \eTD \bTD test test test \eTD \eTD \bTR \bTD[foregroundcolor=white] test test \eTD \bTD[nx=2,align=middle,foregroundstyle=bold,foregroundcolor=white] test \eTD \eTD \bTR \bTD[foregroundcolor=white] test test test \eTD \bTD test test \eTD \bTD test \eTD \eTD \eTABLE \stoptext ----------------------------------------------------------------- Hans Hagen | PRAGMA ADE Ridderstraat 27 | 8061 GH Hasselt | The Netherlands tel: 038 477 53 69 | www.pragma-ade.nl | www.pragma-pod.nl -----------------------------------------------------------------

2 3

metafun transformation error
by Ajith R 04 Jun '21

04 Jun '21

Hi all, I am new to context and need help in solving an error. I am trying to print some numbers in a grid onto a transparent sheet as mirror images so that the numbers are correctly displayed when I view it from the non printed side. The numbers have a particular sequence which cannot be obtained from calculations. So, they are stored in an array of strings : l[0][0] := "38"; ... I place them at the centre of the grid squares using the code below: for i= 0 upto (row - 1): for j= 0 upto (col - 1): middle := 0.5[((( i * unit) + lm), ((j * unit) + bm)), ((((i+1) * unit) + lm), (((j +1) * unit) + bm))]; p := thelabel(l[j][i], middle); draw p; % q := p reflectedabout (0.5[urcorner p, ulcorner p], 0.5[lrcorner p, llcorner p]); % draw q; endfor endfor This works as expected. But, when I try to reflect the label by means of the commented code, I get an error : tex error > mp error on line 643 in file /home/ajith/Desktop/PlayGround/numgrid.tex: >> (xpart T_,ypart T_,-0.00581xpart T_+0.00497ypart T_+0.15294,-0.00497xpart T_ -0.00581ypart T_+0.98824,-0.00497xpart T_-0.00581ypart T_+0.98825,0.00581xpart T_-0.00497ypart T_-0.15294) ! Transform components aren't all known. <to be read again> ; <for(0)> ...lcorner.p];q:=p.reflectedabout(uq,lq); draw.p; ENDFOR <for(0)> ...=p.reflectedabout(uq,lq);draw.p;endfor ENDFOR <*> ...lectedabout (uq, lq); draw p; endfor endfor StopPage ; ; I'm unable to apply a partially specified transformation except to a fully known pair or transform. Proceed, and I'll omit the transformation. I tried a mock example without the loops and that didn't throw an error. How can I make it work within the loops? Thanks, ajith

2 5

oldstyle math
by Alan Bowen 03 Jun '21

03 Jun '21

I no longer get oldstyle numerals in the math environment (ConTeXt ver: 2021.04.29 ) with \definefontfamily[mainface][rm][STIX Two Text] [protrusion=quality, expansion=quality, mode=node, force=yes, features={default, f:oldstyle}, ] \definefallbackfamily[mainface] [mm] [STIX Two Text] [range=digitsnormal, force=yes, features=f:oldstyle, ] \definefontfamily[mainface][mm][STIX Two Math] \setupbodyfont[mainface, 10pt] \starttext 123456789 \m{123456789} \stoptext What have I missed? Alan

3 3

new upload
by Hans Hagen 01 Jun '21

01 Jun '21

Hi, I uploaded a new lmtx version. This time a new mechanism. ----------------------------- From an upcoming details chapter: ----------------------------- The mechanism described here is still experimental. Although it could be implemented in \MKIV\ it is only available in \LMTX. Already early in \MKII\ we had a positioning mechanism available. At that time we had \DVI\ output and specials were used to track positions. A script calculated the positions that were then fed back into the second run. Later Taco wrote \DVIPOS\ which sped up the analysis between runs. When \PDFTEX\ showed, an equivalent positioning mechanism was added there. In \MKIV\ positioning support was optimized a bit as part of the upgrading process but the principles remained the same. The interface to positioning comes with a lot of commands and many of them relate to what we want to do with \METAFUN. The alternative interface discussed here is a bit simpler and has (at least now) less commands and, combined with local name spaces, can be easier to use in more local situations. It's also integrated in the frequently used \type {\framed} commands and has basic support at the \METAFUN\ end. The performance is comparable to the regular positioning mechanisms but especially at the \METAPOST\ end has less overhead. ----------------------------- Here are some examples: ----------------------------- \framed [synchronize=yes,align=normal] {% test test test 1 \sync{one}{1}test test 2 \crlf test test 1 \sync{one}{1}test test test 2 \crlf test 1 \sync{one}{1}test 2 \crlf test test test test 1 \sync{one}{1}test test 2 } \framed [synchronize=yes,align=normal] {% one one \sync{a}{1}two \sync{a}{2}three \crlf one one \sync{a}{1}two two \sync{a}{2}three \crlf one \sync{a}{1}two \sync{a}{2}three \crlf one one one \sync{a}{1}two \sync{a}{2}three } \framed [synchronize=yes,align=normal] {% \syncanchor{one}{1}{1}A \syncanchor{one}{2}{1}BBB \syncanchor{one}{3}{1}C \crlf \syncanchor{one}{1}{2}AA \syncanchor{one}{3}{2}C \crlf \syncanchor{one}{1}{3}AAA \syncanchor{one}{2}{3}BB \syncanchor{one}{3}{3}C } \framed [synchronize=yes,align=normal] {% \alignanchor{one}{1}{1}{l}A \alignanchor{one}{1}{2}{m}AA \alignanchor{one}{1}{3}{r}AAA \syncanchor {one}{1}{4}\crlf \alignanchor{one}{2}{1}{right}B \alignanchor{one}{2}{2}{middle}BB \alignanchor{one}{2}{3}{left}BBB \syncanchor {one}{2}{4} } \startuseMPgraphic{whatever-1} fill OverlayBox withcolor "lightgray" ; drawdot anchorxy("one", 0, 1) withpen pencircle scaled 1mm withcolor "red" ; drawdot anchorxy("one", 0, 2) withpen pencircle scaled 1mm withcolor "red" ; drawdot anchorxy("two", 0, 1) withpen pencircle scaled 1mm withcolor "red" ; drawdot anchorxy("two", 0, 2) withpen pencircle scaled 1mm withcolor "red" ; drawdot anchorxy("three", 0, 1) withpen pencircle scaled 1mm withcolor "red" ; setbounds currentpicture to OverlayBox ; \stopuseMPgraphic \startuseMPgraphic{whatever-2} pair a ; a := anchorxy("one", 0, 1) ; pair b ; b := anchorxy("one", 0, 2) ; drawarrow anchorxy("one", 0, 1) { right } .. anchorxy("one", 0, 2) withcolor "blue" withtransparency (1,.75) ; drawarrow anchorxy("two", 0, 1) { down } .. anchorxy("two", 0, 2) withcolor "blue" withtransparency (1,.75) ; drawarrow anchorxy("two", 0, 1) { dir 30 } .. anchorxy("three", 0, 1) withcolor "blue" withtransparency (1,.75) ; setbounds currentpicture to OverlayBox ; \stopuseMPgraphic \defineoverlay[whatever-1][\useMPgraphic{whatever-1}] \defineoverlay[whatever-2][\useMPgraphic{whatever-2}] \framed [synchronize=yes, align=normal, offset=10pt, frame=off, background={whatever-1,foreground,whatever-2}] {% \markanchor{two}{0}{1}{\red\bf foo}% \markanchor{one}{0}{1} bar rab oof\crlf foo bar rab oof\crlf oof rab bar foo\crlf oof rab \markanchor{two}{0}{2}{\red\bf bar}% \markanchor{one}{0}{2} foo% \markanchor{three}{0}{1}% } \framed [synchronize=yes, align=normal, offset=10pt, frame=off, background={whatever-1,foreground,whatever-2}] {% one one one \syncanchor{a}{1}{1}two two two \syncanchor{a}{2}{1}three three\par one \syncanchor{a}{1}{2}two \syncanchor{a}{2}{2}three\par one \syncanchor{a}{1}{3}two \syncanchor{a}{2}{3}three\par \blank \markanchor{two}{0}{1}{\red\bf foo}% \markanchor{one}{0}{1} bar rab oof\crlf foo bar rab oof\crlf oof rab bar foo\crlf oof rab \markanchor{two}{0}{2}{\red\bf bar}% \markanchor{one}{0}{2} foo% \markanchor{three}{0}{1}% \blank one one \syncanchor{a}{1}{4}two two \syncanchor{a}{2}{4}three\par one one \syncanchor{a}{1}{5}two two \syncanchor{a}{2}{5}three three% \markanchor{three}{0}{1}% } \framed[synchronize=yes,align=normal]{% one one \sync{a}{1}two \sync{a}{2}three\par one one \sync{a}{1}two two \sync{a}{2}three\par \blank tst tst \sync{b}{1}tst \sync{b}{2}tst\par tst \sync{b}{1}tst tst \sync{b}{2}tst\par \blank one \sync{a}{1}two \sync{a}{2}three } \page \startpacked $a = b + c $\par $b = c + d $\par $c = e + f $\par \stoppacked \startpacked \startsynchronizing $a \syncanchor{one}{1}{1}= b \syncanchor{one}{2}{1}+ c$\par $b \syncanchor{one}{1}{2}= c \syncanchor{one}{2}{2}+ d$\par $c \syncanchor{one}{1}{3}= e \syncanchor{one}{2}{3}+ f$\par \stopsynchronizing \stoppacked \startpacked \startsynchronizing $a \sync{one}{1}= b \sync{one}{2}+ c$\par $b \sync{one}{1}= c \sync{one}{2}+ d$\par $c \sync{one}{1}= e \sync{one}{2}+ f$\par \stopsynchronizing \stoppacked \startpacked \startsynchronizing $a \mathsync{1}= b \mathsync{2}+ c$\par $b \mathsync{1}= c \mathsync{2}+ d$\par $ \mordsync{1}= e \mathsync{2}+ f$\par \stopsynchronizing \stoppacked ----------------------------- remark ----------------------------- So, it's a varaant on the positioning mechanism. It also works in framed when the synchronization option is enabled. Don't enable that when not used (as there is some overhead involved). I have no clue how useful it is but users always find a way to use mechanisms. One can do really freaky things with it. Who knows what gets added over time. Also, it doesn't replace the existing positioning mechanism which served us well for decades; it's just a lightweight variant with different pros and cons. Hans ----------------------------------------------------------------- Hans Hagen | PRAGMA ADE Ridderstraat 27 | 8061 GH Hasselt | The Netherlands tel: 038 477 53 69 | www.pragma-ade.nl | www.pragma-pod.nl -----------------------------------------------------------------

2 5

Understanding penalties for orphans and widows
by denis.maier＠ub.unibe.ch 01 Jun '21

01 Jun '21

Hi, I've read in the wiki (https://wiki.contextgarden.net/Widows_and_orphans_control) that this setting can be used to keep at least two lines together: \startsetups[grid][mypenalties] \setdefaultpenalties \setpenalties\widowpenalties{2}{10000} \setpenalties\clubpenalties {2}{10000} \stopsetups After experimenting with the first argument (see below) it looks to me as if the wording on the wiki should be changed a bit, from <Example how to keep at least 2 lines together> to <Example how to keep at least 2 full lines together> (penalties1 gives me one full line and a second line that is almost full ; penalties2 results in two full lines with a third line that is almost full.). Is my interpretation correct? Denis \setuppapersize[A6] \setuplayout[lines=20] \setupalign[line] \showframe \startsetups[penalties1] \setdefaultpenalties \setpenalties\widowpenalties{1}{10000} \stopsetups \startsetups[penalties2] \setdefaultpenalties \setpenalties\widowpenalties{2}{10000} \stopsetups \starttext \setuplayout[setups=penalties1] \samplefile{tufte}\par Here we are writing some more words to see the effect. Here we are writing some more words to see the effect. Here we are writing some more words to see the effect. \page \setuplayout[setups=penalties2] \samplefile{tufte}\par Here we are writing some more words to see the effect. Here we are writing some more words to see the effect. Here we are writing some more words to see the effect. \stoptext

1 0

itemize margins,
by denis.maier＠ub.unibe.ch 01 Jun '21

01 Jun '21

Hi, in the following example the second line of the quote is not lined up with the first line. ========================= \starttext \startitemize[n] [ %right=), %stopper=, %width=2em, %alternative=fit, %alternative=left, %alternative=intext, %distance=1em, %leftmargin=1em, %itemalign=flushleft, ] \startitem \setupindenting[no] \input knuth \stopitem \stoptext ========================== I've played with different options, but I couldn't get the indents and margins right. What am I missing ? Any hints ? Thanks for you help, Denis

2 2

what happend to \writeline?
by Werner Hennrich 31 May '21

31 May '21

Hello everyone, I'm looking into my environment's logging to trace a problem and realize that \writeline is gone mute - that is, the output of subsequent logging lines now gets joined up in the same line, very hard to read... I observe this in version: 2021.05.27 14:15, as well as in version: 2021.05.27 14:15 the last one I used where \writeline did write (and end) the logging line was version: 2021.03.17 17:46. \def\log#1{ \message{ logging: #1} \writeline logging #1\par } \starttext \log{the} \log{quick} \log{brown} \log{fox} \stoptext used to log like this: logging: the logging: quick logging: brown logging: fox but now: logging: the logging: quick logging: brown logging: fox Any idea how I can switch back the old behavior (on the new lmtx)? Thanks you, Werner

2 2

new page before xtable with repeated headers
by Werner Hennrich 31 May '21

31 May '21

Hello everyone, I'm having an xtable spanning several pages and need to have its headers repeated. For this I've set "split=repeat", but unfortunately this causes the table to start with a new new page leaving the rest of the preceding page empty. Having "split=yes" makes the tabe continue on the previous page as a need it to, but then the header isn't repeated any longer. I realize that there has been a very similar question already in https://www.mail-archive.com/ntg-context@ntg.nl/msg93775.html, but my problem happens isolated in a very clean situation w/o any header, floats or the like - and I don't see yet how I can get this working in my situation. Any help is highly appreciated, here is a MWE of my problem: \definextable[mytable] \setupxtable[mytable] [ option=max, split=repeat, %split=yes, header=repeat, width=\textwidth ] \definextable[mytable:header] \setupxtable[mytable:header] [ foregroundstyle=\bf, foregroundcolor=darkred, ] % ================================================== \startdocument \dorecurse{2} { \input tufte \vskip7mm } \startxtable[mytable] \startxtablehead \startxrow[mytable:header] \startxcell Some Header \stopxcell \startxcell More Header \stopxcell \stopxrow \stopxtablehead \startxtablebody \dorecurse{10} { \startxrow \startxcell {\bf (\recurselevel) some tale:} \startitemize \item a quick \item brown fox \item jumps over \item the lazy dog \stopitemize \stopxcell \startxcell {\bf and a fact:} \startitemize \item the vodka \item is good \item but the meat \item is rotten \stopitemize \stopxcell \stopxrow } \stopxtablebody \stopxtable \stopdocument Thank you very much i.a., Werner

2 7