diff options
| author | Magnus Hagander | 2012-09-11 08:16:44 +0000 |
|---|---|---|
| committer | Magnus Hagander | 2012-09-11 08:16:44 +0000 |
| commit | 59bca50329520c9ead771d76f2bfad6f169c0fdb (patch) | |
| tree | 0a70feb3b9677241a51d6c57f0522409d4054219 /synctwitter.py | |
| parent | ab3ac58a26bc853648b46b5aa4aa872896338e28 (diff) | |
Oops, fix SQL query properly
Diffstat (limited to 'synctwitter.py')
| -rwxr-xr-x | synctwitter.py | 2 |
1 files changed, 1 insertions, 1 deletions
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 |