From ab3ac58a26bc853648b46b5aa4aa872896338e28 Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Tue, 11 Sep 2012 10:15:32 +0200 Subject: [PATCH] Turn all twitter handles to lowercase when comparing You can't have different users with twitter handles only differing in case anyway. --- synctwitter.py | 2 +- twitterclient.py | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/synctwitter.py b/synctwitter.py index 32823f2..cb7ee87 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 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 twitteruser"); expected = set([r[0].replace('@','') for r in curs.fetchall()]) # Get list of current screen names the list is following diff --git a/twitterclient.py b/twitterclient.py index 22d8db9..01a7d33 100644 --- a/twitterclient.py +++ b/twitterclient.py @@ -66,7 +66,7 @@ class TwitterClient(object): response = self.twitter_request('%s/%s/members.json' % (self.twittername, self.twitterlist), 'GET', { 'cursor': cursor, }) - handles.extend([x['screen_name'] for x in response['users']]) + handles.extend([x['screen_name'].lower() for x in response['users']]) cursor = response['next_cursor'] return handles -- 2.39.5