C++ (Cpp) SQLConnection Exemples

Exemple #1

Fichier : PushDAO.cpp Projet : ProLove365/Cascades-Samples

int PushDAO::add(const Push &push)
{
    int insertId = -1;
    QSqlQuery sqlQuery(SQLConnection());

    const QString query("INSERT INTO push (seqnum, pushdate, type, pushtime, extension, content, unread)"
                        "VALUES(:seqnum, :pushdate, :type, :pushtime, :extension, :content, :unread)");

    sqlQuery.prepare(query);

    sqlQuery.bindValue(":pushdate", push.pushDateAsString());
    sqlQuery.bindValue(":type", push.contentType());
    sqlQuery.bindValue(":pushtime", push.pushTime());
    sqlQuery.bindValue(":extension", push.fileExtension());
    sqlQuery.bindValue(":content", push.content().toBase64(), QSql::In | QSql::Binary);
    sqlQuery.bindValue(":unread", push.unread());
    sqlQuery.exec();

    const QSqlError err = sqlQuery.lastError();

    if (err.isValid()) {
        qWarning() << "Error executing SQL statement: " << query << ". ERROR: " << err.text();
    } else {
        if (sqlQuery.lastInsertId().isValid()) {
            insertId = sqlQuery.lastInsertId().toInt();
        }
    }

    return insertId;
}

Exemple #2

Fichier : PushDAO.cpp Projet : ProLove365/Cascades-Samples

bool PushDAO::removeAll()
{
    const QString query("DROP TABLE push;");

    // Execute the query.
    QSqlQuery sqlQuery(query, SQLConnection());

    const QSqlError err = sqlQuery.lastError();

    if (err.isValid()) {
        qWarning() << "Error executing SQL statement: " << query << ". ERROR: " << err.text();
        return false;
    }

    return true;
}

Exemple #3

Fichier : PushDAO.cpp Projet : ProLove365/Cascades-Samples

bool PushDAO::createPushTable()
{
    const QString query("CREATE TABLE IF NOT EXISTS push (seqnum INTEGER PRIMARY KEY AUTOINCREMENT, pushdate TEXT, type TEXT, pushtime TEXT, extension TEXT, content BLOB, unread INTEGER);");

    // Execute the query.
    QSqlQuery sqlQuery(query, SQLConnection());

    const QSqlError err = sqlQuery.lastError();

    if (err.isValid()) {
        qWarning() << "Error executing SQL statement: " << query << ". ERROR: " << err.text();
        return false;
    }

    return true;
}

Exemple #4

Fichier : PushDAO.cpp Projet : ProLove365/Cascades-Samples

bool PushDAO::remove(int pushSeqNum)
{
    QSqlQuery sqlQuery(SQLConnection());

    const QString query("DELETE FROM push WHERE seqnum = :seqNum;");

    sqlQuery.prepare(query);

    sqlQuery.bindValue(":seqNum", pushSeqNum);
    sqlQuery.exec();

    const QSqlError err = sqlQuery.lastError();

    if (err.isValid()) {
        qWarning() << "Error executing SQL statement: " << query << ". ERROR: " << err.text();
        return false;
    }

    return true;
}

Exemple #5

Fichier : PushDAO.cpp Projet : ProLove365/Cascades-Samples

bool PushDAO::markAllAsRead()
{
    QSqlQuery sqlQuery(SQLConnection());

    const QString query("UPDATE push SET unread = :unread;");

    sqlQuery.prepare(query);

    sqlQuery.bindValue(":unread", false);
    sqlQuery.exec();

    const QSqlError err = sqlQuery.lastError();

    if (err.isValid()) {
        qWarning() << "Error executing SQL statement: " << query << ". ERROR: " << err.text();
        return false;
    }

    return true;
}

Exemple #6

Fichier : PushDAO.cpp Projet : 13natty/Cascades-Samples

QVariantList PushDAO::pushes()
{
    QVariantList data;

    const QString query("SELECT seqnum, pushdate, type, pushtime, extension, content, unread FROM push ORDER BY seqnum desc;");

    QSqlQuery sqlQuery(query, SQLConnection());

    const QSqlError err = sqlQuery.lastError();

    if (err.isValid()) {
        qWarning() << "Error executing SQL statement: " << query << ". ERROR: " << err.text();
    } else {
        while (sqlQuery.next()){
            data.append(retrievePush(sqlQuery).toMap());
        }
    }

    return data;
}

Exemple #7

Fichier : PushDAO.cpp Projet : 13natty/Cascades-Samples

Push PushDAO::push(int pushSeqNum)
{
    Push push;
    QSqlQuery sqlQuery(SQLConnection());

    const QString query("SELECT seqnum, pushdate, type, pushtime, extension, content, unread FROM push WHERE seqnum = :seqNum;");

    sqlQuery.prepare(query);
    sqlQuery.bindValue(":seqNum", pushSeqNum);
    sqlQuery.exec();

    const QSqlError err = sqlQuery.lastError();

    if (err.isValid()) {
        qWarning() << "Error executing SQL statement: " << query << ". ERROR: " << err.text();
    } else {
        if (sqlQuery.next()){
            push = retrievePush(sqlQuery);
        }
    }

    return push;
}

Exemple #8

Fichier : PushDAO.cpp Projet : ProLove365/Cascades-Samples

QVariantList PushDAO::pushes()
{
    QVariantList data;

    const QString query("SELECT seqnum, pushdate, type, pushtime, extension, content, unread FROM push ORDER BY seqnum desc;");

    QSqlQuery sqlQuery(query, SQLConnection());

    const QSqlError err = sqlQuery.lastError();

    if (err.isValid()) {
        qWarning() << "Error executing SQL statement: " << query << ". ERROR: " << err.text();
    } else {
        const QSqlRecord record = sqlQuery.record();
        while (sqlQuery.next()){
            Push push(sqlQuery.value(0).toInt(),QByteArray::fromBase64(sqlQuery.value(5).toByteArray()),
                    sqlQuery.value(2).toString(),sqlQuery.value(4).toString(), sqlQuery.value(1).toString(),
                    sqlQuery.value(3).toString(), sqlQuery.value(6).toBool());
            data.append(push.toMap());
        }
    }

    return data;
}