2 <?xml version="1.0" encoding="ISO-8859-1"?>
4 <!ELEMENT phrasebook (dictionary)*>
5 <!ELEMENT dictionary (phrase)*>
6 <!ATTLIST dictionary name CDATA #REQUIRED>
7 <!ELEMENT phrase (#PCDATA)>
8 <!ATTLIST phrase name CDATA #REQUIRED>
13 <dictionary name="MySQL">
14 <phrase name="SELECT_ITEMS_BY_ITEMNUBER">
15 "select * from items where itemnumber = $itm";
17 <phrase name="SELECT_LAST_BRANCHTRANSFERS_BY_ITEMNUMBER">
18 "select max(branchtransfers.datearrived) from branchtransfers where branchtransfers.itemnumber=$var1"
20 <phrase name="SELECT_ALL_BRANCHTRANSFERS_BY_ITEMNUMBER_DATEARRIVED">
21 "Select * from branchtransfers where branchtransfers.itemnumber=$var1 and branchtransfers.datearrived=$var2"
23 <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_TIMESTAMP">
24 "Select count(*) from issues where issues.itemnumber=$itm and issues.timestamp > $dat"
26 <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
27 "Select count(*) from issues where itemnumber=$itm and branchcode = $brc"
29 <phrase name="SELECT_MAX_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
30 "Select max(timestamp) from issues where itemnumber=$itm and branchcode = $brc";
32 <phrase name="SELECT_LAST_BRANCHTRANSFER_BY_ITEMNUMBER_AND_TOBRANCH">
33 "Select max(datearrived) from branchtransfers where itemnumber=$itm and tobranch = $brc";
37 <dictionary name="PostgreSQL">
38 <phrase name="SELECT_ITEMS_BY_ITEMNUBER">
39 "select * from items where itemnumber = $itm";
41 <phrase name="SELECT_LAST_BRANCHTRANSFERS_BY_ITEMNUMBER">
42 "select max(branchtransfers.datearrived) from branchtransfers where branchtransfers.itemnumber=$var1"
44 <phrase name="SELECT_ALL_BRANCTRANSFERS_BY_ITEMNUMBER_DATEARRIVED">
45 "Select * from branchtransfers where branchtransfers.itemnumber=$var1 and branchtransfers.datearrived=$var2"
47 <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_TIMESTAMP">
48 "Select count(*) from issues where issues.itemnumber=$itm and issues.timestamp > $dat"
50 <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
51 "Select count(*) from issues where itemnumber=$itm and branchcode = $brc"
53 <phrase name="SELECT_MAX_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
54 "Select max(timestamp) from issues where itemnumber=$itm and branchcode = $brc";
56 <phrase name="SELECT_LAST_BRANCHTRANSFER_BY_ITEMNUMBER_AND_TOBRANCH">
57 "Select max(datearrived) from branchtransfers where itemnumber=$itm and tobranch = $brc";