Package cx.fbn.nevernote.sql.driver

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

962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
   
  }
  // Given a notebook, what tags are valid for it?
  public void deleteLinkedTags(String guid) {
   
        NSqlQuery query = new NSqlQuery(db.getConnection());              
    query.prepare("select distinct tagguid from noteTags " +
        "where noteGuid in " +
        "(SELECT guid from note where notebookguid=:guid)");
    query.bindValue(":guid", guid);
    boolean check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL getValidLinedTags failed.");
    while(query.next()) {
      db.getTagTable().expungeTag(query.valueString(0), false);
    }
   
   
    query.prepare("delete from note " +
        "where notebookguid=:guid");
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL getValidLinedTags failed.");

   
    return;
View Full Code Here
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
  }
 
  // Given a notebook, what tags are valid for it?
  public void convertFromSharedNotebook(String guid, boolean local) {
   
        NSqlQuery query = new NSqlQuery(db.getConnection()); 
       
        query.prepare("Update Notebook set sequence=0, published=false, isdirty=true, local=:local, publishinguri=''"
        +" where guid=:guid");
    query.bindValue(":guid", guid);
    if (local)
      query.bindValue(":local", true);
    else
      query.bindValue(":local", false);
   
    if (!query.exec())
      logger.log(logger.EXTREME, "NotebookTable.convertToLocalNotebook error.");
   
        query.prepare("Update Note set updatesequencenumber=0, isdirty=true"
        +" where notebookguid=:guid");
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "NotebookTable.convertToLocalNotebook #2 error.");
     
    return;
   
   
View Full Code Here
38
39
40
41
42
43
44
45
46
47
    logger = l;
    db = d;
  }
  // Create the table
  public void createTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    logger.log(logger.HIGH, "Creating table DeletedItems...");
        if (!query.exec("Create table DeletedItems (guid varchar primary key, type varchar)"))
             logger.log(logger.HIGH, "Table DeletedItems creation FAILED!!!");
  }
View Full Code Here
45
46
47
48
49
50
51
52
        if (!query.exec("Create table DeletedItems (guid varchar primary key, type varchar)"))
             logger.log(logger.HIGH, "Table DeletedItems creation FAILED!!!");
  }
  // Drop the table
  public void dropTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("Drop table DeletedItems");
  }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
63
64
65
  }
  // Add an item to the deleted table
  public void addDeletedItem(String guid, String type) {
    if (exists(guid,type))
      return;
        NSqlQuery query = new NSqlQuery(db.getConnection());
    query.prepare("Insert Into DeletedItems (guid, type) Values(:guid, :type)");
    query.bindValue(":guid", guid);
    query.bindValue(":type", type);
    if (!query.exec()) {
      logger.log(logger.MEDIUM, "Insert into deleted items failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
  }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
      logger.log(logger.MEDIUM, query.lastError());
    }
  }
  // Check if a record exists
  public boolean exists(String guid, String type) {
        NSqlQuery query = new NSqlQuery(db.getConnection());
    query.prepare("Select guid, type from DeletedItems where guid=:guid and type=:type");
    query.bindValue(":guid", guid);
    query.bindValue(":type", type);
    query.exec();
    if (!query.next()) {
      return false;
    }
    return true;
  }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
88
    }
    return true;
  }
  // Add an item to the deleted table
  public void expungeDeletedItem(String guid, String type) {
        NSqlQuery query = new NSqlQuery(db.getConnection());
    query.prepare("delete from DeletedItems where guid=:guid and type=:type");
    query.bindValue(":guid", guid);
    query.bindValue(":type", type);
    if (!query.exec()) {
      logger.log(logger.LOW, "Expunge deleted items failed.");
      logger.log(logger.LOW, query.lastError());
    }
  }
View Full Code Here
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
  public List <Notebook> getDirty() {
    Notebook tempNotebook;
    List<Notebook> index = new ArrayList<Notebook>();
    boolean check;
           
        NSqlQuery query = new NSqlQuery(db.getConnection());
               
    check = query.exec("Select guid, sequence, name, defaultNotebook, " +
        "serviceCreated, serviceUpdated, published, stack, "+
        "publishinguri, publishingascending, publishingPublicDescription, "+
        "publishingOrder " +
        "from "+dbName+" where isDirty=true and local=false and linked=false");
    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));
     
      DateFormat indfm = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");
      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)));
      if (query.valueString(7) != null && !query.valueString(7).trim().equals(""))
        tempNotebook.setStack(query.valueString(7));
     
      if (tempNotebook.isPublished()) {
        Publishing p = new Publishing();
        p.setUri(query.valueString(8));
        p.setAscending(query.valueBoolean(9, false));
        p.setPublicDescription(query.valueString(10));
        p.setOrder(NoteSortOrder.findByValue(query.valueInteger(11)));
        if (p.getPublicDescription() != null && p.getPublicDescription().trim().equalsIgnoreCase(""))
          p.setPublicDescription(null);
        tempNotebook.setPublishing(p);
      }
     
View Full Code Here
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
  // Get a list of notes that need to be updated
  public Notebook getNotebook(String guid) {
    Notebook tempNotebook;
    boolean check;
           
        NSqlQuery query = new NSqlQuery(db.getConnection());
               
    query.prepare("Select guid, sequence, name, defaultNotebook, " +
        "serviceCreated, serviceUpdated, published, stack, "+
        "publishinguri, publishingascending, publishingPublicDescription, "+
        "publishingOrder " +
        "from "+dbName+" where guid=:guid");
    query.bindValue(":guid", guid);
    check  = query.exec();
    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));
     
      DateFormat indfm = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");
      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)));
      if (query.valueString(7) != null && !query.valueString(7).trim().equals(""))
        tempNotebook.setStack(query.valueString(7));
     
      if (tempNotebook.isPublished()) {
        Publishing p = new Publishing();
        p.setUri(query.valueString(8));
        p.setAscending(query.valueBoolean(9, false));
        p.setPublicDescription(query.valueString(10));
        p.setOrder(NoteSortOrder.findByValue(query.valueInteger(11)));
        if (p.getPublicDescription() != null && p.getPublicDescription().trim().equalsIgnoreCase(""))
          p.setPublicDescription(null);
        tempNotebook.setPublishing(p);
      }
     
View Full Code Here
591
592
593
594
595
596
597
598
599
600
601
602
603
604
    updateNotebook(notebook, isDirty);
  }
  // does a record exist?
  private boolean exists(String guid) {
    
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Select guid from "+dbName+" where guid=:guid");
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, dbName+" SQL retrieve has failed.");
    boolean retval = query.next();
    return retval;
  }
View Full Code Here
TOP

Related Classes of cx.fbn.nevernote.sql.driver.NSqlQuery

  • cx.fbn.nevernote.sql.DatabaseConnection
  • cx.fbn.nevernote.sql.DeletedTable
  • cx.fbn.nevernote.sql.InkImagesTable
  • cx.fbn.nevernote.sql.InvalidXMLTable
  • cx.fbn.nevernote.sql.LinkedNotebookTable
  • cx.fbn.nevernote.sql.NotebookTable
  • cx.fbn.nevernote.sql.NoteResourceTable
  • cx.fbn.nevernote.sql.NoteTable
  • cx.fbn.nevernote.sql.NoteTagsTable
  • cx.fbn.nevernote.sql.REnSearch
    • Copyright © 2018 www.massapicom. 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.