Examples of NSqlQuery

cx.fbn.nevernote.sql.driver.NSqlQuery

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery

      deletedTable.addDeletedItem(new Long(id).toString(), "LinkedNotebook");
    }
  }
  // Check if a notebook exists
  public boolean exists(String id) {
        NSqlQuery query = new NSqlQuery(db.getConnection());
         boolean check = query.prepare("Select guid from linkednotebook where guid=:guid");
         query.bindValue(":guid", id);
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "LinkedNotebook Table exists check failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
    }
    if (query.next())
      return true;
    return false;
  }

View Full Code Here

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery

    if (!exists(tempNotebook.getGuid())) {
      addNotebook(tempNotebook, isDirty);
      return;
    }
    
        NSqlQuery query = new NSqlQuery(db.getConnection());
         check = query.prepare("Update LinkedNotebook set guid=:guid, shareName=:shareName, " +
             "username=:username, shardID=:shardID, uri=:uri, updateSequenceNumber=:usn, isDirty=:isDirty "+
             "where guid=:keyGuid");
    query.bindValue(":guid", tempNotebook.getGuid());
    query.bindValue(":keyGuid", tempNotebook.getGuid());
    query.bindValue(":shareName", tempNotebook.getShareName());
    query.bindValue(":username", tempNotebook.getUsername());
    query.bindValue(":shardID", tempNotebook.getShardId());
    query.bindValue(":shareKey", tempNotebook.getShareKey());
    query.bindValue(":uri", tempNotebook.getUri());
    query.bindValue(":usn", tempNotebook.getUpdateSequenceNum());


    query.bindValue(":isDirty", isDirty);
    
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "LinkedNotebook Table update failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
    }
  }

View Full Code Here

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery

  public List<LinkedNotebook> getAll() {
    LinkedNotebook tempNotebook;
    List<LinkedNotebook> index = new ArrayList<LinkedNotebook>();
    boolean check;
          
        NSqlQuery query = new NSqlQuery(db.getConnection());
                
    check = query.exec("Select guid, shareName, username, shardID, shareKey, uri " +
        " from LinkedNotebook");
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve has failed.");
    while (query.next()) {
      tempNotebook = new LinkedNotebook();
      tempNotebook.setGuid(query.valueString(0));
      tempNotebook.setShareName(query.valueString(1));
      tempNotebook.setUsername(query.valueString(2));
      tempNotebook.setShardId(query.valueString(3));
      tempNotebook.setShareKey(query.valueString(4));
      tempNotebook.setUri(query.valueString(5));


      index.add(tempNotebook); 
    }  
    return index;
  }

View Full Code Here

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery

  // Load notebooks from the database
  public LinkedNotebook getNotebook(String guid) {
    LinkedNotebook tempNotebook;
    boolean check;
          
        NSqlQuery query = new NSqlQuery(db.getConnection());
                
    check = query.prepare("Select guid, shareName, username, shardID, shareKey, uri " +
        " from LinkedNotebook where guid=:guid");
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve notebook prepare has failed.");
    query.bindValue(":guid", guid);
    query.exec();
    while (query.next()) {
      tempNotebook = new LinkedNotebook();
      tempNotebook.setGuid(query.valueString(0));
      tempNotebook.setShareName(query.valueString(1));
      tempNotebook.setUsername(query.valueString(2));
      tempNotebook.setShardId(query.valueString(3));
      tempNotebook.setShareKey(query.valueString(4));
      tempNotebook.setUri(query.valueString(5));
      return tempNotebook;
    }  
    return null;
  }

View Full Code Here

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery

  // Load notebooks from the database
  public LinkedNotebook getByNotebookGuid(String guid) {
    LinkedNotebook tempNotebook;
    boolean check;
          
        NSqlQuery query = new NSqlQuery(db.getConnection());
                
    check = query.prepare("Select guid, shareName, username, shardID, shareKey, uri " +
        " from LinkedNotebook where notebookguid=:guid");
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve notebook prepare has failed.");
    query.bindValue(":guid", guid);
    query.exec();
    while (query.next()) {
      tempNotebook = new LinkedNotebook();
      tempNotebook.setGuid(query.valueString(0));
      tempNotebook.setShareName(query.valueString(1));
      tempNotebook.setUsername(query.valueString(2));
      tempNotebook.setShardId(query.valueString(3));
      tempNotebook.setShareKey(query.valueString(4));
      tempNotebook.setUri(query.valueString(5));
      return tempNotebook;
    }  
    return null;
  }

View Full Code Here

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery

  }
  // Get last sequence date for the notebook
  public long getLastSequenceDate(String guid) {
    boolean check;
          
        NSqlQuery query = new NSqlQuery(db.getConnection());
                
    check = query.prepare("Select LastSequenceDate " 
        +"from LinkedNotebook where guid=:guid");
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "LinkedNotebook SQL retrieve last sequence date has failed.");
    if (query.next()) {
      return query.valueLong(0);
    }  
    return 0;
  }

View Full Code Here

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery

  }      
  // Get a guid by uri
  public String getNotebookGuid(String guid) {
    boolean check;
          
        NSqlQuery query = new NSqlQuery(db.getConnection());
                
    check = query.prepare("Select notebookGuid " 
        +"from LinkedNotebook where guid=:guid");
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "LinkedNotebook SQL retrieve of notebookguid by guidhas failed.");
    if (query.next()) {
      return query.valueString(0);
    }  
    return null;
  }

View Full Code Here

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery

  }  
  // get last sequence numeber
  public int getLastSequenceNumber(String guid) {
    boolean check;
          
        NSqlQuery query = new NSqlQuery(db.getConnection());
                
    check = query.prepare("Select LastSequenceNumber " 
        +"from LinkedNotebook where guid=:guid");
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve has failed.");
    while (query.next()) {
      return query.valueInteger(0);
    }  
    return 0;
  }

View Full Code Here

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery

  
  // get the "true" notebook guid and not the shared notebook guid
  public String getLocalNotebookGuid(String guid) {
    boolean check;
          
        NSqlQuery query = new NSqlQuery(db.getConnection());
                
    check = query.prepare("Select notebookGuid " 
        +"from LinkedNotebook where guid=:guid");
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve has failed.");
    while (query.next()) {
      return query.valueString(0);
    }  
    return null;
  }

View Full Code Here

Examples of cx.fbn.nevernote.sql.driver.NSqlQuery

  }


  // does a record exist?
  public String findNotebookByShareName(String name) {
     
    NSqlQuery query = new NSqlQuery(db.getConnection());
    
    query.prepare("Select guid from Linkednotebook where shareName=:name");
    query.bindValue(":name", name);
    if (!query.exec())
      logger.log(logger.EXTREME, "Linked notebook SQL retrieve by share name has failed.");
    String val = null;
    if (query.next())
      val = query.valueString(0);
    return val;
  }

View Full Code Here

0 1 2 3 4 5

TOP

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.