import java.text.ParseException;\r
import java.text.SimpleDateFormat;\r
import java.util.ArrayList;\r
+import java.util.HashMap;\r
import java.util.List;\r
\r
import com.evernote.edam.type.Note;\r
import com.trolltech.qt.core.QByteArray;\r
import com.trolltech.qt.core.QDateTime;\r
import com.trolltech.qt.core.QTextCodec;\r
+import com.trolltech.qt.gui.QPixmap;\r
\r
import cx.fbn.nevernote.Global;\r
import cx.fbn.nevernote.evernote.EnmlConverter;\r
// Update a note's title\r
public void updateNoteContent(String guid, String content) {\r
NSqlQuery query = new NSqlQuery(db.getConnection());\r
- boolean check = query.prepare("Update Note set content=:content, updated=CURRENT_TIMESTAMP(), isDirty=true, indexNeeded=true " +\r
- " where guid=:guid");\r
+ boolean check = query.prepare("Update Note set content=:content, updated=CURRENT_TIMESTAMP(), isDirty=true, indexNeeded=true, " +\r
+ " thumbnailneeded=true where guid=:guid");\r
if (!check) {\r
logger.log(logger.EXTREME, "Update note content sql prepare has failed.");\r
logger.log(logger.MEDIUM, query.lastError());\r
List<Pair<String,Integer>> returnValue = new ArrayList<Pair<String,Integer>>();\r
NSqlQuery query = new NSqlQuery(db.getConnection());\r
\r
- if (!query.exec("Select titleColor from Note where titleColor != -1 and guid=:guid"))\r
+ query.prepare("Select titleColor from Note where titleColor != -1 and guid=:guid");\r
+ query.bindValue(":guid", guid);\r
+ if (!query.exec())\r
logger.log(logger.EXTREME, "Note SQL retrieve has failed on getNoteTitleColor(guid).");\r
\r
Integer color = -1;\r
if (!check) \r
logger.log(logger.EXTREME, "Note SQL get thumbail failed: " +query.lastError().toString());\r
// Get a list of the notes\r
- if (query.next()) \r
- if (query.getBlob(0) != null)\r
- return new QByteArray(query.getBlob(0)); \r
+ if (query.next()) {\r
+ try {\r
+ if (query.getBlob(0) != null) {\r
+ return new QByteArray(query.getBlob(0)); \r
+ }\r
+ } catch (java.lang.IllegalArgumentException e) {\r
+ return null;\r
+ }\r
+ }\r
return null;\r
}\r
+ // Get all thumbnails\r
+ public HashMap<String, QPixmap> getThumbnails() {\r
+ boolean check; \r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ HashMap<String, QPixmap> map = new HashMap<String,QPixmap>();\r
+ \r
+ check = query.prepare("Select guid,thumbnail from note where thumbnailneeded=false and isExpunged=false");\r
+ check = query.exec();\r
+ if (!check) \r
+ logger.log(logger.EXTREME, "Note SQL get thumbail failed: " +query.lastError().toString());\r
+ // Get a list of the notes\r
+ while (query.next()) {\r
+ try {\r
+ if (query.getBlob(1) != null) {\r
+ QByteArray data = new QByteArray(query.getBlob(1));\r
+ QPixmap img = new QPixmap();\r
+ if (img.loadFromData(data)) {\r
+ img = img.scaled(Global.largeThumbnailSize);\r
+ map.put(query.valueString(0), img);\r
+ }\r
+ } \r
+ } catch (java.lang.IllegalArgumentException e) {\r
+ logger.log(logger.HIGH, "Error retrieving thumbnail " +e.getMessage());\r
+ }\r
+ }\r
+ return map;\r
+ }\r
+ // Get a list of notes that need thumbnails\r
+ public List<String> findThumbnailsNeeded() {\r
+ \r
+ boolean check;\r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ \r
+ check = query.prepare("select guid from note where thumbnailneeded=true and isExpunged=false and DATEDIFF('MINUTE',updated,CURRENT_TIMESTAMP)>5 limit 5");\r
+ check = query.exec();\r
+ if (!check) \r
+ logger.log(logger.EXTREME, "Note SQL findThumbnailsNeeded query failed: " +query.lastError().toString());\r
+ \r
+\r
+ // Get a list of the notes\r
+ List<String> values = new ArrayList<String>();\r
+ while (query.next()) {\r
+ values.add(query.valueString(0)); \r
+ }\r
+\r
+ return values; \r
+ }\r
+ // Get a count of thumbnails needed\r
+ public int getThumbnailNeededCount() {\r
+ \r
+ boolean check;\r
+ NSqlQuery query = new NSqlQuery(db.getConnection());\r
+ \r
+ check = query.prepare("select count(guid) from note where thumbnailneeded=true and isExpunged=false and DATEDIFF('MINUTE',updated,CURRENT_TIMESTAMP)>5 limit 2");\r
+ check = query.exec();\r
+ if (!check) \r
+ logger.log(logger.EXTREME, "Note SQL findThumbnailNeededCount query failed: " +query.lastError().toString());\r
+ \r
+ if (query.next()) {\r
+ return query.valueInteger(0); \r
+ }\r
+\r
+ return 0; \r
+ }\r
+\r
\r
\r
// Update a note content's hash. This happens if a resource is edited outside of NN\r
newSegment +\r
n.getContent().substring(endPos);\r
NSqlQuery query = new NSqlQuery(db.getConnection());\r
- query.prepare("update note set isdirty=true, content=:content where guid=:guid");\r
+ query.prepare("update note set isdirty=true, thumbnailneeded=true, content=:content where guid=:guid");\r
query.bindValue(":content", content);\r
query.bindValue(":guid", n.getGuid());\r
query.exec();\r