diff options
Diffstat (limited to 'db_demo')
-rw-r--r-- | db_demo/Debug/BuildLog.htm | bin | 4516 -> 0 bytes | |||
-rw-r--r-- | db_demo/Debug/db_demo.exe.embed.manifest | 1 | ||||
-rw-r--r-- | db_demo/Debug/db_demo.exe.embed.manifest.res | bin | 2112 -> 0 bytes | |||
-rw-r--r-- | db_demo/Debug/getopt.obj | bin | 1359 -> 0 bytes | |||
-rw-r--r-- | db_demo/Debug/reset.obj | bin | 8898 -> 0 bytes | |||
-rw-r--r-- | db_demo/Debug/vc80.idb | bin | 35840 -> 0 bytes | |||
-rw-r--r-- | db_demo/Debug/vc80.pdb | bin | 61440 -> 0 bytes | |||
-rw-r--r-- | db_demo/db_demo.ncb | bin | 232448 -> 494592 bytes | |||
-rw-r--r-- | db_demo/db_demo.suo | bin | 12288 -> 13824 bytes | |||
-rw-r--r-- | db_demo/db_demo.vcproj | 15 | ||||
-rw-r--r-- | db_demo/getopt.c | 169 | ||||
-rw-r--r-- | db_demo/include/libpq-fe.h | 510 | ||||
-rw-r--r-- | db_demo/include/postgres_ext.h | 69 | ||||
-rw-r--r-- | db_demo/lib/libpq.lib | bin | 0 -> 305128 bytes | |||
-rw-r--r-- | db_demo/lib/libpqdll.lib | bin | 0 -> 24858 bytes | |||
-rw-r--r-- | db_demo/libeay32.dll | bin | 0 -> 1064960 bytes | |||
-rw-r--r-- | db_demo/libiconv-2.dll | bin | 0 -> 916849 bytes | |||
-rw-r--r-- | db_demo/libintl-2.dll | bin | 0 -> 32256 bytes | |||
-rw-r--r-- | db_demo/main.c | 49 | ||||
-rw-r--r-- | db_demo/main.h | 9 | ||||
-rw-r--r-- | db_demo/ssleay32.dll | bin | 0 -> 200704 bytes |
21 files changed, 647 insertions, 175 deletions
diff --git a/db_demo/Debug/BuildLog.htm b/db_demo/Debug/BuildLog.htm Binary files differdeleted file mode 100644 index e0d4f6f..0000000 --- a/db_demo/Debug/BuildLog.htm +++ /dev/null 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 Binary files differdeleted file mode 100644 index 3a6eb75..0000000 --- a/db_demo/Debug/db_demo.exe.embed.manifest.res +++ /dev/null diff --git a/db_demo/Debug/getopt.obj b/db_demo/Debug/getopt.obj Binary files differdeleted file mode 100644 index 9467e62..0000000 --- a/db_demo/Debug/getopt.obj +++ /dev/null diff --git a/db_demo/Debug/reset.obj b/db_demo/Debug/reset.obj Binary files differdeleted file mode 100644 index df39ac1..0000000 --- a/db_demo/Debug/reset.obj +++ /dev/null diff --git a/db_demo/Debug/vc80.idb b/db_demo/Debug/vc80.idb Binary files differdeleted file mode 100644 index 084f6b5..0000000 --- a/db_demo/Debug/vc80.idb +++ /dev/null diff --git a/db_demo/Debug/vc80.pdb b/db_demo/Debug/vc80.pdb Binary files differdeleted file mode 100644 index c105627..0000000 --- a/db_demo/Debug/vc80.pdb +++ /dev/null diff --git a/db_demo/db_demo.ncb b/db_demo/db_demo.ncb Binary files differindex f165350..f24034d 100644 --- a/db_demo/db_demo.ncb +++ b/db_demo/db_demo.ncb diff --git a/db_demo/db_demo.suo b/db_demo/db_demo.suo Binary files differindex 1405612..852290c 100644 --- a/db_demo/db_demo.suo +++ b/db_demo/db_demo.suo 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 Binary files differnew file mode 100644 index 0000000..b3f6cfd --- /dev/null +++ b/db_demo/lib/libpq.lib diff --git a/db_demo/lib/libpqdll.lib b/db_demo/lib/libpqdll.lib Binary files differnew file mode 100644 index 0000000..5413b8b --- /dev/null +++ b/db_demo/lib/libpqdll.lib diff --git a/db_demo/libeay32.dll b/db_demo/libeay32.dll Binary files differnew file mode 100644 index 0000000..e9039dc --- /dev/null +++ b/db_demo/libeay32.dll diff --git a/db_demo/libiconv-2.dll b/db_demo/libiconv-2.dll Binary files differnew file mode 100644 index 0000000..02b9b0a --- /dev/null +++ b/db_demo/libiconv-2.dll diff --git a/db_demo/libintl-2.dll b/db_demo/libintl-2.dll Binary files differnew file mode 100644 index 0000000..fae4dfa --- /dev/null +++ b/db_demo/libintl-2.dll 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 Binary files differnew file mode 100644 index 0000000..246ff11 --- /dev/null +++ b/db_demo/ssleay32.dll |