[exim.git] / test / scripts / 9200-PostgreSQL / 9200

# pgsql lookups - expects specific data
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';}}
****
exim -d -bh 10.0.0.0
mail from:<a@b>
rcpt to:<c@d>
rcpt to:<c@d>
quit
****
exim -odi -d CALLER
Test message
.
****
exim -DSERVERS=\(/tmp/.s.PGSQL.5432\)/test/ph10/ -d-all+lookup -be
${lookup pgsql {select name from them where id='CALLER';}}
****
Commit	Line	Data
59371ea7 PH	1	# pgsql lookups - expects specific data
	2	exim -d-all+lookup -be
	3	${lookup pgsql {select name from them where id='ph10';}}
	4	${lookup pgsql {select name from them where id='ph10';}}
	5	${lookup pgsql {select name from them where id='xxxx';}}
	6	${lookup pgsql {select name from them where id='nothing';}}
	7	${lookup pgsql {select id,name from them where id='nothing';}}
	8	${lookup pgsql {delete from them where id='nonexist';}}
	9	${lookup pgsql {select * from them where id='quote2';}}
	10	${lookup pgsql {select * from them where id='newline';}}
	11	${lookup pgsql {select * from them where id='tab';}}
	12	****
	13	exim -d -bh 10.0.0.0
	14	mail from:<a@b>
	15	rcpt to:<c@d>
	16	rcpt to:<c@d>
	17	quit
	18	****
	19	exim -odi -d CALLER
	20	Test message
	21	.
	22	****
	23	exim -DSERVERS=\(/tmp/.s.PGSQL.5432\)/test/ph10/ -d-all+lookup -be
	24	${lookup pgsql {select name from them where id='CALLER';}}
	25	****