diff -r 000000000000 -r bde4ae8d615e os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/constraints.ini --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/constraints.ini Fri Jun 15 03:10:57 2012 +0200 @@ -0,0 +1,20 @@ +[constraints] +Delete0=c:\test2.db +ExpectedError0=KErrNotFound +Create1=c:\test2.db +NewBlock2=test +Close3= +EndBlock4= + +[test] +Exec0=create table names(pkey int primary key, fname text, lname text NOT NULL, age int, UNIQUE(fname, lname), CHECK(age < 100)); +Exec1=insert into names(pkey, fname, lname, age) values(1, "fred", "smith", 25); +Exec2=insert into names(pkey, fname, lname) values(1, "tom", "jones"); +ExpectedError2=KSqlErrConstraint +Exec3=insert into names(pkey, fname, lname) values(2, "fred", "smith"); +ExpectedError3=KSqlErrConstraint +Exec4=insert into names(pkey, fname) values(3, "fred"); +ExpectedError4=KSqlErrConstraint +Exec5=insert into names(pkey, fname, lname, age) values(2, "tom", "jones", 101); +ExpectedError5=KSqlErrConstraint +EndBlock6=