projects/stargazer/plugins/store/firebird/firebird_store.cpp

   1 /*
   2  *    This program is free software; you can redistribute it and/or modify
   3  *    it under the terms of the GNU General Public License as published by
   4  *    the Free Software Foundation; either version 2 of the License, or
   5  *    (at your option) any later version.
   6  *
   7  *    This program is distributed in the hope that it will be useful,
   8  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
   9  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  10  *    GNU General Public License for more details.
  11  *
  12  *    You should have received a copy of the GNU General Public License
  13  *    along with this program; if not, write to the Free Software
  14  *    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  15  */
  16
  17 /*
  18  *    Author : Maxim Mamontov <faust@stargazer.dp.ua>
  19  */
  20
  21 /*
  22  *  This file contains a realization of a base firebird-storage plugin class
  23  *
  24  *  $Revision: 1.18 $
  25  *  $Date: 2010/01/08 16:00:45 $
  26  *
  27  */
  28
  29 #include "firebird_store.h"
  30
  31 #include "stg/common.h"
  32
  33 #include <string>
  34 #include <vector>
  35
  36 extern "C" STG::Store* GetStore()
  37 {
  38     static FIREBIRD_STORE plugin;
  39     return &plugin;
  40 }
  41 //-----------------------------------------------------------------------------
  42 //-----------------------------------------------------------------------------
  43 //-----------------------------------------------------------------------------
  44 FIREBIRD_STORE::FIREBIRD_STORE()
  45     : version("firebird_store v.1.4"),
  46       db_server("localhost"),
  47       db_database("/var/stg/stargazer.fdb"),
  48       db_user("stg"),
  49       db_password("123456"),
  50       til(IBPP::ilConcurrency),
  51       tlr(IBPP::lrWait),
  52       schemaVersion(0),
  53       logger(STG::PluginLogger::get("store_firebird"))
  54 {
  55 pthread_mutex_init(&mutex, NULL);
  56 }
  57 //-----------------------------------------------------------------------------
  58 FIREBIRD_STORE::~FIREBIRD_STORE()
  59 {
  60 db->Disconnect();
  61 }
  62 //-----------------------------------------------------------------------------
  63 int FIREBIRD_STORE::ParseSettings()
  64 {
  65 std::vector<STG::ParamValue>::iterator i;
  66 std::string s;
  67
  68 for(i = settings.moduleParams.begin(); i != settings.moduleParams.end(); ++i)
  69     {
  70     if (i->value.empty())
  71         continue;
  72     s = ToLower(i->param);
  73
  74     if (s == "server")
  75         db_server = i->value.front();
  76
  77     if (s == "database")
  78         db_database = i->value.front();
  79
  80     if (s == "user")
  81         db_user = i->value.front();
  82
  83     if (s == "password")
  84         db_password = i->value.front();
  85
  86     // Advanced settings block
  87
  88     if (s == "isolationLevel")
  89         {
  90         if (i->value.front() == "Concurrency")
  91             til = IBPP::ilConcurrency;
  92         else if (i->value.front() == "DirtyRead")
  93             til = IBPP::ilReadDirty;
  94         else if (i->value.front() == "ReadCommitted")
  95             til = IBPP::ilReadCommitted;
  96         else if (i->value.front() == "Consistency")
  97             til = IBPP::ilConsistency;
  98         }
  99
 100     if (s == "lockResolution")
 101         {
 102         if (i->value.front() == "Wait")
 103             tlr = IBPP::lrWait;
 104         else if (i->value.front() == "NoWait")
 105             tlr = IBPP::lrNoWait;
 106         }
 107     }
 108
 109 try
 110     {
 111     db = IBPP::DatabaseFactory(db_server, db_database, db_user, db_password, "", "KOI8U", "");
 112     db->Connect();
 113     return CheckVersion();
 114     }
 115 catch (IBPP::Exception & ex)
 116     {
 117     strError = "IBPP exception";
 118     printfd(__FILE__, ex.what());
 119     return -1;
 120     }
 121
 122 return 0;
 123 }
 124 //-----------------------------------------------------------------------------
 125 int FIREBIRD_STORE::CheckVersion()
 126 {
 127 IBPP::Transaction tr = IBPP::TransactionFactory(db, IBPP::amRead, til, tlr);
 128 IBPP::Statement st = IBPP::StatementFactory(db, tr);
 129
 130 try
 131     {
 132     tr->Start();
 133     st->Execute("SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG=0 AND RDB$RELATION_NAME = 'TB_INFO'");
 134     if (!st->Fetch())
 135         {
 136         schemaVersion = 0;
 137         }
 138     else
 139         {
 140         st->Execute("SELECT version FROM tb_info");
 141         while (st->Fetch())
 142             st->Get(1, schemaVersion);
 143         }
 144     tr->Commit();
 145     logger("FIREBIRD_STORE: Current DB schema version: %d", schemaVersion);
 146     }
 147
 148 catch (IBPP::Exception & ex)
 149     {
 150     tr->Rollback();
 151     strError = "IBPP exception";
 152     printfd(__FILE__, ex.what());
 153     return -1;
 154     }
 155
 156 return 0;
 157 }
 158 //-----------------------------------------------------------------------------