diff options
Diffstat (limited to 'src/interfaces/libpgeasy/examples/pginsert.c')
-rw-r--r-- | src/interfaces/libpgeasy/examples/pginsert.c | 98 |
1 files changed, 0 insertions, 98 deletions
diff --git a/src/interfaces/libpgeasy/examples/pginsert.c b/src/interfaces/libpgeasy/examples/pginsert.c deleted file mode 100644 index 85b181b541c..00000000000 --- a/src/interfaces/libpgeasy/examples/pginsert.c +++ /dev/null @@ -1,98 +0,0 @@ -/* - * insert.c - * -*/ - -#include <stdio.h> -#include <time.h> -#include "libpq-fe.h" -#include "../halt.h" -#include "libpgeasy.h" - -int -main(int argc, char **argv) -{ - char query[4000]; - int row = 1; - int aint; - float afloat; - double adouble; - char achar[11], - abpchar[11], - avarchar[51], - atext[51]; - time_t aabstime; - char optstr[256]; - - if (argc != 2) - halt("Usage: %s database\n", argv[0]); - - snprintf(optstr, 256, "dbname=%s", argv[1]); - connectdb(optstr); - - on_error_continue(); - doquery("DROP TABLE testfetch"); - on_error_stop(); - - doquery("\ - CREATE TABLE testfetch( \ - aint int4, \ - afloat float4, \ - adouble float8, \ - achar char, \ - abpchar char(10), \ - avarchar varchar(50), \ - atext text, \ - aabstime abstime) \ - "); - - while (1) - { - sprintf(query, "INSERT INTO testfetch VALUES ( \ - %d, \ - 2322.12, \ - '923121.0323'::float8, \ - 'A', \ - 'Betty', \ - 'Charley', \ - 'Doug', \ - 'now' )", row); - doquery(query); - - doquery("BEGIN WORK"); - doquery("DECLARE c_testfetch BINARY CURSOR FOR \ - SELECT * FROM testfetch"); - - doquery("FETCH ALL IN c_testfetch"); - - while (fetch( - &aint, - &afloat, - &adouble, - achar, - abpchar, - avarchar, - atext, - &aabstime) != END_OF_TUPLES) - printf("int %d\nfloat %f\ndouble %f\nchar %s\n\ -bpchar %s\nvarchar %s\ntext %s\nabstime %s", - aint, - afloat, - adouble, - achar, - abpchar, - avarchar, - atext, - ctime(&aabstime)); - - - doquery("CLOSE c_testfetch"); - doquery("COMMIT WORK"); - printf("--- %-d rows inserted so far\n", row); - - row++; - } - - disconnectdb(); - return 0; -} |