Repository navigation
Expand file tree
/
Copy pathtdatabasecontext.cpp
More file actions
129 lines (99 loc) · 2.72 KB
/
Copy pathtdatabasecontext.cpp
File metadata and controls
129 lines (99 loc) · 2.72 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
/* Copyright (c) 2015, AOYAMA Kazuharu
* All rights reserved.
*
* This software may be used and distributed according to the terms of
* the New BSD License, which is incorporated herein by reference.
*/
#include <QtCore>
#include <QSqlDatabase>
#include <QSqlDriver>
#include <TWebApplication>
#include <TKvsDriver>
#include "tdatabasecontext.h"
#include "tsqldatabasepool.h"
#include "tkvsdatabasepool.h"
#include "tsystemglobal.h"
/*!
\class TDatabaseContext
\brief The TDatabaseContext class is the base class of contexts for
database access.
*/
TDatabaseContext::TDatabaseContext()
: sqlDatabases(),
kvsDatabases(),
transactions()
{ }
TDatabaseContext::~TDatabaseContext()
{
release();
}
QSqlDatabase &TDatabaseContext::getSqlDatabase(int id)
{
T_TRACEFUNC("id:%d", id);
if (!Tf::app()->isSqlDatabaseAvailable()) {
return sqlDatabases[0]; // invalid database
}
if (id < 0 || id >= Tf::app()->sqlDatabaseSettingsCount()) {
throw RuntimeException("error database id", __FILE__, __LINE__);
}
QSqlDatabase &db = sqlDatabases[id];
if (!db.isValid()) {
db = TSqlDatabasePool::instance()->database(id);
beginTransaction(db);
}
return db;
}
void TDatabaseContext::releaseSqlDatabases()
{
rollbackTransactions();
for (QMap<int, QSqlDatabase>::iterator it = sqlDatabases.begin(); it != sqlDatabases.end(); ++it) {
TSqlDatabasePool::instance()->pool(it.value());
}
sqlDatabases.clear();
}
TKvsDatabase &TDatabaseContext::getKvsDatabase(TKvsDatabase::Type type)
{
T_TRACEFUNC("type:%d", (int)type);
TKvsDatabase &db = kvsDatabases[(int)type];
if (!db.isValid()) {
db = TKvsDatabasePool::instance()->database(type);
}
if (db.driver()) {
db.driver()->moveToThread(QThread::currentThread());
}
return db;
}
void TDatabaseContext::releaseKvsDatabases()
{
for (QMap<int, TKvsDatabase>::iterator it = kvsDatabases.begin(); it != kvsDatabases.end(); ++it) {
TKvsDatabasePool::instance()->pool(it.value());
}
kvsDatabases.clear();
}
void TDatabaseContext::release()
{
// Releases all SQL database sessions
releaseSqlDatabases();
// Releases all KVS database sessions
releaseKvsDatabases();
}
void TDatabaseContext::setTransactionEnabled(bool enable)
{
transactions.setEnabled(enable);
}
bool TDatabaseContext::beginTransaction(QSqlDatabase &database)
{
bool ret = true;
if (database.driver()->hasFeature(QSqlDriver::Transactions)) {
ret = transactions.begin(database);
}
return ret;
}
void TDatabaseContext::commitTransactions()
{
transactions.commit();
}
void TDatabaseContext::rollbackTransactions()
{
transactions.rollback();
}