[Summary view] [Print] [Text view]

   1  <?xml version="1.0" encoding="UTF-8" ?>
   2  <!-- User login and view course (not enrolled) - Tests queries 13 (not enroled), 14 (not default) -->
   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>[user2_id]</value>
  12              <value>[site_id]</value>
  13              <value>login</value>
  14          </row>
  15          <row>
  16              <value>[start_2]</value>
  17              <value>[user2_id]</value>
  18              <value>[site_id]</value>
  19              <value>view</value>
  20          </row>
  21          <row>
  22              <value>[start_3]</value>
  23              <value>[user2_id]</value>
  24              <value>[course1_id]</value>
  25              <value>view</value>
  26          </row>
  27      </table>
  28      <table name="stats_daily">
  29          <column>courseid</column>
  30          <column>timeend</column>
  31          <column>roleid</column>
  32          <column>stattype</column>
  33          <column>stat1</column>
  34          <column>stat2</column>
  35          <!-- Query 2 -->
  36          <row>
  37              <value>[site_id]</value>
  38              <value>[end]</value>
  39              <value>0</value>
  40              <value>logins</value>
  41              <value>1</value>
  42              <value>1</value>
  43          </row>
  44          <!-- Query 3 -->
  45          <row>
  46              <value>[course1_id]</value>
  47              <value>[end]</value>
  48              <value>[student_roleid]</value>
  49              <value>enrolments</value>
  50              <value>1</value>
  51              <value>0</value>
  52          </row>
  53          <!-- Query 5 -->
  54          <row>
  55              <value>[course1_id]</value>
  56              <value>[end]</value>
  57              <value>0</value>
  58              <value>enrolments</value>
  59              <value>1</value>
  60              <value>0</value>
  61          </row>
  62          <!-- Query 7 -->
  63          <row>
  64              <value>[site_id]</value>
  65              <value>[end]</value>
  66              <value>0</value>
  67              <value>enrolments</value>
  68              <value>4</value>
  69              <value>1</value>
  70          </row>
  71          <!-- Query 9 -->
  72          <row>
  73              <value>[site_id]</value>
  74              <value>[end]</value>
  75              <value>[frontpage_roleid]</value>
  76              <value>enrolments</value>
  77              <value>4</value>
  78              <value>1</value>
  79          </row>
  80          <!-- Query 11 -->
  81          <row>
  82              <value>[site_id]</value>
  83              <value>[end]</value>
  84              <value>0</value>
  85              <value>activity</value>
  86              <value>1</value>
  87              <value>0</value>
  88          </row>
  89          <!-- Query 11 -->
  90          <row>
  91              <value>[course1_id]</value>
  92              <value>[end]</value>
  93              <value>0</value>
  94              <value>activity</value>
  95              <value>1</value>
  96              <value>0</value>
  97          </row>
  98          <!-- Query 13 -->
  99          <row>
 100              <value>[course1_id]</value>
 101              <value>[end]</value>
 102              <value>[guest_roleid]</value>
 103              <value>activity</value>
 104              <value>1</value>
 105              <value>0</value>
 106          </row>
 107          <!-- Query 14 -->
 108          <row>
 109              <value>[site_id]</value>
 110              <value>[end]</value>
 111              <value>[frontpage_roleid]</value>
 112              <value>activity</value>
 113              <value>1</value>
 114              <value>0</value>
 115          </row>
 116      </table>
 117      <table name="stats_user_daily">
 118          <column>courseid</column>
 119          <column>userid</column>
 120          <column>roleid</column>
 121          <column>timeend</column>
 122          <column>statsreads</column>
 123          <column>statswrites</column>
 124          <column>stattype</column>
 125          <!-- Query 1 -->
 126          <row>
 127              <value>[site_id]</value>
 128              <value>[user2_id]</value>
 129              <value>0</value>
 130              <value>[end]</value>
 131              <value>1</value>
 132              <value>0</value>
 133              <value>logins</value>
 134          </row>
 135          <!-- Query 10 -->
 136          <row>
 137              <value>[course1_id]</value>
 138              <value>[user2_id]</value>
 139              <value>0</value>
 140              <value>[end]</value>
 141              <value>1</value>
 142              <value>0</value>
 143              <value>activity</value>
 144          </row>
 145          <!-- Query 10 -->
 146          <row>
 147              <value>[site_id]</value>
 148              <value>[user2_id]</value>
 149              <value>0</value>
 150              <value>[end]</value>
 151              <value>1</value>
 152              <value>0</value>
 153              <value>activity</value>
 154          </row>
 155          <!-- Query 10 - default record -->
 156          <row>
 157              <value>[site_id]</value>
 158              <value>0</value>
 159              <value>0</value>
 160              <value>[end]</value>
 161              <value>0</value>
 162              <value>0</value>
 163              <value>activity</value>
 164          </row>
 165      </table>
 166  </dataset>