Package cx.fbn.nevernote.sql.driver

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

101
102
103
104
105
106
107
108
109
    return list;

  }
  public void expungeAllDeletedRecords() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("delete from DeletedItems");
  }

}
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
  // Create the table
  public void createTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
        // Create the NoteTag table
        logger.log(logger.HIGH, "Creating table NoteTags...");
        if (!query.exec("Create table NoteTags (noteGuid varchar, " +
            "tagGuid varchar, primary key(noteGuid, tagGuid))"))
          logger.log(logger.HIGH, "Table NoteTags creation FAILED!!!");
  }
  // Drop the table
  public void dropTable() {
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
          logger.log(logger.HIGH, "Table NoteTags creation FAILED!!!");
  }
  // Drop the table
  public void dropTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("drop table NoteTags");
  }
  // Get a note tags by the note's Guid
  public List<String> getNoteTags(String noteGuid) {
    if (noteGuid == null)
      return null;
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
   
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.prepare("Select NoteGuid from NoteTags where tagGuid = :guid");
   
    query.bindValue(":guid", tagGuid);
    if (!query.exec()) {
      logger.log(logger.EXTREME, "getTagNotes SQL select has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return notes;
    }
    while (query.next()) {
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
  // Get a note tags by the note's Guid
  public List<NoteTagsRecord> getAllNoteTags() {
    List<NoteTagsRecord> tags = new ArrayList<NoteTagsRecord>();
   
    NSqlQuery query = new NSqlQuery(db.getConnection());
    if (!query.exec("Select TagGuid, NoteGuid from NoteTags")) {
      logger.log(logger.EXTREME, "NoteTags SQL select has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    while (query.next()) {
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
    if (!check)
      logger.log(logger.EXTREME, "checkNoteTags SQL prepare has failed.");
   
    query.bindValue(":noteGuid", noteGuid);
    query.bindValue(":tagGuid", tagGuid);
    query.exec();
   
    if (!check) {
      logger.log(logger.EXTREME, "checkNoteTags SQL select has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return false;
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
      logger.log(logger.EXTREME, "Note SQL insert prepare has failed.");
 
    query.bindValue(":noteGuid", noteGuid);
    query.bindValue(":tagGuid", tagGuid);
           
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "NoteTags Table insert failed.");   
      logger.log(logger.MEDIUM, query.lastError());
    }
    check = query.prepare("Update Note set isDirty=:isDirty where guid=:guid");
View Full Code Here
162
163
164
165
166
167
168
169
170
171
172
    check = query.prepare("Update Note set isDirty=:isDirty where guid=:guid");
    if (!check)
      logger.log(logger.EXTREME, "RNoteTagsTable.saveNoteTag prepare has failed.");
    query.bindValue(":isDirty", isDirty);
    query.bindValue(":guid", noteGuid);
    query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "RNoteTagsTable.saveNoteTag has failed to set note as dirty.");   
      logger.log(logger.MEDIUM, query.lastError());
    }
  }
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
    check = query.prepare("Delete from NoteTags where noteGuid = :noteGuid");
    if (!check)
      logger.log(logger.EXTREME, "Note SQL delete prepare has failed.");
 
    query.bindValue(":noteGuid", noteGuid);
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "NoteTags Table delete failed.");   
      logger.log(logger.MEDIUM, query.lastError());
    }
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
  }
  // Get a note tag counts
  public List<Pair<String,Integer>> getTagCounts() {
    List<Pair<String,Integer>> counts = new ArrayList<Pair<String,Integer>>();   
    NSqlQuery query = new NSqlQuery(db.getConnection());
    if (!query.exec("select tagguid, count(noteguid) from notetags group by tagguid;")) {
      logger.log(logger.EXTREME, "NoteTags SQL getTagCounts has failed.");
      logger.log(logger.MEDIUM, query.lastError());
      return null;
    }
    while (query.next()) {
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.