From 59bca50329520c9ead771d76f2bfad6f169c0fdb Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Tue, 11 Sep 2012 10:16:44 +0200 Subject: [PATCH] Oops, fix SQL query properly --- synctwitter.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/synctwitter.py b/synctwitter.py index cb7ee87..230f877 100755 --- a/synctwitter.py +++ b/synctwitter.py @@ -23,7 +23,7 @@ class SyncTwitter(TwitterClient): def Run(self): # Get list of handles that should be on the list curs = self.db.cursor() - curs.execute("SELECT DISTINCT lower(twitteruser) FROM planet.feeds WHERE NOT (twitteruser IS NULL OR twitteruser='') ORDER BY twitteruser"); + curs.execute("SELECT DISTINCT lower(twitteruser) FROM planet.feeds WHERE NOT (twitteruser IS NULL OR twitteruser='') ORDER BY lower(twitteruser)"); expected = set([r[0].replace('@','') for r in curs.fetchall()]) # Get list of current screen names the list is following -- 2.39.5