C++ (Cpp) SqlParameters::insert Exemples

Exemple #1

Fichier : eventstablemodel.cpp Projet : tkeisala/harbour-callrecorder

    void guaranteeRange(int rowIndex)
    {
        if (!dataByRowIndex.contains(rowIndex))
        {
            int pageStart = (rowIndex / pageSize) * pageSize;

            qDebug() << "Fetching " << pageSize << " items starting from " << pageStart;

            static const QString stmt(
                        "\nSELECT"
                        "\n    Events.*,"
                        "\n    PhoneNumbers.LineIdentification AS PhoneNumberIDRepresentation"
                        "\nFROM"
                        "\n    Events"
                        ""
                        "\n    LEFT JOIN"
                        "\n        PhoneNumbers"
                        "\n    ON"
                        "\n        PhoneNumbers.ID = Events.PhoneNumberID"
                        "\n%1"
                        "\nORDER BY"
                        "\n    Events.TimeStamp DESC"
                        "\nLIMIT :pageSize"
                        "\nOFFSET :pageStart");

            QString whereClause;
            Database::SqlParameters params;

            makeWhereClause(&whereClause, &params);

            QString selectStmt = stmt.arg(whereClause);

            params.insert(":pageSize", pageSize);
            params.insert(":pageStart", pageStart);

            QScopedPointer< SqlCursor > cursor(db->select(selectStmt, params));

            QStringList columns = cursor->columns();

            for (int i = 0; cursor->next(); i++)
            {
                QHash< QString, QVariant > record;

                for (int j = 0; j < columns.size(); j++)
                    record.insert(columns[j], cursor->value(columns[j]));

                dataByRowIndex.insert(pageStart + i, record);
                oidToRowIndex.insert(record.value("ID").toInt(), pageStart + i);
            }
        }
    }

Exemple #2

Fichier : phonenumberstablemodel.cpp Projet : 0312birdzhang/harbour-callrecorder

bool PhoneNumbersTableModel::contains(const QString& lineIdentification)
{
    static QString stmt(
                "SELECT ID FROM PhoneNumbers WHERE LineIdentification = :lineIdentificaiton");

    Database::SqlParameters params;
    params.insert(QLatin1String(":lineIdentification"), lineIdentification);

    QScopedPointer< SqlCursor > cursor(d->db->select(stmt, params));

    return cursor->next();
}

Exemple #3

Fichier : phonenumberstablemodel.cpp Projet : 0312birdzhang/harbour-callrecorder

int PhoneNumbersTableModel::getIdByLineIdentification(const QString& lineIdentification)
{
    qDebug();

    int id = -1;

    static QString selectStatement(
                "SELECT ID FROM PhoneNumbers WHERE LineIdentification = :lineIdentification");

    Database::SqlParameters params;
    params.insert(QLatin1String(":lineIdentification"), lineIdentification);

    QScopedPointer< SqlCursor > cursor(d->db->select(selectStatement, params));

    // TODO: process errors when selecting from DB
    if (cursor.isNull())
    {
        qCritical() <<  QLatin1String(": unable to retrieve PhoneNumbers.ID for ") <<
                        lineIdentification;
    }
    // phone number was already contacted
    else if (cursor->next())
    {
        id = cursor->value(QLatin1String("ID")).toInt();
    }
    // no data found - insert new row into PhoneNumbers and return its id
    else
    {
        static QString insertStatement(
                    "INSERT INTO PhoneNumbers(LineIdentification) VALUES(:lineIdentification)");

        Database::SqlParameters params;
        params.insert(":lineIdentification", lineIdentification);

        id = d->db->insert(insertStatement, params);
    }

    return id;
}