aboutsummaryrefslogtreecommitdiff
path: root/src/interfaces/libpgeasy/examples
diff options
context:
space:
mode:
Diffstat (limited to 'src/interfaces/libpgeasy/examples')
-rw-r--r--src/interfaces/libpgeasy/examples/Makefile22
-rw-r--r--src/interfaces/libpgeasy/examples/pginsert.c98
-rw-r--r--src/interfaces/libpgeasy/examples/pgmultiresult.c68
-rw-r--r--src/interfaces/libpgeasy/examples/pgnulltest.c135
-rw-r--r--src/interfaces/libpgeasy/examples/pgwordcount.c73
5 files changed, 0 insertions, 396 deletions
diff --git a/src/interfaces/libpgeasy/examples/Makefile b/src/interfaces/libpgeasy/examples/Makefile
deleted file mode 100644
index af8dc0c32a7..00000000000
--- a/src/interfaces/libpgeasy/examples/Makefile
+++ /dev/null
@@ -1,22 +0,0 @@
-#-------------------------------------------------------------------------
-#
-# Makefile
-# Makefile for pgeasy examples
-#
-# IDENTIFICATION
-# $Header: /cvsroot/pgsql/src/interfaces/libpgeasy/examples/Attic/Makefile,v 1.3 2002/03/04 18:50:21 momjian Exp $
-#
-#-------------------------------------------------------------------------
-
-CFLAGS=-I/usr/local/pgsql/include
-TARGET = pginsert pgwordcount pgnulltest pgmultiresult
-LDFLAGS = -L/usr/local/pgsql/lib -lpgeasy
-
-all : $(TARGET)
-
-%: %.c
- gcc -o $@ $(CFLAGS) $@.c $(PGEASY) $(LDFLAGS)
-
-clean:
- rm -f *.o $(TARGET) log core
-
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;
-}
diff --git a/src/interfaces/libpgeasy/examples/pgmultiresult.c b/src/interfaces/libpgeasy/examples/pgmultiresult.c
deleted file mode 100644
index f5cf2112dd0..00000000000
--- a/src/interfaces/libpgeasy/examples/pgmultiresult.c
+++ /dev/null
@@ -1,68 +0,0 @@
-/*
- * pgmultiresult.c
- *
- */
-
-#include <stdio.h>
-#include "libpq-fe.h"
-#include "../halt.h"
-#include "libpgeasy.h"
-
-int
-main(int argc, char **argv)
-{
- char query[4000];
- char val[4000];
- char optstr[256];
- PGresult *res1, *res2;
- int res1_done = 0, res2_done = 0;
-
- if (argc != 2)
- halt("Usage: %s database\n", argv[0]);
-
- snprintf(optstr, 256, "dbname=%s", argv[1]);
- connectdb(optstr);
-
- doquery("\
- SELECT lanname \
- FROM pg_language \
- ORDER BY lanname \
- ");
- res1 = get_result();
-
- doquery("\
- SELECT amname \
- FROM pg_am \
- ORDER BY amname \
- ");
- res2 = get_result();
-
- while (!res1_done && !res2_done)
- {
-
- set_result(res1);
-
- if (!res1_done)
- {
- if (fetch(val) != END_OF_TUPLES)
- puts(val);
- else res1_done = 1;
- }
-
- res1 = get_result();
-
- set_result(res2);
-
- if (!res2_done)
- {
- if (fetch(val) != END_OF_TUPLES)
- puts(val);
- else res2_done = 1;
- }
-
- res2 = get_result();
- }
-
- disconnectdb();
- return 0;
-}
diff --git a/src/interfaces/libpgeasy/examples/pgnulltest.c b/src/interfaces/libpgeasy/examples/pgnulltest.c
deleted file mode 100644
index 0f3ba30336e..00000000000
--- a/src/interfaces/libpgeasy/examples/pgnulltest.c
+++ /dev/null
@@ -1,135 +0,0 @@
-/*
- * pgnulltest.c
- *
-*/
-
-#define TEST_NON_NULLS
-
-#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;
- int aint_null,
- afloat_null,
- adouble_null,
- achar_null,
- abpchar_null,
- avarchar_null,
- atext_null,
- aabstime_null;
- 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) \
- ");
-
-#ifdef TEST_NON_NULLS
- sprintf(query, "INSERT INTO testfetch VALUES ( \
- 0, \
- 0, \
- 0, \
- '', \
- '', \
- '', \
- '', \
- CURRENT_TIMESTAMP::abstime);");
-#else
- sprintf(query, "INSERT INTO testfetch VALUES ( \
- NULL, \
- NULL, \
- NULL, \
- NULL, \
- NULL, \
- NULL, \
- NULL, \
- NULL);");
-#endif
- doquery(query);
-
- doquery("BEGIN WORK");
- doquery("DECLARE c_testfetch BINARY CURSOR FOR \
- SELECT * FROM testfetch");
-
- doquery("FETCH ALL IN c_testfetch");
-
- if (fetchwithnulls(
- &aint,
- &aint_null,
- &afloat,
- &afloat_null,
- &adouble,
- &adouble_null,
- achar,
- &achar_null,
- abpchar,
- &abpchar_null,
- avarchar,
- &avarchar_null,
- atext,
- &atext_null,
- &aabstime,
- &aabstime_null) != END_OF_TUPLES)
- printf("int %d\nfloat %f\ndouble %f\nchar %s\n\
-bpchar %s\nvarchar %s\ntext %s\nabstime %s\n",
- aint,
- afloat,
- adouble,
- achar,
- abpchar,
- avarchar,
- atext,
- ctime(&aabstime));
-
- printf("NULL:\nint %d\nfloat %d\ndouble %d\nchar %d\n\
-bpchar %d\nvarchar %d\ntext %d\nabstime %d\n",
- aint_null,
- afloat_null,
- adouble_null,
- achar_null,
- abpchar_null,
- avarchar_null,
- atext_null,
- aabstime_null);
-
- doquery("CLOSE c_testfetch");
- doquery("COMMIT WORK");
- printf("--- %-d rows inserted so far\n", row);
-
- row++;
-
- disconnectdb();
- return 0;
-}
diff --git a/src/interfaces/libpgeasy/examples/pgwordcount.c b/src/interfaces/libpgeasy/examples/pgwordcount.c
deleted file mode 100644
index 57f888601b5..00000000000
--- a/src/interfaces/libpgeasy/examples/pgwordcount.c
+++ /dev/null
@@ -1,73 +0,0 @@
-/*
- * wordcount.c
- *
-*/
-
-#include <stdio.h>
-#include "libpq-fe.h"
-#include "../halt.h"
-#include "libpgeasy.h"
-
-int
-main(int argc, char **argv)
-{
- char query[4000];
- int row = 0;
- int count;
- char line[4000];
- 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 words");
- on_error_stop();
-
- doquery("\
- CREATE TABLE words( \
- matches int4, \
- word text ) \
- ");
- doquery("\
- CREATE INDEX i_words_1 ON words USING btree ( \
- word text_ops )\
- ");
-
- while (1)
- {
- if (scanf("%s", line) != 1)
- break;
- doquery("BEGIN WORK");
- sprintf(query, "\
- DECLARE c_words BINARY CURSOR FOR \
- SELECT count(*) \
- FROM words \
- WHERE word = '%s'", line);
- doquery(query);
- doquery("FETCH ALL IN c_words");
-
- while (fetch(&count) == END_OF_TUPLES)
- count = 0;
- doquery("CLOSE c_words");
- doquery("COMMIT WORK");
-
- if (count == 0)
- sprintf(query, "\
- INSERT INTO words \
- VALUES (1, '%s')", line);
- else
- sprintf(query, "\
- UPDATE words \
- SET matches = matches + 1 \
- WHERE word = '%s'", line);
- doquery(query);
- row++;
- }
-
- disconnectdb();
- return 0;
-}
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 08:48:46 +0000