Package cx.fbn.nevernote.sql.driver

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

334
335
336
337
338
339
340
341
342
343
344
  public String setNotebookGuid(String shareKey, String notebookGuid) {
    
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update LinkedNotebook set notebookGuid=:notebookGuid where shareKey=:shareKey");
    query.bindValue(":notebookGuid", notebookGuid);
    query.bindValue(":shareKey", shareKey);
    if (!query.exec())
      logger.log(logger.EXTREME, "Linked notebook SQL retrieve by share name has failed.");
    String val = null;
    if (query.next())
View Full Code Here
335
336
337
338
339
340
341
342
343
344
345
    
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update LinkedNotebook set notebookGuid=:notebookGuid where shareKey=:shareKey");
    query.bindValue(":notebookGuid", notebookGuid);
    query.bindValue(":shareKey", shareKey);
    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);
View Full Code Here
349
350
351
352
353
354
355
356
357
358
359
  public String setLastSequenceDate(String guid, long date) {
    
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update LinkedNotebook set lastsequencedate=:date where guid=:guid");
    query.bindValue(":date", date);
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "Linked notebook SQL retrieve by share name has failed.");
    String val = null;
    if (query.next())
View Full Code Here
350
351
352
353
354
355
356
357
358
359
360
    
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update LinkedNotebook set lastsequencedate=:date where guid=:guid");
    query.bindValue(":date", date);
    query.bindValue(":guid", guid);
    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);
View Full Code Here
364
365
366
367
368
369
370
371
372
373
374
  public String setLastSequenceNumber(String guid, int number) {
    
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update LinkedNotebook set lastsequencenumber=:number where guid=:guid");
    query.bindValue(":number", number);
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "Linked notebook SQL retrieve by share name has failed.");
    String val = null;
    if (query.next())
View Full Code Here
365
366
367
368
369
370
371
372
373
374
375
    
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Update LinkedNotebook set lastsequencenumber=:number where guid=:guid");
    query.bindValue(":number", number);
    query.bindValue(":guid", guid);
    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);
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
        + "local, archived) Values("
        +":guid, :sequence, :name, :defaultNotebook,  "
        +":serviceCreated, :serviceUpdated, :published, "
        +":isDirty, :autoEncrypt, "
        +":local, false)");
    query.bindValue(":guid", newnote.getGuid());
    query.bindValue(":sequence", newnote.getUpdateSequenceNum());
    query.bindValue(":name", newnote.getName());
    query.bindValue(":defaultNotebook", newnote.isDefaultNotebook());
   
    StringBuilder serviceCreated = new StringBuilder(simple.format(newnote.getServiceCreated()));     
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
        +":guid, :sequence, :name, :defaultNotebook,  "
        +":serviceCreated, :serviceUpdated, :published, "
        +":isDirty, :autoEncrypt, "
        +":local, false)");
    query.bindValue(":guid", newnote.getGuid());
    query.bindValue(":sequence", newnote.getUpdateSequenceNum());
    query.bindValue(":name", newnote.getName());
    query.bindValue(":defaultNotebook", newnote.isDefaultNotebook());
   
    StringBuilder serviceCreated = new StringBuilder(simple.format(newnote.getServiceCreated()));     
    StringBuilder serviceUpdated = new StringBuilder(simple.format(newnote.getServiceUpdated()));
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
        +":serviceCreated, :serviceUpdated, :published, "
        +":isDirty, :autoEncrypt, "
        +":local, false)");
    query.bindValue(":guid", newnote.getGuid());
    query.bindValue(":sequence", newnote.getUpdateSequenceNum());
    query.bindValue(":name", newnote.getName());
    query.bindValue(":defaultNotebook", newnote.isDefaultNotebook());
   
    StringBuilder serviceCreated = new StringBuilder(simple.format(newnote.getServiceCreated()));     
    StringBuilder serviceUpdated = new StringBuilder(simple.format(newnote.getServiceUpdated()));
    if (serviceUpdated.toString() == null)
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
        +":isDirty, :autoEncrypt, "
        +":local, false)");
    query.bindValue(":guid", newnote.getGuid());
    query.bindValue(":sequence", newnote.getUpdateSequenceNum());
    query.bindValue(":name", newnote.getName());
    query.bindValue(":defaultNotebook", newnote.isDefaultNotebook());
   
    StringBuilder serviceCreated = new StringBuilder(simple.format(newnote.getServiceCreated()));     
    StringBuilder serviceUpdated = new StringBuilder(simple.format(newnote.getServiceUpdated()));
    if (serviceUpdated.toString() == null)
      serviceUpdated = serviceCreated;
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.