Commit9956c56

committed

Add libpgeasy example file.

1 parent5ca7c8e commit9956c56Copy full SHA for 9956c56

File tree

+68

-0

lines changed

+68

-0

lines changed

Lines changed: 68 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,68 @@`
	`1`	`+/*`
	`2`	`+ * pgmultiresult.c`
	`3`	`+ *`
	`4`	`+ */`
	`5`	`+`
	`6`	`+#include<stdio.h>`
	`7`	`+#include"libpq-fe.h"`
	`8`	`+#include"../halt.h"`
	`9`	`+#include"libpgeasy.h"`
	`10`	`+`
	`11`	`+int`
	`12`	`+main(intargc,char**argv)`
	`13`	`+{`
	`14`	`+charquery[4000];`
	`15`	`+charval[4000];`
	`16`	`+charoptstr[256];`
	`17`	`+PGresultres1,res2;`
	`18`	`+intres1_done=0,res2_done=0;`
	`19`	`+`
	`20`	`+if (argc!=2)`
	`21`	`+halt("Usage: %s database\n",argv[0]);`
	`22`	`+`
	`23`	`+snprintf(optstr,256,"dbname=%s",argv[1]);`
	`24`	`+connectdb(optstr);`
	`25`	`+`
	`26`	`+doquery("\`
	`27`	`+SELECT lanname \`
	`28`	`+FROM pg_language \`
	`29`	`+ORDER BY lanname \`
	`30`	`+");`
	`31`	`+res1=get_result();`
	`32`	`+`
	`33`	`+doquery("\`
	`34`	`+SELECT amname \`
	`35`	`+FROM pg_am \`
	`36`	`+ORDER BY amname \`
	`37`	`+");`
	`38`	`+res2=get_result();`
	`39`	`+`
	`40`	`+while (!res1_done&& !res2_done)`
	`41`	`+{`
	`42`	`+`
	`43`	`+set_result(res1);`
	`44`	`+`
	`45`	`+if (!res1_done)`
	`46`	`+{`
	`47`	`+if (fetch(val)!=END_OF_TUPLES)`
	`48`	`+puts(val);`
	`49`	`+elseres1_done=1;`
	`50`	`+}`
	`51`	`+`
	`52`	`+res1=get_result();`
	`53`	`+`
	`54`	`+set_result(res2);`
	`55`	`+`
	`56`	`+if (!res2_done)`
	`57`	`+{`
	`58`	`+if (fetch(val)!=END_OF_TUPLES)`
	`59`	`+puts(val);`
	`60`	`+elseres2_done=1;`
	`61`	`+}`
	`62`	`+`
	`63`	`+res2=get_result();`
	`64`	`+}`
	`65`	`+`
	`66`	`+disconnectdb();`
	`67`	`+return0;`
	`68`	`+}`

Comments

(0)