X-Git-Url: https://git.netwichtig.de/gitweb/?a=blobdiff_plain;f=test%2Fscripts%2F2600-SQLite%2F2600;h=27e4ab6051c38eff116654063727616752516b53;hb=c4b4086235b1d5e21fcf1ad72a1b05813e15dcbd;hp=2a557a46ac2e6ebb2a02a4ef0b3e1177118001dc;hpb=298849d8ea217fd104d167f5233bd11240b3ddae;p=user%2Fhenk%2Fcode%2Fexim.git diff --git a/test/scripts/2600-SQLite/2600 b/test/scripts/2600-SQLite/2600 index 2a557a46a..27e4ab605 100644 --- a/test/scripts/2600-SQLite/2600 +++ b/test/scripts/2600-SQLite/2600 @@ -1,29 +1,40 @@ # sqlite lookups exim -d-all+lookup -be +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select name from them where id='userx';}} ${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}} -${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}} -${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='xxxx';}} -${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='nothing';}} -${lookup sqlite{DIR/aux-fixed/sqlitedb select id,name from them where id='nothing';}} -${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='quote2';}} -${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='newline';}} -${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='tab';}} -${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='its';}} -${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where name='${quote_sqlite:it's}';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='userx';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='userx';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='xxxx';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select name from them where id='nothing';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select id,name from them where id='nothing';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb {select * from them where id='quote2';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='newline';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='tab';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='its';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where name='${quote_sqlite:it's}';}} +**** +exim -d -DOPT=y -bh 10.0.0.0 +helo test +mail from: +rcpt to: +rcpt to: +quit **** exim -d -bh 10.0.0.0 +helo test mail from: rcpt to: rcpt to: quit **** exim -d -bh 10.10.10.10 +helo test mail from: rcpt to: rcpt to: quit **** -exim -odi -d userx +exim -DOPT=y -odi -d userx Test message . **** @@ -35,3 +46,9 @@ ${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}} exim -DDATA=DIR/aux-fixed/sqlitedb -d-all+lookup -be ${lookup sqlite{select name from them where id='userx';}} **** +exim -DDATA=nonabsolute_filename -d-all+lookup -be +${lookup sqlite{select name from them where id='userx';}} +**** +exim -DDATA=DIR/missingfile -d-all+lookup -be +${lookup sqlite{select name from them where id='userx';}} +****