Package cx.fbn.nevernote.sql.driver

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

58
59
60
61
62
63
64
65
66
67
68
    query.prepare("Insert Into Sync (key,  value) values (:key, :value);");
    query.bindValue(":key", key);
    query.bindValue(":value", value);
    if (!query.exec()) {
      logger.log(logger.MEDIUM, "Add to into Sync failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
  }
  // Add an item to the table
  public void deleteRecord(String key) {
        NSqlQuery query = new NSqlQuery(db.getConnection());
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
        NSqlQuery query = new NSqlQuery(db.getConnection());
    query.prepare("Delete From Sync where key=:key");
    query.bindValue(":key", key);
    if (!query.exec()) {
      logger.log(logger.MEDIUM, "Delete from Sync failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
  }
  // Get a key field
  public String getRecord(String key) {
        NSqlQuery query = new NSqlQuery(db.getConnection());
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
        NSqlQuery query = new NSqlQuery(db.getConnection());
        query.prepare("Select value from Sync where key=:key");
        query.bindValue(":key", key);
    if (!query.exec()) {
      logger.log(logger.MEDIUM, "getRecord from sync failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    if (query.next()) {
      return (query.valueString(0));
    }
View Full Code Here
302
303
304
305
306
307
308
309
310
311
312
 
    if (!query.exec()) {
      logger.log(logger.MEDIUM, "NoteResource Select failed." +
          "Note Guid:" +noteGuid+
          "Data Body Hash:" +hash);   
      logger.log(logger.MEDIUM, query.lastError());
    }
    if (!query.next()) {
      logger.log(logger.MEDIUM, "Note Resource not found.");
      return null;
    }
View Full Code Here
317
318
319
320
321
322
323
324
325
326
327
   
    NSqlQuery binary = new NSqlQuery(db.getResourceConnection());
    if (!binary.prepare("Select databinary from NoteResources " +
          "where guid=:guid")) {
      logger.log(logger.MEDIUM, "Prepare for NoteResources Binary failed");
      logger.log(logger.MEDIUM, binary.lastError());
    }
   
    if (!binary.exec()) {
      logger.log(logger.MEDIUM, "NoteResources Binary Select failed." +
          "Note Guid:" +noteGuid+
View Full Code Here
324
325
326
327
328
329
330
331
332
333
334
   
    if (!binary.exec()) {
      logger.log(logger.MEDIUM, "NoteResources Binary Select failed." +
          "Note Guid:" +noteGuid+
          "Data Body Hash:" +hash);   
      logger.log(logger.MEDIUM, binary.lastError());
    }
    if (!binary.next()) {
      logger.log(logger.MEDIUM, "Note Resource Binary not found.");
      return null;
    }
View Full Code Here
360
361
362
363
364
365
366
367
368
369
370
    query.prepare(queryString);
   
    query.bindValue(":guid", guid);
    if (!query.exec()) {
      logger.log(logger.EXTREME, "NoteResources SQL select has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    Resource r = null;
    if (query.next()) {
                 
View Full Code Here
436
437
438
439
440
441
442
443
444
445
446
    query.prepare("Select guid"
        +" from NoteResources where noteGuid = :noteGuid");
    query.bindValue(":noteGuid", noteGuid);
    if (!query.exec()) {
      logger.log(logger.EXTREME, "NoteResources SQL select has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    while (query.next()) {
      String guid = (query.valueString(0));
      res.add(getNoteResource(guid, withBinary));
View Full Code Here
457
458
459
460
461
462
463
464
465
466
467
    check = query.prepare("Select "
        +"recognitionHash, recognitionSize, recognitionBinary "
        +" from NoteResources where noteGuid=:guid");
    if (!check) {
      logger.log(logger.EXTREME, "NoteTable.getNoteRecognition SQL prepare has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    query.bindValue(":guid", noteGuid);
    if (!check) {
      logger.log(logger.EXTREME, "NoteTable.getNoteRecognition exec has failed.");
View Full Code Here
463
464
465
466
467
468
469
470
471
472
473
      return null;
    }
    query.bindValue(":guid", noteGuid);
    if (!check) {
      logger.log(logger.EXTREME, "NoteTable.getNoteRecognition exec has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    while (query.next()) { 
      Resource r = new Resource();   
      res.add(r);
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.