Package cx.fbn.nevernote.sql.driver

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

448
449
450
451
452
453
454
455
456
457
458
    }
  }
  // Update a notebook GUID number
  public void updateNotebookGuid(String oldGuid, String newGuid) {
        NSqlQuery query = new NSqlQuery(db.getConnection());
    query.prepare("Update "+dbName+" set guid=:newGuid where guid=:oldGuid");
    query.bindValue(":oldGuid", oldGuid);
    query.bindValue(":newGuid", newGuid);
    if (!query.exec()) {
      logger.log(logger.MEDIUM, dbName+" guid update failed.");
      logger.log(logger.MEDIUM, query.lastError());
View Full Code Here
457
458
459
460
461
462
463
464
465
466
467
      logger.log(logger.MEDIUM, dbName+" guid update failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
    
    // Update any notes containing the notebook guid
    query.prepare("Update Note set notebookGuid=:newGuid where notebookGuid=:oldGuid");
    query.bindValue(":oldGuid", oldGuid);
    query.bindValue(":newGuid", newGuid);
    if (!query.exec()) {
      logger.log(logger.MEDIUM, dbName+" guid update for note failed.");
      logger.log(logger.MEDIUM, query.lastError());
View Full Code Here
467
468
469
470
471
472
473
474
475
476
477
      logger.log(logger.MEDIUM, query.lastError());
    }
   
    // Update any watch folders with the new guid
    query = new NSqlQuery(db.getConnection());
    query.prepare("Update WatchFolders set notebook=:newGuid where notebook=:oldGuid");
    query.bindValue(":oldGuid", oldGuid);
    query.bindValue(":newGuid", newGuid);
    if (!query.exec()) {
      logger.log(logger.MEDIUM, "Update WatchFolder notebook failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
View Full Code Here
530
531
532
533
534
535
536
537
538
539
540
    Notebook tempNotebook;
    boolean check;
           
        NSqlQuery query = new NSqlQuery(db.getConnection());
               
    query.prepare("Select guid, sequence, name, defaultNotebook, " +
        "serviceCreated, serviceUpdated, published, stack, "+
        "publishinguri, publishingascending, publishingPublicDescription, "+
        "publishingOrder " +
        "from "+dbName+" where guid=:guid");
    query.bindValue(":guid", guid);
View Full Code Here
593
594
595
596
597
598
599
600
601
602
603
  // does a record exist?
  private boolean exists(String guid) {
    
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Select guid from "+dbName+" where guid=:guid");
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, dbName+" SQL retrieve has failed.");
    boolean retval = query.next();
    return retval;
View Full Code Here
604
605
606
607
608
609
610
611
612
613
614
  }
  // Reset the dirty flag.  Typically done after a sync.
  public void  resetDirtyFlag(String guid) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update "+dbName+" set isdirty='false' where guid=:guid");
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error resetting "+dbName+" dirty field.");
  }
  // Set the default notebook
View Full Code Here
613
614
615
616
617
618
619
620
621
622
623
  }
  // Set the default notebook
  public void setDefaultNotebook(String guid) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update "+dbName+" set defaultNotebook=false, isDirty=true where linked=false and defaultNotebook=true");
    if (!query.exec())
      logger.log(logger.EXTREME, "Error removing default "+dbName+".");
    query.prepare("Update "+dbName+" set defaultNotebook=true, isDirty=true where guid=:guid and linked=false");
    query.bindValue(":guid", guid);
    if (!query.exec())
View Full Code Here
616
617
618
619
620
621
622
623
624
625
626
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update "+dbName+" set defaultNotebook=false, isDirty=true where linked=false and defaultNotebook=true");
    if (!query.exec())
      logger.log(logger.EXTREME, "Error removing default "+dbName+".");
    query.prepare("Update "+dbName+" set defaultNotebook=true, isDirty=true where guid=:guid and linked=false");
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error setting default "+dbName+".");
  }
 
View Full Code Here
644
645
646
647
648
649
650
651
652
653
654
 
  // Get the notebooks custom icon
  public QIcon getIcon(String guid) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    if (!query.prepare("Select icon from "+dbName+" where guid=:guid"))
      logger.log(logger.EXTREME, "Error preparing "+dbName+" icon select.");
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error finding "+dbName+" icon.");
    if (!query.next() || query.getBlob(0) == null)
View Full Code Here
660
661
662
663
664
665
666
667
668
669
670
  }
  // Get the notebooks custom icon
  public QByteArray getIconAsByteArray(String guid) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    if (!query.prepare("Select icon from "+dbName+" where guid=:guid"))
      logger.log(logger.EXTREME, "Error preparing "+dbName+" icon select.");
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error finding "+dbName+" icon.");
    if (!query.next() || query.getBlob(0) == null)
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.