// Return a note structure given the LID
bool NoteTable::get(Note ¬e, qint32 lid,bool loadResources, bool loadResourceRecognition) {
QSqlQuery query;
query.prepare("Select key, data from DataStore where lid=:lid");
query.bindValue(":lid", lid);
query.exec();
while (query.next()) {
qint32 key = query.value(0).toInt();
switch (key) {
case (NOTE_GUID):
note.guid = query.value(1).toString().toStdString();
note.__isset.guid = true;
break;
case (NOTE_UPDATE_SEQUENCE_NUMBER):
note.updateSequenceNum = query.value(1).toInt();
note.__isset.updateSequenceNum = true;
break;
case (NOTE_ACTIVE):
note.active = query.value(1).toBool();
note.__isset.active = true;
break;
case (NOTE_DELETED_DATE):
note.active = query.value(1).toLongLong();
note.__isset.deleted = true;
break;
case (NOTE_ATTRIBUTE_SOURCE_URL):
note.attributes.sourceURL = query.value(1).toString().toStdString();
note.__isset.attributes = true;
note.attributes.__isset.sourceURL = true;
break;
case (NOTE_ATTRIBUTE_SOURCE_APPLICATION):
note.attributes.sourceApplication = query.value(1).toString().toStdString();
note.__isset.attributes = true;
note.attributes.__isset.sourceApplication = true;
break;
case (NOTE_CONTENT_LENGTH):
note.contentLength = query.value(1).toLongLong();
note.__isset.contentLength = true;
break;
case (NOTE_ATTRIBUTE_LONGITUDE):
note.attributes.longitude = query.value(1).toFloat();
note.__isset.attributes = true;
note.attributes.__isset.longitude = true;
break;
case (NOTE_TITLE):
note.title = query.value(1).toString().toStdString();
note.__isset.title = true;
break;
case (NOTE_ATTRIBUTE_SOURCE):
note.attributes.source = query.value(1).toString().toStdString();
note.__isset.attributes = true;
note.attributes.__isset.source = true;
break;
case (NOTE_ATTRIBUTE_ALTITUDE):
note.attributes.altitude = query.value(1).toFloat();
note.__isset.attributes = true;
note.attributes.__isset.altitude = true;
break;
case (NOTE_NOTEBOOK_LID): {
qint32 notebookLid = query.value(1).toInt();
NotebookTable ntable;
QString notebookGuid;
ntable.getGuid(notebookGuid, notebookLid);
note.notebookGuid = notebookGuid.toStdString();
note.__isset.notebookGuid = true;
break;
}
case (NOTE_UPDATED_DATE):
note.updated = query.value(1).toLongLong();
note.__isset.updated = true;
break;
case (NOTE_CREATED_DATE):
note.created = query.value(1).toLongLong();
note.__isset.created = true;
break;
case (NOTE_ATTRIBUTE_SUBJECT_DATE):
note.attributes.subjectDate = query.value(1).toLongLong();
note.__isset.attributes = true;
note.attributes.__isset.subjectDate = true;
break;
case (NOTE_ATTRIBUTE_LATITUDE):
note.attributes.latitude = query.value(1).toFloat();
note.__isset.attributes = true;
note.attributes.__isset.latitude = true;
break;
case (NOTE_CONTENT):
note.content = query.value(1).toByteArray().data();
note.__isset.content = true;
break;
case (NOTE_CONTENT_HASH):
note.contentHash = query.value(1).toString().toStdString();
note.__isset.contentHash = true;
break;
case (NOTE_ATTRIBUTE_AUTHOR):
note.attributes.author = query.value(1).toString().toStdString();
note.__isset.attributes = true;
note.attributes.__isset.author = true;
break;
case (NOTE_ISDIRTY):
break;
case (NOTE_ATTRIBUTE_SHARE_DATE) :
note.attributes.shareDate = query.value(1).toLongLong();
note.__isset.attributes = true;
note.attributes.__isset.shareDate = true;
break;
case (NOTE_ATTRIBUTE_PLACE_NAME) :
note.attributes.placeName = query.value(1).toString().toStdString();
note.__isset.attributes = true;
note.attributes.__isset.placeName = true;
break;
case (NOTE_ATTRIBUTE_CONTENT_CLASS) :
note.attributes.contentClass = query.value(1).toString().toStdString();
note.__isset.attributes = true;
note.attributes.__isset.contentClass = true;
break;
case (NOTE_TAG_LID) :
TagTable tagTable;
qint32 tagLid = query.value(1).toInt();
Tag tag;
tagTable.get(tag, tagLid);
note.__isset.tagGuids = true;
note.__isset.tagNames = true;
note.tagGuids.push_back(tag.guid);
note.tagNames.push_back(tag.name);
break;
}
}
ResourceTable resTable;
QList<qint32> resList;
if (resTable.getResourceList(resList, lid)) {
for (int i=0; i<resList.size(); i++) {
Resource resource;
if (loadResources) {
resTable.get(resource, resList[i]);
} else {
QString resGuid = resTable.getGuid(resList[i]);
resource.guid = resGuid.toStdString();
resource.__isset.guid = true;
}
note.__isset.resources = true;
note.resources.push_back(resource);
}
}
/*
TagScanner test;
test.setData(QString::fromStdString(note.content));
QList<TagScannerRecord> retval;
int k = test.findAll(retval, QString("en-note"));
*/
if (note.__isset.guid)
return true;
else
return false;
}
qint32 NoteTable::duplicateNote(qint32 oldLid) {
ConfigStore cs;
qint32 newLid = cs.incrementLidCounter();
QSqlQuery query;
QString tempTableName = "notecopy" + QString::number(oldLid);
query.exec("drop temporary table " +tempTableName);
query.prepare("create temporary table " +tempTableName +" as select * from datastore where lid=:oldLid");
query.bindValue(":oldLid", oldLid);
query.exec();
query.prepare("Update " +tempTableName +" set lid=:newLid");
query.bindValue(":newLid", newLid);
query.exec();
query.exec("insert into datastore select lid, key, data from " +tempTableName);
query.exec("drop " +tempTableName);
query.prepare("update datastore set data=:data where lid=:lid and key=:key");
query.bindValue(":data", 0);
query.bindValue(":lid", newLid);
query.bindValue(":key", NOTE_UPDATE_SEQUENCE_NUMBER);
query.exec();
Note n;
get(n, newLid, false,false);
updateNoteList(newLid, n, true);
setDirty(newLid, true);
// Update all the resources
ResourceTable resTable;
QList<qint32> lids;
resTable.getResourceList(lids, oldLid);
for (int i=0; i<lids.size(); i++) {
qint32 newResLid = cs.incrementLidCounter();
query.prepare("create temporary table " +tempTableName +" as select * from datastore where lid=:oldLid");
query.bindValue(":oldLid", lids[i]);
query.exec();
query.prepare("Update " +tempTableName +" set lid=:newLid");
query.bindValue(":newLid", newResLid);
query.exec();
query.exec("insert into datastore select lid, key, data from " +tempTableName);
query.exec("drop " +tempTableName);
query.prepare("update datastore set data=:data where lid=:lid and key=:key");
query.bindValue(":data", 0);
query.bindValue(":lid", newResLid);
query.bindValue(":key", RESOURCE_UPDATE_SEQUENCE_NUMBER);
query.exec();
query.prepare("update datastore set data=:data where lid=:lid and key=:key");
query.bindValue(":data", 0);
query.bindValue(":lid", newResLid);
query.bindValue(":key", RESOURCE_NOTE_LID);
query.exec();
QStringList filter;
QDir resDir(global.fileManager.getDbaDirPath());
filter << QString::number(lids[i])+".*";
QStringList files = resDir.entryList(filter);
for (int j=0; j<files.size(); j++) {
QFile file(global.fileManager.getDbaDirPath()+files[j]);
int pos = files[j].indexOf(".");
QString type = files[j].mid(pos);
file.open(QIODevice::ReadOnly);
file.copy(global.fileManager.getDbaDirPath()+
QString::number(newResLid) +type);
file.close();
}
}
return newLid;
}