Method getNewUnsequencedCount

sql/notebooktable.cpp:988–1002

Get a count of all new unsequenced notebooks

// Get a count of all new unsequenced notebooks
int NotebookTable::getNewUnsequencedCount() {
    db->lockForRead();
    NSqlQuery query(db);
    query.prepare("Select count(lid) from DataStore where key=:key and data=0 and lid not in (select lid from datastore where key=:localkey and data=1)");
    query.bindValue(":key", NOTEBOOK_UPDATE_SEQUENCE_NUMBER);
    query.bindValue(":localkey", NOTEBOOK_IS_LOCAL);
    query.exec();
    qint32 retval = 0;
    while(query.next()) {
        retval = query.value(0).toInt();
    }
    query.finish();
    db->unlock();
    return retval;
}