]> git.stg.codes - stg.git/blob - stargazer/plugins/store/firebird/firebird_store.cpp
Public interfaces: part 3
[stg.git] / 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 //-----------------------------------------------------------------------------