sqlitedatabase.cpp 4.11 KB
Newer Older
1 2
/****************************************************************************
**
3 4
** Copyright (C) 2016 The Qt Company Ltd.
** Contact: https://www.qt.io/licensing/
5 6 7 8 9 10 11
**
** This file is part of Qt Creator.
**
** Commercial License Usage
** Licensees holding valid commercial Qt licenses may use this file in
** accordance with the commercial license agreement provided with the
** Software or, alternatively, in accordance with the terms contained in
12 13 14
** a written agreement between you and The Qt Company. For licensing terms
** and conditions see https://www.qt.io/terms-conditions. For further
** information use the contact form at https://www.qt.io/contact-us.
15
**
16 17 18 19 20 21 22
** GNU General Public License Usage
** Alternatively, this file may be used under the terms of the GNU
** General Public License version 3 as published by the Free Software
** Foundation with exceptions as appearing in the file LICENSE.GPL3-EXCEPT
** included in the packaging of this file. Please review the following
** information to ensure the GNU General Public License requirements will
** be met: https://www.gnu.org/licenses/gpl-3.0.html.
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 130 131 132 133 134 135 136 137 138 139 140 141
**
****************************************************************************/

#include "sqlitedatabase.h"

#include "sqlitetable.h"

SqliteDatabase::SqliteDatabase()
    : readDatabaseConnection(QStringLiteral("ReadWorker")),
      writeDatabaseConnection(QStringLiteral("WriterWorker")),
      journalMode_(JournalMode::Wal)
{
    connect(&readDatabaseConnection, &SqliteDatabaseConnectionProxy::connectionIsOpened, this, &SqliteDatabase::handleReadDatabaseConnectionIsOpened);
    connect(&writeDatabaseConnection, &SqliteDatabaseConnectionProxy::connectionIsOpened, this, &SqliteDatabase::handleWriteDatabaseConnectionIsOpened);
    connect(&readDatabaseConnection, &SqliteDatabaseConnectionProxy::connectionIsClosed, this, &SqliteDatabase::handleReadDatabaseConnectionIsClosed);
    connect(&writeDatabaseConnection, &SqliteDatabaseConnectionProxy::connectionIsClosed, this, &SqliteDatabase::handleWriteDatabaseConnectionIsClosed);
}

SqliteDatabase::~SqliteDatabase()
{
    qDeleteAll(sqliteTables);
}

void SqliteDatabase::open()
{
    writeDatabaseConnection.setDatabaseFilePath(databaseFilePath());
    writeDatabaseConnection.setJournalMode(journalMode());
}

void SqliteDatabase::close()
{
    writeDatabaseConnection.close();
}

bool SqliteDatabase::isOpen() const
{
    return readDatabaseConnection.isOpen() && writeDatabaseConnection.isOpen();
}

void SqliteDatabase::addTable(SqliteTable *newSqliteTable)
{
    newSqliteTable->setSqliteDatabase(this);
    sqliteTables.append(newSqliteTable);
}

const QVector<SqliteTable *> &SqliteDatabase::tables() const
{
    return sqliteTables;
}

void SqliteDatabase::setDatabaseFilePath(const QString &databaseFilePath)
{
    databaseFilePath_ = databaseFilePath;
}

const QString &SqliteDatabase::databaseFilePath() const
{
    return databaseFilePath_;
}

void SqliteDatabase::setJournalMode(JournalMode journalMode)
{
    journalMode_ = journalMode;
}

JournalMode SqliteDatabase::journalMode() const
{
    return journalMode_;
}

QThread *SqliteDatabase::writeWorkerThread() const
{
    return writeDatabaseConnection.connectionThread();
}

QThread *SqliteDatabase::readWorkerThread() const
{
    return readDatabaseConnection.connectionThread();
}

void SqliteDatabase::handleReadDatabaseConnectionIsOpened()
{
    if (writeDatabaseConnection.isOpen() && readDatabaseConnection.isOpen()) {
        initializeTables();
        emit databaseIsOpened();
    }
}

void SqliteDatabase::handleWriteDatabaseConnectionIsOpened()
{
    readDatabaseConnection.setDatabaseFilePath(databaseFilePath());
}

void SqliteDatabase::handleReadDatabaseConnectionIsClosed()
{
    if (!writeDatabaseConnection.isOpen() && !readDatabaseConnection.isOpen()) {
        shutdownTables();
        emit databaseIsClosed();
    }
}

void SqliteDatabase::handleWriteDatabaseConnectionIsClosed()
{
    readDatabaseConnection.close();
}

void SqliteDatabase::initializeTables()
{
    for (SqliteTable *table: tables())
        table->initialize();
}

void SqliteDatabase::shutdownTables()
{
    for (SqliteTable *table: tables())
        table->shutdown();
}