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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
|
<?xml version="1.0" encoding="utf-8"?>
<page xmlns="http://projectmallard.org/1.0/" type="topic" id="data-manager-xml-syntax" xml:lang="sl">
<info>
<title type="sort">1</title>
</info>
<title>Skladnja XML podatkovnega upravljalnika</title>
<p>
The XML tree's root node must be a <code><data></code>, which
is allowed to contain one or more data source definitions.
Each data source is defined by <code><query></code> or <code><table></code> nodes,
both accepting the following optional attributes:
</p>
<list>
<item><p>"id" to specify a data source string ID, used when linking data sources one to another;</p></item>
<item><p>"naziv" za določevanje naziva.</p></item>
</list>
<p>
It is of course possible to use both the <code><query></code> or <code><table></code> tags
in the same data sources specifications.
</p>
<section id="data-manager-exp-variables">
<title>Izvožene spremenljivke</title>
<p>
Each data source exports some variables which can be reused by other data sources to introduce
a dependency. When the data sources are executed, the contents of these exported variables are
reset depending on the row actually selected in the resulting tabular view. If no row is selected
then the variable is unset.
</p>
<p>
Any data source depending on a variable is executed again when the variable changes, and
in case the variable is unset, the data source's execution result is an empty data set.
</p>
</section>
<section id="data-manager-query-tag">
<title>The <code><query></code> tag</title>
<p>
Use the <code><query></code> tag to specify an SQL SELECT statement, as the contents of the tag.
Linkage to other data sources can be achieved using <link xref="variables-syntax">variables</link> in the
SELECT's SQL.
</p>
<code><![CDATA[
<data>
<query title="Customers" id="customers">
SELECT id, name FROM customers where name like ##name::string
</query>
<query title="Customer's details" id="cust_details">
SELECT * FROM customers WHERE id=##customers@id::int
</query>
</data>]]>
</code>
<p>
For example the previous XML specification defines two data sources:
</p>
<list>
<item><p>the <code>customers</code> data source which selects some fields from the
<em>customers</em> table, and which depends on a string variable named <code>name</code>.
This variable has to be set when the data sources are executed because it won't be exported
by any data source in this specification.</p></item>
<item><p>the <code>cust_details</code> data source which selects all the details of a customer
specified using its ID. This second data source depends on the previous one because the
<code>customers@id</code> variable is exported from the <code>customers</code> data source.
</p></item>
</list>
<p>
Executing this data sources specification will create two tabular views: one where you can select
a customer, and one which displays all the attributes for the selected customer.
</p>
<section id="data-manager-query-exp-variables">
<title>Izvožene spremenljivke</title>
<p>
Each data source defined by a <code><query></code> tag exports the following variable for
each column of the resulting data set (the variable's type is the same as the column's type):
</p>
<list>
<item><p><code><data source ID>@<column position></code> where the column's position
starts at 1</p></item>
<item><p><code><data source ID>@<column name> if the data set's column is a table column</code></p></item>
</list>
</section>
</section>
<section id="data-manager-table-tag">
<title>The <code><table></code> tag</title>
<p>
Use the <code><table></code> tag to define a data source which will display the contents of a table.
This tag:
</p>
<list>
<item><p>requires the "name" attribute which represents the table name.</p></item>
<item><p>can have a "id" attribute corresponding to the data source's ID. If not present,
and ID will be assigned automatically.</p></item>
<item><p>can contain a <code><depend></code> tag which defines a dependency on another
data source with
the "foreign_key_table" attribute defining the name of the table to which there are foreign keys
used to determine the dependency, and the "id" attribute can specify a data source ID if different than
the aforementioned table</p></item>
</list>
<p>
The <code><depend></code> tag, which, for a data source from a table, defines a dependency to
another data source from a table:
</p>
<list>
<item><p>requires the "foreign_key_table" attribute defining the name of the table to which there are
foreign keys used to determine the dependency</p></item>
<item><p>can have a "id" attribute corresponding to the ID of the referenced data source. If not
provided, then the dependency may fail if there is no data source which ID is the"foreign_key_table"
attribute.</p></item>
<item><p>can contain one or more <code><column></code> tag which contents define the columns
to identify the foreign key to use; this is necessary if there are multiple foreign keys,
and can be omitted if there is only one possible foreign key. The listed columns are the one
from the table where the foreign key exists.</p></item>
</list>
<code><![CDATA[
<data>
<table id="the_cust" name="customers"/>
<table name="orders">
<depend id="the_cust" foreign_key_table="customers">
<column>customer_id</column>
</depend>
</table>
</data>]]>
</code>
<p>
For example the previous XML specification defines two data sources:
</p>
<list>
<item><p>the <code>customers</code> data source which selects all the contents of the
<em>customers</em> table.</p></item>
<item><p>the <code>orders</code> data source which selects among contents of the <code>orders</code>
table, the rows which correspond to a row in the <code>customers</code> table using the foreign key
on table orders which involves the "orders.customer_id" column and the primary key of the
customers table. The "id" attribute of the <code><depend></code> tag is necessary here to
identify referenced the data source.
</p></item>
</list>
<p>Bodite pozorni, da v tem primeru:</p>
<list>
<item><p>you don't have to specify the fields involved in the foreign key linking the
<code>orders</code> and <code>customers</code> tables</p></item>
<item><p>the data sources IDs have been assigned the names of the selected tables as no "id" attribute
has been specified for the <code><table></code> tags.</p></item>
</list>
<section id="data-manager-table-exp-variables">
<title>Izvožene spremenljivke</title>
<p>
Each data source defined by a <code><query></code> tag exports the following variable for
each table's column (the variable's type is the same as the column's type):
</p>
<list>
<item><p><code><data source ID>@<column name></code></p></item>
<item><p><code><data source ID>@<column position></code> where the column's position
starts at 1</p></item>
</list>
</section>
</section>
</page>
|
