Package cx.fbn.nevernote.sql.driver

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

55
56
57
58
59
60
61
62
63
64
65
          logger.log(logger.HIGH, "Table SavedSearch creation FAILED!!!");
  }
  // Drop the table
  public void dropTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("Drop table SavedSearch");
  }
  // get all tags
  public List<SavedSearch> getAll() {
    SavedSearch tempSearch;
    List<SavedSearch> index = new ArrayList<SavedSearch>();
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
    List<SavedSearch> index = new ArrayList<SavedSearch>();
    boolean check;
           
        NSqlQuery query = new NSqlQuery(db.getConnection());
                       
    check = query.exec("Select guid, name, query, format, sequence"
        +" from SavedSearch");
    if (!check)
      logger.log(logger.EXTREME, "SavedSearch SQL retrieve has failed in getAll().");
    while (query.next()) {
      tempSearch = new SavedSearch();
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
    check = query.prepare("Select guid, name, query, format, sequence"
        +" from SavedSearch where guid=:guid");
    if (!check)
      logger.log(logger.EXTREME, "SavedSearch SQL prepare has failed in getSavedSearch.");
    query.bindValue(":guid", guid);
    query.exec();
    if (!check)
      logger.log(logger.EXTREME, "SavedSearch SQL retrieve has failed in getSavedSearch.");
    if (query.next()) {
      tempSearch = new SavedSearch();
      tempSearch.setGuid(query.valueString(0));
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
    else
      query.bindValue(":format", 2);
   
    query.bindValue(":guid", search.getGuid());
   
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "Tag Table update failed.");
      logger.log(logger.EXTREME, query.lastError().toString());
    }
  }
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
    if (!check) {
      logger.log(logger.EXTREME, "SavedSearch SQL delete prepare has failed.");
      logger.log(logger.EXTREME, query.lastError().toString());
    }
    query.bindValue(":guid", guid);
    check = query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "Saved Search delete failed.");
      logger.log(logger.EXTREME, query.lastError().toString());
    }
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
    else
      query.bindValue(":format", 2);
    query.bindValue(":name", search.getName());
    query.bindValue(":isDirty", isDirty);
 
    check = query.exec();
    if  (!check) {
      logger.log(logger.MEDIUM, "Search Table insert failed.");
      logger.log(logger.MEDIUM, query.lastError().toString());
    }
  }
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
     ;
        NSqlQuery query = new NSqlQuery(db.getConnection());
    check = query.prepare("Update SavedSearch set sequence=:sequence where guid=:guid");
    query.bindValue(":sequence", sequence);
    query.bindValue(":guid", guid);
    query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "SavedSearch sequence update failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
  }
View Full Code Here
215
216
217
218
219
220
221
222
223
224
225
    boolean check;
        NSqlQuery query = new NSqlQuery(db.getConnection());
    check = query.prepare("Update SavedSearch set guid=:newGuid where guid=:oldGuid");
    query.bindValue(":newGuid", newGuid);
    query.bindValue(":oldGuid", oldGuid);
    query.exec();
    if (!check) {
      logger.log(logger.MEDIUM, "SavedSearch guid update failed.");
      logger.log(logger.MEDIUM, query.lastError());
    }
  }
View Full Code Here
813
814
815
816
817
818
819
820
821
822
823
  public boolean stackExists(String stack) {
    NSqlQuery query = new NSqlQuery(db.getConnection());
   
    query.prepare("Select guid from "+dbName+" where stack=:stack limit 1");
    query.bindValue(":stack", stack);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error setting "+dbName+" stack.");
    if (query.next())
      return true;
    else
      return false;
View Full Code Here
836
837
838
839
840
841
842
843
844
845
846
        query.bindValue(":publishingOrder", p.getOrder().getValue());
    query.bindValue(":publishingAscending", p.isAscending());
    query.bindValue(":publishingPublicDescription", p.getPublicDescription());
    query.bindValue(":published", published);
    query.bindValue(":guid", guid);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error setting "+dbName+" stack.");
  }
  // Get a notebook by uri
  public String getNotebookByUri(String uri) {
    boolean check;
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.