summaryrefslogtreecommitdiff
path: root/tex/context/base/mkiv/mtx-context-sql.tex
blob: 16613c2453af74437a9823102a6f89e43a641fa1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
%D \module
%D   [       file=mtx-context-sql-tables,
%D        version=2012.10.19,
%D          title=\CONTEXT\ Extra Trickry,
%D       subtitle=SQL Tables,
%D         author=Hans Hagen,
%D           date=\currentdate,
%D      copyright={PRAGMA ADE \& \CONTEXT\ Development Team}]
%C
%C This module is part of the \CONTEXT\ macro||package and is
%C therefore copyrighted by \PRAGMA. See mreadme.pdf for
%C details.

% begin help
%
% usage: context --extra=sql --tables [options]
%
% --host                  : hostname (default: localhost)
% --username              : username (default: root)
% --password              : password
% --database              : database of which we want tables
%
% example: context --extra=sql --tables --host=localhost --username=root --password=*** --database=test
%
% end help

\usemodule
  [art-01,sql-tables]

\setupbodyfont
  [10pt]

\setupheader
  [state=high]

\setuptabulate
  [before={\blank[big,samepage]}]

\starttext

\startluacode

    require("s-sql-tables")

    local arguments = environment.arguments

    local presets   = arguments.presets
    local preloaded = presets and table.load(presets) or { }

    local presets   = {
        host     = preloaded.host     or arguments.host     or "localhost",
        username = preloaded.username or arguments.username or "root",
        password = preloaded.password or arguments.password or "",
        database = preloaded.database or arguments.database or "",
    }


    if arguments.tables then
        moduledata.sql.tables.showdefined(presets)
    end

\stopluacode

\stoptext