]> git.stg.codes - stg.git/blob - projects/stargazer/plugins/store/firebird/firebird_store.cpp
37b5184f8aabedfc6c2b8dee2b0a2bd4d2342644
[stg.git] / 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/ibpp.h"
32 #include "stg/plugin_creator.h"
33
34 #include <string>
35 #include <vector>
36 #include <algorithm>
37
38 #include <cctype>
39
40 namespace
41 {
42 PLUGIN_CREATOR<FIREBIRD_STORE> frsc;
43 }
44
45 extern "C" STORE * GetStore();
46 //-----------------------------------------------------------------------------
47 STORE * GetStore()
48 {
49 return frsc.GetPlugin();
50 }
51 //-----------------------------------------------------------------------------
52 //-----------------------------------------------------------------------------
53 //-----------------------------------------------------------------------------
54 FIREBIRD_STORE::FIREBIRD_STORE()
55     : version("firebird_store v.1.4"),
56       strError(),
57       db_server("localhost"),
58       db_database("/var/stg/stargazer.fdb"),
59       db_user("stg"),
60       db_password("123456"),
61       settings(),
62       db(),
63       mutex(),
64       til(IBPP::ilConcurrency),
65       tlr(IBPP::lrWait),
66       logger(GetPluginLogger(GetStgLogger(), "store_firebird"))
67 {
68 pthread_mutex_init(&mutex, NULL);
69 }
70 //-----------------------------------------------------------------------------
71 FIREBIRD_STORE::~FIREBIRD_STORE()
72 {
73 db->Disconnect();
74 }
75 //-----------------------------------------------------------------------------
76 int FIREBIRD_STORE::ParseSettings()
77 {
78 std::vector<PARAM_VALUE>::iterator i;
79 std::string s;
80
81 for(i = settings.moduleParams.begin(); i != settings.moduleParams.end(); ++i)
82     {
83     s = i->param;
84
85     std::transform(s.begin(), s.end(), s.begin(), ::tolower);
86
87     if (s == "server")
88         db_server = *(i->value.begin());
89
90     if (s == "database")
91         db_database = *(i->value.begin());
92
93     if (s == "user")
94         db_user = *(i->value.begin());
95
96     if (s == "password")
97         db_password = *(i->value.begin());
98
99     // Advanced settings block
100
101     if (s == "isolationLevel")
102         {
103         if (*(i->value.begin()) == "Concurrency")
104             til = IBPP::ilConcurrency;
105         else if (*(i->value.begin()) == "DirtyRead")
106             til = IBPP::ilReadDirty;
107         else if (*(i->value.begin()) == "ReadCommitted")
108             til = IBPP::ilReadCommitted;
109         else if (*(i->value.begin()) == "Consistency")
110             til = IBPP::ilConsistency;
111         }
112
113     if (s == "lockResolution")
114         {
115         if (*(i->value.begin()) == "Wait")
116             tlr = IBPP::lrWait;
117         else if (*(i->value.begin()) == "NoWait")
118             tlr = IBPP::lrNoWait;
119         }
120     }
121
122 try
123     {
124     db = IBPP::DatabaseFactory(db_server, db_database, db_user, db_password, "", "KOI8U", "");
125     db->Connect();
126     return CheckVersion();
127     }
128 catch (IBPP::Exception & ex)
129     {
130     strError = "IBPP exception";
131     printfd(__FILE__, ex.what());
132     return -1;
133     }
134
135 return 0;
136 }
137 //-----------------------------------------------------------------------------
138 int FIREBIRD_STORE::CheckVersion()
139 {
140 IBPP::Transaction tr = IBPP::TransactionFactory(db, IBPP::amRead, til, tlr);
141 IBPP::Statement st = IBPP::StatementFactory(db, tr);
142
143 std::string name;
144
145 try
146     {
147     tr->Start();
148     st->Execute("SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG=0 AND RDB$RELATION_NAME = 'TB_INFO'");
149     if (!st->Fetch())
150         {
151         schemaVersion = 0;
152         }
153     else
154         {
155         st->Execute("SELECT version FROM tb_info");
156         while (st->Fetch())
157             st->Get(1, schemaVersion);
158         }
159     tr->Commit();
160     logger("FIREBIRD_STORE: Current DB schema version: %d", schemaVersion);
161     }
162
163 catch (IBPP::Exception & ex)
164     {
165     tr->Rollback();
166     strError = "IBPP exception";
167     printfd(__FILE__, ex.what());
168     return -1;
169     }
170
171 return 0;
172 }
173 //-----------------------------------------------------------------------------