Package cx.fbn.nevernote.sql.driver

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

91
92
93
94
95
96
97
98
99
100
101
    List<DeletedItemRecord> list = new ArrayList<DeletedItemRecord>();
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("Select guid, type from DeletedItems");
    while (query.next()) {
      DeletedItemRecord record = new DeletedItemRecord();
      record.guid = query.valueString(0);
      record.type = query.valueString(1);
      list.add(record);
    }
    logger.log(logger.HIGH, "Leaving DeletedTable.getAllDeleted");
    return list;
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("Select guid, type from DeletedItems");
    while (query.next()) {
      DeletedItemRecord record = new DeletedItemRecord();
      record.guid = query.valueString(0);
      record.type = query.valueString(1);
      list.add(record);
    }
    logger.log(logger.HIGH, "Leaving DeletedTable.getAllDeleted");
    return list;
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
      logger.log(logger.EXTREME, "getTagNotes SQL select has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return notes;
    }
    while (query.next()) {
      notes.add(query.valueString(0));
    } 
    return notes;
  }
  void prepareGetNoteTagsQuery() {
    getNoteTagsQuery = new NSqlQuery(db.getConnection());
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    while (query.next()) {
      NoteTagsRecord record = new NoteTagsRecord();
      record.tagGuid = query.valueString(0);
      record.noteGuid = query.valueString(1);
      tags.add(record);
    } 
    return tags;
  }
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
      return null;
    }
    while (query.next()) {
      NoteTagsRecord record = new NoteTagsRecord();
      record.tagGuid = query.valueString(0);
      record.noteGuid = query.valueString(1);
      tags.add(record);
    } 
    return tags;
  }
  // Check if a note has a specific tag already
View Full Code Here
195
196
197
198
199
200
201
202
203
204
205
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    while (query.next()) {
      Pair<String,Integer> newCount = new Pair<String,Integer>();
      newCount.setFirst(query.valueString(0));
      newCount.setSecond(query.valueInteger(1));
      counts.add(newCount);
    } 
    return counts;
  }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
  // 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;
  }

  // Clear out the word index table
  public void clearWordIndex() {
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
   
    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()");
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
        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
182
183
184
185
186
187
188
189
190
191
192
        " from LinkedNotebook");
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve has failed.");
    while (query.next()) {
      tempNotebook = new LinkedNotebook();
      tempNotebook.setGuid(query.valueString(0));
      tempNotebook.setShareName(query.valueString(1));
      tempNotebook.setUsername(query.valueString(2));
      tempNotebook.setShardId(query.valueString(3));
      tempNotebook.setShareKey(query.valueString(4));
      tempNotebook.setUri(query.valueString(5));
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.