Package cx.fbn.nevernote.sql.driver

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

90
91
92
93
94
95
96
97
98
99
100
  }
  public void expungeAll() {
        NSqlQuery query = new NSqlQuery(db.getConnection());
    if (!query.exec("delete from WatchFolders")) {
      logger.log(logger.MEDIUM, "Expunge all WatchFolder failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
  }
  public List<WatchFolderRecord> getAll() {
    logger.log(logger.HIGH, "Entering RWatchFolders.getAll");
   
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
      "hashCode=:hashCode, name=:name, isDirty=:isDirty "
      +"where guid=:guid");
     
    if (!check) {
      logger.log(logger.EXTREME, "Tag SQL update prepare has failed.");
      logger.log(logger.EXTREME, query.lastError());
    }
    query.bindValue(":parentGuid", tempTag.getParentGuid());
    query.bindValue(":sequence", tempTag.getUpdateSequenceNum());
    query.bindValue(":hashCode", tempTag.hashCode());
    query.bindValue(":name", tempTag.getName());
View Full Code Here
185
186
187
188
189
190
191
192
193
194
195
         check = query.prepare("delete from Tag "
           +"where guid=:guid");
    if (!check) {
      logger.log(logger.EXTREME, "Tag SQL delete prepare has failed.");
      logger.log(logger.EXTREME, query.lastError());
    }
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.MEDIUM, "Tag delete failed.");
View Full Code Here
196
197
198
199
200
201
202
203
204
205
206
   
         check = query.prepare("delete from NoteTags "
           +"where tagGuid=:guid");
    if (!check) {
      logger.log(logger.EXTREME, "NoteTags SQL delete prepare has failed.");
      logger.log(logger.EXTREME, query.lastError());
    }
   
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
View Full Code Here
223
224
225
226
227
228
229
230
231
232
233
        NSqlQuery query = new NSqlQuery(db.getConnection());
    check = query.prepare("Insert Into Tag (guid, parentGuid, sequence, hashCode, name, isDirty, linked, realName, notebookGuid)"
        +" Values(:guid, :parentGuid, :sequence, :hashCode, :name, :isDirty, :linked, :realName, :notebookGuid)");
    if (!check) {
      logger.log(logger.EXTREME, "Tag SQL insert prepare has failed.");
      logger.log(logger.EXTREME, query.lastError());
    }
    query.bindValue(":guid", tempTag.getGuid());
    query.bindValue(":parentGuid", tempTag.getParentGuid());
    query.bindValue(":sequence", tempTag.getUpdateSequenceNum());
    query.bindValue(":hashCode", tempTag.hashCode());
View Full Code Here
238
239
240
241
242
243
244
245
246
247
248
    query.bindValue(":notebookGuid", notebookGuid);
   
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "Tag Table insert failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
  }
  // Update a tag's parent
  public void updateTagParent(String guid, String parentGuid) {
    boolean check;
View Full Code Here
249
250
251
252
253
254
255
256
257
258
259
    
        NSqlQuery query = new NSqlQuery(db.getConnection());
    check = query.prepare("Update Tag set parentGuid=:parentGuid where guid=:guid");
    if (!check) {
      logger.log(logger.EXTREME, "Tag SQL tag parent update prepare has failed.");
      logger.log(logger.EXTREME, query.lastError());
    }

    query.bindValue(":parentGuid", parentGuid);
    query.bindValue(":guid", guid);
   
View Full Code Here
258
259
260
261
262
263
264
265
266
267
268
    query.bindValue(":guid", guid);
   
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "Tag parent update failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
  }
  //Save tags from Evernote
  public void saveTags(List<Tag> tags) {
    Tag tempTag;
View Full Code Here
280
281
282
283
284
285
286
287
288
289
290
    query.bindValue(":guid", guid);
   
    query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "Tag sequence update failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
    
  }
  // Update a tag sequence number
  public void updateTagGuid(String oldGuid, String newGuid) {
View Full Code Here
295
296
297
298
299
300
301
302
303
304
305
    query.bindValue(":newGuid", newGuid);
    query.bindValue(":oldGuid", oldGuid);
    query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "Tag guid update failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
   
    check = query.prepare("Update Tag set parentGuid=:newGuid where parentGuid=:oldGuid");
    query.bindValue(":newGuid", newGuid);
    query.bindValue(":oldGuid", oldGuid);
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.