Mercurial Mercurial > oss > FCL > sf > os > persistentdata / diff
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
persistentstorage/sql/TEST/testexecute/SQLite/config/BUR.ini
changeset 0 08ec8eefde2f
child 51 7d4490026038 
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/persistentstorage/sql/TEST/testexecute/SQLite/config/BUR.ini	Fri Jan 22 11:06:30 2010 +0200
@@ -0,0 +1,305 @@
+[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=
+
+
+
FCL/sf/os/persistentdata