credentialsdb_p.h

Go to the documentation of this file.

/* -*- Mode: C++; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
 * This file is part of signon
 *
 * Copyright (C) 2009-2010 Nokia Corporation.
 * Copyright (C) 2012 Canonical Ltd.
 *
 * Contact: Alberto Mardegan <alberto.mardegan@canonical.com>
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public License
 * version 2.1 as published by the Free Software Foundation.
 *
 * This library is distributed in the hope that it will be useful, but
 * WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
 * 02110-1301 USA
 */

#ifndef CREDENTIALS_DB_P_H
#define CREDENTIALS_DB_P_H

#include <QObject>
#include <QtSql>

#include "SignOn/abstract-secrets-storage.h"
#include "signonidentityinfo.h"

#define SSO_METADATADB_VERSION 2
#define SSO_SECRETSDB_VERSION 1

class TestDatabase;

namespace SignonDaemonNS {

class SecretsCache
{
    friend class ::TestDatabase;
public:
    class AuthCache
    {
        friend class SecretsCache;

    private:
        QString m_username;
        QString m_password;
        bool m_storePassword;
        QHash<quint32,QVariantMap> m_blobData;
    };

    SecretsCache() {};
    ~SecretsCache() {};

    bool lookupCredentials(quint32 id,
                           QString &username,
                           QString &password) const;
    QVariantMap lookupData(quint32 id, quint32 method) const;

    void updateCredentials(quint32 id,
                           const QString &username,
                           const QString &password,
                           bool storePassword);
    void updateData(quint32 id, quint32 method, const QVariantMap &data);

    void storeToDB(SignOn::AbstractSecretsStorage *secretsStorage) const;
    void clear();

private:
    QHash<quint32, AuthCache> m_cache;
};

class SqlDatabase
{
    friend class ::TestDatabase;
public:
    SqlDatabase(const QString &hostname, const QString &connectionName,
                int version);

    virtual ~SqlDatabase();

    bool init();

    virtual bool createTables() = 0;
    virtual bool clear() = 0;
    virtual bool updateDB(int version);

    bool connect();
    void disconnect();

    bool startTransaction();
    bool commit();
    void rollback();

    bool connected() { return m_database.isOpen(); }

    void setDatabaseName(const QString &databaseName) {
        m_database.setDatabaseName(databaseName);
    }

    void setUsername(const QString &username) {
        m_database.setUserName(username);
    }

    void setPassword(const QString &password) {
        m_database.setPassword(password);
    }

    QString databaseName() const { return m_database.databaseName(); }

    QString username() const { return m_database.userName(); }

    QString password() const { return m_database.password(); }

    QSqlQuery newQuery() const { return QSqlQuery(m_database); }

    QSqlQuery exec(const QString &query);

    QSqlQuery exec(QSqlQuery &query);

    bool transactionalExec(const QStringList &queryList);

    bool hasTables() const {
        return m_database.tables().count() > 0 ? true : false;
    }

    static QStringList supportedDrivers() { return QSqlDatabase::drivers(); }

    SignOn::CredentialsDBError lastError() const;
    bool errorOccurred() const { return lastError().isValid(); };
    void clearError() { m_lastError.clear(); }

    static QString errorInfo(const QSqlError &error);

    QString connectionName() const { return m_database.connectionName(); }

protected:
    QStringList queryList(const QString &query_str);
    QStringList queryList(QSqlQuery &query);
    void setLastError(const QSqlError &sqlError);

private:
    SignOn::CredentialsDBError m_lastError;

protected:
    int m_version;
    QSqlDatabase m_database;

    friend class CredentialsDB;
};

class MetaDataDB: public SqlDatabase
{
    friend class ::TestDatabase;
public:
    MetaDataDB(const QString &name):
        SqlDatabase(name, QLatin1String("SSO-metadata"),
                    SSO_METADATADB_VERSION) {}

    bool createTables();
    bool updateDB(int version);

    QStringList methods(const quint32 id,
                        const QString &securityToken = QString());
    quint32 insertMethod(const QString &method, bool *ok = 0);
    quint32 methodId(const QString &method);
    SignonIdentityInfo identity(const quint32 id);
    QList<SignonIdentityInfo> identities(const QMap<QString, QString> &filter);

    quint32 updateIdentity(const SignonIdentityInfo &info);
    bool removeIdentity(const quint32 id);

    bool clear();

    QStringList accessControlList(const quint32 identityId);
    QStringList ownerList(const quint32 identityId);

    bool addReference(const quint32 id,
                      const QString &token,
                      const QString &reference);
    bool removeReference(const quint32 id,
                         const QString &token,
                         const QString &reference = QString());
    QStringList references(const quint32 id, const QString &token = QString());

private:
    bool insertMethods(QMap<QString, QStringList> methods);
    quint32 updateCredentials(const SignonIdentityInfo &info);
    bool updateRealms(quint32 id, const QStringList &realms, bool isNew);
    QStringList tableUpdates2();
};

} // namespace SignonDaemonNS

#endif // CREDENTIALSDB_P_H