+ public InkImagesTable getInkImagesTable() {
+ return inkImagesTable;
+ }
+
+ // ICHANGED
+ public HistoryTable getHistoryTable() {
+ return historyTable;
+ }
+
+ // ICHANGED
+ public ExcludedTable getExcludedTable() {
+ return excludedTable;
+ }
+
+ // ICHANGED
+ public StaredTable getStaredTable() {
+ return staredTable;
+ }
+
+ //****************************************************************
+ //* Begin/End transactions
+ //****************************************************************
+ public void beginTransaction() {
+ commitTransaction();
+ NSqlQuery query = new NSqlQuery(getConnection());
+ if (!query.exec("Begin Transaction"))
+ logger.log(logger.EXTREME, "Begin transaction has failed: " +query.lastError());
+
+ }
+ public void commitTransaction() {
+ NSqlQuery query = new NSqlQuery(getConnection());
+
+ if (!query.exec("Commit"))
+ logger.log(logger.EXTREME, "Transaction commit has failed: " +query.lastError());
+ }
+
+ //****************************************************************
+ //* Check if a table exists
+ //****************************************************************
+ public boolean dbTableExists(String name) {
+ NSqlQuery query = new NSqlQuery(getConnection());
+ query.prepare("select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME=:name");
+ query.bindValue(":name", name.toUpperCase());
+ query.exec();
+ if (query.next())
+ return true;
+ else
+ return false;
+ }
+
+ //****************************************************************
+ //* Check if a row in a table exists
+ //****************************************************************
+ public boolean dbTableColumnExists(String tableName, String columnName) {
+ NSqlQuery query = new NSqlQuery(getConnection());
+ query.prepare("select TABLE_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=:name and COLUMN_NAME=:column");
+ query.bindValue(":name", tableName.toUpperCase());
+ query.bindValue(":column", columnName);
+ query.exec();
+ if (query.next())
+ return true;
+ else
+ return false;
+ }