Difference between revisions of "M-database"

From Wiki
Jump to navigation Jump to search
m (move CSV link from top to bottom list, fix link titles)
(new example)
 
(2 intermediate revisions by one other user not shown)
Line 3: Line 3:
 
{{todo|more examples and explanation}}
 
{{todo|more examples and explanation}}
  
<texcode>
+
== Inline ==
\usemodule[database]
 
  
\defineseparatedlist [MyTable]
+
(This might be outdated)
[
 
    separator=tab,
 
    before=\bTABLE, after=\eTABLE,
 
    first=\bTR, last=\eTR,
 
    left=\bTD, right=\eTD,
 
    commentchar=\letterpercent,
 
]
 
% The % must be set as the comment char explicitly, because by default its catcode is changed.
 
 
 
% columns are separated with a tab (not with a space)
 
\startMyTable
 
% Cows in Holland, 1 unit meaning 1000 cows.
 
Cows Total Milking Pregnant
 
01/1995 1709 1449 260
 
01/1996 1713 1444 269
 
... ... ... ...
 
11/2004 1457 1295 161
 
11/2005 1421 1263 158
 
\stopMyTable
 
</texcode>
 
  
<context>
+
<context source=yes mode=mkiv>
 
\setuplayout[scale=0.8]
 
\setuplayout[scale=0.8]
 
\setupcolors[state=start]
 
\setupcolors[state=start]
Line 57: Line 36:
 
11/2005 1421 1263 158
 
11/2005 1421 1263 158
 
\stopMyTable
 
\stopMyTable
 +
 +
%load from a file
 +
%\processseparatedfile[TSV][cows.tsv]
 +
 +
</context>
 +
 +
==Data from File==
 +
 +
(This is current as of 2016-05-31)
 +
 +
<context source=yes mode=mkiv>
 +
\usemodule[database]
 +
 +
\starttext
 +
 +
\defineseparatedlist
 +
[test]
 +
[separator=space, % tab
 +
  before=\bTABLE,after=\eTABLE,
 +
  first=\bTR,last=\eTR,
 +
  left=\bTD,right=\eTD]
 +
 +
\processdatabasefile[test][csv.csv]
 +
 +
\stoptext
  
 
</context>
 
</context>

Latest revision as of 04:03, 1 June 2016

< m-database source | Tables Overview >


TODO: more examples and explanation (See: To-Do List)


Inline

(This might be outdated)

\setuplayout[scale=0.8]
\setupcolors[state=start]
\usemodule[database]

\defineseparatedlist
  [MyTable]
  [separator=tab,
   left=\bTD,right=\eTD,
   first=\bTR,last=\eTR,
   before=\bTABLE,after=\eTABLE]

\setupTABLE[c][each][align=flushright,width=2.5cm,align=middle]
\setupTABLE[r][1][background=color,backgroundcolor=gray]
\startMyTable
Cows	Total	Milking	Pregnant
01/1995	1709	1449	260
01/1996	1713	1444	269
01/1997	1606	1387	219
01/1998	1634	1416	218
11/1998	1558	1350	208
11/1999	1520	1307	212
11/2000	1475	1285	190
11/2001	1496	1345	151
11/2002	1498	1338	160
11/2003	1492	1324	169
11/2004	1457	1295	161
11/2005	1421	1263	158
\stopMyTable

%load from a file
%\processseparatedfile[TSV][cows.tsv]

Data from File

(This is current as of 2016-05-31)

\usemodule[database]

\starttext

\defineseparatedlist
 [test]
 [separator=space, % tab
  before=\bTABLE,after=\eTABLE,
  first=\bTR,last=\eTR,
  left=\bTD,right=\eTD]

\processdatabasefile[test][csv.csv]

\stoptext

internal error: copy error 1LWKBY/cropped.pdf

Links