Method getSize

sql/notetable.cpp:2613–2633

qlonglong NoteTable::getSize(qint32 lid) {
    NSqlQuery query(db);
    db->lockForRead();
    query.prepare("select data from datastore where key=:key and lid=:lid");
    query.bindValue(":key", NOTE_CONTENT_LENGTH);
    query.bindValue(":lid", lid);
    query.exec();
    qlonglong returnValue = 0;
    if (query.next()) {
        returnValue = query.value(0).toLongLong();
    }
    query.prepare("Select sum(data) from DataStore where key=:key and lid in (select lid from datastore where key=:key2 and data=:lid)");
    query.bindValue(":key", RESOURCE_DATA_SIZE);
    query.bindValue(":key2", RESOURCE_NOTE_LID);
    query.bindValue(":data", lid);
    query.exec();
    while (query.next()) {
        returnValue = returnValue+query.value(0).toLongLong();
    }
    return returnValue;
}