diff options
-rw-r--r-- | src/main/Analyzor.java | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/src/main/Analyzor.java b/src/main/Analyzor.java index b2aad4d..6e6ca67 100644 --- a/src/main/Analyzor.java +++ b/src/main/Analyzor.java @@ -292,7 +292,10 @@ public class Analyzor { System.out.println("Obtaining all selected entries in tweet."); if (queryText.isEmpty()) { - queryText = "SELECT tweetid, text FROM tweet"; + // select all tweets which are not yet classified + queryText = "SELECT tweetid, text FROM tweet t WHERE NOT EXISTS" + + " (SELECT 1 FROM mentionsbrand b WHERE b.tweetid=t.tweetid)"; + } // print expected count, this will increase the initial startup time |