summaryrefslogtreecommitdiff
path: root/test/scripts/2600-SQLite/2600
blob: f388b1ac110f0b968cae568319bbad7c42e77c68 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
# sqlite lookups
exim -d-all+lookup -be
${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}';}}
****
exim -d -bh 10.0.0.0
mail from:<a@b>
rcpt to:<c@d>
rcpt to:<c@d>
quit
****
exim -d -bh 10.10.10.10
mail from:<a@b>
rcpt to:<c@d>
rcpt to:<c@d>
quit
****
exim -odi -d userx
Test message
.
****
exim -d-all+lookup -be
${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}}
****