Package cx.fbn.nevernote.sql.driver

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

157
158
159
160
161
162
163
164
165
166
167
    query.bindValue(":keyGuid", tempNotebook.getGuid());
    query.bindValue(":shareName", tempNotebook.getShareName());
    query.bindValue(":username", tempNotebook.getUsername());
    query.bindValue(":shardID", tempNotebook.getShardId());
    query.bindValue(":shareKey", tempNotebook.getShareKey());
    query.bindValue(":uri", tempNotebook.getUri());
    query.bindValue(":usn", tempNotebook.getUpdateSequenceNum());

    query.bindValue(":isDirty", isDirty);
   
    check = query.exec();
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
    query.bindValue(":shareName", tempNotebook.getShareName());
    query.bindValue(":username", tempNotebook.getUsername());
    query.bindValue(":shardID", tempNotebook.getShardId());
    query.bindValue(":shareKey", tempNotebook.getShareKey());
    query.bindValue(":uri", tempNotebook.getUri());
    query.bindValue(":usn", tempNotebook.getUpdateSequenceNum());

    query.bindValue(":isDirty", isDirty);
   
    check = query.exec();
    if (!check) {
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
    query.bindValue(":shardID", tempNotebook.getShardId());
    query.bindValue(":shareKey", tempNotebook.getShareKey());
    query.bindValue(":uri", tempNotebook.getUri());
    query.bindValue(":usn", tempNotebook.getUpdateSequenceNum());

    query.bindValue(":isDirty", isDirty);
   
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "LinkedNotebook Table update failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
View Full Code Here
204
205
206
207
208
209
210
211
212
213
214
               
    check = query.prepare("Select guid, shareName, username, shardID, shareKey, uri " +
        " from LinkedNotebook where guid=:guid");
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve notebook prepare has failed.");
    query.bindValue(":guid", guid);
    query.exec();
    while (query.next()) {
      tempNotebook = new LinkedNotebook();
      tempNotebook.setGuid(query.valueString(0));
      tempNotebook.setShareName(query.valueString(1));
View Full Code Here
229
230
231
232
233
234
235
236
237
238
239
               
    check = query.prepare("Select guid, shareName, username, shardID, shareKey, uri " +
        " from LinkedNotebook where notebookguid=:guid");
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve notebook prepare has failed.");
    query.bindValue(":guid", guid);
    query.exec();
    while (query.next()) {
      tempNotebook = new LinkedNotebook();
      tempNotebook.setGuid(query.valueString(0));
      tempNotebook.setShareName(query.valueString(1));
View Full Code Here
251
252
253
254
255
256
257
258
259
260
261
         
        NSqlQuery query = new NSqlQuery(db.getConnection());
               
    check = query.prepare("Select LastSequenceDate "
        +"from LinkedNotebook where guid=:guid");
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "LinkedNotebook SQL retrieve last sequence date has failed.");
    if (query.next()) {
      return query.valueLong(0);
View Full Code Here
268
269
270
271
272
273
274
275
276
277
278
         
        NSqlQuery query = new NSqlQuery(db.getConnection());
               
    check = query.prepare("Select notebookGuid "
        +"from LinkedNotebook where guid=:guid");
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "LinkedNotebook SQL retrieve of notebookguid by guidhas failed.");
    if (query.next()) {
      return query.valueString(0);
View Full Code Here
285
286
287
288
289
290
291
292
293
294
295
         
        NSqlQuery query = new NSqlQuery(db.getConnection());
               
    check = query.prepare("Select LastSequenceNumber "
        +"from LinkedNotebook where guid=:guid");
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve has failed.");
    while (query.next()) {
      return query.valueInteger(0);
View Full Code Here
303
304
305
306
307
308
309
310
311
312
313
         
        NSqlQuery query = new NSqlQuery(db.getConnection());
               
    check = query.prepare("Select notebookGuid "
        +"from LinkedNotebook where guid=:guid");
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check)
      logger.log(logger.EXTREME, "Notebook SQL retrieve has failed.");
    while (query.next()) {
      return query.valueString(0);
View Full Code Here
319
320
321
322
323
324
325
326
327
328
329
  public String findNotebookByShareName(String name) {
    
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Select guid from Linkednotebook where shareName=:name");
    query.bindValue(":name", name);
    if (!query.exec())
      logger.log(logger.EXTREME, "Linked notebook SQL retrieve by share name has failed.");
    String val = null;
    if (query.next())
      val = query.valueString(0);
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.