* This file contains a realization of a base postgresql-storage plugin class
*
* v. 1.3
- * FreeMb logging on dosconnects added
+ * FreeMb logging on disconnects added
*
* v. 1.2
* Reconnection on faults added
#include <libpq-fe.h>
-#include "postgresql_store.h"
+#include "stg/module_settings.h"
+#include "stg/plugin_creator.h"
#include "postgresql_store_utils.h"
-#include "base_settings.h"
+#include "postgresql_store.h"
-class POSTGRESQL_STORE_CREATOR
-{
-public:
- POSTGRESQL_STORE_CREATOR()
- : pqStore(new POSTGRESQL_STORE())
- {
- };
- ~POSTGRESQL_STORE_CREATOR()
- {
- delete pqStore;
- };
- POSTGRESQL_STORE * GetStore() { return pqStore; };
-private:
- POSTGRESQL_STORE * pqStore;
-} pqStoreeCreator;
+PLUGIN_CREATOR<POSTGRESQL_STORE> pqStoreeCreator;
//-----------------------------------------------------------------------------
-BASE_STORE * GetStore()
+STORE * GetStore()
{
-return pqStoreeCreator.GetStore();
+return pqStoreeCreator.GetPlugin();
}
//-----------------------------------------------------------------------------
POSTGRESQL_STORE::POSTGRESQL_STORE()
- : connection(NULL)
+ : versionString("postgresql_store v.1.3"),
+ server("localhost"),
+ database("stargazer"),
+ user("stg"),
+ password("123456"),
+ version(0),
+ retries(3),
+ connection(NULL)
{
-server = "localhost";
-database = "stargazer";
-user = "stg";
-password = "123456";
-versionString = "postgresql_store v.1.3";
pthread_mutex_init(&mutex, NULL);
}
//-----------------------------------------------------------------------------
{
password = *(i->value.begin());
}
+ if (s == "retries")
+ {
+ if (str2x(*(i->value.begin()), retries))
+ {
+ strError = "Invalid 'retries' value";
+ printfd(__FILE__, "POSTGRESQL_STORE::ParseSettings(): '%s'\n", strError.c_str());
+ return -1;
+ }
+ }
}
clientEncoding = "KOI8";
{
strError = PQerrorMessage(connection);
printfd(__FILE__, "POSTGRESQL_STORE::Connect(): '%s'\n", strError.c_str());
- return 1;
+ // Will try to connect later
+ return 0;
}
if (PQsetClientEncoding(connection, clientEncoding.c_str()))
//-----------------------------------------------------------------------------
int POSTGRESQL_STORE::Reset() const
{
-PQreset(connection);
+for (int i = 0; i < retries && PQstatus(connection) != CONNECTION_OK; ++i)
+ {
+ struct timespec ts = {1, 0};
+ nanosleep(&ts, NULL);
+ PQreset(connection);
+ }
if (PQstatus(connection) != CONNECTION_OK)
{
{
strError = PQerrorMessage(connection);
printfd(__FILE__, "POSTGRESQL_STORE::Reset(): '%s'\n", strError.c_str());
- return 1;
+ return -1;
}
return CheckVersion();