[Summary view] [Print] [Text view]

   1  <?xml version="1.0" encoding="UTF-8" ?>
   2  <!-- Single login - Tests queries 1, 2 (with logins), 4 -->
   3  <dataset>
   4      <table name="log">
   5          <column>time</column>
   6          <column>userid</column>
   7          <column>course</column>
   8          <column>action</column>
   9          <row>
  10              <value>[start_1]</value>
  11              <value>[user1_id]</value>
  12              <value>[site_id]</value>
  13              <value>login</value>
  14          </row>
  15      </table>
  16      <table name="stats_daily">
  17          <column>courseid</column>
  18          <column>timeend</column>
  19          <column>roleid</column>
  20          <column>stattype</column>
  21          <column>stat1</column>
  22          <column>stat2</column>
  23          <!-- Query 2 -->
  24          <row>
  25              <value>[site_id]</value>
  26              <value>[end]</value>
  27              <value>0</value>
  28              <value>logins</value>
  29              <value>1</value>
  30              <value>1</value>
  31          </row>
  32          <!-- Query 3 -->
  33          <row>
  34              <value>[course1_id]</value>
  35              <value>[end]</value>
  36              <value>[student_roleid]</value>
  37              <value>enrolments</value>
  38              <value>1</value>
  39              <value>0</value>
  40          </row>
  41          <!-- Query 5 -->
  42          <row>
  43              <value>[course1_id]</value>
  44              <value>[end]</value>
  45              <value>0</value>
  46              <value>enrolments</value>
  47              <value>1</value>
  48              <value>0</value>
  49          </row>
  50          <!-- Query 7 -->
  51          <row>
  52              <value>[site_id]</value>
  53              <value>[end]</value>
  54              <value>0</value>
  55              <value>enrolments</value>
  56              <value>4</value>
  57              <value>1</value>
  58          </row>
  59          <!-- Query 9 -->
  60          <row>
  61              <value>[site_id]</value>
  62              <value>[end]</value>
  63              <value>[frontpage_roleid]</value>
  64              <value>enrolments</value>
  65              <value>4</value>
  66              <value>1</value>
  67          </row>
  68          <!-- Query 11 -->
  69          <row>
  70              <value>[site_id]</value>
  71              <value>[end]</value>
  72              <value>0</value>
  73              <value>activity</value>
  74              <value>0</value>
  75              <value>0</value>
  76          </row>
  77      </table>
  78      <table name="stats_user_daily">
  79          <column>courseid</column>
  80          <column>userid</column>
  81          <column>roleid</column>
  82          <column>timeend</column>
  83          <column>statsreads</column>
  84          <column>statswrites</column>
  85          <column>stattype</column>
  86          <!-- Query 1 -->
  87          <row>
  88              <value>[site_id]</value>
  89              <value>[user1_id]</value>
  90              <value>0</value>
  91              <value>[end]</value>
  92              <value>1</value>
  93              <value>0</value>
  94              <value>logins</value>
  95          </row>
  96          <!-- Query 10 - read -->
  97          <row>
  98              <value>[site_id]</value>
  99              <value>[user1_id]</value>
 100              <value>0</value>
 101              <value>[end]</value>
 102              <value>0</value>
 103              <value>0</value>
 104              <value>activity</value>
 105          </row>
 106          <!-- Query 10 - default record -->
 107          <row>
 108              <value>[site_id]</value>
 109              <value>0</value>
 110              <value>0</value>
 111              <value>[end]</value>
 112              <value>0</value>
 113              <value>0</value>
 114              <value>activity</value>
 115          </row>
 116      </table>
 117  </dataset>