[Summary view] [Print] [Text view]

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