Package cx.fbn.nevernote.sql.driver

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

78
79
80
81
82
83
84
85
86
87
88
    query.bindValue(":id", tempNotebook.getId());
    query.bindValue(":userid", tempNotebook.getUserId());
    query.bindValue(":notebookGuid", tempNotebook.getNotebookGuid());
    query.bindValue(":email", tempNotebook.getEmail());
    query.bindValue(":notebookModifiable", tempNotebook.isNotebookModifiable());
    query.bindValue(":requireLogin", tempNotebook.isRequireLogin());

    StringBuilder serviceCreated = new StringBuilder(simple.format(tempNotebook.getServiceCreated()));     
    query.bindValue(":serviceCreated", serviceCreated.toString());
   
    query.bindValue(":shareKey", tempNotebook.getShareKey());
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
    query.bindValue(":email", tempNotebook.getEmail());
    query.bindValue(":notebookModifiable", tempNotebook.isNotebookModifiable());
    query.bindValue(":requireLogin", tempNotebook.isRequireLogin());

    StringBuilder serviceCreated = new StringBuilder(simple.format(tempNotebook.getServiceCreated()));     
    query.bindValue(":serviceCreated", serviceCreated.toString());
   
    query.bindValue(":shareKey", tempNotebook.getShareKey());
    query.bindValue(":username", tempNotebook.getUsername());
   
    if (isDirty)
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
    query.bindValue(":requireLogin", tempNotebook.isRequireLogin());

    StringBuilder serviceCreated = new StringBuilder(simple.format(tempNotebook.getServiceCreated()));     
    query.bindValue(":serviceCreated", serviceCreated.toString());
   
    query.bindValue(":shareKey", tempNotebook.getShareKey());
    query.bindValue(":username", tempNotebook.getUsername());
   
    if (isDirty)
      query.bindValue(":isDirty", true);
    else
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
    StringBuilder serviceCreated = new StringBuilder(simple.format(tempNotebook.getServiceCreated()));     
    query.bindValue(":serviceCreated", serviceCreated.toString());
   
    query.bindValue(":shareKey", tempNotebook.getShareKey());
    query.bindValue(":username", tempNotebook.getUsername());
   
    if (isDirty)
      query.bindValue(":isDirty", true);
    else
      query.bindValue(":isDirty", false);
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
   
    query.bindValue(":shareKey", tempNotebook.getShareKey());
    query.bindValue(":username", tempNotebook.getUsername());
   
    if (isDirty)
      query.bindValue(":isDirty", true);
    else
      query.bindValue(":isDirty", false);

    check = query.exec();
    if (!check) {
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
    query.bindValue(":username", tempNotebook.getUsername());
   
    if (isDirty)
      query.bindValue(":isDirty", true);
    else
      query.bindValue(":isDirty", false);

    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "SharedNotebook Table insert failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
  // Check if a notebook exists
  public boolean exists(long id) {
        NSqlQuery query = new NSqlQuery(db.getConnection());
        logger.log(logger.EXTREME, "Checking if shared notebook " +id +" exists");
         boolean check = query.prepare("Select id from sharednotebook where id=:id");
         query.bindValue(":id", id);
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "SharedNotebook Table exists check failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
    }
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
           +"where id=:id");
    if (!check) {
      logger.log(logger.EXTREME, "SharedNotebook SQL delete prepare has failed.");
      logger.log(logger.EXTREME, query.lastError().toString());
    }
    query.bindValue(":id", id);
    check = query.exec();
    if (!check)
      logger.log(logger.MEDIUM, "SharedNotebook delete failed.");
   
    // Signal the parent that work needs to be done
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
           +"where guid=:id");
    if (!check) {
      logger.log(logger.EXTREME, "SharedNotebook SQL delete by notebook guid prepare has failed.");
      logger.log(logger.EXTREME, query.lastError().toString());
    }
    query.bindValue(":id", id);
    check = query.exec();
    if (!check)
      logger.log(logger.MEDIUM, "SharedNotebook delete by notebook guid failed.");
   
    // Signal the parent that work needs to be done
View Full Code Here
196
197
198
199
200
201
202
203
204
205
206
    StringBuilder serviceCreated = new StringBuilder(simple.format(tempNotebook.getServiceCreated()));           
        NSqlQuery query = new NSqlQuery(db.getConnection());
         check = query.prepare("Update SharedNotebook set userid=:userid, notebookGuid=:notebook, "
             + "email=:email, notebookModifiable=:mod, requireLogin=:rlogin, serviceCreated=:serviceCreated, "
             + "shareKey=:shareKey, username=:username, isDirty=:isdirty where id=:id");
    query.bindValue(":id", tempNotebook.getId());
    query.bindValue(":userid", tempNotebook.getUserId());
    query.bindValue(":notebook", tempNotebook.getNotebookGuid());
    query.bindValue(":email", tempNotebook.getEmail());
    query.bindValue(":mod", tempNotebook.isNotebookModifiable());
    query.bindValue(":rlogin", tempNotebook.isRequireLogin());
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.