blob: 28dcaa92650e7631a10f5a6b7cfbbf76ec98fe31 (
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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
<?xml version="1.0"?>
<?xml-stylesheet href="chrome://global/skin" type="text/css"?>
<?xml-stylesheet href="chrome://mochikit/content/tests/SimpleTest/test.css" type="text/css"?>
<!--
storage listbox with multiqueries
-->
<window title="XUL Template Tests" width="500" height="600"
onload="test_template();"
xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul">
<script type="application/javascript"
src="chrome://mochikit/content/tests/SimpleTest/SimpleTest.js"></script>
<body xmlns="http://www.w3.org/1999/xhtml" style="height: 300px; overflow: auto;"/>
<data id="output">
<listitem anyid="true" label="Mammal: African Elephant"/>
<listitem anyid="true" label="Mammal: Gorilla" style="font-weight:bold"/>
<listitem anyid="true" label="Mammal: HIPPOPOTAMUS"/>
<listitem anyid="true" label="Mammal: LAMA"/>
<listitem anyid="true" label="Mammal: Lion"/>
<listitem anyid="true" label="Mammal: Nine-banded Armadillo" style="font-weight:bold"/>
<listitem anyid="true" label="Mammal: Polar Bear"/>
<listitem anyid="true" label="Mammal: aardvark"/>
<listitem anyid="true" label="Bird: Barn Owl" style="font-style:italic"/>
<listitem anyid="true" label="Bird: Emu"/>
<listitem anyid="true" label="Bird: Raven"/>
</data>
<script src="templates_shared.js"/>
<script>
<![CDATA[
SimpleTest.waitForExplicitFinish();
copyToProfile('animals.sqlite');
var testid ="storage listbox with multiqueries";
var queryType = "storage";
var isTreeBuilder = false;
var needsOpen = false;
var notWorkingYet = false;
var notWorkingYetDynamic = false;
var expectedOutput = document.getElementById("output");
var changes = [];
]]>
</script>
<listbox xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root"
flex="1" datasources="profile:animals.sqlite" ref="." querytype="storage">
<template>
<queryset>
<query>SELECT * FROM animals WHERE species_id = 5 ORDER BY name</query>
<rule>
<where subject="?id" rel="greater" value="12"/>
<action>
<listitem uri="?" label="Mammal: ?name" style="font-weight:bold"/>
</action>
</rule>
<rule>
<action>
<listitem uri="?" label="Mammal: ?name"/>
</action>
</rule>
</queryset>
<queryset>
<!-- we use aliases on columns just to have different "column names" in the result set
to "similate" a result set from another table for example -->
<query>SELECT * FROM animals WHERE species_id = 2 ORDER BY name</query>
<rule>
<where subject="?id" rel="equals" value="3"/>
<action>
<listitem uri="?" label="Bird: ?name" style="font-style:italic"/>
</action>
</rule>
<rule>
<action>
<listitem uri="?" label="Bird: ?name"/>
</action>
</rule>
</queryset>
</template>
</listbox>
</window>
|
