Method get

sql/filewatchertable.cpp:68–100

Get an individual record

// Get an individual record
void FileWatcherTable::get(qint32 lid, QString &baseDir, FileWatcher::ScanType &type, qint32 &notebookLid, bool &includeSubdirs) {
    NSqlQuery sql(db);
    db->lockForRead();
    sql.prepare("Select key, data from DataStore where lid=:lid");
    sql.bindValue(":lid", lid);
    sql.exec();

    while(sql.next()) {
        int key = sql.value(0).toInt();
        switch(key) {
        case FILE_WATCHER_DIR :
            baseDir = sql.value(1).toString();
            break;
        case FILE_WATCHER_NOTEBOOK :
            notebookLid = sql.value(1).toInt();
            break;
        case FILE_WATCHER_SUBDIRS :
            includeSubdirs = sql.value(1).toBool();
            break;
        case FILE_WATCHER_TYPE : {
            int value = sql.value(1).toInt();
            if (value == FileWatcher::ImportDelete)
                type = FileWatcher::ImportDelete;
            else
                type = FileWatcher::ImportKeep;
         }
         default :
            break;
        }
    }
    db->unlock();
    sql.finish();
}