Sqlite: new main option sqlite_dbfile
[exim.git] / test / scripts / 2600-SQLite / 2600
CommitLineData
59371ea7
PH
1# sqlite lookups
2exim -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****
14exim -d -bh 10.0.0.0
15mail from:<a@b>
16rcpt to:<c@d>
17rcpt to:<c@d>
18quit
19****
20exim -d -bh 10.10.10.10
21mail from:<a@b>
22rcpt to:<c@d>
23rcpt to:<c@d>
24quit
25****
26exim -odi -d userx
27Test message
28.
29****
30exim -d-all+lookup -be
31${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}}
32****
298849d8
JH
33#
34#
35exim -DDATA=DIR/aux-fixed/sqlitedb -d-all+lookup -be
36${lookup sqlite{select name from them where id='userx';}}
37****