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