summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorWilrik de Loose <wilrik@wilrik.nl>2008-05-07 10:06:20 (GMT)
committerWilrik de Loose <wilrik@wilrik.nl>2008-05-07 10:06:20 (GMT)
commitf88154ffd368af3a63ddbed5516f51097721a248 (patch)
tree5ad50e33347603bfa6d00f138a0d2c5ef143d833
parent58d04319139a590473e556ad9017e18127bfc70c (diff)
download2iv55-f88154ffd368af3a63ddbed5516f51097721a248.zip
2iv55-f88154ffd368af3a63ddbed5516f51097721a248.tar.gz
2iv55-f88154ffd368af3a63ddbed5516f51097721a248.tar.bz2
Eerste werkende versie
-rw-r--r--db_demo/Debug/BuildLog.htmbin4516 -> 0 bytes
-rw-r--r--db_demo/Debug/db_demo.exe.embed.manifest1
-rw-r--r--db_demo/Debug/db_demo.exe.embed.manifest.resbin2112 -> 0 bytes
-rw-r--r--db_demo/Debug/getopt.objbin1359 -> 0 bytes
-rw-r--r--db_demo/Debug/reset.objbin8898 -> 0 bytes
-rw-r--r--db_demo/Debug/vc80.idbbin35840 -> 0 bytes
-rw-r--r--db_demo/Debug/vc80.pdbbin61440 -> 0 bytes
-rw-r--r--db_demo/db_demo.ncbbin232448 -> 494592 bytes
-rw-r--r--db_demo/db_demo.suobin12288 -> 13824 bytes
-rw-r--r--db_demo/db_demo.vcproj15
-rw-r--r--db_demo/getopt.c169
-rw-r--r--db_demo/include/libpq-fe.h510
-rw-r--r--db_demo/include/postgres_ext.h69
-rw-r--r--db_demo/lib/libpq.libbin0 -> 305128 bytes
-rw-r--r--db_demo/lib/libpqdll.libbin0 -> 24858 bytes
-rw-r--r--db_demo/libeay32.dllbin0 -> 1064960 bytes
-rw-r--r--db_demo/libiconv-2.dllbin0 -> 916849 bytes
-rw-r--r--db_demo/libintl-2.dllbin0 -> 32256 bytes
-rw-r--r--db_demo/main.c49
-rw-r--r--db_demo/main.h9
-rw-r--r--db_demo/ssleay32.dllbin0 -> 200704 bytes
21 files changed, 647 insertions, 175 deletions
diff --git a/db_demo/Debug/BuildLog.htm b/db_demo/Debug/BuildLog.htm
deleted file mode 100644
index e0d4f6f..0000000
--- a/db_demo/Debug/BuildLog.htm
+++ /dev/null
Binary files differ
diff --git a/db_demo/Debug/db_demo.exe.embed.manifest b/db_demo/Debug/db_demo.exe.embed.manifest
deleted file mode 100644
index d2d2076..0000000
--- a/db_demo/Debug/db_demo.exe.embed.manifest
+++ /dev/null
@@ -1 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" standalone="yes"?><assembly manifestVersion="1.0" xmlns="urn:schemas-microsoft-com:asm.v1"></assembly> \ No newline at end of file
diff --git a/db_demo/Debug/db_demo.exe.embed.manifest.res b/db_demo/Debug/db_demo.exe.embed.manifest.res
deleted file mode 100644
index 3a6eb75..0000000
--- a/db_demo/Debug/db_demo.exe.embed.manifest.res
+++ /dev/null
Binary files differ
diff --git a/db_demo/Debug/getopt.obj b/db_demo/Debug/getopt.obj
deleted file mode 100644
index 9467e62..0000000
--- a/db_demo/Debug/getopt.obj
+++ /dev/null
Binary files differ
diff --git a/db_demo/Debug/reset.obj b/db_demo/Debug/reset.obj
deleted file mode 100644
index df39ac1..0000000
--- a/db_demo/Debug/reset.obj
+++ /dev/null
Binary files differ
diff --git a/db_demo/Debug/vc80.idb b/db_demo/Debug/vc80.idb
deleted file mode 100644
index 084f6b5..0000000
--- a/db_demo/Debug/vc80.idb
+++ /dev/null
Binary files differ
diff --git a/db_demo/Debug/vc80.pdb b/db_demo/Debug/vc80.pdb
deleted file mode 100644
index c105627..0000000
--- a/db_demo/Debug/vc80.pdb
+++ /dev/null
Binary files differ
diff --git a/db_demo/db_demo.ncb b/db_demo/db_demo.ncb
index f165350..f24034d 100644
--- a/db_demo/db_demo.ncb
+++ b/db_demo/db_demo.ncb
Binary files differ
diff --git a/db_demo/db_demo.suo b/db_demo/db_demo.suo
index 1405612..852290c 100644
--- a/db_demo/db_demo.suo
+++ b/db_demo/db_demo.suo
Binary files differ
diff --git a/db_demo/db_demo.vcproj b/db_demo/db_demo.vcproj
index 8fae3cd..d4717c3 100644
--- a/db_demo/db_demo.vcproj
+++ b/db_demo/db_demo.vcproj
@@ -20,6 +20,9 @@
OutputDirectory="$(SolutionDir)$(ConfigurationName)"
IntermediateDirectory="$(ConfigurationName)"
ConfigurationType="1"
+ UseOfMFC="0"
+ UseOfATL="0"
+ ATLMinimizesCRunTimeLibraryUsage="false"
CharacterSet="1"
>
<Tool
@@ -40,10 +43,11 @@
<Tool
Name="VCCLCompilerTool"
Optimization="0"
- PreprocessorDefinitions="WIN32;_DEBUG;_CONSOLE"
+ AdditionalIncludeDirectories=".\include"
+ PreprocessorDefinitions="WIN32;_DEBUG;_CONSOLE;_CRT_SECURE_NO_DEPRECATE"
MinimalRebuild="true"
BasicRuntimeChecks="3"
- RuntimeLibrary="3"
+ RuntimeLibrary="1"
UsePrecompiledHeader="0"
WarningLevel="3"
Detect64BitPortabilityProblems="true"
@@ -60,8 +64,9 @@
/>
<Tool
Name="VCLinkerTool"
- AdditionalDependencies="libpq.dll"
+ AdditionalDependencies="libpqdll.lib"
LinkIncremental="2"
+ AdditionalLibraryDirectories=".\lib"
GenerateDebugInformation="true"
SubSystem="1"
TargetMachine="1"
@@ -176,7 +181,7 @@
UniqueIdentifier="{4FC737F1-C7A5-4376-A066-2A32D752A2FF}"
>
<File
- RelativePath=".\reset.c"
+ RelativePath=".\main.c"
>
</File>
</Filter>
@@ -186,7 +191,7 @@
UniqueIdentifier="{93995380-89BD-4b04-88EB-625FBE52EBFB}"
>
<File
- RelativePath=".\reset.h"
+ RelativePath=".\main.h"
>
</File>
</Filter>
diff --git a/db_demo/getopt.c b/db_demo/getopt.c
deleted file mode 100644
index 2c65f00..0000000
--- a/db_demo/getopt.c
+++ /dev/null
@@ -1,169 +0,0 @@
-
-
-/*
-* Disktest
-* Copyright (c) International Business Machines Corp., 2001
-*
-*
-* This program is free software; you can redistribute it and/or modify
-* it under the terms of the GNU General Public License as published by
-* the Free Software Foundation; either version 2 of the License, or
-* (at your option) any later version.
-*
-* This program is distributed in the hope that it will be useful,
-* but WITHOUT ANY WARRANTY; without even the implied warranty of
-* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-* GNU General Public License for more details.
-*
-* You should have received a copy of the GNU General Public License
-* along with this program; if not, write to the Free Software
-* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
-*
-* Please send e-mail to yardleyb@us.ibm.com if you have
-* questions or comments.
-*
-* Project Website: TBD
-*
-*
-* $Id: Getopt.c,v 1.4 2005/05/04 17:54:00 mridge Exp $
-* $Log: Getopt.c,v $
-* Revision 1.4 2005/05/04 17:54:00 mridge
-* Update to version 1.2.8
-*
-* Revision 1.4 2002/03/30 01:32:14 yardleyb
-* Major Changes:
-*
-* Added Dumping routines for
-* data miscompares,
-*
-* Updated performance output
-* based on command line. Gave
-* one decimal in MB/s output.
-*
-* Rewrote -pL IO routine to show
-* correct stats. Now show pass count
-* when using -C.
-*
-* Minor Changes:
-*
-* Code cleanup to remove the plethera
-* if #ifdef for windows/unix functional
-* differences.
-*
-* Revision 1.3 2002/02/21 21:32:19 yardleyb
-* Added more unix compatability
-* ifdef'd function out when
-* compiling for unix env. that
-* have getopt
-*
-* Revision 1.2 2002/02/04 20:35:38 yardleyb
-* Changed max. number of threads to 64k.
-* Check for max threads in parsing.
-* Fixed windows getopt to return correctly
-* when a bad option is given.
-* Update time output to be in the format:
-* YEAR/MONTH/DAY-HOUR:MIN:SEC
-* instead of epoch time.
-*
-* Revision 1.1 2001/12/04 18:57:36 yardleyb
-* This source add for windows compatability only.
-*
-*/
-
-#ifdef WINDOWS
-
-#include <stdio.h>
-#include <stddef.h>
-#include <ctype.h>
-#include <string.h>
-#include "getopt.h"
-
-/*
- *
- * FUNCTION: getopt()
- *
- * Get next command line option and parameter
- * source gathered from MS examples and modified
- * to conform with unix like getopt.
- *
- */
-
-/* Global Exportable */
-int optind;
-char *optarg;
-
-int getopt (int argc, char** argv, char* pszValidOpts) {
- char chOpt;
- char* psz = NULL;
- char* pszParam = NULL;
- static int iArg = 1;
-
- if (iArg < argc) {
- psz = &(argv[iArg][0]);
- if (*psz == '-' || *psz == '/') {
- /* we have an option specifier */
- chOpt = argv[iArg][1];
- if (isalnum(chOpt) || ispunct(chOpt)) {
- /* we have an option character */
- psz = strchr(pszValidOpts, chOpt);
- if (psz != NULL) {
- /* option is valid, we want to return chOpt */
- if (psz[1] == ':') {
- /* option can have a parameter */
- psz = &(argv[iArg][2]);
- if (*psz == '\0') {
- /* must look at next argv for param */
- if (iArg+1 < argc) {
- psz = &(argv[iArg+1][0]);
- if (*psz == '-' || *psz == '/') {
- /* next argv is a new option, so param
- * not given for current option
- */
- fprintf(stderr, "-%c option requires an argument.\n", chOpt);
- chOpt = '?';
- pszParam = NULL;
- } else {
- /* next argv is the param */
- iArg++;
- pszParam = psz;
- }
- } else {
- /* reached end of args looking for param */
- }
- } else {
- /* param is attached to option */
- pszParam = psz;
- }
- } else {
- /* option is alone, has no parameter */
- }
- } else {
- /* option specified is not in list of valid options */
- fprintf(stderr, "Invalid option -- %c\n", chOpt);
- chOpt = '?';
- pszParam = NULL;
- }
- } else {
- /* though option specifier was given, option character
- * is not alpha or was was not specified
- */
- chOpt = 0;
- pszParam = &(argv[iArg][0]);
- }
- } else {
- /* standalone arg given with no option specifier */
- chOpt = -1;
- pszParam = &(argv[iArg][0]);
- }
- } else {
- /* end of argument list */
- chOpt = -1;
- }
-
- optind = iArg++;
- optarg = pszParam;
- return (chOpt);
-}
-
-#endif /* defined WINDOWS */
-
diff --git a/db_demo/include/libpq-fe.h b/db_demo/include/libpq-fe.h
new file mode 100644
index 0000000..a675335
--- /dev/null
+++ b/db_demo/include/libpq-fe.h
@@ -0,0 +1,510 @@
+/*-------------------------------------------------------------------------
+ *
+ * libpq-fe.h
+ * This file contains definitions for structures and
+ * externs for functions used by frontend postgres applications.
+ *
+ * Portions Copyright (c) 1996-2005, PostgreSQL Global Development Group
+ * Portions Copyright (c) 1994, Regents of the University of California
+ *
+ * $PostgreSQL: pgsql/src/interfaces/libpq/libpq-fe.h,v 1.116.4.1 2006/05/21 20:20:05 tgl Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#ifndef LIBPQ_FE_H
+#define LIBPQ_FE_H
+
+#ifdef __cplusplus
+extern "C"
+{
+#endif
+
+#include <stdio.h>
+
+/*
+ * postgres_ext.h defines the backend's externally visible types,
+ * such as Oid.
+ */
+#include "postgres_ext.h"
+
+/* SSL type is needed here only to declare PQgetssl() */
+#ifdef USE_SSL
+#include <openssl/ssl.h>
+#endif
+
+/* Application-visible enum types */
+
+typedef enum
+{
+ /*
+ * Although it is okay to add to this list, values which become unused
+ * should never be removed, nor should constants be redefined - that
+ * would break compatibility with existing code.
+ */
+ CONNECTION_OK,
+ CONNECTION_BAD,
+ /* Non-blocking mode only below here */
+
+ /*
+ * The existence of these should never be relied upon - they should
+ * only be used for user feedback or similar purposes.
+ */
+ CONNECTION_STARTED, /* Waiting for connection to be made. */
+ CONNECTION_MADE, /* Connection OK; waiting to send. */
+ CONNECTION_AWAITING_RESPONSE, /* Waiting for a response from the
+ * postmaster. */
+ CONNECTION_AUTH_OK, /* Received authentication; waiting for
+ * backend startup. */
+ CONNECTION_SETENV, /* Negotiating environment. */
+ CONNECTION_SSL_STARTUP, /* Negotiating SSL. */
+ CONNECTION_NEEDED /* Internal state: connect() needed */
+} ConnStatusType;
+
+typedef enum
+{
+ PGRES_POLLING_FAILED = 0,
+ PGRES_POLLING_READING, /* These two indicate that one may */
+ PGRES_POLLING_WRITING, /* use select before polling again. */
+ PGRES_POLLING_OK,
+ PGRES_POLLING_ACTIVE /* unused; keep for awhile for backwards
+ * compatibility */
+} PostgresPollingStatusType;
+
+typedef enum
+{
+ PGRES_EMPTY_QUERY = 0, /* empty query string was executed */
+ PGRES_COMMAND_OK, /* a query command that doesn't return
+ * anything was executed properly by the
+ * backend */
+ PGRES_TUPLES_OK, /* a query command that returns tuples was
+ * executed properly by the backend,
+ * PGresult contains the result tuples */
+ PGRES_COPY_OUT, /* Copy Out data transfer in progress */
+ PGRES_COPY_IN, /* Copy In data transfer in progress */
+ PGRES_BAD_RESPONSE, /* an unexpected response was recv'd from
+ * the backend */
+ PGRES_NONFATAL_ERROR, /* notice or warning message */
+ PGRES_FATAL_ERROR /* query failed */
+} ExecStatusType;
+
+typedef enum
+{
+ PQTRANS_IDLE, /* connection idle */
+ PQTRANS_ACTIVE, /* command in progress */
+ PQTRANS_INTRANS, /* idle, within transaction block */
+ PQTRANS_INERROR, /* idle, within failed transaction */
+ PQTRANS_UNKNOWN /* cannot determine status */
+} PGTransactionStatusType;
+
+typedef enum
+{
+ PQERRORS_TERSE, /* single-line error messages */
+ PQERRORS_DEFAULT, /* recommended style */
+ PQERRORS_VERBOSE /* all the facts, ma'am */
+} PGVerbosity;
+
+/* PGconn encapsulates a connection to the backend.
+ * The contents of this struct are not supposed to be known to applications.
+ */
+typedef struct pg_conn PGconn;
+
+/* PGresult encapsulates the result of a query (or more precisely, of a single
+ * SQL command --- a query string given to PQsendQuery can contain multiple
+ * commands and thus return multiple PGresult objects).
+ * The contents of this struct are not supposed to be known to applications.
+ */
+typedef struct pg_result PGresult;
+
+/* PGcancel encapsulates the information needed to cancel a running
+ * query on an existing connection.
+ * The contents of this struct are not supposed to be known to applications.
+ */
+typedef struct pg_cancel PGcancel;
+
+/* PGnotify represents the occurrence of a NOTIFY message.
+ * Ideally this would be an opaque typedef, but it's so simple that it's
+ * unlikely to change.
+ * NOTE: in Postgres 6.4 and later, the be_pid is the notifying backend's,
+ * whereas in earlier versions it was always your own backend's PID.
+ */
+typedef struct pgNotify
+{
+ char *relname; /* notification condition name */
+ int be_pid; /* process ID of server process */
+ char *extra; /* notification parameter */
+ /* Fields below here are private to libpq; apps should not use 'em */
+ struct pgNotify *next; /* list link */
+} PGnotify;
+
+/* Function types for notice-handling callbacks */
+typedef void (*PQnoticeReceiver) (void *arg, const PGresult *res);
+typedef void (*PQnoticeProcessor) (void *arg, const char *message);
+
+/* Print options for PQprint() */
+typedef char pqbool;
+
+typedef struct _PQprintOpt
+{
+ pqbool header; /* print output field headings and row
+ * count */
+ pqbool align; /* fill align the fields */
+ pqbool standard; /* old brain dead format */
+ pqbool html3; /* output html tables */
+ pqbool expanded; /* expand tables */
+ pqbool pager; /* use pager for output if needed */
+ char *fieldSep; /* field separator */
+ char *tableOpt; /* insert to HTML <table ...> */
+ char *caption; /* HTML <caption> */
+ char **fieldName; /* null terminated array of repalcement
+ * field names */
+} PQprintOpt;
+
+/* ----------------
+ * Structure for the conninfo parameter definitions returned by PQconndefaults
+ *
+ * All fields except "val" point at static strings which must not be altered.
+ * "val" is either NULL or a malloc'd current-value string. PQconninfoFree()
+ * will release both the val strings and the PQconninfoOption array itself.
+ * ----------------
+ */
+typedef struct _PQconninfoOption
+{
+ char *keyword; /* The keyword of the option */
+ char *envvar; /* Fallback environment variable name */
+ char *compiled; /* Fallback compiled in default value */
+ char *val; /* Option's current value, or NULL */
+ char *label; /* Label for field in connect dialog */
+ char *dispchar; /* Character to display for this field in
+ * a connect dialog. Values are: ""
+ * Display entered value as is "*"
+ * Password field - hide value "D" Debug
+ * option - don't show by default */
+ int dispsize; /* Field size in characters for dialog */
+} PQconninfoOption;
+
+/* ----------------
+ * PQArgBlock -- structure for PQfn() arguments
+ * ----------------
+ */
+typedef struct
+{
+ int len;
+ int isint;
+ union
+ {
+ int *ptr; /* can't use void (dec compiler barfs) */
+ int integer;
+ } u;
+} PQArgBlock;
+
+/* ----------------
+ * Exported functions of libpq
+ * ----------------
+ */
+
+/* === in fe-connect.c === */
+
+/* make a new client connection to the backend */
+/* Asynchronous (non-blocking) */
+extern PGconn *PQconnectStart(const char *conninfo);
+extern PostgresPollingStatusType PQconnectPoll(PGconn *conn);
+
+/* Synchronous (blocking) */
+extern PGconn *PQconnectdb(const char *conninfo);
+extern PGconn *PQsetdbLogin(const char *pghost, const char *pgport,
+ const char *pgoptions, const char *pgtty,
+ const char *dbName,
+ const char *login, const char *pwd);
+
+#define PQsetdb(M_PGHOST,M_PGPORT,M_PGOPT,M_PGTTY,M_DBNAME) \
+ PQsetdbLogin(M_PGHOST, M_PGPORT, M_PGOPT, M_PGTTY, M_DBNAME, NULL, NULL)
+
+/* close the current connection and free the PGconn data structure */
+extern void PQfinish(PGconn *conn);
+
+/* get info about connection options known to PQconnectdb */
+extern PQconninfoOption *PQconndefaults(void);
+
+/* free the data structure returned by PQconndefaults() */
+extern void PQconninfoFree(PQconninfoOption *connOptions);
+
+/*
+ * close the current connection and restablish a new one with the same
+ * parameters
+ */
+/* Asynchronous (non-blocking) */
+extern int PQresetStart(PGconn *conn);
+extern PostgresPollingStatusType PQresetPoll(PGconn *conn);
+
+/* Synchronous (blocking) */
+extern void PQreset(PGconn *conn);
+
+/* request a cancel structure */
+extern PGcancel *PQgetCancel(PGconn *conn);
+
+/* free a cancel structure */
+extern void PQfreeCancel(PGcancel *cancel);
+
+/* issue a cancel request */
+extern int PQcancel(PGcancel *cancel, char *errbuf, int errbufsize);
+
+/* backwards compatible version of PQcancel; not thread-safe */
+extern int PQrequestCancel(PGconn *conn);
+
+/* Accessor functions for PGconn objects */
+extern char *PQdb(const PGconn *conn);
+extern char *PQuser(const PGconn *conn);
+extern char *PQpass(const PGconn *conn);
+extern char *PQhost(const PGconn *conn);
+extern char *PQport(const PGconn *conn);
+extern char *PQtty(const PGconn *conn);
+extern char *PQoptions(const PGconn *conn);
+extern ConnStatusType PQstatus(const PGconn *conn);
+extern PGTransactionStatusType PQtransactionStatus(const PGconn *conn);
+extern const char *PQparameterStatus(const PGconn *conn,
+ const char *paramName);
+extern int PQprotocolVersion(const PGconn *conn);
+extern int PQserverVersion(const PGconn *conn);
+extern char *PQerrorMessage(const PGconn *conn);
+extern int PQsocket(const PGconn *conn);
+extern int PQbackendPID(const PGconn *conn);
+extern int PQclientEncoding(const PGconn *conn);
+extern int PQsetClientEncoding(PGconn *conn, const char *encoding);
+
+#ifdef USE_SSL
+/* Get the SSL structure associated with a connection */
+extern SSL *PQgetssl(PGconn *conn);
+#else
+extern void *PQgetssl(PGconn *conn);
+#endif
+
+/* Tell libpq whether it needs to initialize OpenSSL */
+extern void PQinitSSL(int do_init);
+
+/* Set verbosity for PQerrorMessage and PQresultErrorMessage */
+extern PGVerbosity PQsetErrorVerbosity(PGconn *conn, PGVerbosity verbosity);
+
+/* Enable/disable tracing */
+extern void PQtrace(PGconn *conn, FILE *debug_port);
+extern void PQuntrace(PGconn *conn);
+
+/* Override default notice handling routines */
+extern PQnoticeReceiver PQsetNoticeReceiver(PGconn *conn,
+ PQnoticeReceiver proc,
+ void *arg);
+extern PQnoticeProcessor PQsetNoticeProcessor(PGconn *conn,
+ PQnoticeProcessor proc,
+ void *arg);
+
+/*
+ * Used to set callback that prevents concurrent access to
+ * non-thread safe functions that libpq needs.
+ * The default implementation uses a libpq internal mutex.
+ * Only required for multithreaded apps that use kerberos
+ * both within their app and for postgresql connections.
+ */
+typedef void (*pgthreadlock_t) (int acquire);
+
+extern pgthreadlock_t PQregisterThreadLock(pgthreadlock_t newhandler);
+
+/* === in fe-exec.c === */
+
+/* Simple synchronous query */
+extern PGresult *PQexec(PGconn *conn, const char *query);
+extern PGresult *PQexecParams(PGconn *conn,
+ const char *command,
+ int nParams,
+ const Oid *paramTypes,
+ const char *const * paramValues,
+ const int *paramLengths,
+ const int *paramFormats,
+ int resultFormat);
+extern PGresult *PQprepare(PGconn *conn, const char *stmtName,
+ const char *query, int nParams,
+ const Oid *paramTypes);
+extern PGresult *PQexecPrepared(PGconn *conn,
+ const char *stmtName,
+ int nParams,
+ const char *const * paramValues,
+ const int *paramLengths,
+ const int *paramFormats,
+ int resultFormat);
+
+/* Interface for multiple-result or asynchronous queries */
+extern int PQsendQuery(PGconn *conn, const char *query);
+extern int PQsendQueryParams(PGconn *conn,
+ const char *command,
+ int nParams,
+ const Oid *paramTypes,
+ const char *const * paramValues,
+ const int *paramLengths,
+ const int *paramFormats,
+ int resultFormat);
+extern int PQsendPrepare(PGconn *conn, const char *stmtName,
+ const char *query, int nParams,
+ const Oid *paramTypes);
+extern int PQsendQueryPrepared(PGconn *conn,
+ const char *stmtName,
+ int nParams,
+ const char *const * paramValues,
+ const int *paramLengths,
+ const int *paramFormats,
+ int resultFormat);
+extern PGresult *PQgetResult(PGconn *conn);
+
+/* Routines for managing an asynchronous query */
+extern int PQisBusy(PGconn *conn);
+extern int PQconsumeInput(PGconn *conn);
+
+/* LISTEN/NOTIFY support */
+extern PGnotify *PQnotifies(PGconn *conn);
+
+/* Routines for copy in/out */
+extern int PQputCopyData(PGconn *conn, const char *buffer, int nbytes);
+extern int PQputCopyEnd(PGconn *conn, const char *errormsg);
+extern int PQgetCopyData(PGconn *conn, char **buffer, int async);
+
+/* Deprecated routines for copy in/out */
+extern int PQgetline(PGconn *conn, char *string, int length);
+extern int PQputline(PGconn *conn, const char *string);
+extern int PQgetlineAsync(PGconn *conn, char *buffer, int bufsize);
+extern int PQputnbytes(PGconn *conn, const char *buffer, int nbytes);
+extern int PQendcopy(PGconn *conn);
+
+/* Set blocking/nonblocking connection to the backend */
+extern int PQsetnonblocking(PGconn *conn, int arg);
+extern int PQisnonblocking(const PGconn *conn);
+
+/* Force the write buffer to be written (or at least try) */
+extern int PQflush(PGconn *conn);
+
+/*
+ * "Fast path" interface --- not really recommended for application
+ * use
+ */
+extern PGresult *PQfn(PGconn *conn,
+ int fnid,
+ int *result_buf,
+ int *result_len,
+ int result_is_int,
+ const PQArgBlock *args,
+ int nargs);
+
+/* Accessor functions for PGresult objects */
+extern ExecStatusType PQresultStatus(const PGresult *res);
+extern char *PQresStatus(ExecStatusType status);
+extern char *PQresultErrorMessage(const PGresult *res);
+extern char *PQresultErrorField(const PGresult *res, int fieldcode);
+extern int PQntuples(const PGresult *res);
+extern int PQnfields(const PGresult *res);
+extern int PQbinaryTuples(const PGresult *res);
+extern char *PQfname(const PGresult *res, int field_num);
+extern int PQfnumber(const PGresult *res, const char *field_name);
+extern Oid PQftable(const PGresult *res, int field_num);
+extern int PQftablecol(const PGresult *res, int field_num);
+extern int PQfformat(const PGresult *res, int field_num);
+extern Oid PQftype(const PGresult *res, int field_num);
+extern int PQfsize(const PGresult *res, int field_num);
+extern int PQfmod(const PGresult *res, int field_num);
+extern char *PQcmdStatus(PGresult *res);
+extern char *PQoidStatus(const PGresult *res); /* old and ugly */
+extern Oid PQoidValue(const PGresult *res); /* new and improved */
+extern char *PQcmdTuples(PGresult *res);
+extern char *PQgetvalue(const PGresult *res, int tup_num, int field_num);
+extern int PQgetlength(const PGresult *res, int tup_num, int field_num);
+extern int PQgetisnull(const PGresult *res, int tup_num, int field_num);
+
+/* Delete a PGresult */
+extern void PQclear(PGresult *res);
+
+/* For freeing other alloc'd results, such as PGnotify structs */
+extern void PQfreemem(void *ptr);
+
+/* Exists for backward compatibility. bjm 2003-03-24 */
+#define PQfreeNotify(ptr) PQfreemem(ptr)
+
+/* Define the string so all uses are consistent. */
+#define PQnoPasswordSupplied "fe_sendauth: no password supplied\n"
+
+/*
+ * Make an empty PGresult with given status (some apps find this
+ * useful). If conn is not NULL and status indicates an error, the
+ * conn's errorMessage is copied.
+ */
+extern PGresult *PQmakeEmptyPGresult(PGconn *conn, ExecStatusType status);
+
+
+/* Quoting strings before inclusion in queries. */
+extern size_t PQescapeStringConn(PGconn *conn,
+ char *to, const char *from, size_t length,
+ int *error);
+extern unsigned char *PQescapeByteaConn(PGconn *conn,
+ const unsigned char *from, size_t from_length,
+ size_t *to_length);
+extern unsigned char *PQunescapeBytea(const unsigned char *strtext,
+ size_t *retbuflen);
+/* These forms are deprecated! */
+extern size_t PQescapeString(char *to, const char *from, size_t length);
+extern unsigned char *PQescapeBytea(const unsigned char *from, size_t from_length,
+ size_t *to_length);
+
+
+
+/* === in fe-print.c === */
+
+extern void
+PQprint(FILE *fout, /* output stream */
+ const PGresult *res,
+ const PQprintOpt *ps); /* option structure */
+
+/*
+ * really old printing routines
+ */
+extern void
+PQdisplayTuples(const PGresult *res,
+ FILE *fp, /* where to send the output */
+ int fillAlign, /* pad the fields with spaces */
+ const char *fieldSep, /* field separator */
+ int printHeader, /* display headers? */
+ int quiet);
+
+extern void
+PQprintTuples(const PGresult *res,
+ FILE *fout, /* output stream */
+ int printAttName, /* print attribute names */
+ int terseOutput, /* delimiter bars */
+ int width); /* width of column, if 0, use variable
+ * width */
+
+
+/* === in fe-lobj.c === */
+
+/* Large-object access routines */
+extern int lo_open(PGconn *conn, Oid lobjId, int mode);
+extern int lo_close(PGconn *conn, int fd);
+extern int lo_read(PGconn *conn, int fd, char *buf, size_t len);
+extern int lo_write(PGconn *conn, int fd, char *buf, size_t len);
+extern int lo_lseek(PGconn *conn, int fd, int offset, int whence);
+extern Oid lo_creat(PGconn *conn, int mode);
+extern int lo_tell(PGconn *conn, int fd);
+extern int lo_unlink(PGconn *conn, Oid lobjId);
+extern Oid lo_import(PGconn *conn, const char *filename);
+extern int lo_export(PGconn *conn, Oid lobjId, const char *filename);
+
+/* === in fe-misc.c === */
+
+/* Determine length of multibyte encoded char at *s */
+extern int PQmblen(const unsigned char *s, int encoding);
+
+/* Determine display length of multibyte encoded char at *s */
+extern int PQdsplen(const unsigned char *s, int encoding);
+
+/* Get encoding id from environment variable PGCLIENTENCODING */
+extern int PQenv2encoding(void);
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* LIBPQ_FE_H */
diff --git a/db_demo/include/postgres_ext.h b/db_demo/include/postgres_ext.h
new file mode 100644
index 0000000..efffad2
--- /dev/null
+++ b/db_demo/include/postgres_ext.h
@@ -0,0 +1,69 @@
+/*-------------------------------------------------------------------------
+ *
+ * postgres_ext.h
+ *
+ * This file contains declarations of things that are visible everywhere
+ * in PostgreSQL *and* are visible to clients of frontend interface libraries.
+ * For example, the Oid type is part of the API of libpq and other libraries.
+ *
+ * Declarations which are specific to a particular interface should
+ * go in the header file for that interface (such as libpq-fe.h). This
+ * file is only for fundamental Postgres declarations.
+ *
+ * User-written C functions don't count as "external to Postgres."
+ * Those function much as local modifications to the backend itself, and
+ * use header files that are otherwise internal to Postgres to interface
+ * with the backend.
+ *
+ * $PostgreSQL: pgsql/src/include/postgres_ext.h,v 1.16 2004/08/29 05:06:55 momjian Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#ifndef POSTGRES_EXT_H
+#define POSTGRES_EXT_H
+
+/*
+ * Object ID is a fundamental type in Postgres.
+ */
+typedef unsigned int Oid;
+
+#ifdef __cplusplus
+#define InvalidOid (Oid(0))
+#else
+#define InvalidOid ((Oid) 0)
+#endif
+
+#define OID_MAX UINT_MAX
+/* you will need to include <limits.h> to use the above #define */
+
+
+/*
+ * NAMEDATALEN is the max length for system identifiers (e.g. table names,
+ * attribute names, function names, etc). It must be a multiple of
+ * sizeof(int) (typically 4).
+ *
+ * NOTE that databases with different NAMEDATALEN's cannot interoperate!
+ */
+#define NAMEDATALEN 64
+
+
+/*
+ * Identifiers of error message fields. Kept here to keep common
+ * between frontend and backend, and also to export them to libpq
+ * applications.
+ */
+#define PG_DIAG_SEVERITY 'S'
+#define PG_DIAG_SQLSTATE 'C'
+#define PG_DIAG_MESSAGE_PRIMARY 'M'
+#define PG_DIAG_MESSAGE_DETAIL 'D'
+#define PG_DIAG_MESSAGE_HINT 'H'
+#define PG_DIAG_STATEMENT_POSITION 'P'
+#define PG_DIAG_INTERNAL_POSITION 'p'
+#define PG_DIAG_INTERNAL_QUERY 'q'
+#define PG_DIAG_CONTEXT 'W'
+#define PG_DIAG_SOURCE_FILE 'F'
+#define PG_DIAG_SOURCE_LINE 'L'
+#define PG_DIAG_SOURCE_FUNCTION 'R'
+
+#endif
diff --git a/db_demo/lib/libpq.lib b/db_demo/lib/libpq.lib
new file mode 100644
index 0000000..b3f6cfd
--- /dev/null
+++ b/db_demo/lib/libpq.lib
Binary files differ
diff --git a/db_demo/lib/libpqdll.lib b/db_demo/lib/libpqdll.lib
new file mode 100644
index 0000000..5413b8b
--- /dev/null
+++ b/db_demo/lib/libpqdll.lib
Binary files differ
diff --git a/db_demo/libeay32.dll b/db_demo/libeay32.dll
new file mode 100644
index 0000000..e9039dc
--- /dev/null
+++ b/db_demo/libeay32.dll
Binary files differ
diff --git a/db_demo/libiconv-2.dll b/db_demo/libiconv-2.dll
new file mode 100644
index 0000000..02b9b0a
--- /dev/null
+++ b/db_demo/libiconv-2.dll
Binary files differ
diff --git a/db_demo/libintl-2.dll b/db_demo/libintl-2.dll
new file mode 100644
index 0000000..fae4dfa
--- /dev/null
+++ b/db_demo/libintl-2.dll
Binary files differ
diff --git a/db_demo/main.c b/db_demo/main.c
new file mode 100644
index 0000000..c28f273
--- /dev/null
+++ b/db_demo/main.c
@@ -0,0 +1,49 @@
+#include <stdio.h>
+#include <time.h>
+#include <libpq-fe.h>
+
+#include "main.h"
+
+int main(int argc, char *argv[]) {
+ PGconn *conn;
+ char SQL_query[512];
+ PGresult *res;
+ int ntuples, nfields;
+ int i, j;
+
+ conn = PQsetdbLogin(PGHOST, PGPORT, PGOPTIONS, PGTTY, DBNAME, LOGIN, PWD);
+
+
+ if(CONNECTION_BAD == PQstatus(conn))
+ {
+ fprintf(stderr, "Connection to database '%s' failed.\n %s", DBNAME, PQerrorMessage(conn));
+ PQfinish(conn);
+ return 1;
+ }
+
+ sprintf(SQL_query, "SELECT * FROM testicle");
+ res = PQexec(conn, SQL_query);
+
+ if(res == NULL || PQresultStatus(res) != PGRES_TUPLES_OK)
+ {
+ printf("Unable to execute query: %s\n %s\n", SQL_query, PQerrorMessage(conn));
+ }
+ else
+ {
+ ntuples = PQntuples(res);
+ nfields = PQnfields(res);
+
+ for (i = 0; i < ntuples; i++)
+ {
+ for (j = 0; j < nfields; j++)
+ {
+ printf("Query result: %s - %s\n", PQfname(res, j), PQgetvalue(res, i, j));
+ }
+ }
+ }
+
+ PQclear(res);
+ PQfinish(conn);
+
+ return 0;
+}
diff --git a/db_demo/main.h b/db_demo/main.h
new file mode 100644
index 0000000..1064d61
--- /dev/null
+++ b/db_demo/main.h
@@ -0,0 +1,9 @@
+#define VERSION 0.0.1
+
+#define PGHOST "matchblox.schinagl.nl"
+#define PGPORT "5432"
+#define PGOPTIONS "\0"
+#define PGTTY "\0"
+#define DBNAME "2iv55"
+#define LOGIN "2iv55"
+#define PWD "uhtfiwwp"
diff --git a/db_demo/ssleay32.dll b/db_demo/ssleay32.dll
new file mode 100644
index 0000000..246ff11
--- /dev/null
+++ b/db_demo/ssleay32.dll
Binary files differ