test/scripts/2600-SQLite/2600

   1 # sqlite lookups
   2 exim -d-all+lookup -be
   3 ${lookup sqlite,file=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,file=DIR/aux-fixed/sqlitedb{ select name from them where id='userx';}}
   6 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='userx';}}
   7 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='xxxx';}}
   8 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select name from them where id='nothing';}}
   9 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select id,name from them where id='nothing';}}
  10 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb {select * from them where id='quote2';}}
  11 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='newline';}}
  12 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='tab';}}
  13 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='its';}}
  14 ${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where name='${quote_sqlite:it's}';}}
  15 ****
  16 exim -d -DOPT=y -bh 10.0.0.0
  17 helo test
  18 mail from:<a@b>
  19 rcpt to:<c@d>
  20 rcpt to:<c@d>
  21 quit
  22 ****
  23 exim -d -bh 10.0.0.0
  24 helo test
  25 mail from:<a@b>
  26 rcpt to:<c@d>
  27 rcpt to:<c@d>
  28 quit
  29 ****
  30 exim -d -bh 10.10.10.10
  31 helo test
  32 mail from:<a@b>
  33 rcpt to:<c@d>
  34 rcpt to:<c@d>
  35 quit
  36 ****
  37 exim -DOPT=y -odi -d userx
  38 Test message
  39 .
  40 ****
  41 exim -d-all+lookup -be
  42 ${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}}
  43 ****
  44 #
  45 #
  46 exim -DDATA=DIR/aux-fixed/sqlitedb -d-all+lookup -be
  47 ${lookup sqlite{select name from them where id='userx';}}
  48 ****
  49 exim -DDATA=nonabsolute_filename -d-all+lookup -be
  50 ${lookup sqlite{select name from them where id='userx';}}
  51 ****
  52 exim -DDATA=DIR/missingfile -d-all+lookup -be
  53 ${lookup sqlite{select name from them where id='userx';}}
  54 ****