Package cx.fbn.nevernote.sql.driver

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

269
270
271
272
273
274
275
276
277
278
279
        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);
    } 
View Full Code Here
286
287
288
289
290
291
292
293
294
295
296
        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);
    } 
View Full Code Here
304
305
306
307
308
309
310
311
312
313
314
        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);
    } 
View Full Code Here
320
321
322
323
324
325
326
327
328
329
330
    
    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
336
337
338
339
340
341
342
343
344
345
346
    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);
    return val;
View Full Code Here
351
352
353
354
355
356
357
358
359
360
361
    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);
    return val;
View Full Code Here
366
367
368
369
370
371
372
373
374
375
376
    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);
    return val;
View Full Code Here
380
381
382
383
384
385
386
387
388
389
390
  public List<String> getDirtyGuids() {
    List<String> index = new ArrayList<String>();
    boolean check; 
        NSqlQuery query = new NSqlQuery(db.getConnection());
               
    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));
    } 
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
      if (dbTableExists("NoteResources")) {
        // Begin migration of database
        NSqlQuery query = new NSqlQuery(resourceConn);
        String linkcmd = "create linked table oldnoteresources "+
            "('org.h2.Driver', '"+url+"', '"+userid+"', '"+passwordString+"', 'NoteResources')";
        query.exec(linkcmd);
        query.exec("insert into noteresources (select * from oldnoteresources)");
        query.exec("Drop table oldnoteresources;");
        query.exec("Update noteresources set indexneeded='true'");
       
      }
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
        // Begin migration of database
        NSqlQuery query = new NSqlQuery(resourceConn);
        String linkcmd = "create linked table oldnoteresources "+
            "('org.h2.Driver', '"+url+"', '"+userid+"', '"+passwordString+"', 'NoteResources')";
        query.exec(linkcmd);
        query.exec("insert into noteresources (select * from oldnoteresources)");
        query.exec("Drop table oldnoteresources;");
        query.exec("Update noteresources set indexneeded='true'");
       
      }
    }
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.