Package cx.fbn.nevernote.sql.driver

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

142
143
144
145
146
147
148
149
150
151
152
    }
    insertWords.bindValue(":word", word);
    insertWords.bindValue(":guid", guid);
    insertWords.bindValue(":weight", weight);
    insertWords.bindValue(":type", type);
    if (!insertWords.exec()) {
      String err = insertWords.lastError();
      logger.log(logger.MEDIUM, "Error inserting words into index: " +err);
    }
  }
View Full Code Here
153
154
155
156
157
158
159
160
161
162
163
  // Get a list of GUIDs in the table
  public List<String> getGuidList() {
    NSqlQuery query = new NSqlQuery(db.getIndexConnection());
        logger.log(logger.HIGH, "gedGuidList()");
       
        boolean check = query.exec("Select distinct guid from words");
        if (!check)
          logger.log(logger.HIGH, "Table WORDS select distinct guid has FAILED!!!"); 
       
        List<String> guids = new ArrayList<String>();
        while (query.next()) {
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
  }
  // Create the table
  public void createTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
        logger.log(logger.HIGH, "Creating table SystemIcon...");
        if (!query.exec("Create table SystemIcon (name varchar, " +
            "type varchar, " +
            "primary key(name, type), " +
            "icon blob)"))             
          logger.log(logger.HIGH, "Table SystemIcon creation FAILED!!!");  
  }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
          logger.log(logger.HIGH, "Table SystemIcon creation FAILED!!!");  
  }
  // Drop the table
  public void dropTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("Drop table SystemIcon");
  }

 
  // Get the notebooks custom icon
  public QIcon getIcon(String name, String type) {
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
   
    if (!query.prepare("Select icon from SystemIcon where name=:name and type=:type"))
      logger.log(logger.EXTREME, "Error preparing system icon select.");
    query.bindValue(":name", name);
    query.bindValue(":type", type);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error finding system icon.");
    if (!query.next() || query.getBlob(0) == null)
      return null;
   
    QByteArray blob = new QByteArray(query.getBlob(0));
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
   
    if (!query.prepare("Select icon from SystemIcon where name=:name and type=:type"))
      logger.log(logger.EXTREME, "Error preparing system icon select.");
    query.bindValue(":name", name);
    query.bindValue(":type", type);
    if (!query.exec())
      logger.log(logger.EXTREME, "Error finding system icon.");
    if (!query.next() || query.getBlob(0) == null)
      return false;
    return true;
  }
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
           else
             return;
    }
    query.bindValue(":name", name);
    query.bindValue(":type", rectype);
    if (!query.exec())
      logger.log(logger.LOW, "Error setting system icon. " +query.lastError());
  }
 
 
 
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
           else
             return;
    }
    query.bindValue(":name", name);
    query.bindValue(":type", rectype);
    if (!query.exec())
      logger.log(logger.LOW, "Error setting system icon. " +query.lastError());
  }

}
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
  }
  // Create the table
  public void createTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
        logger.log(logger.HIGH, "Creating table SharedNotebook...");
        if (!query.exec("Create table SharedNotebook (id long primary key, " +
            "userid Integer, " +
            "notebookGuid VarChar, "+
            "email VarChar, "+
            "notebookModifiable boolean, " +
            "requireLogin boolean, "+
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
          logger.log(logger.HIGH, "Table SharedNotebook creation FAILED!!!");  
  }
  // Drop the table
  public void dropTable() {
    NSqlQuery query = new NSqlQuery(db.getConnection());
    query.exec("Drop table SharedNotebook");
  }
  // Save an individual notebook
  public void addNotebook(SharedNotebook tempNotebook, boolean isDirty) {
    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.