/*\r
- * This file is part of NixNote \r
+ * This file is part of NixNote/NeighborNote \r
* Copyright 2009 Randy Baumgarte\r
* \r
* This file may be licensed under the terms of of the\r
}\r
\r
public void saveNoteResource(Resource r, boolean isDirty) {\r
- logger.log(logger.HIGH, "Entering DBRunner.saveNoteResources");\r
+ logger.log(logger.HIGH, "Entering saveNoteResources: isDirty " +isDirty);\r
boolean check;\r
+ logger.log(logger.HIGH, "Note: " +r.getNoteGuid());\r
+ logger.log(logger.HIGH, "Resource: " +r.getGuid());\r
NSqlQuery query = new NSqlQuery(db.getResourceConnection());\r
SimpleDateFormat simple = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");\r
\r
- check = query.prepare("Insert Into NoteResources ("\r
+ query.prepare("Insert Into NoteResources ("\r
+"guid, noteGuid, dataHash, dataSize, dataBinary, updateSequenceNumber, "\r
+"mime, width, height, duration, active, recognitionHash, " \r
+"recognitionSize, recognitionBinary, attributeSourceUrl, attributeTimestamp, "\r
+":attributeCameraModel, "\r
+":attributeClientWillIndex, :attributeRecoType, :attributeFileName, :attributeAttachment, "\r
+":isDirty, true)");\r
- if (!check) {\r
- logger.log(logger.EXTREME, "NoteResource SQL insert prepare has failed.");\r
- logger.log(logger.MEDIUM, query.lastError());\r
- }\r
\r
query.bindValue(":guid", r.getGuid());\r
query.bindValue(":noteGuid", r.getNoteGuid());\r
query.bindValue(":attributeRecoType", r.getAttributes().getRecoType());\r
query.bindValue(":attributeFileName", r.getAttributes().getFileName());\r
query.bindValue(":attributeAttachment", r.getAttributes().isAttachment()); \r
- }\r
+ } \r
query.bindValue(":isDirty", isDirty);\r
\r
check = query.exec();\r
logger.log(logger.HIGH, "Leaving NoteResourceTable.getDistinctNoteGuids()");\r
return guids;\r
}\r
+\r
+ public void resetAllDirty() {\r
+ NSqlQuery query = new NSqlQuery(db.getResourceConnection());\r
+ query.exec("update noteresources set isdirty=false");\r
+ }\r
+ \r
+ // リソーステキストを更新\r
+ public void updateResourceText(String guid, String text) {\r
+ logger.log(logger.HIGH, "Entering NoteResourceTable.updateResourceText");\r
+ NSqlQuery query = new NSqlQuery(db.getResourceConnection());\r
+ boolean check = query.prepare("Update noteResources set resourceText=:resourceText where guid=:guid");\r
+ if (!check) {\r
+ logger.log(logger.EXTREME, "Update resourceText sql prepare has failed.");\r
+ logger.log(logger.MEDIUM, query.lastError());\r
+ }\r
+ \r
+ query.bindValue(":resourceText", text);\r
+ query.bindValue(":guid", guid);\r
+ \r
+ check = query.exec();\r
+ if (!check) {\r
+ logger.log(logger.EXTREME, "Update resourceText has failed.");\r
+ logger.log(logger.MEDIUM, query.lastError());\r
+ }\r
+ logger.log(logger.HIGH, "Leaving NoteResourceTable.updateResourceText");\r
+ query.exec();\r
+ }\r
}\r
+\r