summaryrefslogtreecommitdiff
path: root/support/nlatexdb/examples/test2.tex
blob: 0c2f6466bbe4a558bdc6abaa2e871ed8214ddf59 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
\documentclass[a4paper]{article}
\usepackage[latin1]{inputenc}
\begin{document}
\newcommand{\texdbconnectionnet}[2]{}
\newcommand{\texdbdef}[3]{}
\newcommand{\texdbfor}[2]{#2}
\newcommand{\texdbif}[2]{#2}
\newcommand{\texdbcommand}[1]{}
\texdbconnectionnet{Mono.Data.Sqlite}{URI=file:kleinertest.db3}
\texdbdef{??personqry}{select id, firstname, lastname, gender, gender from person}{??id,??firstname,??lastname,??gender/m/male/f/female,??pronoun/m/He/f/She}
\texdbdef{??phoneqry}{select phonenumber, phonetype from telephone where fk_person = ??id}{??phonenumber,??phonetype}
\texdbfor{??personqry}{There is a certain ??firstname ??lastname in the database. ??pronoun is ??gender.

\texdbif{??phoneqry}{
Phone numbers:

  \begin{tabular}{ll}
\texdbfor{??phoneqry}{??phonenumber & ??phonetype \\}
\end{tabular}
}}
\end{document}