Examples of NSqlQuery

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

45
46
47
48
49
50
51
52
          logger.log(logger.HIGH, query.lastError());
        }  
  }
  // Drop the table
  public void dropTable() {
    NSqlQuery query = new NSqlQuery(db.getIndexConnection());
    query.exec("drop table words");
  }
View Full Code Here

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

50
51
52
53
54
55
56
57
58
59
60
    NSqlQuery query = new NSqlQuery(db.getIndexConnection());
    query.exec("drop table words");
  }
  // Count unindexed notes
  public int getWordCount() {
        NSqlQuery query = new NSqlQuery(db.getIndexConnection());
    query.exec("select count(*) from words");
    query.next();
    int returnValue = new Integer(query.valueString(0));
    return returnValue;
  }
View Full Code Here

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

59
60
61
62
63
64
65
66
67
68
69
70
    return returnValue;
  }

  // Clear out the word index table
  public void clearWordIndex() {
    NSqlQuery query = new NSqlQuery(db.getIndexConnection());
        logger.log(logger.HIGH, "DELETE FROM WORDS");
       
        boolean check = query.exec("DELETE FROM WORDS");
        if (!check)
          logger.log(logger.HIGH, "Table WORDS clear has FAILED!!!"); 
  } 
View Full Code Here

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

73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
  //********************************************************************************
  //* Support adding & deleting index words
  //********************************************************************************
  //********************************************************************************
  public void expungeFromWordIndex(String guid, String type) {
    NSqlQuery deleteWords = new NSqlQuery(db.getIndexConnection());
    if (!deleteWords.prepare("delete from words where guid=:guid and source=:source")) {
      logger.log(logger.EXTREME, "Note SQL select prepare deleteWords has failed.");
      logger.log(logger.MEDIUM, deleteWords.lastError());
    }
 
    deleteWords.bindValue(":guid", guid);
    deleteWords.bindValue(":source", type);
    deleteWords.exec();

  }
View Full Code Here

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

86
87
88
89
90
91
92
93
94
95
96
97
98
99
    deleteWords.exec();

  }
  // Expunge words
  public void expunge(String guid) {
    NSqlQuery deleteWords = new NSqlQuery(db.getIndexConnection());
    if (!deleteWords.prepare("delete from words where guid=:guid")) {
      logger.log(logger.EXTREME, "Word SQL select prepare expunge has failed.");
      logger.log(logger.MEDIUM, deleteWords.lastError());
    }
 
    deleteWords.bindValue(":guid", guid);
    deleteWords.exec();
  }
View Full Code Here

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

97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
    deleteWords.bindValue(":guid", guid);
    deleteWords.exec();
  }
  // Reindex a note
  public synchronized void addWordToNoteIndex(String guid, String word, String type, Integer weight) {
    NSqlQuery findWords = new NSqlQuery(db.getIndexConnection());
    if (!findWords.prepare("Select weight from words where guid=:guid and source=:type and word=:word")) {
        logger.log(logger.MEDIUM, "Prepare failed in addWordToNoteIndex()");
      logger.log(logger.MEDIUM, findWords.lastError());
    }
   
    findWords.bindValue(":guid", guid);
    findWords.bindValue(":type", type);
    findWords.bindValue(":word", word);
   
    boolean addNeeded = true;
    findWords.exec();
    // If we have a match, find out which has the heigher weight & update accordingly
    if (findWords.next()) {
      int recordWeight = new Integer(findWords.valueString(0));
      addNeeded = false;
      if (recordWeight < weight) {
        NSqlQuery updateWord = new NSqlQuery(db.getIndexConnection());
        if (!updateWord.prepare("Update words set weight=:weight where guid=:guid and source=:type and word=:word")) {
          logger.log(logger.MEDIUM, "Prepare failed for find words in addWordToNoteIndex()");
          logger.log(logger.MEDIUM, findWords.lastError());         
        }
       
        updateWord.bindValue(":weight", weight);
        updateWord.bindValue(":guid", guid);
        updateWord.bindValue(":type", type);
        updateWord.bindValue(":word",word);
        updateWord.exec();
      }
    }
   
   
    if (!addNeeded)
      return;
   
    NSqlQuery insertWords = new NSqlQuery(db.getIndexConnection());
    if (!insertWords.prepare("Insert Into Words (word, guid, weight, source)"
        +" Values(:word, :guid, :weight, :type )")) {
      logger.log(logger.EXTREME, "Note SQL select prepare checkWords has failed.");
      logger.log(logger.MEDIUM, insertWords.lastError());
    }
    insertWords.bindValue(":word", word);
    insertWords.bindValue(":guid", guid);
    insertWords.bindValue(":weight", weight);
    insertWords.bindValue(":type", type);
    if (!insertWords.exec()) {
      String err = insertWords.lastError();
      logger.log(logger.MEDIUM, "Error inserting words into index: " +err);
    }
  }
View Full Code Here

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

150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
    }
  }

  // Get a list of GUIDs in the table
  public List<String> getGuidList() {
    NSqlQuery query = new NSqlQuery(db.getIndexConnection());
        logger.log(logger.HIGH, "gedGuidList()");
       
        boolean check = query.exec("Select distinct guid from words");
        if (!check)
          logger.log(logger.HIGH, "Table WORDS select distinct guid has FAILED!!!"); 
       
        List<String> guids = new ArrayList<String>();
        while (query.next()) {
          guids.add(query.valueString(0));
        }
        return guids;
  } 
View Full Code Here

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

40
41
42
43
44
45
46
47
48
49
50
51
52
    logger = l;
    db = d;
  }
  // Create the table
  public void createTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
        logger.log(logger.HIGH, "Creating table SystemIcon...");
        if (!query.exec("Create table SystemIcon (name varchar, " +
            "type varchar, " +
            "primary key(name, type), " +
            "icon blob)"))             
          logger.log(logger.HIGH, "Table SystemIcon creation FAILED!!!");  
  }
View Full Code Here

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

50
51
52
53
54
55
56
57
            "icon blob)"))             
          logger.log(logger.HIGH, "Table SystemIcon creation FAILED!!!");  
  }
  // Drop the table
  public void dropTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("Drop table SystemIcon");
  }
View Full Code Here

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

57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
  }

 
  // Get the notebooks custom icon
  public QIcon getIcon(String name, String type) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    if (!query.prepare("Select icon from SystemIcon where name=:name and type=:type"))
      logger.log(logger.EXTREME, "Error preparing system icon select.");
    query.bindValue(":name", name);
    query.bindValue(":type", type);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error finding system icon.");
    if (!query.next() || query.getBlob(0) == null)
      return null;
   
    QByteArray blob = new QByteArray(query.getBlob(0));
    QIcon icon = new QIcon(QPixmap.fromImage(QImage.fromData(blob)));
    return icon;
  }
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.