| 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 | **** |