diff options
| author | Magnus Hagander | 2012-09-11 08:15:32 +0000 |
|---|---|---|
| committer | Magnus Hagander | 2012-09-11 08:15:32 +0000 |
| commit | ab3ac58a26bc853648b46b5aa4aa872896338e28 (patch) | |
| tree | ca0517baa4442cc5f0cfdd839c1cf071b8af72ba | |
| parent | bdc9e9822260e7cef7c99a60a6bef6371df25b94 (diff) | |
Turn all twitter handles to lowercase when comparing
You can't have different users with twitter handles only differing in
case anyway.
| -rwxr-xr-x | synctwitter.py | 2 | ||||
| -rw-r--r-- | 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 |