tenfourfox/dom/xul/templates/tests/chrome/test_tmpl_storage_parameters.xul
Cameron Kaiser c9b2922b70 hello FPR
2017-04-19 00:56:45 -07:00

161 lines
4.7 KiB
XML

<?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 query parameters
-->
<window title="XUL Template Tests" width="500" height="600"
onload="test_storage_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-birds">
<listitem anyid="true" label="Barn Owl"/>
<listitem anyid="true" label="Emu"/>
<listitem anyid="true" label="Raven"/>
</data>
<data id="output-L">
<listitem anyid="true" label="LAMA"/>
<listitem anyid="true" label="Lion"/>
</data>
<script src="templates_shared.js"/>
<script>
<![CDATA[
copyToProfile('animals.sqlite');
SimpleTest.waitForExplicitFinish();
function test_storage_template()
{
var root = document.getElementById("root1");
expectedOutput = document.getElementById("output-birds");
checkResults(root, 0);
root = document.getElementById("root2");
checkResults(root, 0);
root = document.getElementById("root6");
checkResults(root, 0);
root = document.getElementById("root3");
expectedOutput = document.getElementById("output-L");
checkResults(root, 0);
root = document.getElementById("root4");
checkResults(root, 0);
root = document.getElementById("root5");
checkResults(root, 0);
SimpleTest.finish();
}
var testid ="storage listbox with query parameters";
var queryType = "storage";
var isTreeBuilder = false;
var needsOpen = false;
var notWorkingYet = false;
var notWorkingYetDynamic = false;
var expectedOutput;
var changes = [];
]]>
</script>
<listbox xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root1"
flex="1" datasources="profile:animals.sqlite" ref="." querytype="storage">
<template>
<query>
SELECT * FROM animals WHERE species_id = ? ORDER BY name
<param>2</param>
</query>
<action>
<listitem uri="?" label="?name"/>
</action>
</template>
</listbox>
<listbox xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root2"
flex="1" datasources="profile:animals.sqlite" ref="." querytype="storage">
<template>
<query>
SELECT * FROM animals WHERE species_id = ? ORDER BY name
<param type="int32">2</param>
</query>
<action>
<listitem uri="?" label="?name"/>
</action>
</template>
</listbox>
<listbox xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root3"
flex="1" datasources="profile:animals.sqlite" ref="." querytype="storage">
<template>
<query>
SELECT * FROM animals WHERE species_id = :spec AND name like ? ORDER BY name
<param name="spec" type="int32">5</param>
<param>L%</param>
</query>
<action>
<listitem uri="?" label="?name"/>
</action>
</template>
</listbox>
<listbox xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root4"
flex="1" datasources="profile:animals.sqlite" ref="." querytype="storage">
<template>
<query>
SELECT * FROM animals WHERE species_id = ?3 AND name like ?1 ORDER BY name
<param index="3" type="int32">5</param>
<param index="1">L%</param>
</query>
<action>
<listitem uri="?" label="?name"/>
</action>
</template>
</listbox>
<listbox xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root5"
flex="1" datasources="profile:animals.sqlite" ref="." querytype="storage">
<template>
<query>
SELECT * FROM animals WHERE species_id = ?3 AND name like :pattern ORDER BY name
<param name="pattern">L%</param>
<param index="3" type="int32">5</param>
</query>
<action>
<listitem uri="?" label="?name"/>
</action>
</template>
</listbox>
<listbox xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root6"
flex="1" datasources="profile:animals.sqlite" ref="." querytype="storage">
<template>
<query>
SELECT * FROM animals WHERE species_id = ? ORDER BY name
<param type="int32">2qsdqsd</param>
</query>
<action>
<listitem uri="?" label="?name"/>
</action>
</template>
</listbox>
</window>