MercurialSymaptic / file revision
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | raw | help
os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/BUR.ini
author sl@SLION-WIN7.fritz.box
Fri, 15 Jun 2012 03:10:57 +0200
changeset 0 bde4ae8d615e
permissions -rw-r--r--
First public contribution. 
     1 [wait]

     2 Sleep0=5000000

     3 EndBlock1=

     4 

     5 [bur]

     6 BackupDir=c:\BackupArchive\

     7 IsPartial=1

     8 BaseOnly=1

     9 DriveList=c

    10 IDs=102827c7

    11 

    12 [bur2]

    13 BackupDir=c:\BackupArchive\

    14 IsPartial=1

    15 BaseOnly=1

    16 DriveList=c

    17 IDs=102827c7, 102827c8

    18 

    19 [setup]

    20 SPCreate0=

    21 SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData

    22 CreateSP2=c:[102827c7]bur.db

    23 SPClose3=

    24 Exec4=create table names(pkey int, fname text, lname text, ref int);

    25 Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);

    26 Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);

    27 Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);

    28 Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);

    29 Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);

    30 Close10=

    31 EndBlock11=

    32 

    33 [check]

    34 Open0=c:[102827c7]bur.db

    35 //check the number of records is correct firstly

    36 Prepare1=select count(*) from names;

    37 ColumnIndex2=

    38 Next3=

    39 ColumnInt4=0,5

    40 St_Close5=

    41 //now check the data

    42 Prepare6=select * from names;

    43 ColumnIndex7=pkey

    44 ColumnIndex8=fname

    45 ColumnIndex9=lname

    46 ColumnIndex10=ref

    47 Next11=

    48 ColumnInt12=0,1

    49 ColumnTextL13=1,tom

    50 ColumnTextL14=2,jones

    51 ColumnInt15=3,2

    52 Next16=

    53 ColumnInt17=0,2

    54 ColumnTextL18=1,jim

    55 ColumnTextL19=2,davies

    56 ColumnInt20=3,1

    57 Next21=

    58 ColumnInt22=0,3

    59 ColumnTextL23=1,bob

    60 ColumnTextL24=2,smith

    61 ColumnInt25=3,1

    62 Next26=

    63 ColumnInt27=0,4

    64 ColumnTextL28=1,dave

    65 ColumnTextL29=2,house

    66 ColumnInt30=3,3

    67 Next31=

    68 ColumnInt32=0,5

    69 ColumnTextL33=1,jane

    70 ColumnTextL34=2,hobbs

    71 ColumnInt35=3,4

    72 Next36=

    73 St_Close37=

    74 Close38=

    75 EndBlock39=

    76 

    77 [modify]

    78 Open0=c:[102827c7]bur.db

    79 Exec1=insert into names(pkey, fname, lname, ref) values(6, "extra1", "another", 4);

    80 Exec2=insert into names(pkey, fname, lname, ref) values(7, "extra2", "another", 4);

    81 Close3=

    82 EndBlock4=

    83 

    84 [setup2]

    85 SPCreate0=

    86 SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData

    87 CreateSP2=c:[102827c8]bur.db

    88 SPClose3=

    89 Exec4=create table names(pkey int, fname text, lname text, ref int);

    90 Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);

    91 Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);

    92 Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);

    93 Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);

    94 Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);

    95 Close10=

    96 EndBlock11=

    97 

    98 [check2]

    99 Open0=c:[102827c8]bur.db

   100 //check the number of records is correct firstly

   101 Prepare1=select count(*) from names;

   102 ColumnIndex2=

   103 Next3=

   104 ColumnInt4=0,5

   105 St_Close5=

   106 //now check the data

   107 Prepare6=select * from names;

   108 ColumnIndex7=pkey

   109 ColumnIndex8=fname

   110 ColumnIndex9=lname

   111 ColumnIndex10=ref

   112 Next11=

   113 ColumnInt12=0,1

   114 ColumnTextL13=1,tom

   115 ColumnTextL14=2,jones

   116 ColumnInt15=3,2

   117 Next16=

   118 ColumnInt17=0,2

   119 ColumnTextL18=1,jim

   120 ColumnTextL19=2,davies

   121 ColumnInt20=3,1

   122 Next21=

   123 ColumnInt22=0,3

   124 ColumnTextL23=1,bob

   125 ColumnTextL24=2,smith

   126 ColumnInt25=3,1

   127 Next26=

   128 ColumnInt27=0,4

   129 ColumnTextL28=1,dave

   130 ColumnTextL29=2,house

   131 ColumnInt30=3,3

   132 Next31=

   133 ColumnInt32=0,5

   134 ColumnTextL33=1,jane

   135 ColumnTextL34=2,hobbs

   136 ColumnInt35=3,4

   137 Next36=

   138 St_Close37=

   139 Close38=

   140 EndBlock39=

   141 

   142 [setup3]

   143 SPCreate0=

   144 SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData

   145 CreateSP2=c:[102827c7]bur1.db

   146 SPClose3=

   147 Exec4=create table nums(pkey int);

   148 Exec5=insert into nums(pkey) values(1);

   149 Exec6=insert into nums(pkey) values(2);

   150 Exec7=insert into nums(pkey) values(3);

   151 Exec8=insert into nums(pkey) values(4);

   152 Exec9=insert into nums(pkey) values(5);

   153 Close10=

   154 SPCreate11=

   155 SetDBPolicy12=ESchemaPolicy,ECapabilityWriteUserData

   156 CreateSP13=c:[102827c7]bur2.db

   157 SPClose14=

   158 Exec15=create table nums(pkey int);

   159 Exec16=insert into nums(pkey) values(6);

   160 Exec17=insert into nums(pkey) values(7);

   161 Exec18=insert into nums(pkey) values(8);

   162 Exec19=insert into nums(pkey) values(9);

   163 Exec20=insert into nums(pkey) values(10);

   164 Close21=

   165 SPCreate22=

   166 SetDBPolicy23=ESchemaPolicy,ECapabilityWriteUserData

   167 CreateSP24=c:[102827c7]bur3.db

   168 SPClose25=

   169 Exec26=create table nums(pkey int);

   170 Exec27=insert into nums(pkey) values(11);

   171 Exec28=insert into nums(pkey) values(12);

   172 Exec29=insert into nums(pkey) values(13);

   173 Exec30=insert into nums(pkey) values(14);

   174 Exec31=insert into nums(pkey) values(15);

   175 Close32=

   176 EndBlock33=

   177 

   178 [check3]

   179 Open0=c:[102827c7]bur1.db

   180 //check the number of records is correct firstly

   181 Prepare1=select count(*) from nums;

   182 ColumnIndex2=

   183 Next3=

   184 ColumnInt4=0,5

   185 St_Close5=

   186 //now check the data

   187 Prepare6=select * from nums;

   188 ColumnIndex7=pkey

   189 Next8=

   190 ColumnInt9=0,1

   191 Next10=

   192 ColumnInt11=0,2

   193 Next12=

   194 ColumnInt13=0,3

   195 Next14=

   196 ColumnInt15=0,4

   197 Next16=

   198 ColumnInt17=0,5

   199 Next18=

   200 St_Close19=

   201 Close20=

   202 Open21=c:[102827c7]bur2.db

   203 //check the number of records is correct firstly

   204 Prepare22=select count(*) from nums;

   205 ColumnIndex23=

   206 Next24=

   207 ColumnInt25=0,5

   208 St_Close26=

   209 //now check the data

   210 Prepare27=select * from nums;

   211 ColumnIndex28=pkey

   212 Next29=

   213 ColumnInt30=0,6

   214 Next31=

   215 ColumnInt32=0,7

   216 Next33=

   217 ColumnInt34=0,8

   218 Next35=

   219 ColumnInt36=0,9

   220 Next37=

   221 ColumnInt38=0,10

   222 Next39=

   223 St_Close40=

   224 Close41=

   225 Open42=c:[102827c7]bur3.db

   226 //check the number of records is correct firstly

   227 Prepare43=select count(*) from nums;

   228 ColumnIndex44=

   229 Next45=

   230 ColumnInt46=0,5

   231 St_Close47=

   232 //now check the data

   233 Prepare48=select * from nums;

   234 ColumnIndex49=pkey

   235 Next50=

   236 ColumnInt51=0,11

   237 Next52=

   238 ColumnInt53=0,12

   239 Next54=

   240 ColumnInt55=0,13

   241 Next56=

   242 ColumnInt57=0,14

   243 Next58=

   244 ColumnInt59=0,15

   245 Next60=

   246 St_Close61=

   247 Close62=

   248 EndBlock63=

   249 

   250 [setup4]

   251 SPCreate0=

   252 SetDBPolicy1=ESchemaPolicy,ECapabilityWriteUserData

   253 CreateSP2=c:[102827c7]118192

   254 SPClose3=

   255 Exec4=create table names(pkey int, fname text, lname text, ref int);

   256 Exec5=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);

   257 Exec6=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);

   258 Exec7=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);

   259 Exec8=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);

   260 Exec9=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);

   261 Close10=

   262 EndBlock11=

   263 

   264 [check4]

   265 Open0=c:[102827c7]118192

   266 //check the number of records is correct firstly

   267 Prepare1=select count(*) from names;

   268 ColumnIndex2=

   269 Next3=

   270 ColumnInt4=0,5

   271 St_Close5=

   272 //now check the data

   273 Prepare6=select * from names;

   274 ColumnIndex7=pkey

   275 ColumnIndex8=fname

   276 ColumnIndex9=lname

   277 ColumnIndex10=ref

   278 Next11=

   279 ColumnInt12=0,1

   280 ColumnTextL13=1,tom

   281 ColumnTextL14=2,jones

   282 ColumnInt15=3,2

   283 Next16=

   284 ColumnInt17=0,2

   285 ColumnTextL18=1,jim

   286 ColumnTextL19=2,davies

   287 ColumnInt20=3,1

   288 Next21=

   289 ColumnInt22=0,3

   290 ColumnTextL23=1,bob

   291 ColumnTextL24=2,smith

   292 ColumnInt25=3,1

   293 Next26=

   294 ColumnInt27=0,4

   295 ColumnTextL28=1,dave

   296 ColumnTextL29=2,house

   297 ColumnInt30=3,3

   298 Next31=

   299 ColumnInt32=0,5

   300 ColumnTextL33=1,jane

   301 ColumnTextL34=2,hobbs

   302 ColumnInt35=3,4

   303 Next36=

   304 St_Close37=

   305 Close38=

   306 EndBlock39=

   307 

   308 

   309
Symaptic