count = 0
try:
print '[ ] loading approved submitters for /r/%s' % sub,
stdout.flush()
for user in Reddit.get_approved_submitters(sub):
if db.count('subs_approved', 'subreddit = ? and username = ?', [sub, user]) == 0:
db.insert('subs_approved', (sub, user))
count += 1
print '[+] subs_approved: added %d contributors' % count
except Exception, e:
print '[!] %s' % str(e)
# MODERATORS
count = 0
try:
print '[ ] loading moderators for /r/%s' % sub,
stdout.flush()
for user in Reddit.get_moderators(sub):
if db.count('subs_approved', 'subreddit = ? and username = ?', [sub, user]) == 0:
db.insert('subs_approved', (sub, user))
count += 1
print '[+] subs_approved: added %d moderators' % count
if count > 0:
db.commit()
except Exception, e:
print '[!] %s' % str(e)
if count > 0:
db.commit()
