logger.log(logger.MEDIUM, query.lastError());
}
}
// Update a notebook GUID number
public void updateNotebookGuid(String oldGuid, String newGuid) {
NSqlQuery query = new NSqlQuery(db.getConnection());
query.prepare("Update "+dbName+" set guid=:newGuid where guid=:oldGuid");
query.bindValue(":oldGuid", oldGuid);
query.bindValue(":newGuid", newGuid);
if (!query.exec()) {
logger.log(logger.MEDIUM, dbName+" guid update failed.");
logger.log(logger.MEDIUM, query.lastError());
}
// Update any notes containing the notebook guid
query.prepare("Update Note set notebookGuid=:newGuid where notebookGuid=:oldGuid");
query.bindValue(":oldGuid", oldGuid);
query.bindValue(":newGuid", newGuid);
if (!query.exec()) {
logger.log(logger.MEDIUM, dbName+" guid update for note failed.");
logger.log(logger.MEDIUM, query.lastError());
}
// Update any watch folders with the new guid
query = new NSqlQuery(db.getConnection());
query.prepare("Update WatchFolders set notebook=:newGuid where notebook=:oldGuid");
query.bindValue(":oldGuid", oldGuid);
query.bindValue(":newGuid", newGuid);
if (!query.exec()) {
logger.log(logger.MEDIUM, "Update WatchFolder notebook failed.");
logger.log(logger.MEDIUM, query.lastError().toString());
}
}