// //////////////////////////////////////////////////////////////////////// 

//

// Configuration tests - try changing the values of the default encoding

// and cache_size and page_size. From an integration test we can't really

// detect an effect of the _size settings, though we can read them back

// with the 'pragma' syntax.

//

// First check the defaults. If these change it will confuse the other tests

// so we might as well detect that change and generate a failure ASAP...

[CheckDefaults]

// First open a zero length database to check the defaults.

NoOperation0=

Open1=Z:\TEF_SQL\TestData\ReadOnly.db

Function2=ScalarFullSelect

Method2=SelectTextL

Result2=UTF-16le

Use_Set2=0

Statement2=PRAGMA encoding;

Function3=ScalarFullSelect

Method3=SelectIntL

Result3=1024

Use_Set3=1

Statement3=PRAGMA page_size;

Function4=ScalarFullSelect

Method4=SelectIntL

Result4=DEFAULT_SOFT_HEAP_LIMIT

Use_Set4=1

Statement4=PRAGMA cache_size;

Close5=

EndBlock6=

// Check that gibberish in the configuration string prevents Create from

// working.

[CheckOverride1]

DefineConfig0=this is a load of old rubbish which should have no effect on settings

Delete1=C:\ConfigTest1.db

ExpectedError1=KErrNotFound

Create2=C:\ConfigTest1.db

ExpectedError2=KErrArgument

// The next line will PANIC the client because the Create will have failed due

// to the bad configuration line. That's ok, we're expecting it.

Exec3=Select * from SomeTable;

EndBlock4=

// Check that properly formatted configuration options work, but that

// page_size can't be changed for a pre-existing db, and a bad encoding

// has no effect. The cache_size is also not affected.

[CheckOverride2]

DefineConfig0=page_size=2048;cache_size=64;encoding=hatstand

// On a pre-existing database we can't change the page size, plus the

// bad encoding will have been ignored.

Open1=Z:\TEF_SQL\TestData\ReadOnly.db

// encoding will not have been changed from its default of utf-16

Function2=ScalarFullSelect

Method2=SelectTextL

Result2=UTF-16le

Use_Set2=1

Statement2=PRAGMA encoding;

// page_size will not have been changed from its default of 1024..

Function3=ScalarFullSelect

Method3=SelectIntL

Result3=1024

Use_Set3=1

Statement3=PRAGMA page_size;

// cache_size WILL NOT have changed.

Function4=ScalarFullSelect

Method4=SelectIntL

Result4=64

Use_Set4=1

Statement4=PRAGMA cache_size;

Close5=

EndBlock6=

// Try changing all three config items to legal values, and check them.

[CheckOverride3]

DefineConfig0=page_size=2048;cache_size=34;encoding=UTF-8

// On a new database we can change the page size and the encoding.

// Not the cache_size.

Delete1=C:\ConfigTest2.db

ExpectedError1=KErrNotFound

Create2=C:\ConfigTest2.db

// encoding will not have been changed from its default of utf-16

Function3=ScalarFullSelect

Method3=SelectTextL

Result3=UTF-8

Use_Set3=1

Statement3=PRAGMA encoding;

// page_size will have been changed from its default of 1024..

Function4=ScalarFullSelect

Method4=SelectIntL

Result4=2048

Use_Set4=1

Statement4=PRAGMA page_size;

// cache_size WILL have changed to 34..

Function5=ScalarFullSelect

Method5=SelectIntL

Result5=34

Use_Set5=1

Statement5=PRAGMA cache_size;

Close6=

Delete7=C:\ConfigTest2.db

EndBlock8=

// Try setting page_size to a non-power-of-two (no effect), stick in some

// properly formatted by useless extras (no effect) and attempt to set

// cache_size (works) and an unsupported encoding (doesn't work).

[CheckOverride4]

DefineConfig0=page_size=4095;x=y;i=j;cache_size=43;encoding=UTF-16be

// On a new database we can change the page size and the encoding.

// But page_size is supposed to be a power of 2.

Delete1=C:\ConfigTest3.db

ExpectedError1=KErrNotFound

Create2=C:\ConfigTest3.db

// encoding will not have been changed from its default of utf-16

Function3=ScalarFullSelect

Method3=SelectTextL

Result3=UTF-16le

Use_Set3=1

Statement3=PRAGMA encoding;

// page_size will not have been changed from its default of 1024..

Function4=ScalarFullSelect

Method4=SelectIntL

Result4=1024

Use_Set4=1

Statement4=PRAGMA page_size;

// cache_size WILL have changed.

Function5=ScalarFullSelect

Method5=SelectIntL

Result5=43

Use_Set5=1

Statement5=PRAGMA cache_size;

Close6=

Delete7=C:\ConfigTest3.db

EndBlock8=

// Try setting a legal page_size (works), a cache_size (doesn't work) and

// a legal character encoding (works).

[CheckOverride5]

DefineConfig0=page_size=512;cache_size=432;encoding=UTF-8

// On a new database we can change the page size, cache size and the

// encoding.

Delete1=C:\ConfigTest4.db

ExpectedError1=KErrNotFound

Create2=C:\ConfigTest4.db

// encoding will not have been changed from its default of utf-16

Function3=ScalarFullSelect

Method3=SelectTextL

Result3=UTF-8

Use_Set3=1

Statement3=PRAGMA encoding;

// page_size will not have been changed from its default of 1024..

Function4=ScalarFullSelect

Method4=SelectIntL

Result4=512

Use_Set4=1

Statement4=PRAGMA page_size;

// cache_size WILL have changed.

Function5=ScalarFullSelect

Method5=SelectIntL

Result5=432

Use_Set5=1

Statement5=PRAGMA cache_size;

Close6=

Delete7=C:\ConfigTest4.db

EndBlock8=

// /////////////////////////////////////////////////////////////////////////

// The following tests create two functionally identical databases but one

// block uses UTF-8. Then check that the file sizes differ.

// Create a database with a single table containing a single cell containing

// the text content of the reference1.txt text file. Set UTF-16.

[WriteTextDB-16bit]

Delete0=C:\ConfigTest5.db

ExpectedError0=KErrNotFound

Create1=C:\ConfigTest5.db

// First check for our expected defaults.

Function2=ScalarFullSelect

Method2=SelectTextL

Result2=UTF-16le

Use_Set2=1

Statement2=PRAGMA encoding;

Function3=ScalarFullSelect

Method3=SelectIntL

Result3=1024

Use_Set3=1

Statement3=PRAGMA page_size;

Function4=ScalarFullSelect

Method4=SelectIntL

Result4=DEFAULT_SOFT_HEAP_LIMIT

Use_Set4=1

Statement4=PRAGMA cache_size;

Exec5=Create Table Sometable(f1 text);

Prepare6=Insert into Sometable values(:val);

ParameterIndex7=:val

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

St_Exec9=

Reset10=

St_Close11=

Prepare12=select f1 from Sometable;

ColumnIndex13=f1

Next14=KSqlAtRow

ColumnSize15=0,3626

St_Close16=

Close17=

EndBlock18=

// Create a database with a single table containing a single cell containing

// the text content of the reference1.txt text file. Set UTF-8.

[WriteTextDB-8bit]

Delete0=C:\ConfigTest6.db

ExpectedError0=KErrNotFound

DefineConfig1=encoding=UTF-8

Create2=C:\ConfigTest6.db

// Check the defaults (plus our changed character encoding)

Function3=ScalarFullSelect

Method3=SelectTextL

Result3=UTF-8

Use_Set3=1

Statement3=PRAGMA encoding;

Function4=ScalarFullSelect

Method4=SelectIntL

Result4=1024

Use_Set4=1

Statement4=PRAGMA page_size;

Function5=ScalarFullSelect

Method5=SelectIntL

Result5=DEFAULT_SOFT_HEAP_LIMIT

Use_Set5=1

Statement5=PRAGMA cache_size;

Exec6=Create Table Sometable(f1 text);

Prepare7=Insert into Sometable values(:val);

ParameterIndex8=:val

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

St_Exec10=

Reset11=

St_Close12=

Prepare13=select f1 from Sometable;

ColumnIndex14=f1

Next15=KSqlAtRow

ColumnSize16=0,3626

St_Close17=

Close18=

EndBlock19=

// Check that the two databases created above (which are exactly equivalent)

// differ in size. That will suggest that the UTF-8/UTF-16

// encoding options have done their work. Through the SQLite APIs they generate

// identical output. It seems kind of overkill to have a whole code-driven

// test function to do this but I see no other way..

// Attempt an attach of UTF-16 to UTF-8 database - it will fail, that's an

// illegal operation.

[FilesDiffer]

Function0=FilesDifferBySize

FileA0=C:\ConfigTest5.db

FileB0=C:\ConfigTest6.db

Open1=C:\ConfigTest5.db

Exec2=Attach "C:\ConfigTest6.db" as ThatOne;

ExpectedError2=KSqlErrGeneral

LastErrorMessage3=attached databases must use the same text encoding as main database

// Delete will succeed because the attach didn't.

Delete4=C:\ConfigTest6.db

Close5=

Delete6=C:\ConfigTest5.db

EndBlock7=