# pgsql lookups # # first, populate a DB to test against sudo rm -fr DIR/pgsql perl system 'DIR/bin.sys/initdb -D DIR/pgsql/data'; **** sudo rm test-stdout background DIR/bin.sys/postgres -D DIR/pgsql/data -p PORT_N -k DIR/pgsql **** sleep 1 perl system 'createdb -h localhost -p PORT_N test'; system 'psql -h localhost -p PORT_N -d test \ -c "CREATE TABLE them ( name text, id text ); \ INSERT INTO them VALUES ( \'Philip Hazel\', \'ph10\' ); \ INSERT INTO them VALUES ( \'Aristotle\', \'aaaa\' ); \ INSERT INTO them VALUES ( \'\', \'nothing\' ); \ INSERT INTO them VALUES ( \'\"stquot\', \'quote2\' ); \ INSERT INTO them VALUES ( \'before\' || CHR(13) || CHR(10) || \'after\', \'newline\' ); \ INSERT INTO them VALUES ( \'x\' || CHR(9) || \'x\', \'tab\' ); \ INSERT INTO them VALUES ( CHR(39) || \'stquot\', \'quote1\' );" \ '; **** # # now, the tests exim -d-all+lookup -be ${lookup pgsql {select name from them where id='ph10';}} ${lookup pgsql {select name from them where id='ph10';}} ${lookup pgsql {select name from them where id='xxxx';}} ${lookup pgsql {select name from them where id='nothing';}} ${lookup pgsql {select id,name from them where id='nothing';}} ${lookup pgsql {delete from them where id='nonexist';}} ${lookup pgsql {select * from them where id='quote2';}} ${lookup pgsql {select * from them where id='newline';}} ${lookup pgsql {select * from them where id='tab';}} ${lookup pgsql {select * from them where name='${quote_pgsql:'stquot}';}} ${lookup pgsql {servers=x:localhost; select name from them where id='ph10';}} ${lookup pgsql {servers=localhost::PORT_N:x; select name from them where id='ph10';}} ${lookup pgsql {servers=localhost::PORT_N/test/CALLER/:x; select name from them where id='ph10';}} ${lookup pgsql {servers=(DIR/pgsql/.s.PGSQL.PORT_N)/test/CALLER/:x; select name from them where id='ph10';}} x ${lookup pgsql {SELECT name FROM them WHERE id IN ('ph10', 'aaaa');}} ${lookup pgsql {SELECT * FROM them WHERE id IN ('ph10', 'aaaa');}} ${lookup pgsql {delete from them where id='aaaa'}} **** exim -d -bh 10.0.0.0 mail from: rcpt to: rcpt to: quit **** exim -odi -d CALLER Test message . **** exim -DSERVERS=\(DIR/pgsql/.s.PGSQL.PORT_N\)/test/CALLER/ -d-all+lookup -be ${lookup pgsql {select name from them where id='ph10';}} **** # perl system 'pg_ctl stop -D DIR/pgsql/data -m immediate'; **** killdaemon sudo rm -fr DIR/pgsql