// Called by BasicSQL2.script. This config file contains information

// for basic API tests. We're going to exercise to some basic level all

// client side APIs the SQLite system. In some cases we'll make deliberate

// errors and look for the expected error codes and messages.

// First some basic RSqlDatabase tests.

[Top]

Close0=

Delete1=C:\BrieflyExists.db

ExpectedError1=KErrNotFound

Open2=C:\BrieflyExists.db

ExpectedError2=KErrNotFound

NoOperation3=

NoOperation4=C:\BrieflyExists.db

NoOperation4=KErrNotFound

Create5=C:\BrieflyExists.db

Close6=

Create7=C:\BrieflyExists.db

ExpectedError7=KErrAlreadyExists

Open8=C:\BrieflyExists.db

Exec9=what a load of gibberish

ExpectedError9=KSqlErrGeneral

LastErrorMessage10=near "what": syntax error

Exec11=Create Table Table1(Field1 int primary key, Field2 text, Field3 Real);

SetIsolationLevel12=EReadUncommitted

Close13=

Delete14=C:\BrieflyExists.db

Delete15=C:\SqlStatement.db

ExpectedError15=KErrNotFound

Create16=C:\SqlStatement.db

Exec17=Create Table Table1(Field1 int primary key, Field2 text, Field3 Real);

NewBlock18=rsqlstatement

Close19=

EndBlock20=

// Leave the db lying around, we'll do some more in another script line.

// Play with BindInt, BindReal, BindNull and BindText.

// Check the result with AtRow, ColumnInt, ColumnReal, ColumnTextL (result

// specified inline, not in a file), also checks IsNull to check the previous

// BindNull.

[rsqlstatement]

Prepare0=Insert into Table1(Field1, Field2, Field3) values(:huey, :dewey, :louie);

ParameterIndex1=:huey

ParameterIndex2=:dewey

ParameterIndex3=:louie

BindInt4=0,711

BindText5=1,Here's some text.

BindReal6=2,2.7182818282

St_Exec7=

Reset8=

BindInt9=0,1234

BindText10=1,Some more text....

BindReal11=2,3.141592654

St_Exec12=

Reset13=

BindInt14=0,1235

BindText15=1,Yet more text....

BindReal16=2,9.869604401

St_Exec17=

Reset18=

BindInt19=0,1236

BindNull20=1

BindReal21=2,6.0827626

St_Exec22=

St_Close23=

Prepare24=select * from table1;

AtRow25=FAlse

ColumnIndex26=Field1

ColumnIndex27=Field2

ColumnIndex28=Field3

Next29=

AtRow30=TruE

ColumnInt31=0,711

ColumnType32=1,ESqlText

ColumnTextL33=1,Here's some text.

ColumnReal34=2,2.7182818282

Next35=

ColumnInt36=0,1234

ColumnSize37=1,18

ColumnTextL38=1,Some more text....

ColumnReal39=2,3.141592654

ColumnSize40=2,8

Next41=

ColumnInt42=0,1235

ColumnTextL43=1,Yet more text....

ColumnReal44=2,9.869604401

Next45=

ColumnInt46=0,1236

IsNull47=1,tRue

ColumnReal48=2,6.0827626

Delete49=C:\SqlStatement.db

ExpectedError49=KErrInUse

Next50=

AtRow51=FalSe

St_Close52=

EndBlock53=

// This is a separate case, trigger by the second line in the script file.

// It adds to the existing table in SqlStatement.db, checks 'ColumnInt64',

// and BindInt64, plus verifies the return from 'Next'. On completion this

// section deletes the database.

[AddtoTable]

Open0=C:\SqlStatement.db

Exec1=alter table Table1 add Field4 int;

Prepare2=Update Table1 Set Field4=108 where Field3 < 5.8;

St_Exec3=

Reset4=

St_Close5=

Prepare6=Insert into Table1(Field1, Field2, Field3, Field4) values(:huey, :dewey, :louie, :donald);

ParameterIndex7=:huey

ParameterIndex8=:dewey

ParameterIndex9=:louie

ParameterIndex10=:donald

ParameterIndex11=:somerubbish

ExpectedError11=KErrNotFound

// The next line may not be appropriate - I think LastErrorMessage is only

// relevant following a 'KSqlErrGeneral' (which we don't have).

LastErrorMessage12=not an error

BindInt13=0,17141

BindText14=1,AddtoTable stuff

BindReal15=2,299792458

BindInt64_16=3,123456789012345

St_Exec17=

Reset18=

St_Close19=

Prepare20=select * from table1 where Field1=17141;

ColumnIndex21=Field4

AtRow22=FaLse

Next23=

AtRow24=trUe

ColumnType25=0,ESqlInt64

ColumnInt64_26=0,123456789012345

Next27=KSqlAtEnd

St_Close28=

Close29=

Delete30=C:\SqlStatement.db

EndBlock31=

// Tests writing to a text field with a stream (RSqlParamWriteStream).

// Checks the content with all variants of ColumnText.

[SWBindText]

Delete0=C:\texttest1

ExpectedError0=KErrNotFound

Create1=C:\texttest1

Exec2=create table table2(field1 text(32770), field2 integer);

Prepare3=insert into table2(field1, field2) values(:largetext, :int);

ParameterIndex4=:largetext

ParameterIndex5=:int

StreamWriteBindText6=0,Z:\TEF_SQL\TestData\reference1.txt

BindInt7=1,1234321

St_Exec8=

Reset9=

St_Close10=

Prepare11=SELECT * from table2;

ColumnIndex12=field1

ColumnIndex13=field2

Next14=KSqlAtRow

ColumnSize15=0,3626

ColumnSize16=1,4

ColumnTextP17=0,Z:\TEF_SQL\TestData\reference1.txt

ColumnInt18=1,1234321

Next19=KSqlAtEnd

St_Close20=ignored

Prepare21=SELECT * from table2;

ColumnIndex22=field1

ColumnIndex23=field2

Next24=KSqlAtRow

ColumnSize25=0,3626

ColumnSize26=1,4

ColumnTextL27=0,Z:\TEF_SQL\TestData\reference1.txt

ColumnInt28=1,1234321

Next29=KSqlAtEnd

St_Close30=ignored

Prepare31=SELECT * from table2;

ColumnIndex32=field1

ColumnIndex33=field2

Next34=KSqlAtRow

ColumnSize35=0,3626

ColumnSize36=1,4

ColumnTextD37=0,Z:\TEF_SQL\TestData\reference1.txt

ColumnInt38=1,1234321

Next39=KSqlAtEnd

St_Close40=ignored

Prepare41=SELECT * from table2;

ColumnIndex42=field1

ColumnIndex43=field2

Next44=KSqlAtRow

ColumnSize45=0,3626

ColumnSize46=1,4

StreamReadColText47=0,Z:\TEF_SQL\TestData\reference1.txt

ColumnInt48=1,1234321

Next49=KSqlAtEnd

St_Close50=ignored

Close51=also ignored

Delete52=C:\texttest1

EndBlock53=

[SWBindBinary]

Delete0=C:\binarytest1

ExpectedError0=KErrNotFound

Create1=C:\binarytest1

Exec2=create table table2(field1 blob(32770));

Prepare3=insert into table2(field1) values(:largebin);

ParameterIndex4=:largebin

StreamWriteBindBin5=0,Z:\TEF_SQL\TestData\reference1.bin

St_Exec6=

Reset7=

St_Close8=

Prepare9=SELECT field1 from table2;

ColumnIndex10=field1

Next11=KSqlAtRow

ColumnSize12=0,8094

ColumnBinaryL13=0,Z:\TEF_SQL\TestData\reference1.bin

Next14=KSqlAtEnd

St_Close15=ignored

Prepare16=SELECT field1 from table2;

ColumnIndex17=field1

Next18=KSqlAtRow

ColumnSize19=0,8094

ColumnBinaryP20=0,Z:\TEF_SQL\TestData\reference1.bin

Next21=KSqlAtEnd

St_Close22=ignored

Prepare23=SELECT field1 from table2;

ColumnIndex24=field1

Next25=KSqlAtRow

ColumnSize26=0,8094

ColumnBinaryD27=0,Z:\TEF_SQL\TestData\reference1.bin

Next28=KSqlAtEnd

St_Close29=ignored

Prepare30=SELECT field1 from table2;

ColumnIndex31=field1

Next32=KSqlAtRow

ColumnSize33=0,8094

StreamReadColBin34=0,Z:\TEF_SQL\TestData\reference1.bin

Next35=KSqlAtEnd

St_Close36=ignored

Close37=also ignored

Delete38=C:\binarytest1

EndBlock39=

// Use anonymous (if that's the right word) column indices to check, for

// example the number of records in a database.

// Use a Copy..

[Countlines]

Copy0=Z:\TEF_SQL\TestData\test1.db,Z:\test1.db

ExpectedError0=KErrAccessDenied

Delete1=C:\test1.db

ExpectedError1=KErrNotFound

Copy2=Z:\TEF_SQL\TestData\test1.db,C:\test1.db

Open3=C:\test1.db

Prepare4=select count(*) from phone;

Next5=KSqlAtRow

ColumnIndex6=

ColumnInt7=0,1000

Next8=KSqlAtEnd

St_Close9=

Prepare10=select avg(cm_id) from phone;

Next11=KSqlAtRow

ColumnIndex12=

ColumnReal13=0,500.5

Next14=KSqlAtEnd

St_Close15=

Prepare16=select sum(cm_id) from phone;

Next17=KSqlAtRow

AtRow18=True

ColumnIndex19=

ColumnInt20=0,500500

Next21=KSqlAtEnd

St_Close22=

Close23=

// This delete is in itself a test - the 'Copy' above does not and should not

// propagate file permissions from the Z: drive. If it did, this delete would

// fail, but it should not.

Delete24=C:\test1.db

EndBlock25=