Examples of NSqlQuery

cx.fbn.nevernote.sql.driver.NSqlQuery

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

      logger.log(logger.MEDIUM, query.lastError().toString());
    }
  }
  // Check if a notebook exists
  public boolean exists(long id) {
        NSqlQuery query = new NSqlQuery(db.getConnection());
        logger.log(logger.EXTREME, "Checking if shared notebook " +id +" exists");
         boolean check = query.prepare("Select id from sharednotebook where id=:id");
         query.bindValue(":id", id);
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "SharedNotebook Table exists check failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
    }
    if (query.next())
      return true;
        logger.log(logger.EXTREME, "Shared notebook " +id +" does not exist");    
    return false;
  }

View Full Code Here

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

    return false;
  }
  // Delete the notebook based on a id
  public void expungeNotebook(long id, boolean needsSync) {
    boolean check;
        NSqlQuery query = new NSqlQuery(db.getConnection());


         check = query.prepare("delete from SharedNotebook "
           +"where id=:id");
    if (!check) {
      logger.log(logger.EXTREME, "SharedNotebook SQL delete prepare has failed.");
      logger.log(logger.EXTREME, query.lastError().toString());
    }
    query.bindValue(":id", id);
    check = query.exec();
    if (!check) 
      logger.log(logger.MEDIUM, "SharedNotebook delete failed.");
    
    // Signal the parent that work needs to be done
    if  (needsSync) {

View Full Code Here

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

    }
  }
  // Delete the notebook based on a id
  public void expungeNotebookByGuid(String id, boolean needsSync) {
    boolean check;
        NSqlQuery query = new NSqlQuery(db.getConnection());


         check = query.prepare("delete from SharedNotebook "
           +"where guid=:id");
    if (!check) {
      logger.log(logger.EXTREME, "SharedNotebook SQL delete by notebook guid prepare has failed.");
      logger.log(logger.EXTREME, query.lastError().toString());
    }
    query.bindValue(":id", id);
    check = query.exec();
    if (!check) 
      logger.log(logger.MEDIUM, "SharedNotebook delete by notebook guid failed.");
    
    // Signal the parent that work needs to be done
    if  (needsSync) {

View Full Code Here

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

    }
    
    SimpleDateFormat simple = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");
    
    StringBuilder serviceCreated = new StringBuilder(simple.format(tempNotebook.getServiceCreated()));            
        NSqlQuery query = new NSqlQuery(db.getConnection());
         check = query.prepare("Update SharedNotebook set userid=:userid, notebookGuid=:notebook, "
             + "email=:email, notebookModifiable=:mod, requireLogin=:rlogin, serviceCreated=:serviceCreated, "
             + "shareKey=:shareKey, username=:username, isDirty=:isdirty where id=:id");
    query.bindValue(":id", tempNotebook.getId());
    query.bindValue(":userid", tempNotebook.getUserId());
    query.bindValue(":notebook", tempNotebook.getNotebookGuid());
    query.bindValue(":email", tempNotebook.getEmail());
    query.bindValue(":mod", tempNotebook.isNotebookModifiable());
    query.bindValue(":rlogin", tempNotebook.isRequireLogin());
    query.bindValue(":serviceCreated", serviceCreated.toString());
    query.bindValue(":shareKey", tempNotebook.getShareKey());
    query.bindValue(":username", tempNotebook.getUsername());
    
    query.bindValue(":isDirty", isDirty);
    
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "SharedNotebook Table update failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
    }
  }

View Full Code Here

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

  public List<SharedNotebook> getAll() {
    SharedNotebook tempNotebook;
    List<SharedNotebook> index = new ArrayList<SharedNotebook>();
    boolean check;
          
        NSqlQuery query = new NSqlQuery(db.getConnection());
                
    check = query.exec("Select id, userid, notebookGuid, email, notebookModifiable, requireLogin, " +
        "serviceCreated, "+
        "shareKey, username from SharedNotebook");
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve has failed.");
    while (query.next()) {
      tempNotebook = new SharedNotebook();
      tempNotebook.setId(query.valueLong(0));
      tempNotebook.setUserId(query.valueInteger(1));
      tempNotebook.setNotebookGuid(query.valueString(2));
      tempNotebook.setEmail(query.valueString(3));
      tempNotebook.setNotebookModifiable(query.valueBoolean(4,false));
      tempNotebook.setRequireLogin(query.valueBoolean(5,true));
      DateFormat indfm = null;
      try {
        indfm = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");
      } catch (Exception e) {  }
      try {
        tempNotebook.setServiceCreated(indfm.parse(query.valueString(6)).getTime());
      } catch (ParseException e) {
        e.printStackTrace();
      }
      tempNotebook.setShareKey(query.valueString(7));
      tempNotebook.setUsername(query.valueString(8));


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

View Full Code Here

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

  public List<SharedNotebook> getForNotebook(String guid) {
    SharedNotebook tempNotebook;
    List<SharedNotebook> index = new ArrayList<SharedNotebook>();
    boolean check;
          
        NSqlQuery query = new NSqlQuery(db.getConnection());
                
    check = query.prepare("Select id, userid, notebookGuid, email, notebookModifiable, requireLogin, " +
        "serviceCreated, "+
        "shareKey, username from SharedNotebook where notebookGuid=:notebookGuid ");
    if (!check)
      logger.log(logger.EXTREME, "SharedNotebook getForNotebook SQL prepare has failed.");
    query.bindValue(":notebookGuid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "SharedNotebook getForNotebook SQL exec has failed.");
    
    while (query.next()) {
      tempNotebook = new SharedNotebook();
      tempNotebook.setId(query.valueLong(0));
      tempNotebook.setUserId(query.valueInteger(1));
      tempNotebook.setNotebookGuid(query.valueString(2));
      tempNotebook.setEmail(query.valueString(3));
      tempNotebook.setNotebookModifiable(query.valueBoolean(4,false));
      tempNotebook.setRequireLogin(query.valueBoolean(5,true));
      DateFormat indfm = null;
      try {
        indfm = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");
      } catch (Exception e) {  }
      try {
        tempNotebook.setServiceCreated(indfm.parse(query.valueString(6)).getTime());
      } catch (ParseException e) {
        e.printStackTrace();
      }
      tempNotebook.setShareKey(query.valueString(7));
      tempNotebook.setUsername(query.valueString(8));


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

View Full Code Here

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

  
  // Get a list of shared notebooks that need to be updated
  public List <Long> getDirtyIds() {
    List<Long> index = new ArrayList<Long>();
    boolean check;  
        NSqlQuery query = new NSqlQuery(db.getConnection());
                
    check = query.exec("Select id from SharedNotebook where isDirty = true");
    if (!check) 
      logger.log(logger.EXTREME, "SharedNotebook SQL retrieve has failed in getdirtyIds.");
    while (query.next()) {
      index.add(query.valueLong(0));
    }  
    return index;  
  }

View Full Code Here

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

    }
  }
  public List<DeletedItemRecord> getAllDeleted() {
    logger.log(logger.HIGH, "Entering DeletedTable.getAllDeleted");
    List<DeletedItemRecord> list = new ArrayList<DeletedItemRecord>();
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("Select guid, type from DeletedItems");
    while (query.next()) {
      DeletedItemRecord record = new DeletedItemRecord();
      record.guid = query.valueString(0);
      record.type = query.valueString(1);
      list.add(record);
    }
    logger.log(logger.HIGH, "Leaving DeletedTable.getAllDeleted");
    return list;

View Full Code Here

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

    logger.log(logger.HIGH, "Leaving DeletedTable.getAllDeleted");
    return list;


  }
  public void expungeAllDeletedRecords() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("delete from DeletedItems");
  }

View Full Code Here

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

    logger = l;
    db = d;
  }
  // Create the table
  public void createTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
        // Create the NoteTag table
        logger.log(logger.HIGH, "Creating table NoteTags...");
        if (!query.exec("Create table NoteTags (noteGuid varchar, " +
            "tagGuid varchar, primary key(noteGuid, tagGuid))"))
          logger.log(logger.HIGH, "Table NoteTags creation FAILED!!!"); 
  }

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.