Package cx.fbn.nevernote.sql.driver

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

77
78
79
80
81
82
83
84
85
86
87
  }
  // 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
78
79
80
81
82
83
84
85
86
87
88
  // 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
79
80
81
82
83
84
85
86
87
88
89
    List<String> notes = new ArrayList<String>();
   
    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;
    }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
    check = query.prepare("Select "
        +"NoteGuid, TagGuid from NoteTags where noteGuid = :noteGuid and tagGuid = :tagGuid");
    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.");
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
        +"NoteGuid, TagGuid from NoteTags where noteGuid = :noteGuid and tagGuid = :tagGuid");
    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());
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
        +"Values("
        +":noteGuid, :tagGuid)");
    if (!check)
      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.");   
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
        +":noteGuid, :tagGuid)");
    if (!check)
      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());
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
      logger.log(logger.MEDIUM, query.lastError());
    }
    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
161
162
163
164
165
166
167
168
169
170
171
    }
    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
176
177
178
179
180
181
182
183
184
185
186
    NSqlQuery query = new NSqlQuery(db.getConnection());
    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
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.