diff -r 000000000000 -r bde4ae8d615e os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/BUR.ini --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/BUR.ini Fri Jun 15 03:10:57 2012 +0200 @@ -0,0 +1,309 @@ +[wait] +Sleep0=5000000 +EndBlock1= + +[bur] +BackupDir=c:\BackupArchive\ +IsPartial=1 +BaseOnly=1 +DriveList=c +IDs=102827c7 + +[bur2] +BackupDir=c:\BackupArchive\ +IsPartial=1 +BaseOnly=1 +DriveList=c +IDs=102827c7, 102827c8 + +[setup] +SPCreate0= +SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData +CreateSP2=c:[102827c7]bur.db +SPClose3= +Exec4=create table names(pkey int, fname text, lname text, ref int); +Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2); +Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1); +Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1); +Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3); +Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4); +Close10= +EndBlock11= + +[check] +Open0=c:[102827c7]bur.db +//check the number of records is correct firstly +Prepare1=select count(*) from names; +ColumnIndex2= +Next3= +ColumnInt4=0,5 +St_Close5= +//now check the data +Prepare6=select * from names; +ColumnIndex7=pkey +ColumnIndex8=fname +ColumnIndex9=lname +ColumnIndex10=ref +Next11= +ColumnInt12=0,1 +ColumnTextL13=1,tom +ColumnTextL14=2,jones +ColumnInt15=3,2 +Next16= +ColumnInt17=0,2 +ColumnTextL18=1,jim +ColumnTextL19=2,davies +ColumnInt20=3,1 +Next21= +ColumnInt22=0,3 +ColumnTextL23=1,bob +ColumnTextL24=2,smith +ColumnInt25=3,1 +Next26= +ColumnInt27=0,4 +ColumnTextL28=1,dave +ColumnTextL29=2,house +ColumnInt30=3,3 +Next31= +ColumnInt32=0,5 +ColumnTextL33=1,jane +ColumnTextL34=2,hobbs +ColumnInt35=3,4 +Next36= +St_Close37= +Close38= +EndBlock39= + +[modify] +Open0=c:[102827c7]bur.db +Exec1=insert into names(pkey, fname, lname, ref) values(6, "extra1", "another", 4); +Exec2=insert into names(pkey, fname, lname, ref) values(7, "extra2", "another", 4); +Close3= +EndBlock4= + +[setup2] +SPCreate0= +SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData +CreateSP2=c:[102827c8]bur.db +SPClose3= +Exec4=create table names(pkey int, fname text, lname text, ref int); +Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2); +Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1); +Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1); +Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3); +Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4); +Close10= +EndBlock11= + +[check2] +Open0=c:[102827c8]bur.db +//check the number of records is correct firstly +Prepare1=select count(*) from names; +ColumnIndex2= +Next3= +ColumnInt4=0,5 +St_Close5= +//now check the data +Prepare6=select * from names; +ColumnIndex7=pkey +ColumnIndex8=fname +ColumnIndex9=lname +ColumnIndex10=ref +Next11= +ColumnInt12=0,1 +ColumnTextL13=1,tom +ColumnTextL14=2,jones +ColumnInt15=3,2 +Next16= +ColumnInt17=0,2 +ColumnTextL18=1,jim +ColumnTextL19=2,davies +ColumnInt20=3,1 +Next21= +ColumnInt22=0,3 +ColumnTextL23=1,bob +ColumnTextL24=2,smith +ColumnInt25=3,1 +Next26= +ColumnInt27=0,4 +ColumnTextL28=1,dave +ColumnTextL29=2,house +ColumnInt30=3,3 +Next31= +ColumnInt32=0,5 +ColumnTextL33=1,jane +ColumnTextL34=2,hobbs +ColumnInt35=3,4 +Next36= +St_Close37= +Close38= +EndBlock39= + +[setup3] +SPCreate0= +SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData +CreateSP2=c:[102827c7]bur1.db +SPClose3= +Exec4=create table nums(pkey int); +Exec5=insert into nums(pkey) values(1); +Exec6=insert into nums(pkey) values(2); +Exec7=insert into nums(pkey) values(3); +Exec8=insert into nums(pkey) values(4); +Exec9=insert into nums(pkey) values(5); +Close10= +SPCreate11= +SetDBPolicy12=ESchemaPolicy,ECapabilityWriteUserData +CreateSP13=c:[102827c7]bur2.db +SPClose14= +Exec15=create table nums(pkey int); +Exec16=insert into nums(pkey) values(6); +Exec17=insert into nums(pkey) values(7); +Exec18=insert into nums(pkey) values(8); +Exec19=insert into nums(pkey) values(9); +Exec20=insert into nums(pkey) values(10); +Close21= +SPCreate22= +SetDBPolicy23=ESchemaPolicy,ECapabilityWriteUserData +CreateSP24=c:[102827c7]bur3.db +SPClose25= +Exec26=create table nums(pkey int); +Exec27=insert into nums(pkey) values(11); +Exec28=insert into nums(pkey) values(12); +Exec29=insert into nums(pkey) values(13); +Exec30=insert into nums(pkey) values(14); +Exec31=insert into nums(pkey) values(15); +Close32= +EndBlock33= + +[check3] +Open0=c:[102827c7]bur1.db +//check the number of records is correct firstly +Prepare1=select count(*) from nums; +ColumnIndex2= +Next3= +ColumnInt4=0,5 +St_Close5= +//now check the data +Prepare6=select * from nums; +ColumnIndex7=pkey +Next8= +ColumnInt9=0,1 +Next10= +ColumnInt11=0,2 +Next12= +ColumnInt13=0,3 +Next14= +ColumnInt15=0,4 +Next16= +ColumnInt17=0,5 +Next18= +St_Close19= +Close20= +Open21=c:[102827c7]bur2.db +//check the number of records is correct firstly +Prepare22=select count(*) from nums; +ColumnIndex23= +Next24= +ColumnInt25=0,5 +St_Close26= +//now check the data +Prepare27=select * from nums; +ColumnIndex28=pkey +Next29= +ColumnInt30=0,6 +Next31= +ColumnInt32=0,7 +Next33= +ColumnInt34=0,8 +Next35= +ColumnInt36=0,9 +Next37= +ColumnInt38=0,10 +Next39= +St_Close40= +Close41= +Open42=c:[102827c7]bur3.db +//check the number of records is correct firstly +Prepare43=select count(*) from nums; +ColumnIndex44= +Next45= +ColumnInt46=0,5 +St_Close47= +//now check the data +Prepare48=select * from nums; +ColumnIndex49=pkey +Next50= +ColumnInt51=0,11 +Next52= +ColumnInt53=0,12 +Next54= +ColumnInt55=0,13 +Next56= +ColumnInt57=0,14 +Next58= +ColumnInt59=0,15 +Next60= +St_Close61= +Close62= +EndBlock63= + +[setup4] +SPCreate0= +SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData +CreateSP2=c:[102827c7]118192 +SPClose3= +Exec4=create table names(pkey int, fname text, lname text, ref int); +Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2); +Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1); +Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1); +Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3); +Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4); +Close10= +EndBlock11= + +[check4] +Open0=c:[102827c7]118192 +//check the number of records is correct firstly +Prepare1=select count(*) from names; +ColumnIndex2= +Next3= +ColumnInt4=0,5 +St_Close5= +//now check the data +Prepare6=select * from names; +ColumnIndex7=pkey +ColumnIndex8=fname +ColumnIndex9=lname +ColumnIndex10=ref +Next11= +ColumnInt12=0,1 +ColumnTextL13=1,tom +ColumnTextL14=2,jones +ColumnInt15=3,2 +Next16= +ColumnInt17=0,2 +ColumnTextL18=1,jim +ColumnTextL19=2,davies +ColumnInt20=3,1 +Next21= +ColumnInt22=0,3 +ColumnTextL23=1,bob +ColumnTextL24=2,smith +ColumnInt25=3,1 +Next26= +ColumnInt27=0,4 +ColumnTextL28=1,dave +ColumnTextL29=2,house +ColumnInt30=3,3 +Next31= +ColumnInt32=0,5 +ColumnTextL33=1,jane +ColumnTextL34=2,hobbs +ColumnInt35=3,4 +Next36= +St_Close37= +Close38= +EndBlock39= + + +