Package cx.fbn.nevernote.sql.driver

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

340
341
342
343
344
345
346
347
348
349
350
    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);
    return val;
  }
  // set sync date
  public String setLastSequenceDate(String guid, long date) {
    
View Full Code Here
355
356
357
358
359
360
361
362
363
364
365
    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);
    return val;
  }
  // set sync number
  public String setLastSequenceNumber(String guid, int number) {
    
View Full Code Here
370
371
372
373
374
375
376
377
378
379
380
    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);
    return val;
  }
 
  // Get a list of linked notebooks that need to be updated
  public List<String> getDirtyGuids() {
View Full Code Here
384
385
386
387
388
389
390
391
392
393
394
               
    check = query.exec("Select guid from LinkedNotebook where isDirty = true");
    if (!check)
      logger.log(logger.EXTREME, "LinkedNotebook SQL retrieve has failed in getdirtyIds.");
    while (query.next()) {
      index.add(query.valueString(0));
    } 
    return index; 
  }

}
View Full Code Here
274
275
276
277
278
279
280
281
282
283
284
        "publishingOrder from "+dbName+" order by name");
    if (!check)
      logger.log(logger.EXTREME, dbName+" SQL retrieve has failed.");
    while (query.next()) {
      tempNotebook = new Notebook();
      tempNotebook.setGuid(query.valueString(0));
      int sequence = new Integer(query.valueString(1)).intValue();
      tempNotebook.setUpdateSequenceNum(sequence);
      tempNotebook.setName(query.valueString(2));
      tempNotebook.setDefaultNotebook(query.valueBoolean(3, false));
      DateFormat indfm = null;
View Full Code Here
275
276
277
278
279
280
281
282
283
284
285
    if (!check)
      logger.log(logger.EXTREME, dbName+" SQL retrieve has failed.");
    while (query.next()) {
      tempNotebook = new Notebook();
      tempNotebook.setGuid(query.valueString(0));
      int sequence = new Integer(query.valueString(1)).intValue();
      tempNotebook.setUpdateSequenceNum(sequence);
      tempNotebook.setName(query.valueString(2));
      tempNotebook.setDefaultNotebook(query.valueBoolean(3, false));
      DateFormat indfm = null;
      try {
View Full Code Here
277
278
279
280
281
282
283
284
285
286
287
    while (query.next()) {
      tempNotebook = new Notebook();
      tempNotebook.setGuid(query.valueString(0));
      int sequence = new Integer(query.valueString(1)).intValue();
      tempNotebook.setUpdateSequenceNum(sequence);
      tempNotebook.setName(query.valueString(2));
      tempNotebook.setDefaultNotebook(query.valueBoolean(3, false));
      DateFormat indfm = null;
      try {
        indfm = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");
//        indfm = new SimpleDateFormat("EEE MMM dd HH:mm:ss yyyy");
View Full Code Here
285
286
287
288
289
290
291
292
293
294
295
      try {
        indfm = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");
//        indfm = new SimpleDateFormat("EEE MMM dd HH:mm:ss yyyy");
      } catch (Exception e) {  }
      try {
        tempNotebook.setServiceCreated(indfm.parse(query.valueString(4)).getTime());
        tempNotebook.setServiceUpdated(indfm.parse(query.valueString(5)).getTime());
      } catch (ParseException e) {
        e.printStackTrace();
      }
      tempNotebook.setPublished(new Boolean(query.valueString(6)));
View Full Code Here
286
287
288
289
290
291
292
293
294
295
296
        indfm = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");
//        indfm = new SimpleDateFormat("EEE MMM dd HH:mm:ss yyyy");
      } catch (Exception e) {  }
      try {
        tempNotebook.setServiceCreated(indfm.parse(query.valueString(4)).getTime());
        tempNotebook.setServiceUpdated(indfm.parse(query.valueString(5)).getTime());
      } catch (ParseException e) {
        e.printStackTrace();
      }
      tempNotebook.setPublished(new Boolean(query.valueString(6)));
      tempNotebook.setStack(query.valueString(7));
View Full Code Here
290
291
292
293
294
295
296
297
298
299
300
        tempNotebook.setServiceCreated(indfm.parse(query.valueString(4)).getTime());
        tempNotebook.setServiceUpdated(indfm.parse(query.valueString(5)).getTime());
      } catch (ParseException e) {
        e.printStackTrace();
      }
      tempNotebook.setPublished(new Boolean(query.valueString(6)));
      tempNotebook.setStack(query.valueString(7));
      if (tempNotebook.isPublished()) {
        Publishing p = new Publishing();
        p.setUri(query.valueString(8));
        p.setAscending(query.valueBoolean(9, false));
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.