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                         <name>Silly Fact table</name>
  22                         <description>Silly Fact table</description>
  23                         <tablename>stats.silly_fact</tablename>
  24
  25                         <partition>
  26                                 <field>said_when</field>
  27                                 <!-- Valid options:  years, months, weeks, days, hours, minutes, seconds  -->
  28                                 <chunk>months</chunk>
  29                                 <start>2005-09-01</start>
  30                                 <end>2005-12-31</end>
  31                         </partition>
  32
  33                         <fields>
  34                                 <field
  35                                   name="silly_word_dim"
  36                                   datatype="int"
  37                                   indexed="true">
  38                                         <label>Silly word dim</label>
  39                                         <description>Silly word entry dimension link</description>
  40                                 </field>
  41                                 <field
  42                                   name="silly_sayer_dim"
  43                                   datatype="int"
  44                                   indexed="true">
  45                                         <label>Silly sayer dim</label>
  46                                         <description>Silly sayer entry dimension link</description>
  47                                 </field>
  48                                 <field
  49                                   name="said_when"
  50                                   datatype="timestamptz"
  51                                   core="true"
  52                                   indexed="true"
  53                                   default="now()">
  54                                         <label>Silly word timestamp</label>
  55                                         <description>Silly word entry timestamp</description>
  56                                 </field>
  57                         </fields>
  58                         <links>
  59                                 <link
  60                                   field="silly_word_dim"
  61                                   table="silly.word_dim"
  62                                   key="id"
  63                                   type="has_a"/>
  64                                 <link
  65                                   field="silly_sayer_dim"
  66                                   table="silly.sayer_dim"
  67                                   key="id"
  68                                   type="has_a"/>
  69                         </links>
  70                 </table>
  71
  72                 <table id="silly.word_dim">
  73                         <name>Silly word list</name>
  74                         <description>Silly word list</description>
  75                         <tablename>stats.words</tablename>
  76                         <fields>
  77                                 <field
  78                                   name="id"
  79                                   primary="1"
  80                                   create-type="serial"
  81                                   datatype="int"/>
  82                                 <field
  83                                   name="word"
  84                                   datatype="text"
  85                                   indexed="true"
  86                                   index-type="BTREE"/>
  87                         </fields>
  88                 </table>
  89
  90                 <table id="silly.sayer_dim">
  91                         <name>Silly word sayer list</name>
  92                         <description>Silly word sayer list</description>
  93                         <tablename>stats.silly_sayers</tablename>
  94                         <fields>
  95                                 <field
  96                                   name="id"
  97                                   primary="1"
  98                                   create-type="serial"
  99                                   datatype="int"/>
 100                                 <field
 101                                   name="sayer"
 102                                   datatype="text"
 103                                   indexed="true"
 104                                   index-type="BTREE"/>
 105                         </fields>
 106                 </table>
 107
 108         </tables>
 109 </reporter>