lib/bookcount.xml

   1
   2  <?xml version="1.0" encoding="ISO-8859-1"?>
   3  <!DOCTYPE phrasebook [
   4  <!ELEMENT phrasebook (dictionary)*>
   5  <!ELEMENT dictionary (phrase)*>
   6  <!ATTLIST dictionary name CDATA #REQUIRED>
   7  <!ELEMENT phrase (#PCDATA)>
   8  <!ATTLIST phrase name CDATA #REQUIRED>
   9  ]>
  10
  11
  12  <phrasebook>
  13   <dictionary name="MySQL">
  14    <phrase name="SELECT_ITEMS_BY_ITEMNUBER">
  15     "select * from items where itemnumber = $itm";
  16    </phrase>
  17    <phrase name="SELECT_LAST_BRANCHTRANSFERS_BY_ITEMNUMBER">
  18     "select max(branchtransfers.datearrived) from branchtransfers where branchtransfers.itemnumber=$var1"
  19    </phrase>
  20    <phrase name="SELECT_ALL_BRANCHTRANSFERS_BY_ITEMNUMBER_DATEARRIVED">
  21     "Select * from branchtransfers where branchtransfers.itemnumber=$var1 and branchtransfers.datearrived=$var2"
  22    </phrase>
  23    <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_TIMESTAMP">
  24     "Select count(*) from issues where issues.itemnumber=$itm and issues.timestamp > $dat"
  25    </phrase>
  26    <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
  27     "Select count(*) from issues where itemnumber=$itm and branchcode = $brc"
  28    </phrase>
  29    <phrase name="SELECT_MAX_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
  30     "Select max(timestamp) from issues where itemnumber=$itm and branchcode = $brc";
  31    </phrase>
  32    <phrase name="SELECT_LAST_BRANCHTRANSFER_BY_ITEMNUMBER_AND_TOBRANCH">
  33     "Select max(datearrived) from branchtransfers where itemnumber=$itm and tobranch = $brc";
  34    </phrase>
  35   </dictionary>
  36
  37   <dictionary name="PostgreSQL">
  38    <phrase name="SELECT_ITEMS_BY_ITEMNUBER">
  39     "select * from items where itemnumber = $itm";
  40    </phrase>
  41    <phrase name="SELECT_LAST_BRANCHTRANSFERS_BY_ITEMNUMBER">
  42     "select max(branchtransfers.datearrived) from branchtransfers where branchtransfers.itemnumber=$var1"
  43    </phrase>
  44    <phrase name="SELECT_ALL_BRANCTRANSFERS_BY_ITEMNUMBER_DATEARRIVED">
  45     "Select * from branchtransfers where branchtransfers.itemnumber=$var1 and branchtransfers.datearrived=$var2"
  46    </phrase>
  47    <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_TIMESTAMP">
  48     "Select count(*) from issues where issues.itemnumber=$itm and issues.timestamp > $dat"
  49    </phrase>
  50    <phrase name="SELECT_COUNT_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
  51     "Select count(*) from issues where itemnumber=$itm and branchcode = $brc"
  52    </phrase>
  53    <phrase name="SELECT_MAX_ISSUES_BY_ITEMNUMBER_BRANCHCODE">
  54     "Select max(timestamp) from issues where itemnumber=$itm and branchcode = $brc";
  55    </phrase>
  56    <phrase name="SELECT_LAST_BRANCHTRANSFER_BY_ITEMNUMBER_AND_TOBRANCH">
  57     "Select max(datearrived) from branchtransfers where itemnumber=$itm and tobranch = $brc";
  58    </phrase>
  59   </dictionary>
  60  </phrasebook>
  61
  62