1
//////////////////////////////////////////////////////////////////////////
3
// pgAdmin III - PostgreSQL Tools
4
// RCS-ID: $Id: pgConn.h,v 1.27 2004/10/13 19:09:13 andreas Exp $
5
// Copyright (C) 2002 - 2004, The pgAdmin Development Team
6
// This software is released under the Artistic Licence
8
// pgConn.h - PostgreSQL Connection class
10
//////////////////////////////////////////////////////////////////////////
29
PGCONN_OK = CONNECTION_OK,
30
PGCONN_BAD = CONNECTION_BAD,
33
PGCONN_ABORTED, // connect user aborted
34
PGCONN_BROKEN // tcp/pipe broken
39
PGCONN_EMPTY_QUERY = PGRES_EMPTY_QUERY,
40
PGCONN_COMMAND_OK = PGRES_COMMAND_OK,
41
PGCONN_TUPLES_OK = PGRES_TUPLES_OK,
42
PGCONN_COPY_OUT = PGRES_COPY_OUT,
43
PGCONN_COPY_IN = PGRES_COPY_IN,
44
PGCONN_BAD_RESPONSE = PGRES_BAD_RESPONSE,
45
PGCONN_NONFATAL_ERROR = PGRES_NONFATAL_ERROR,
46
PGCONN_FATAL_ERROR = PGRES_FATAL_ERROR
53
pgConn(const wxString& server = wxT(""), const wxString& database = wxT(""), const wxString& username = wxT(""), const wxString& password = wxT(""), int port = 5432, int sslmode=0, OID oid=0);
57
bool HasPrivilege(const wxString &objTyp, const wxString &objName, const wxString &priv);
58
bool HasFeature(int feature=0);
59
bool ExecuteVoid(const wxString& sql);
60
wxString ExecuteScalar(const wxString& sql);
61
pgSet *ExecuteSet(const wxString& sql);
62
wxString GetUser() const { return wxString(PQuser(conn), *conv); }
63
wxString GetPassword() const { return wxString(PQpass(conn), *conv); }
64
wxString GetHost() const { return dbHost; }
65
int GetPort() const { return atoi(PQport(conn)); };
66
wxString GetTTY() const { return wxString(PQtty(conn), *conv); }
67
wxString GetOptions() const { return wxString(PQoptions(conn), *conv); }
68
int GetBackendPID() const { return PQbackendPID(conn); }
69
int GetStatus() const;
70
int GetLastResultStatus() const { return lastResultStatus; }
72
wxString GetLastError() const;
73
wxString GetVersionString();
74
OID GetLastSystemOID() const { return lastSystemOID; }
75
OID GetDbOid() const { return dbOid; }
76
bool BackendMinimumVersion(int major, int minor);
77
void RegisterNoticeProcessor(PQnoticeProcessor proc, void *arg);
78
wxString SystemNamespaceRestriction(const wxString &nsp);
83
bool IsSSLconnected();
85
PGconn *connection() { return conn; }
86
void Notice(const char *msg);
94
int minorVersion, majorVersion;
102
PQnoticeProcessor noticeProc;
104
friend class pgQueryThread;