From 2b0f787915e5b4f2918ce98f471bd27a7a4ed292 Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Tue, 8 Mar 2016 17:53:42 +0100 Subject: [PATCH] Don't synchronize twitter users for unapproved feeds --- synctwitter.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/synctwitter.py b/synctwitter.py index 892de3c..c840e3d 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 feeds WHERE NOT (twitteruser IS NULL OR twitteruser='') ORDER BY lower(twitteruser)"); + curs.execute("SELECT DISTINCT lower(twitteruser) FROM feeds WHERE approved AND 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