|
sl@0
|
1 |
// Create tests
|
|
sl@0
|
2 |
|
|
sl@0
|
3 |
[create1]
|
|
sl@0
|
4 |
SPCreateL0=
|
|
sl@0
|
5 |
SetDBPolicy1=ESchemaPolicy,ECapabilityAllFiles
|
|
sl@0
|
6 |
SetDBPolicy2=EReadPolicy,ECapabilityAllFiles
|
|
sl@0
|
7 |
CreateSP3=[102827c7]sec.db
|
|
sl@0
|
8 |
SPClose4=
|
|
sl@0
|
9 |
Exec5=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
10 |
Exec6=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
11 |
Exec7=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
12 |
Exec8=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
13 |
Exec9=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
14 |
Exec10=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
15 |
Close11=
|
|
sl@0
|
16 |
EndBlock12=
|
|
sl@0
|
17 |
|
|
sl@0
|
18 |
[create1a]
|
|
sl@0
|
19 |
SPCreateL0=
|
|
sl@0
|
20 |
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
21 |
SetDBPolicy2=EReadPolicy,ECapabilityWriteUserData
|
|
sl@0
|
22 |
CreateSP3=[102827c7]sec1.db
|
|
sl@0
|
23 |
SPClose4=
|
|
sl@0
|
24 |
Exec5=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
25 |
Exec6=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
26 |
Exec7=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
27 |
Exec8=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
28 |
Exec9=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
29 |
Exec10=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
30 |
Close11=
|
|
sl@0
|
31 |
EndBlock12=
|
|
sl@0
|
32 |
|
|
sl@0
|
33 |
[create1b]
|
|
sl@0
|
34 |
SPCreate0=
|
|
sl@0
|
35 |
SetDBPolicy1=ESchemaPolicy,ECapabilityAllFiles
|
|
sl@0
|
36 |
SetDBPolicy2=EWritePolicy,ECapabilityAllFiles
|
|
sl@0
|
37 |
SetDBPolicy3=EReadPolicy,ECapabilityWriteUserData
|
|
sl@0
|
38 |
CreateSP4=[102827c7]sec4.db
|
|
sl@0
|
39 |
SPClose5=
|
|
sl@0
|
40 |
Exec6=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
41 |
Exec7=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
42 |
Exec8=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
43 |
Exec9=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
44 |
Exec10=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
45 |
Exec11=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
46 |
Close12=
|
|
sl@0
|
47 |
EndBlock13=
|
|
sl@0
|
48 |
|
|
sl@0
|
49 |
[create2]
|
|
sl@0
|
50 |
SPCreate0=
|
|
sl@0
|
51 |
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
52 |
CreateSP2=[102827c7]sec2.db
|
|
sl@0
|
53 |
SPClose3=
|
|
sl@0
|
54 |
Exec4=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
55 |
Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
56 |
Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
57 |
Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
58 |
Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
59 |
Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
60 |
Close10=
|
|
sl@0
|
61 |
EndBlock11=
|
|
sl@0
|
62 |
|
|
sl@0
|
63 |
[create3]
|
|
sl@0
|
64 |
SPCreate0=
|
|
sl@0
|
65 |
SetDBPolicy1=ESchemaPolicy,ECapabilityAllFiles
|
|
sl@0
|
66 |
CreateSP2=[102827c7]sec.db
|
|
sl@0
|
67 |
ExpectedError2=KErrPermissionDenied
|
|
sl@0
|
68 |
SPClose3=
|
|
sl@0
|
69 |
EndBlock4=
|
|
sl@0
|
70 |
|
|
sl@0
|
71 |
[create4]
|
|
sl@0
|
72 |
SPCreate0=
|
|
sl@0
|
73 |
SetDBPolicy1=ESchemaPolicy,ECapabilityAllFiles
|
|
sl@0
|
74 |
CreateSP2=[102827c8]sec.db
|
|
sl@0
|
75 |
ExpectedError2=KErrPermissionDenied
|
|
sl@0
|
76 |
SPClose3=
|
|
sl@0
|
77 |
EndBlock4=
|
|
sl@0
|
78 |
|
|
sl@0
|
79 |
[create5]
|
|
sl@0
|
80 |
SPCreate0=
|
|
sl@0
|
81 |
CreateSP1=[102827c7]sec.db
|
|
sl@0
|
82 |
ExpectedError1=KErrPermissionDenied
|
|
sl@0
|
83 |
SPClose2=
|
|
sl@0
|
84 |
EndBlock3=
|
|
sl@0
|
85 |
|
|
sl@0
|
86 |
[create6]
|
|
sl@0
|
87 |
CreateSP0=[102827c7]sec.db
|
|
sl@0
|
88 |
EndBlock1=
|
|
sl@0
|
89 |
|
|
sl@0
|
90 |
[create7]
|
|
sl@0
|
91 |
SPCreate0=
|
|
sl@0
|
92 |
SetDBPolicy1=EReadPolicy,ECapabilityAllFiles
|
|
sl@0
|
93 |
CreateSP2=[102827c7]sec.db
|
|
sl@0
|
94 |
ExpectedError2=KErrPermissionDenied
|
|
sl@0
|
95 |
SPClose3=
|
|
sl@0
|
96 |
EndBlock4=
|
|
sl@0
|
97 |
|
|
sl@0
|
98 |
[create8]
|
|
sl@0
|
99 |
SPCreate0=
|
|
sl@0
|
100 |
SetDBPolicy1=EWritePolicy,ECapabilityAllFiles
|
|
sl@0
|
101 |
CreateSP2=[102827c7]sec.db
|
|
sl@0
|
102 |
ExpectedError2=KErrPermissionDenied
|
|
sl@0
|
103 |
SPClose3=
|
|
sl@0
|
104 |
EndBlock4=
|
|
sl@0
|
105 |
|
|
sl@0
|
106 |
[create9]
|
|
sl@0
|
107 |
SPCreate0=
|
|
sl@0
|
108 |
SetDBPolicy1=EWritePolicy,ECapabilityAllFiles
|
|
sl@0
|
109 |
SetDBPolicy2=EReadPolicy,ECapabilityAllFiles
|
|
sl@0
|
110 |
CreateSP3=[102827c7]sec.db
|
|
sl@0
|
111 |
ExpectedError3=KErrPermissionDenied
|
|
sl@0
|
112 |
SPClose4=
|
|
sl@0
|
113 |
EndBlock5=
|
|
sl@0
|
114 |
|
|
sl@0
|
115 |
[create10]
|
|
sl@0
|
116 |
SPCreate0=
|
|
sl@0
|
117 |
SetDBPolicy1=EWritePolicy,ECapabilityAllFiles
|
|
sl@0
|
118 |
SetDBPolicy2=EReadPolicy,ECapabilityAllFiles
|
|
sl@0
|
119 |
SetDBPolicy2=ESchemaPolicy,ECapabilityAllFiles
|
|
sl@0
|
120 |
CreateSP3=[102827c7]sec3.db
|
|
sl@0
|
121 |
ExpectedError3=KErrPermissionDenied
|
|
sl@0
|
122 |
SPClose4=
|
|
sl@0
|
123 |
EndBlock5=
|
|
sl@0
|
124 |
|
|
sl@0
|
125 |
[create11]
|
|
sl@0
|
126 |
SPCreate0=
|
|
sl@0
|
127 |
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
128 |
CreateSP2=[102827c8]sec.db
|
|
sl@0
|
129 |
SPClose3=
|
|
sl@0
|
130 |
Exec4=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
131 |
Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
132 |
Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
133 |
Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
134 |
Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
135 |
Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
136 |
Close10=
|
|
sl@0
|
137 |
EndBlock11=
|
|
sl@0
|
138 |
|
|
sl@0
|
139 |
[create12]
|
|
sl@0
|
140 |
Create0=c:\private\102827c7\sec.db
|
|
sl@0
|
141 |
Exec1=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
142 |
Exec2=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
143 |
Exec3=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
144 |
Exec4=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
145 |
Exec5=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
146 |
Exec6=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
147 |
Close7=
|
|
sl@0
|
148 |
EndBlock8=
|
|
sl@0
|
149 |
|
|
sl@0
|
150 |
[create12a]
|
|
sl@0
|
151 |
Create0=c:\private\102827c8\sec.db
|
|
sl@0
|
152 |
ExpectedError0=KErrPermissionDenied
|
|
sl@0
|
153 |
EndBlock1=
|
|
sl@0
|
154 |
|
|
sl@0
|
155 |
[create12b]
|
|
sl@0
|
156 |
Create0=c:\private\102827c8\sec3.db
|
|
sl@0
|
157 |
Exec1=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
158 |
Exec2=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
159 |
Exec3=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
160 |
Exec4=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
161 |
Exec5=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
162 |
Exec6=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
163 |
Close7=
|
|
sl@0
|
164 |
EndBlock8=
|
|
sl@0
|
165 |
|
|
sl@0
|
166 |
// Read tests
|
|
sl@0
|
167 |
|
|
sl@0
|
168 |
[read1]
|
|
sl@0
|
169 |
Open0=[102827c7]sec.db
|
|
sl@0
|
170 |
Prepare1=select count(*) from names;
|
|
sl@0
|
171 |
ColumnIndex2=
|
|
sl@0
|
172 |
Next3=
|
|
sl@0
|
173 |
ColumnInt4=0,5
|
|
sl@0
|
174 |
St_Close5=
|
|
sl@0
|
175 |
Close6=[102827c7]sec.db
|
|
sl@0
|
176 |
EndBlock7=
|
|
sl@0
|
177 |
|
|
sl@0
|
178 |
[read2]
|
|
sl@0
|
179 |
Open0=[102827c8]sec.db
|
|
sl@0
|
180 |
Prepare1=select count(*) from names;
|
|
sl@0
|
181 |
ColumnIndex2=
|
|
sl@0
|
182 |
Next3=
|
|
sl@0
|
183 |
ColumnInt4=0,5
|
|
sl@0
|
184 |
St_Close5=
|
|
sl@0
|
185 |
Close6=[102827c8]sec.db
|
|
sl@0
|
186 |
EndBlock7=
|
|
sl@0
|
187 |
|
|
sl@0
|
188 |
[read3]
|
|
sl@0
|
189 |
Open0=[102827c7]sec.db
|
|
sl@0
|
190 |
ExpectedError0=KErrPermissionDenied
|
|
sl@0
|
191 |
Close1=[102827c7]sec.db
|
|
sl@0
|
192 |
EndBlock2=
|
|
sl@0
|
193 |
|
|
sl@0
|
194 |
[read4]
|
|
sl@0
|
195 |
Open0=[102827c7]sec1.db
|
|
sl@0
|
196 |
Prepare1=select count(*) from names;
|
|
sl@0
|
197 |
ColumnIndex2=
|
|
sl@0
|
198 |
Next3=
|
|
sl@0
|
199 |
ColumnInt4=0,5
|
|
sl@0
|
200 |
St_Close5=
|
|
sl@0
|
201 |
Close6=[102827c7]sec1.db
|
|
sl@0
|
202 |
EndBlock7=
|
|
sl@0
|
203 |
|
|
sl@0
|
204 |
// Write tests
|
|
sl@0
|
205 |
|
|
sl@0
|
206 |
[write1]
|
|
sl@0
|
207 |
Open0=[102827c7]sec4.db
|
|
sl@0
|
208 |
Prepare1=select count(*) from names;
|
|
sl@0
|
209 |
ColumnIndex2=
|
|
sl@0
|
210 |
Next3=
|
|
sl@0
|
211 |
ColumnInt4=0,5
|
|
sl@0
|
212 |
St_Close5=
|
|
sl@0
|
213 |
Exec6=insert into names(pkey, fname, lname, ref) values(6, "new", "starter", 1);
|
|
sl@0
|
214 |
ExpectedError6=KErrPermissionDenied
|
|
sl@0
|
215 |
Prepare7=select count(*) from names;
|
|
sl@0
|
216 |
ColumnIndex8=
|
|
sl@0
|
217 |
Next9=
|
|
sl@0
|
218 |
ColumnInt10=0,5
|
|
sl@0
|
219 |
St_Close11=
|
|
sl@0
|
220 |
Close12=[102827c7]sec4.db
|
|
sl@0
|
221 |
EndBlock13=
|
|
sl@0
|
222 |
|
|
sl@0
|
223 |
[write2]
|
|
sl@0
|
224 |
Open0=[102827c7]sec4.db
|
|
sl@0
|
225 |
Prepare1=select count(*) from names;
|
|
sl@0
|
226 |
ColumnIndex2=
|
|
sl@0
|
227 |
Next3=
|
|
sl@0
|
228 |
ColumnInt4=0,5
|
|
sl@0
|
229 |
St_Close5=
|
|
sl@0
|
230 |
Exec6=insert into names(pkey, fname, lname, ref) values(6, "new", "starter", 1);
|
|
sl@0
|
231 |
Prepare7=select count(*) from names;
|
|
sl@0
|
232 |
ColumnIndex8=
|
|
sl@0
|
233 |
Next9=
|
|
sl@0
|
234 |
ColumnInt10=0,6
|
|
sl@0
|
235 |
St_Close11=
|
|
sl@0
|
236 |
Close12=[102827c7]sec4.db
|
|
sl@0
|
237 |
EndBlock13=
|
|
sl@0
|
238 |
|
|
sl@0
|
239 |
// Schema tests
|
|
sl@0
|
240 |
|
|
sl@0
|
241 |
[schema1]
|
|
sl@0
|
242 |
Open0=[102827c7]sec4.db
|
|
sl@0
|
243 |
Exec1=create table newtab(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
244 |
ExpectedError1=KErrPermissionDenied
|
|
sl@0
|
245 |
Close2=
|
|
sl@0
|
246 |
EndBlock3=
|
|
sl@0
|
247 |
|
|
sl@0
|
248 |
[schema2]
|
|
sl@0
|
249 |
Open0=[102827c7]sec4.db
|
|
sl@0
|
250 |
Exec1=create table newtab(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
251 |
Close2=
|
|
sl@0
|
252 |
EndBlock3=
|
|
sl@0
|
253 |
|
|
sl@0
|
254 |
// Attach tests
|
|
sl@0
|
255 |
|
|
sl@0
|
256 |
[attach1]
|
|
sl@0
|
257 |
Open0=[102827c7]sec1.db
|
|
sl@0
|
258 |
Prepare1=select count(*) from names;
|
|
sl@0
|
259 |
ColumnIndex2=
|
|
sl@0
|
260 |
Next3=
|
|
sl@0
|
261 |
ColumnInt4=0,5
|
|
sl@0
|
262 |
St_Close5=
|
|
sl@0
|
263 |
Exec6=attach "C:\private\10281e17\[102827c7]sec1.db" as [102827c7]sec1
|
|
sl@0
|
264 |
ExpectedError6=KErrPermissionDenied
|
|
sl@0
|
265 |
Close7=
|
|
sl@0
|
266 |
EndBlock8=
|
|
sl@0
|
267 |
|
|
sl@0
|
268 |
[attach2]
|
|
sl@0
|
269 |
Open0=[102827c7]sec.db
|
|
sl@0
|
270 |
Prepare1=select count(*) from names;
|
|
sl@0
|
271 |
ColumnIndex2=
|
|
sl@0
|
272 |
Next3=
|
|
sl@0
|
273 |
ColumnInt4=0,5
|
|
sl@0
|
274 |
St_Close5=
|
|
sl@0
|
275 |
Attach6=C:[102827c7]sec1.db,fred
|
|
sl@0
|
276 |
Prepare7=select count(*) from fred.names;
|
|
sl@0
|
277 |
ColumnIndex8=
|
|
sl@0
|
278 |
Next9=
|
|
sl@0
|
279 |
ColumnInt10=0,5
|
|
sl@0
|
280 |
St_Close11=
|
|
sl@0
|
281 |
Detach12=fred
|
|
sl@0
|
282 |
Prepare13=select count(*) from fred.names;
|
|
sl@0
|
283 |
ExpectedError13=KSqlErrGeneral
|
|
sl@0
|
284 |
Close14=
|
|
sl@0
|
285 |
EndBlock15=
|
|
sl@0
|
286 |
|
|
sl@0
|
287 |
[attach3]
|
|
sl@0
|
288 |
Open0=[102827c7]sec1.db
|
|
sl@0
|
289 |
Prepare1=select count(*) from names;
|
|
sl@0
|
290 |
ColumnIndex2=
|
|
sl@0
|
291 |
Next3=
|
|
sl@0
|
292 |
ColumnInt4=0,5
|
|
sl@0
|
293 |
St_Close5=
|
|
sl@0
|
294 |
Attach6=C:[102827c7]sec.db,tom
|
|
sl@0
|
295 |
ExpectedError6=KErrPermissionDenied
|
|
sl@0
|
296 |
Close7=
|
|
sl@0
|
297 |
EndBlock8=
|
|
sl@0
|
298 |
|
|
sl@0
|
299 |
[attach4]
|
|
sl@0
|
300 |
Open0=[102827c7]sec.db
|
|
sl@0
|
301 |
Prepare1=select count(*) from names;
|
|
sl@0
|
302 |
ColumnIndex2=
|
|
sl@0
|
303 |
Next3=
|
|
sl@0
|
304 |
ColumnInt4=0,5
|
|
sl@0
|
305 |
St_Close5=
|
|
sl@0
|
306 |
Attach6=c:\private\102827c7\sec.db,bob
|
|
sl@0
|
307 |
Prepare7=select count(*) from bob.names;
|
|
sl@0
|
308 |
ColumnIndex8=
|
|
sl@0
|
309 |
Next9=
|
|
sl@0
|
310 |
ColumnInt10=0,5
|
|
sl@0
|
311 |
St_Close11=
|
|
sl@0
|
312 |
Detach12=bob
|
|
sl@0
|
313 |
Prepare13=select count(*) from bob.names;
|
|
sl@0
|
314 |
ExpectedError13=KSqlErrGeneral
|
|
sl@0
|
315 |
Close14=
|
|
sl@0
|
316 |
EndBlock15=
|
|
sl@0
|
317 |
|
|
sl@0
|
318 |
[attach5]
|
|
sl@0
|
319 |
Open0=c:\private\102827c7\sec.db
|
|
sl@0
|
320 |
Prepare1=select count(*) from names;
|
|
sl@0
|
321 |
ColumnIndex2=
|
|
sl@0
|
322 |
Next3=
|
|
sl@0
|
323 |
ColumnInt4=0,5
|
|
sl@0
|
324 |
St_Close5=
|
|
sl@0
|
325 |
Attach6=[102827c7]sec.db,bob
|
|
sl@0
|
326 |
Prepare7=select count(*) from bob.names;
|
|
sl@0
|
327 |
ColumnIndex8=
|
|
sl@0
|
328 |
Next9=
|
|
sl@0
|
329 |
ColumnInt10=0,5
|
|
sl@0
|
330 |
St_Close11=
|
|
sl@0
|
331 |
Detach12=bob
|
|
sl@0
|
332 |
Prepare13=select count(*) from bob.names;
|
|
sl@0
|
333 |
ExpectedError13=KSqlErrGeneral
|
|
sl@0
|
334 |
Close14=
|
|
sl@0
|
335 |
EndBlock15=
|
|
sl@0
|
336 |
|
|
sl@0
|
337 |
[attach6]
|
|
sl@0
|
338 |
// this is the test case where we try to cheat ATTACH by passing in arguments that will execute SQL while the authorizer is disabled.
|
|
sl@0
|
339 |
Open0=[102827c7]sec.db
|
|
sl@0
|
340 |
Prepare1=select count(*) from names;
|
|
sl@0
|
341 |
ColumnIndex2=
|
|
sl@0
|
342 |
Next3=
|
|
sl@0
|
343 |
ColumnInt4=0,5
|
|
sl@0
|
344 |
St_Close5=
|
|
sl@0
|
345 |
Attach6=[102827c7]sec1.db' AS fred; delete from names;,fred2
|
|
sl@0
|
346 |
ExpectedError6=KSqlErrGeneral
|
|
sl@0
|
347 |
Prepare7=select count(*) from names;
|
|
sl@0
|
348 |
ColumnIndex8=
|
|
sl@0
|
349 |
Next9=
|
|
sl@0
|
350 |
ColumnInt10=0,5
|
|
sl@0
|
351 |
St_Close11=
|
|
sl@0
|
352 |
Prepare12=select count(*) from fred.names;
|
|
sl@0
|
353 |
ColumnIndex13=
|
|
sl@0
|
354 |
Next14=
|
|
sl@0
|
355 |
ColumnInt15=0,5
|
|
sl@0
|
356 |
St_Close16=
|
|
sl@0
|
357 |
Detach17=fred
|
|
sl@0
|
358 |
Prepare18=select count(*) from fred.names;
|
|
sl@0
|
359 |
ExpectedError18=KSqlErrGeneral
|
|
sl@0
|
360 |
Close19=
|
|
sl@0
|
361 |
EndBlock20=
|
|
sl@0
|
362 |
|
|
sl@0
|
363 |
// Copy tests
|
|
sl@0
|
364 |
|
|
sl@0
|
365 |
[copy1]
|
|
sl@0
|
366 |
Copy0=[102827c7]sec.db,C:\sec_dest.db
|
|
sl@0
|
367 |
ExpectedError0=KErrPermissionDenied
|
|
sl@0
|
368 |
EndBlock1=
|
|
sl@0
|
369 |
|
|
sl@0
|
370 |
[copy2]
|
|
sl@0
|
371 |
Create0=C:\[102827c7]sec_source.db
|
|
sl@0
|
372 |
Copy1=C:\[102827c7]sec.db,[102827c7]sec_dest.db
|
|
sl@0
|
373 |
ExpectedError1=KErrPermissionDenied
|
|
sl@0
|
374 |
Close2=
|
|
sl@0
|
375 |
Delete3=C:\[102827c7]sec_source.db
|
|
sl@0
|
376 |
EndBlock4=
|
|
sl@0
|
377 |
|
|
sl@0
|
378 |
[copy3]
|
|
sl@0
|
379 |
Copy0=C:\private\102827c7\sec.db,[102827c7]sec_dest.db
|
|
sl@0
|
380 |
ExpectedError0=KErrPermissionDenied
|
|
sl@0
|
381 |
EndBlock1=
|
|
sl@0
|
382 |
|
|
sl@0
|
383 |
[copy4]
|
|
sl@0
|
384 |
Copy0=[102827c7]sec.db,C:\private\102827c7\sec_dest.db
|
|
sl@0
|
385 |
ExpectedError0=KErrPermissionDenied
|
|
sl@0
|
386 |
EndBlock1=
|
|
sl@0
|
387 |
|
|
sl@0
|
388 |
[copy5]
|
|
sl@0
|
389 |
Copy0=[102827c7]sec.db,[102827c7]sec_copy.db
|
|
sl@0
|
390 |
EndBlock1=
|
|
sl@0
|
391 |
|
|
sl@0
|
392 |
[copy6]
|
|
sl@0
|
393 |
Copy0=C:\private\102827c7\sec.db, C:\private\102827c7\sec_copy.db
|
|
sl@0
|
394 |
ExpectedError0=KErrPermissionDenied
|
|
sl@0
|
395 |
EndBlock1=
|
|
sl@0
|
396 |
|
|
sl@0
|
397 |
[copy7]
|
|
sl@0
|
398 |
Copy0=C:\private\102827c7\sec.db, C:\sec_copy.db
|
|
sl@0
|
399 |
ExpectedError0=KErrPermissionDenied
|
|
sl@0
|
400 |
EndBlock1=
|
|
sl@0
|
401 |
|
|
sl@0
|
402 |
|
|
sl@0
|
403 |
// Concurrency tests
|
|
sl@0
|
404 |
|
|
sl@0
|
405 |
|
|
sl@0
|
406 |
// Policy check tests
|
|
sl@0
|
407 |
|
|
sl@0
|
408 |
[policy1]
|
|
sl@0
|
409 |
SPCreateL0=
|
|
sl@0
|
410 |
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
411 |
SetDBPolicy2=EReadPolicy,ECapabilityWriteUserData
|
|
sl@0
|
412 |
SetPolicy3=ETable,names,EWritePolicy,ECapabilityAllFiles
|
|
sl@0
|
413 |
SetPolicy4=ETable,names,EReadPolicy,ECapabilityAllFiles
|
|
sl@0
|
414 |
CreateSP5=[102827c7]secpol.db
|
|
sl@0
|
415 |
SPClose6=
|
|
sl@0
|
416 |
Exec7=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
417 |
Exec8=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
418 |
Exec9=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
419 |
Exec10=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
420 |
Exec11=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
421 |
Exec12=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
422 |
Close13=
|
|
sl@0
|
423 |
EndBlock14=
|
|
sl@0
|
424 |
|
|
sl@0
|
425 |
[policy2]
|
|
sl@0
|
426 |
Open0=[102827c7]secpol.db
|
|
sl@0
|
427 |
Prepare1=select count(*) from names;
|
|
sl@0
|
428 |
ColumnIndex2=
|
|
sl@0
|
429 |
Next3=
|
|
sl@0
|
430 |
ColumnInt4=0,5
|
|
sl@0
|
431 |
St_Close5=
|
|
sl@0
|
432 |
Exec6=insert into names(pkey, fname, lname, ref) values(6, "new", "starter", 1);
|
|
sl@0
|
433 |
Prepare7=select count(*) from names;
|
|
sl@0
|
434 |
ColumnIndex8=
|
|
sl@0
|
435 |
Next9=
|
|
sl@0
|
436 |
ColumnInt10=0,6
|
|
sl@0
|
437 |
St_Close11=
|
|
sl@0
|
438 |
Close12=
|
|
sl@0
|
439 |
EndBlock13=
|
|
sl@0
|
440 |
|
|
sl@0
|
441 |
[policy3]
|
|
sl@0
|
442 |
// this test has been deferred as it has duplicated a developer test
|
|
sl@0
|
443 |
SPCreateL0=
|
|
sl@0
|
444 |
SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
|
|
sl@0
|
445 |
SetDBPolicy2=EReadPolicy,ECapabilityWriteUserData
|
|
sl@0
|
446 |
SetPolicy3=ETable,names,EWritePolicy,ECapabilityAllFiles
|
|
sl@0
|
447 |
SetPolicy4=ETable,names,EReadPolicy,ECapabilityAllFiles
|
|
sl@0
|
448 |
CreateSP5=[102827c7]secpol1.db
|
|
sl@0
|
449 |
|
|
sl@0
|
450 |
Exec7=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
451 |
Exec8=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
452 |
Exec9=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
453 |
Exec10=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
454 |
Exec11=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
455 |
Exec12=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
456 |
Close13=
|
|
sl@0
|
457 |
Function14=SecurityPolicyCheck
|
|
sl@0
|
458 |
|
|
sl@0
|
459 |
SPClose6=
|
|
sl@0
|
460 |
EndBlock14=
|
|
sl@0
|
461 |
|
|
sl@0
|
462 |
|
|
sl@0
|
463 |
// Inernalize & Externalize tests
|
|
sl@0
|
464 |
|
|
sl@0
|
465 |
[External1]
|
|
sl@0
|
466 |
SPCreate0=
|
|
sl@0
|
467 |
SetDBPolicy1=ESchemaPolicy,ECapabilityAllFiles
|
|
sl@0
|
468 |
SetDBPolicy2=EReadPolicy,ECapabilityAllFiles
|
|
sl@0
|
469 |
SetPolicy3=ETable,names,EWritePolicy,ECapabilityAllFiles
|
|
sl@0
|
470 |
Delete4=c:\ext.pol
|
|
sl@0
|
471 |
ExpectedError4=KErrNotFound
|
|
sl@0
|
472 |
SPExternalizeL5=c:\ext.pol
|
|
sl@0
|
473 |
EndBlock6=
|
|
sl@0
|
474 |
|
|
sl@0
|
475 |
[External2]
|
|
sl@0
|
476 |
SPCreate0=
|
|
sl@0
|
477 |
SPInternalizeL1=c:\ext.pol
|
|
sl@0
|
478 |
CreateSP2=[102827c7]ext.db
|
|
sl@0
|
479 |
SPClose3=
|
|
sl@0
|
480 |
Exec4=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
481 |
Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
482 |
Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
483 |
Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
484 |
Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
485 |
Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
486 |
Close10=
|
|
sl@0
|
487 |
EndBlock11=
|
|
sl@0
|
488 |
|
|
sl@0
|
489 |
[External3]
|
|
sl@0
|
490 |
Open0=[102827c7]ext.db
|
|
sl@0
|
491 |
ExpectedError0=KErrPermissionDenied
|
|
sl@0
|
492 |
Close1=[102827c7]ext.db
|
|
sl@0
|
493 |
EndBlock2=
|
|
sl@0
|
494 |
|