Proyectos de Subversion Moodle

Rev

| Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1 efrain 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>