Open-ILS/src/reporter/report_base.example.xml

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <reporter xmlns:xi="http://www.w3.org/2001/XInclude">
   3
   4         <setup>
   5                 <files>
   6                         <stage1>/tmp/reporter/</stage1>
   7                         <stage2>/tmp/reporter/</stage2>
   8                         <stage3>/tmp/reporter/</stage3>
   9                 </files>
  10                 <database>
  11                         <host>10.0.0.2</host>
  12                         <name>demo-dev</name>
  13                         <user>postgres</user>
  14                         <password/>
  15                 </database>
  16         </setup>
  17
  18         <tables>
  19
  20                 <table id="silly.fact" partition="true">
  21                         <tablename>stats.silly_fact</tablename>
  22
  23                         <partition>
  24                                 <field>said_when</field>
  25                                 <!-- Valid options:  month, year, woy (week of year), doy (day of year) -->
  26                                 <chunk>month</chunk>
  27                                 <start>2005-09-01</start>
  28                                 <end>2005-12-31</end>
  29                         </partition>
  30
  31                         <fields>
  32                                 <field
  33                                   name="silly_word_dim"
  34                                   datatype="int"
  35                                   indexed="true">
  36                                         <label>Silly word dim</label>
  37                                         <description>Silly word entry dimension link</description>
  38                                 </field>
  39                                 <field
  40                                   name="silly_sayer_dim"
  41                                   datatype="int"
  42                                   indexed="true">
  43                                         <label>Silly sayer dim</label>
  44                                         <description>Silly sayer entry dimension link</description>
  45                                 </field>
  46                                 <field
  47                                   name="said_when"
  48                                   datatype="timestamptz"
  49                                   core="true"
  50                                   indexed="true"
  51                                   default="now()">
  52                                         <label>Silly word timestamp</label>
  53                                         <description>Silly word entry timestamp</description>
  54                                 </field>
  55                         </fields>
  56                         <links>
  57                                 <link
  58                                   field="silly_word_dim"
  59                                   table="silly.word_dim"
  60                                   key="id"
  61                                   type="has_a"/>
  62                                 <link
  63                                   field="silly_sayer_dim"
  64                                   table="silly.sayer_dim"
  65                                   key="id"
  66                                   type="has_a"/>
  67                         </links>
  68                 </table>
  69
  70                 <table id="silly.word_dim">
  71                         <name>Silly word list</name>
  72                         <tablename>stats.words</tablename>
  73                         <fields>
  74                                 <field
  75                                   name="id"
  76                                   primary="1"
  77                                   create-type="serial"
  78                                   datatype="int"/>
  79                                 <field
  80                                   name="word"
  81                                   datatype="text"
  82                                   indexed="true"
  83                                   index-type="BTREE"/>
  84                         </fields>
  85                 </table>
  86
  87                 <table id="silly.sayer_dim">
  88                         <name>Silly word sayer list</name>
  89                         <tablename>stats.silly_sayers</tablename>
  90                         <fields>
  91                                 <field
  92                                   name="id"
  93                                   primary="1"
  94                                   create-type="serial"
  95                                   datatype="int"/>
  96                                 <field
  97                                   name="sayer"
  98                                   datatype="text"
  99                                   indexed="true"
 100                                   index-type="BTREE"/>
 101                         </fields>
 102                 </table>
 103
 104         </tables>
 105 </reporter>