1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/views.ini	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,94 @@
     1.4 +[views]
     1.5 +Delete0=c:\test3.db
     1.6 +ExpectedError0=KErrNotFound
     1.7 +Create1=c:\test3.db
     1.8 +NewBlock2=create1
     1.9 +NewBlock3=create2
    1.10 +NewBlock4=create3
    1.11 +NewBlock5=view1
    1.12 +NewBlock6=view2
    1.13 +EndBlock7=
    1.14 +
    1.15 +[create1]
    1.16 +Exec0=create table names(pkey int primary key, fname text, lname text, ref int);
    1.17 +Exec1=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
    1.18 +Exec2=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
    1.19 +Exec3=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
    1.20 +Exec4=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
    1.21 +Exec5=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
    1.22 +EndBlock6=
    1.23 +
    1.24 +[create2]
    1.25 +Exec0=create table roles(ref int primary key, job text, band text);
    1.26 +Exec1=insert into roles(ref, job, band) values(1, "engineer", "A");
    1.27 +Exec2=insert into roles(ref, job, band) values(2, "sales", "A");
    1.28 +Exec3=insert into roles(ref, job, band) values(3, "consultant", "B");
    1.29 +Exec4=insert into roles(ref, job, band) values(4, "manager", "C");
    1.30 +Exec5=insert into roles(ref, job, band) values(5, "VP", "D");
    1.31 +EndBlock6= 
    1.32 +
    1.33 +[create3]
    1.34 +Exec0=create table sal(band text primary key, wage real);
    1.35 +Exec1=insert into sal(band, wage) values ("A", 24000);
    1.36 +Exec2=insert into sal(band, wage) values ("B", 30000);
    1.37 +Exec3=insert into sal(band, wage) values ("C", 45000);
    1.38 +Exec4=insert into sal(band, wage) values ("D", 60000);
    1.39 +EndBlock5=
    1.40 +
    1.41 +[view1]
    1.42 +Exec0=create view v1 as select fname, lname, job from names, roles where names.ref = roles.ref;
    1.43 +Prepare1=select * from v1;
    1.44 +ColumnIndex2=fname
    1.45 +ColumnIndex3=lname
    1.46 +ColumnIndex4=job
    1.47 +Next5=
    1.48 +ColumnTextL6=0,tom
    1.49 +ColumnTextL7=1,jones
    1.50 +ColumnTextL8=2,sales
    1.51 +Next9=
    1.52 +ColumnTextL10=0,jim
    1.53 +ColumnTextL11=1,davies
    1.54 +ColumnTextL12=2,engineer
    1.55 +Next13=
    1.56 +ColumnTextL14=0,bob
    1.57 +ColumnTextL15=1,smith
    1.58 +ColumnTextL16=2,engineer
    1.59 +Next17=
    1.60 +ColumnTextL18=0,dave
    1.61 +ColumnTextL19=1,house
    1.62 +ColumnTextL20=2,consultant
    1.63 +Next21=
    1.64 +ColumnTextL22=0,jane
    1.65 +ColumnTextL23=1,hobbs
    1.66 +ColumnTextL24=2,manager
    1.67 +St_Close25=
    1.68 +EndBlock26=
    1.69 +
    1.70 +[view2]
    1.71 +Exec0=create view v2 as select fname, job, wage from names, roles, sal where names.ref = roles.ref and roles.band = sal.band;
    1.72 +Prepare1=select * from v2;
    1.73 +ColumnIndex2=fname
    1.74 +ColumnIndex3=job
    1.75 +ColumnIndex4=wage
    1.76 +Next5=
    1.77 +ColumnTextL6=0,tom
    1.78 +ColumnTextL7=1,sales
    1.79 +ColumnReal8=2,24000
    1.80 +Next9=
    1.81 +ColumnTextL10=0,jim
    1.82 +ColumnTextL11=1,engineer
    1.83 +ColumnReal12=2,24000
    1.84 +Next13=
    1.85 +ColumnTextL14=0,bob
    1.86 +ColumnTextL15=1,engineer
    1.87 +ColumnReal16=2,24000
    1.88 +Next17=
    1.89 +ColumnTextL18=0,dave
    1.90 +ColumnTextL19=1,consultant
    1.91 +ColumnReal20=2,30000
    1.92 +Next21=
    1.93 +ColumnTextL22=0,jane
    1.94 +ColumnTextL23=1,manager
    1.95 +ColumnReal24=2,45000
    1.96 +St_Close25=
    1.97 +EndBlock26=