diff options
author | Aaron Marks <nymacro@gmail.com> | 2005-06-19 12:26:04 +0000 |
---|---|---|
committer | Aaron Marks <nymacro@gmail.com> | 2005-06-19 12:26:04 +0000 |
commit | f194e2fb62234ff66d0ee12282ce4a22aa237e89 (patch) | |
tree | 60b48cf64e8b16abcee01516e7f35020b77e1171 /src/dal/pqdataprovider.h | |
parent | d711ab557a1e3613df1f6fd1ad818695acda05ed (diff) | |
download | manaserv-f194e2fb62234ff66d0ee12282ce4a22aa237e89.tar.gz manaserv-f194e2fb62234ff66d0ee12282ce4a22aa237e89.tar.bz2 manaserv-f194e2fb62234ff66d0ee12282ce4a22aa237e89.tar.xz manaserv-f194e2fb62234ff66d0ee12282ce4a22aa237e89.zip |
Added PostgreSQL DAL class.
Updated configure.ac to include PostgreSQL & MySQL. (MySQL needs to be adjusted, and it seems that using --with-sqlite will drop out of configure after check for atexit. I dont know why, as i didn't touch the SQLite stuff) :)
Diffstat (limited to 'src/dal/pqdataprovider.h')
-rw-r--r-- | src/dal/pqdataprovider.h | 107 |
1 files changed, 107 insertions, 0 deletions
diff --git a/src/dal/pqdataprovider.h b/src/dal/pqdataprovider.h new file mode 100644 index 00000000..1e8beedc --- /dev/null +++ b/src/dal/pqdataprovider.h @@ -0,0 +1,107 @@ +/* + * The Mana World Server + * Copyright 2004 The Mana World Development Team + * + * This file is part of The Mana World. + * + * The Mana World 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 any later version. + * + * The Mana World 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 The Mana World; if not, write to the Free Software Foundation, Inc., + * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + * + * $Id$ + */ + +#ifndef PQDATAPROVIDER_H +#define PQDATAPROVIDER_H + +#include <string> +#include "dataprovider.h" +#include "libpq-fe.h" + +namespace tmwserv +{ +namespace dal +{ + +class PqDataProvider : public DataProvider +{ + public: + /** + * Constructor + */ + PqDataProvider() + throw(); + + /** + * Destructor + */ + ~PqDataProvider() + throw(); + + /** + * Get name of the database backend + * + * @return the database backend name + */ + DbBackends + getDbBackend(void) const + throw(); + + /** + * Create a connection to the database. + * + * @param dbName the database name. + * @param userName the user name. + * @param password the user password. + * + * @exception DbConnectionFailure if unsuccessful connection. + */ + void + connect(const std::string& dbName, + const std::string& userName, + const std::string& password); + + + /** + * Execute a SQL query. + * + * @param sql the SQL query. + * @param refresh if true, refresh the cache (default = false). + * + * @return a recordset. + * + * @exception DbSqlQueryExecFailure if unsuccessful execution. + * @exception std::runtime_error if trying to query a closed database. + */ + const RecordSet& + execSql(const std::string& sql, + const bool refresh = false); + + + /** + * Close the connection to the database. + * + * @exception DbDisconnectionFailure if unsuccessful disconnection. + */ + void + disconnect(void); + + protected: + PGconn *mDb; /**< Database connection handle */ + +}; + + +} +} + +#endif |