Package cx.fbn.nevernote.sql.driver

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery.lastError()

494
495
496
497
498
499
500
501
502
503
504
    check = query.prepare("Select "
        +"recognitionHash, recognitionSize, recognitionBinary, noteGuid "
        +" from NoteResources where guid=:guid");
    if (!check) {
      logger.log(logger.EXTREME, "NoteTable.getNoteRecognition SQL prepare has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    query.bindValue(":guid", guid);
    query.exec();
    if (!check) {
View Full Code Here
501
502
503
504
505
506
507
508
509
510
511
    }
    query.bindValue(":guid", guid);
    query.exec();
    if (!check) {
      logger.log(logger.EXTREME, "NoteTable.getNoteRecognition exec has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    Resource r = null;
    while (query.next()) {
                 
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    NSqlQuery query = new NSqlQuery(db.getResourceConnection());
   
    query.prepare("Update noteresources set isdirty=false where guid=:guid");
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error resetting noteresource dirty field. " +query.lastError());
    else
      query.exec("commit");
  }
  // Set if the resource should be indexed
  public void  setIndexNeeded(String guid, Boolean indexNeeded) {
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
    NSqlQuery query = new NSqlQuery(db.getResourceConnection());   
    query.prepare("Update noteresources set indexNeeded=:needed where guid=:guid");
    query.bindValue(":needed", indexNeeded);
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error setting noteresource indexneeded field: " +query.lastError());
    else
      query.exec("commit");
  }
  // get any unindexed resource
  public List<String> getNextUnindexed(int limit) {
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
  public List<String> getNextUnindexed(int limit) {
    List<String> guids = new ArrayList<String>();
        NSqlQuery query = new NSqlQuery(db.getResourceConnection());
               
    if (!query.exec("Select guid from NoteResources where indexNeeded = true limit " +limit))
      logger.log(logger.EXTREME, "NoteResources SQL retrieve has failed on getNextUnindexed(): " +query.lastError());

    // Get a list of the notes
    String guid;
    while (query.next()) {
      guid = new String();
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
  public List<String> getUnindexed() {
    List<String> guids = new ArrayList<String>();
        NSqlQuery query = new NSqlQuery(db.getResourceConnection());
               
    if (!query.exec("Select guid from NoteResources where indexNeeded = true"))
      logger.log(logger.EXTREME, "NoteResources SQL retrieve has failed on getUnindexed(): " +query.lastError());

    // Get a list of the notes
    String guid;
    while (query.next()) {
      guid = new String();
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
    List<String> guids = new ArrayList<String>();
    NSqlQuery query = new NSqlQuery(db.getResourceConnection());
   
    query.prepare("Select guid from noteresources;");
    if (!query.exec())
      logger.log(logger.EXTREME, "Error getting all note resource guids. " +query.lastError());
   
    while (query.next()) {
      guids.add(query.valueString(0));
    }
    return guids;
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
    List<String> guids = new ArrayList<String>();
    NSqlQuery query = new NSqlQuery(db.getResourceConnection());
   
    query.prepare("Select guid from noteresources where mime='application/vnd.evernote.ink'");
    if (!query.exec())
      logger.log(logger.EXTREME, "Error searching for ink notes. " +query.lastError());
   
    while (query.next()) {
      guids.add(query.valueString(0));
    }
    return guids;
View Full Code Here
226
227
228
229
230
231
232
233
234
235
236
      query.bindValue(":isDirty", isDirty);
           
      check = query.exec();
      if (!check) {
        logger.log(logger.MEDIUM, "*** NoteResource Table insert failed.");   
        logger.log(logger.MEDIUM, query.lastError());
      } else
        query.exec("commit");
     
           
      logger.log(logger.HIGH, "Leaving DBRunner.saveNoteResources");
View Full Code Here
263
264
265
266
267
268
269
270
271
272
273
          "where noteGuid=:noteGuid and dataHash=:hash");
    if (check)
      logger.log(logger.EXTREME, "NoteResource SQL select prepare was successful.");
    else {
       logger.log(logger.EXTREME, "NoteResource SQL select prepare has failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
    query.bindValue(":noteGuid", noteGuid);
    query.bindValue(":hash", hash);
 
    check = query.exec();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.