X-Git-Url: http://git.sourceforge.jp/view?p=neighbornote%2FNeighborNote.git;a=blobdiff_plain;f=src%2Fcx%2Ffbn%2Fnevernote%2Fsql%2FSyncTable.java;h=21f90ea879ca70c5779a95cebf18b097a68e12fd;hp=092609b65234155525006f8103c8bdd64eb41065;hb=8a07f5da9560792e75e4f85dd6bb1d096519b975;hpb=1927e5bfe9782fae40364961f6a4f9c61cf88275

diff --git a/src/cx/fbn/nevernote/sql/SyncTable.java b/src/cx/fbn/nevernote/sql/SyncTable.java
index 092609b..21f90ea 100644
--- a/src/cx/fbn/nevernote/sql/SyncTable.java
+++ b/src/cx/fbn/nevernote/sql/SyncTable.java
@@ -20,6 +20,9 @@
 
 package cx.fbn.nevernote.sql;
 
+import java.util.ArrayList;
+import java.util.List;
+
 import cx.fbn.nevernote.sql.driver.NSqlQuery;
 import cx.fbn.nevernote.utilities.ApplicationLogger;
 import cx.fbn.nevernote.utilities.ListManager;
@@ -70,7 +73,7 @@ public class SyncTable {
 			logger.log(logger.MEDIUM, query.lastError());
 		}
 	}
-	// Set a key field
+	// Get a key field
 	public String getRecord(String key) {
         NSqlQuery query = new NSqlQuery(db.getConnection());
         query.prepare("Select value from Sync where key=:key");
@@ -114,7 +117,23 @@ public class SyncTable {
 	public int getUpdateSequenceNumber() {
 		return new Integer(getRecord("UpdateSequenceNumber"));
 	}
-	
-
+	// Get notebooks/tags to ignore
+	public List<String> getIgnoreRecords(String type) {
+		List<String> values = new ArrayList<String>();
+        NSqlQuery query = new NSqlQuery(db.getConnection());
+        if (!query.prepare("Select value from Sync where key like :type")) {
+			logger.log(logger.MEDIUM, "getIgnoreRecords from sync failed.");
+			logger.log(logger.MEDIUM, query.lastError());
+			return null;
+		}
+        query.bindValue(":type", "IGNORE" +type +"-%");
+        query.exec();
+		while (query.next()) {
+			values.add(query.valueString(0));
+		}
+ 		return values;
+	}
+	// Expunge ignore records
+	// Add an item to the table
 
 }