Files
ssp/db/databasemanager.cpp
2026-08-20 11:22:55 +08:00

155 lines
3.2 KiB
C++

#include "databasemanager.h"
#include <QCoreApplication>
#include <QSqlError>
#include <QThread>
DatabaseManager &DatabaseManager::instance()
{
static DatabaseManager manager;
return manager;
}
DatabaseManager::DatabaseManager()
: m_config(DbConfig::defaultConfig())
{
}
void DatabaseManager::setConfig(const DbConfig &config)
{
if (isOpen()) {
close();
}
m_config = config;
}
DbConfig DatabaseManager::config() const
{
return m_config;
}
bool DatabaseManager::open(QString *error)
{
const QString name = connectionName();
QSqlDatabase db;
if (QSqlDatabase::contains(name)) {
db = QSqlDatabase::database(name);
} else {
db = QSqlDatabase::addDatabase(m_config.driverName, name);
}
if (db.isOpen()) {
return true;
}
db.setHostName(m_config.hostName);
db.setPort(m_config.port);
db.setDatabaseName(m_config.databaseName);
db.setUserName(m_config.userName);
db.setPassword(m_config.password);
if (!db.open()) {
m_lastErrorText = db.lastError().text();
if (error) {
*error = m_lastErrorText;
}
return false;
}
m_lastErrorText.clear();
return true;
}
void DatabaseManager::close()
{
const QString name = connectionName();
if (!QSqlDatabase::contains(name)) {
return;
}
{
QSqlDatabase db = QSqlDatabase::database(name, false);
if (db.isValid() && db.isOpen()) {
db.close();
}
}
QSqlDatabase::removeDatabase(name);
}
bool DatabaseManager::isOpen() const
{
const QString name = connectionName();
if (!QSqlDatabase::contains(name)) {
return false;
}
return QSqlDatabase::database(name, false).isOpen();
}
QSqlDatabase DatabaseManager::database() const
{
const QString name = connectionName();
if (!QSqlDatabase::contains(name)) {
return QSqlDatabase();
}
return QSqlDatabase::database(name);
}
QString DatabaseManager::lastErrorText() const
{
return m_lastErrorText;
}
bool DatabaseManager::transaction(QString *error)
{
if (!open(error)) {
return false;
}
QSqlDatabase db = database();
if (!db.transaction()) {
m_lastErrorText = db.lastError().text();
if (error) {
*error = m_lastErrorText;
}
return false;
}
return true;
}
bool DatabaseManager::commit(QString *error)
{
QSqlDatabase db = database();
if (!db.commit()) {
m_lastErrorText = db.lastError().text();
if (error) {
*error = m_lastErrorText;
}
return false;
}
return true;
}
bool DatabaseManager::rollback(QString *error)
{
QSqlDatabase db = database();
if (!db.rollback()) {
m_lastErrorText = db.lastError().text();
if (error) {
*error = m_lastErrorText;
}
return false;
}
return true;
}
QString DatabaseManager::connectionName() const
{
if (QThread::currentThread() == QCoreApplication::instance()->thread()) {
return m_config.connectionName;
}
return QString("%1_%2")
.arg(m_config.connectionName)
.arg(reinterpret_cast<quintptr>(QThread::currentThreadId()), 0, 16);
}