1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/BUR.ini Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,309 @@
1.4 +[wait]
1.5 +Sleep0=5000000
1.6 +EndBlock1=
1.7 +
1.8 +[bur]
1.9 +BackupDir=c:\BackupArchive\
1.10 +IsPartial=1
1.11 +BaseOnly=1
1.12 +DriveList=c
1.13 +IDs=102827c7
1.14 +
1.15 +[bur2]
1.16 +BackupDir=c:\BackupArchive\
1.17 +IsPartial=1
1.18 +BaseOnly=1
1.19 +DriveList=c
1.20 +IDs=102827c7, 102827c8
1.21 +
1.22 +[setup]
1.23 +SPCreate0=
1.24 +SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
1.25 +CreateSP2=c:[102827c7]bur.db
1.26 +SPClose3=
1.27 +Exec4=create table names(pkey int, fname text, lname text, ref int);
1.28 +Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
1.29 +Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
1.30 +Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
1.31 +Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
1.32 +Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
1.33 +Close10=
1.34 +EndBlock11=
1.35 +
1.36 +[check]
1.37 +Open0=c:[102827c7]bur.db
1.38 +//check the number of records is correct firstly
1.39 +Prepare1=select count(*) from names;
1.40 +ColumnIndex2=
1.41 +Next3=
1.42 +ColumnInt4=0,5
1.43 +St_Close5=
1.44 +//now check the data
1.45 +Prepare6=select * from names;
1.46 +ColumnIndex7=pkey
1.47 +ColumnIndex8=fname
1.48 +ColumnIndex9=lname
1.49 +ColumnIndex10=ref
1.50 +Next11=
1.51 +ColumnInt12=0,1
1.52 +ColumnTextL13=1,tom
1.53 +ColumnTextL14=2,jones
1.54 +ColumnInt15=3,2
1.55 +Next16=
1.56 +ColumnInt17=0,2
1.57 +ColumnTextL18=1,jim
1.58 +ColumnTextL19=2,davies
1.59 +ColumnInt20=3,1
1.60 +Next21=
1.61 +ColumnInt22=0,3
1.62 +ColumnTextL23=1,bob
1.63 +ColumnTextL24=2,smith
1.64 +ColumnInt25=3,1
1.65 +Next26=
1.66 +ColumnInt27=0,4
1.67 +ColumnTextL28=1,dave
1.68 +ColumnTextL29=2,house
1.69 +ColumnInt30=3,3
1.70 +Next31=
1.71 +ColumnInt32=0,5
1.72 +ColumnTextL33=1,jane
1.73 +ColumnTextL34=2,hobbs
1.74 +ColumnInt35=3,4
1.75 +Next36=
1.76 +St_Close37=
1.77 +Close38=
1.78 +EndBlock39=
1.79 +
1.80 +[modify]
1.81 +Open0=c:[102827c7]bur.db
1.82 +Exec1=insert into names(pkey, fname, lname, ref) values(6, "extra1", "another", 4);
1.83 +Exec2=insert into names(pkey, fname, lname, ref) values(7, "extra2", "another", 4);
1.84 +Close3=
1.85 +EndBlock4=
1.86 +
1.87 +[setup2]
1.88 +SPCreate0=
1.89 +SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
1.90 +CreateSP2=c:[102827c8]bur.db
1.91 +SPClose3=
1.92 +Exec4=create table names(pkey int, fname text, lname text, ref int);
1.93 +Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
1.94 +Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
1.95 +Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
1.96 +Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
1.97 +Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
1.98 +Close10=
1.99 +EndBlock11=
1.100 +
1.101 +[check2]
1.102 +Open0=c:[102827c8]bur.db
1.103 +//check the number of records is correct firstly
1.104 +Prepare1=select count(*) from names;
1.105 +ColumnIndex2=
1.106 +Next3=
1.107 +ColumnInt4=0,5
1.108 +St_Close5=
1.109 +//now check the data
1.110 +Prepare6=select * from names;
1.111 +ColumnIndex7=pkey
1.112 +ColumnIndex8=fname
1.113 +ColumnIndex9=lname
1.114 +ColumnIndex10=ref
1.115 +Next11=
1.116 +ColumnInt12=0,1
1.117 +ColumnTextL13=1,tom
1.118 +ColumnTextL14=2,jones
1.119 +ColumnInt15=3,2
1.120 +Next16=
1.121 +ColumnInt17=0,2
1.122 +ColumnTextL18=1,jim
1.123 +ColumnTextL19=2,davies
1.124 +ColumnInt20=3,1
1.125 +Next21=
1.126 +ColumnInt22=0,3
1.127 +ColumnTextL23=1,bob
1.128 +ColumnTextL24=2,smith
1.129 +ColumnInt25=3,1
1.130 +Next26=
1.131 +ColumnInt27=0,4
1.132 +ColumnTextL28=1,dave
1.133 +ColumnTextL29=2,house
1.134 +ColumnInt30=3,3
1.135 +Next31=
1.136 +ColumnInt32=0,5
1.137 +ColumnTextL33=1,jane
1.138 +ColumnTextL34=2,hobbs
1.139 +ColumnInt35=3,4
1.140 +Next36=
1.141 +St_Close37=
1.142 +Close38=
1.143 +EndBlock39=
1.144 +
1.145 +[setup3]
1.146 +SPCreate0=
1.147 +SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
1.148 +CreateSP2=c:[102827c7]bur1.db
1.149 +SPClose3=
1.150 +Exec4=create table nums(pkey int);
1.151 +Exec5=insert into nums(pkey) values(1);
1.152 +Exec6=insert into nums(pkey) values(2);
1.153 +Exec7=insert into nums(pkey) values(3);
1.154 +Exec8=insert into nums(pkey) values(4);
1.155 +Exec9=insert into nums(pkey) values(5);
1.156 +Close10=
1.157 +SPCreate11=
1.158 +SetDBPolicy12=ESchemaPolicy,ECapabilityWriteUserData
1.159 +CreateSP13=c:[102827c7]bur2.db
1.160 +SPClose14=
1.161 +Exec15=create table nums(pkey int);
1.162 +Exec16=insert into nums(pkey) values(6);
1.163 +Exec17=insert into nums(pkey) values(7);
1.164 +Exec18=insert into nums(pkey) values(8);
1.165 +Exec19=insert into nums(pkey) values(9);
1.166 +Exec20=insert into nums(pkey) values(10);
1.167 +Close21=
1.168 +SPCreate22=
1.169 +SetDBPolicy23=ESchemaPolicy,ECapabilityWriteUserData
1.170 +CreateSP24=c:[102827c7]bur3.db
1.171 +SPClose25=
1.172 +Exec26=create table nums(pkey int);
1.173 +Exec27=insert into nums(pkey) values(11);
1.174 +Exec28=insert into nums(pkey) values(12);
1.175 +Exec29=insert into nums(pkey) values(13);
1.176 +Exec30=insert into nums(pkey) values(14);
1.177 +Exec31=insert into nums(pkey) values(15);
1.178 +Close32=
1.179 +EndBlock33=
1.180 +
1.181 +[check3]
1.182 +Open0=c:[102827c7]bur1.db
1.183 +//check the number of records is correct firstly
1.184 +Prepare1=select count(*) from nums;
1.185 +ColumnIndex2=
1.186 +Next3=
1.187 +ColumnInt4=0,5
1.188 +St_Close5=
1.189 +//now check the data
1.190 +Prepare6=select * from nums;
1.191 +ColumnIndex7=pkey
1.192 +Next8=
1.193 +ColumnInt9=0,1
1.194 +Next10=
1.195 +ColumnInt11=0,2
1.196 +Next12=
1.197 +ColumnInt13=0,3
1.198 +Next14=
1.199 +ColumnInt15=0,4
1.200 +Next16=
1.201 +ColumnInt17=0,5
1.202 +Next18=
1.203 +St_Close19=
1.204 +Close20=
1.205 +Open21=c:[102827c7]bur2.db
1.206 +//check the number of records is correct firstly
1.207 +Prepare22=select count(*) from nums;
1.208 +ColumnIndex23=
1.209 +Next24=
1.210 +ColumnInt25=0,5
1.211 +St_Close26=
1.212 +//now check the data
1.213 +Prepare27=select * from nums;
1.214 +ColumnIndex28=pkey
1.215 +Next29=
1.216 +ColumnInt30=0,6
1.217 +Next31=
1.218 +ColumnInt32=0,7
1.219 +Next33=
1.220 +ColumnInt34=0,8
1.221 +Next35=
1.222 +ColumnInt36=0,9
1.223 +Next37=
1.224 +ColumnInt38=0,10
1.225 +Next39=
1.226 +St_Close40=
1.227 +Close41=
1.228 +Open42=c:[102827c7]bur3.db
1.229 +//check the number of records is correct firstly
1.230 +Prepare43=select count(*) from nums;
1.231 +ColumnIndex44=
1.232 +Next45=
1.233 +ColumnInt46=0,5
1.234 +St_Close47=
1.235 +//now check the data
1.236 +Prepare48=select * from nums;
1.237 +ColumnIndex49=pkey
1.238 +Next50=
1.239 +ColumnInt51=0,11
1.240 +Next52=
1.241 +ColumnInt53=0,12
1.242 +Next54=
1.243 +ColumnInt55=0,13
1.244 +Next56=
1.245 +ColumnInt57=0,14
1.246 +Next58=
1.247 +ColumnInt59=0,15
1.248 +Next60=
1.249 +St_Close61=
1.250 +Close62=
1.251 +EndBlock63=
1.252 +
1.253 +[setup4]
1.254 +SPCreate0=
1.255 +SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData
1.256 +CreateSP2=c:[102827c7]118192
1.257 +SPClose3=
1.258 +Exec4=create table names(pkey int, fname text, lname text, ref int);
1.259 +Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
1.260 +Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
1.261 +Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
1.262 +Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
1.263 +Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
1.264 +Close10=
1.265 +EndBlock11=
1.266 +
1.267 +[check4]
1.268 +Open0=c:[102827c7]118192
1.269 +//check the number of records is correct firstly
1.270 +Prepare1=select count(*) from names;
1.271 +ColumnIndex2=
1.272 +Next3=
1.273 +ColumnInt4=0,5
1.274 +St_Close5=
1.275 +//now check the data
1.276 +Prepare6=select * from names;
1.277 +ColumnIndex7=pkey
1.278 +ColumnIndex8=fname
1.279 +ColumnIndex9=lname
1.280 +ColumnIndex10=ref
1.281 +Next11=
1.282 +ColumnInt12=0,1
1.283 +ColumnTextL13=1,tom
1.284 +ColumnTextL14=2,jones
1.285 +ColumnInt15=3,2
1.286 +Next16=
1.287 +ColumnInt17=0,2
1.288 +ColumnTextL18=1,jim
1.289 +ColumnTextL19=2,davies
1.290 +ColumnInt20=3,1
1.291 +Next21=
1.292 +ColumnInt22=0,3
1.293 +ColumnTextL23=1,bob
1.294 +ColumnTextL24=2,smith
1.295 +ColumnInt25=3,1
1.296 +Next26=
1.297 +ColumnInt27=0,4
1.298 +ColumnTextL28=1,dave
1.299 +ColumnTextL29=2,house
1.300 +ColumnInt30=3,3
1.301 +Next31=
1.302 +ColumnInt32=0,5
1.303 +ColumnTextL33=1,jane
1.304 +ColumnTextL34=2,hobbs
1.305 +ColumnInt35=3,4
1.306 +Next36=
1.307 +St_Close37=
1.308 +Close38=
1.309 +EndBlock39=
1.310 +
1.311 +
1.312 +