Symaptic: os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/views.ini@bde4ae8d615e

     1 [views]

     2 Delete0=c:\test3.db

     3 ExpectedError0=KErrNotFound

     4 Create1=c:\test3.db

     5 NewBlock2=create1

     6 NewBlock3=create2

     7 NewBlock4=create3

     8 NewBlock5=view1

     9 NewBlock6=view2

    10 EndBlock7=

    12 [create1]

    13 Exec0=create table names(pkey int primary key, fname text, lname text, ref int);

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

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

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

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

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

    19 EndBlock6=

    21 [create2]

    22 Exec0=create table roles(ref int primary key, job text, band text);

    23 Exec1=insert into roles(ref, job, band) values(1, "engineer", "A");

    24 Exec2=insert into roles(ref, job, band) values(2, "sales", "A");

    25 Exec3=insert into roles(ref, job, band) values(3, "consultant", "B");

    26 Exec4=insert into roles(ref, job, band) values(4, "manager", "C");

    27 Exec5=insert into roles(ref, job, band) values(5, "VP", "D");

    28 EndBlock6=

    30 [create3]

    31 Exec0=create table sal(band text primary key, wage real);

    32 Exec1=insert into sal(band, wage) values ("A", 24000);

    33 Exec2=insert into sal(band, wage) values ("B", 30000);

    34 Exec3=insert into sal(band, wage) values ("C", 45000);

    35 Exec4=insert into sal(band, wage) values ("D", 60000);

    36 EndBlock5=

    38 [view1]

    39 Exec0=create view v1 as select fname, lname, job from names, roles where names.ref = roles.ref;

    40 Prepare1=select * from v1;

    41 ColumnIndex2=fname

    42 ColumnIndex3=lname

    43 ColumnIndex4=job

    44 Next5=

    45 ColumnTextL6=0,tom

    46 ColumnTextL7=1,jones

    47 ColumnTextL8=2,sales

    48 Next9=

    49 ColumnTextL10=0,jim

    50 ColumnTextL11=1,davies

    51 ColumnTextL12=2,engineer

    52 Next13=

    53 ColumnTextL14=0,bob

    54 ColumnTextL15=1,smith

    55 ColumnTextL16=2,engineer

    56 Next17=

    57 ColumnTextL18=0,dave

    58 ColumnTextL19=1,house

    59 ColumnTextL20=2,consultant

    60 Next21=

    61 ColumnTextL22=0,jane

    62 ColumnTextL23=1,hobbs

    63 ColumnTextL24=2,manager

    64 St_Close25=

    65 EndBlock26=

    67 [view2]

    68 Exec0=create view v2 as select fname, job, wage from names, roles, sal where names.ref = roles.ref and roles.band = sal.band;

    69 Prepare1=select * from v2;

    70 ColumnIndex2=fname

    71 ColumnIndex3=job

    72 ColumnIndex4=wage

    73 Next5=

    74 ColumnTextL6=0,tom

    75 ColumnTextL7=1,sales

    76 ColumnReal8=2,24000

    77 Next9=

    78 ColumnTextL10=0,jim

    79 ColumnTextL11=1,engineer

    80 ColumnReal12=2,24000

    81 Next13=

    82 ColumnTextL14=0,bob

    83 ColumnTextL15=1,engineer

    84 ColumnReal16=2,24000

    85 Next17=

    86 ColumnTextL18=0,dave

    87 ColumnTextL19=1,consultant

    88 ColumnReal20=2,30000

    89 Next21=

    90 ColumnTextL22=0,jane

    91 ColumnTextL23=1,manager

    92 ColumnReal24=2,45000

    93 St_Close25=

    94 EndBlock26=

author	sl@SLION-WIN7.fritz.box
	Fri, 15 Jun 2012 03:10:57 +0200
changeset 0	bde4ae8d615e
permissions	-rw-r--r--