a11d46ef173d78f17da86922d6fcefa346c3d301
[exim.git] / test / scripts / 2600-SQLite / 2600
1 # sqlite lookups
2 exim -d-all+lookup -be
3 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select name from them where id='userx';}}
4 ${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}}
5 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='userx';}}
6 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='userx';}}
7 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='xxxx';}}
8 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select name from them where id='nothing';}}
9 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select id,name from them where id='nothing';}}
10 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb {select * from them where id='quote2';}}
11 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='newline';}}
12 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='tab';}}
13 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='its';}}
14 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where name='${quote_sqlite:it's}';}}
15 ****
16 exim -d -DOPT=y -bh 10.0.0.0
17 mail from:<a@b>
18 rcpt to:<c@d>
19 rcpt to:<c@d>
20 quit
21 ****
22 exim -d -bh 10.0.0.0
23 mail from:<a@b>
24 rcpt to:<c@d>
25 rcpt to:<c@d>
26 quit
27 ****
28 exim -d -bh 10.10.10.10
29 mail from:<a@b>
30 rcpt to:<c@d>
31 rcpt to:<c@d>
32 quit
33 ****
34 exim -DOPT=y -odi -d userx
35 Test message
36 .
37 ****
38 exim -d-all+lookup -be
39 ${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}}
40 ****
41 #
42 #
43 exim -DDATA=DIR/aux-fixed/sqlitedb -d-all+lookup -be
44 ${lookup sqlite{select name from them where id='userx';}}
45 ****
46 exim -DDATA=nonabsolute_filename -d-all+lookup -be
47 ${lookup sqlite{select name from them where id='userx';}}
48 ****
49 exim -DDATA=DIR/missingfile -d-all+lookup -be
50 ${lookup sqlite{select name from them where id='userx';}}
51 ****