debian experimental exim-daemon-heavy config
[exim.git] / test / scripts / 2600-SQLite / 2600
1 # sqlite lookups
2 exim -d-all+lookup -be
3 ${lookup sqlite{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{DIR/aux-fixed/sqlitedb select name from them where id='xxxx';}}
6 ${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='nothing';}}
7 ${lookup sqlite{DIR/aux-fixed/sqlitedb select id,name from them where id='nothing';}}
8 ${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='quote2';}}
9 ${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='newline';}}
10 ${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='tab';}}
11 ${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='its';}}
12 ${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where name='${quote_sqlite:it's}';}}
13 ****
14 exim -d -bh 10.0.0.0
15 mail from:<a@b>
16 rcpt to:<c@d>
17 rcpt to:<c@d>
18 quit
19 ****
20 exim -d -bh 10.10.10.10
21 mail from:<a@b>
22 rcpt to:<c@d>
23 rcpt to:<c@d>
24 quit
25 ****
26 exim -odi -d userx
27 Test message
28 .
29 ****
30 exim -d-all+lookup -be
31 ${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}}
32 ****
33 #
34 #
35 exim -DDATA=DIR/aux-fixed/sqlitedb -d-all+lookup -be
36 ${lookup sqlite{select name from them where id='userx';}}
37 ****