Package cx.fbn.nevernote.sql.driver

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

675
676
677
678
679
680
681
682
683
684
685
  }
  // Set the notebooks custom icon
  public void setIcon(String guid, QIcon icon, String type) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    if (icon == null) {
      if (!query.prepare("update "+dbName+" set icon=null where guid=:guid"))
        logger.log(logger.EXTREME, "Error preparing "+dbName+" icon select.");
    } else {
      if (!query.prepare("update "+dbName+" set icon=:icon where guid=:guid"))
        logger.log(logger.EXTREME, "Error preparing "+dbName+" icon select.");
      QBuffer buffer = new QBuffer();
View Full Code Here
678
679
680
681
682
683
684
685
686
687
688
    NSqlQuery query = new NSqlQuery(db.getConnection());
    if (icon == null) {
      if (!query.prepare("update "+dbName+" set icon=null where guid=:guid"))
        logger.log(logger.EXTREME, "Error preparing "+dbName+" icon select.");
    } else {
      if (!query.prepare("update "+dbName+" set icon=:icon where guid=:guid"))
        logger.log(logger.EXTREME, "Error preparing "+dbName+" icon select.");
      QBuffer buffer = new QBuffer();
          if (!buffer.open(QIODevice.OpenModeFlag.ReadWrite)) {
            logger.log(logger.EXTREME, "Failure to open buffer.  Aborting.");
            return;
View Full Code Here
702
703
704
705
706
707
708
709
710
711
712
      logger.log(logger.LOW, "Error setting "+dbName+" icon. " +query.lastError());
  }
  // Set the notebooks custom icon
  public void setReadOnly(String guid, boolean readOnly) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    if (!query.prepare("update "+dbName+" set readOnly=:readOnly where guid=:guid"))
      logger.log(logger.EXTREME, "Error preparing "+dbName+" read only.");
    query.bindValue(":guid", guid);
    query.bindValue(":readOnly", readOnly);
    if (!query.exec())
      logger.log(logger.LOW, "Error setting "+dbName+" read only. " +query.lastError());
View Full Code Here
715
716
717
718
719
720
721
722
723
724
725
  // does a record exist?
  public String findNotebookByName(String newname) {
    
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Select guid from "+dbName+" where name=:newname");
    query.bindValue(":newname", newname);
    if (!query.exec())
      logger.log(logger.EXTREME, dbName+" SQL retrieve has failed.");
    String val = null;
    if (query.next())
View Full Code Here
749
750
751
752
753
754
755
756
757
758
759
  // Get/Set stacks
  public void clearStack(String guid) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update "+dbName+" set stack='' where guid=:guid");
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error clearing "+dbName+" stack.");
  }
  // Get/Set stacks
View Full Code Here
758
759
760
761
762
763
764
765
766
767
768
  }
  // Get/Set stacks
  public void setStack(String guid, String stack) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update "+dbName+" set stack=:stack, isDirty=true where guid=:guid");
    query.bindValue(":guid", guid);
    query.bindValue(":stack", stack);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error setting notebook stack.");
  }
View Full Code Here
784
785
786
787
788
789
790
791
792
793
794
  }
  // Rename a stack
  public void renameStacks(String oldName, String newName) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    if (!query.prepare("update "+dbName+" set stack=:newName where stack=:oldName")) {
      logger.log(logger.EXTREME, "Error preparing in renameStacks.");
      return;
    }
    query.bindValue(":oldName", oldName);
    query.bindValue(":newName", newName);
View Full Code Here
795
796
797
798
799
800
801
802
803
804
805
    if (!query.exec()) {
      logger.log(logger.EXTREME, "Error updating stack names");
      return;
    }
   
    if (!query.prepare("update SystemIcon set name=:newName where name=:oldName and type='STACK'")) {
      logger.log(logger.EXTREME, "Error preparing icon rename in renameStacks.");
      return;
    }
    query.bindValue(":oldName", oldName);
    query.bindValue(":newName", newName);
View Full Code Here
253
254
255
256
257
258
259
260
261
262
263
  }
  // Find a guid based upon the name
  public String findSavedSearchByName(String name) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Select guid from SavedSearch where name=:name");
    query.bindValue(":name", name);
    if (!query.exec())
      logger.log(logger.EXTREME, "SavedSearch SQL retrieve has failed in findSavedSearchByName().");
    String val = null;
    if (query.next())
View Full Code Here
265
266
267
268
269
270
271
272
273
274
275
    return val;
  }
  // given a guid, does the tag exist
  public boolean exists(String guid) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.prepare("Select guid from SavedSearch where guid=:guid");
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "SavedSearch SQL retrieve has failed in exists().");
    boolean retval = query.next();
    return retval;
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.