From a56add7424d858e2dab0c6ec5cf3681a4b47666b Mon Sep 17 00:00:00 2001
From: ahbanks <ahbanks>
Date: Mon, 7 Apr 2003 19:44:11 +0000
Subject: [PATCH] Staring Phrasebook for bookcount.pl

---
 lib/bookcount.xml | 62 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 62 insertions(+)
 create mode 100644 lib/bookcount.xml

diff --git a/lib/bookcount.xml b/lib/bookcount.xml
new file mode 100644
index 0000000000..6e2e548a23
--- /dev/null
+++ b/lib/bookcount.xml
@@ -0,0 +1,62 @@
+
+ <?xml version="1.0" encoding="ISO-8859-1"?>
+ <!DOCTYPE phrasebook [
+ <!ELEMENT phrasebook (dictionary)*>
+ <!ELEMENT dictionary (phrase)*>
+ <!ATTLIST dictionary name CDATA #REQUIRED>
+ <!ELEMENT phrase (#PCDATA)>
+ <!ATTLIST phrase name CDATA #REQUIRED>
+ ]>
+
+
+ <phrasebook>
+  <dictionary name="MySQL">
+   <phrase name="SELECT_ITEMS_BY_ITEMNUBER">
+    "select * from items where itemnumber = $itm";
+   </phrase>
+   <phrase name="SELECT_LAST_BRANCHTRANSFERS_BY_ITEMNUMBER">
+    "select max(branchtransfers.datearrived) from branchtransfers where branchtransfers.itemnumber=$var1"
+   </phrase>
+   <phrase name="SELECT_ALL_BRANCTRANSFERS_BY_ITEMNUMBER_DATEARRIVED">
+    "Select * from branchtransfers where branchtransfers.itemnumber=$var1 and branchtransfers.datearrived=$var2"
+   </phrase>
+   <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_TIMESTAMP">
+    "Select count(*) from issues where issues.itemnumber=$itm and issues.timestamp > $dat"
+   </phrase>
+   <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
+    "Select count(*) from issues where itemnumber=$itm and branchcode = $brc"
+   </phrase>
+   <phrase name="SELECT_MAX_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
+    "Select max(timestamp) from issues where itemnumber=$itm and branchcode = $brc";
+   </phrase>
+   <phrase name="SELECT_LAST_BRANCHTRANSFER_BY_ITEMNUMBER_AND_TOBRANCH">
+    "Select max(datearrived) from branchtransfers where itemnumber=$itm and tobranch = $brc";
+   </phrase>
+  </dictionary>
+
+  <dictionary name="PostgreSQL">
+   <phrase name="SELECT_ITEMS_BY_ITEMNUBER">
+    "select * from items where itemnumber = $itm";
+   </phrase>
+   <phrase name="SELECT_LAST_BRANCHTRANSFERS_BY_ITEMNUMBER">
+    "select max(branchtransfers.datearrived) from branchtransfers where branchtransfers.itemnumber=$var1"
+   </phrase>
+   <phrase name="SELECT_ALL_BRANCTRANSFERS_BY_ITEMNUMBER_DATEARRIVED">
+    "Select * from branchtransfers where branchtransfers.itemnumber=$var1 and branchtransfers.datearrived=$var2"
+   </phrase>
+   <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_TIMESTAMP">
+    "Select count(*) from issues where issues.itemnumber=$itm and issues.timestamp > $dat"
+   </phrase>
+   <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
+    "Select count(*) from issues where itemnumber=$itm and branchcode = $brc"
+   </phrase>
+   <phrase name="SELECT_MAX_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
+    "Select max(timestamp) from issues where itemnumber=$itm and branchcode = $brc";
+   </phrase>
+   <phrase name="SELECT_LAST_BRANCHTRANSFER_BY_ITEMNUMBER_AND_TOBRANCH">
+    "Select max(datearrived) from branchtransfers where itemnumber=$itm and tobranch = $brc";
+   </phrase>
+  </dictionary> 
+ </phrasebook>
+
+
-- 
2.11.0