Package cx.fbn.nevernote.sql.driver

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

79
80
81
82
83
84
85
86
87
88
89
    query.bindValue(":usn", tempNotebook.getUpdateSequenceNum());
    query.bindValue(":uri", tempNotebook.getUri());
    query.bindValue(":notebookGuid", "");
   
    if (isDirty)
      query.bindValue(":isDirty", true);
    else
      query.bindValue(":isDirty", false);

    check = query.exec();
    if (!check) {
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
    query.bindValue(":notebookGuid", "");
   
    if (isDirty)
      query.bindValue(":isDirty", true);
    else
      query.bindValue(":isDirty", false);

    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "LinkedNotebook Table insert failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
           +"where guid=:guid");
    if (!check) {
      logger.log(logger.EXTREME, "LinkedNotebook SQL delete prepare has failed.");
      logger.log(logger.EXTREME, query.lastError().toString());
    }
    query.bindValue(":guid", id);
    check = query.exec();
    if (!check)
      logger.log(logger.MEDIUM, "LinkedNotebook delete failed.");
   
    if  (needsSync) {
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
  }
  // Check if a notebook exists
  public boolean exists(String id) {
        NSqlQuery query = new NSqlQuery(db.getConnection());
         boolean check = query.prepare("Select guid from linkednotebook where guid=:guid");
         query.bindValue(":guid", id);
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "LinkedNotebook Table exists check failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
    }
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
   
        NSqlQuery query = new NSqlQuery(db.getConnection());
         check = query.prepare("Update LinkedNotebook set guid=:guid, shareName=:shareName, " +
             "username=:username, shardID=:shardID, uri=:uri, updateSequenceNumber=:usn, isDirty=:isDirty "+
             "where guid=:keyGuid");
    query.bindValue(":guid", tempNotebook.getGuid());
    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());
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
        NSqlQuery query = new NSqlQuery(db.getConnection());
         check = query.prepare("Update LinkedNotebook set guid=:guid, shareName=:shareName, " +
             "username=:username, shardID=:shardID, uri=:uri, updateSequenceNumber=:usn, isDirty=:isDirty "+
             "where guid=:keyGuid");
    query.bindValue(":guid", tempNotebook.getGuid());
    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());
View Full Code Here
153
154
155
156
157
158
159
160
161
162
163
         check = query.prepare("Update LinkedNotebook set guid=:guid, shareName=:shareName, " +
             "username=:username, shardID=:shardID, uri=:uri, updateSequenceNumber=:usn, isDirty=:isDirty "+
             "where guid=:keyGuid");
    query.bindValue(":guid", tempNotebook.getGuid());
    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());
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
             "username=:username, shardID=:shardID, uri=:uri, updateSequenceNumber=:usn, isDirty=:isDirty "+
             "where guid=:keyGuid");
    query.bindValue(":guid", tempNotebook.getGuid());
    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());
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
             "where guid=:keyGuid");
    query.bindValue(":guid", tempNotebook.getGuid());
    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);
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
    query.bindValue(":guid", tempNotebook.getGuid());
    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);
   
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.