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 ****
  38 exim -DDATA=nonabsolute_filename -d-all+lookup -be
  39 ${lookup sqlite{select name from them where id='userx';}}
  40 ****
  41 exim -DDATA=DIR/missingfile -d-all+lookup -be
  42 ${lookup sqlite{select name from them where id='userx';}}
  43 ****