def remove_spammer(store, name, confirm=False): user = store.get_user(name) if not user: sys.exit('user %r does not exist' % name) cursor = st.get_cursor() cursor.execute( """ select distinct(submitted_from) from journals where submitted_by = %s """, (name, )) print 'IP addresses of spammers to possibly block:' for (ip, ) in cursor.fetchall(): print ' ', ip for p in store.get_user_packages(name): print p['package_name'] if confirm: store.remove_package(p['package_name']) if confirm: cursor.execute( "update accounts_user set password='******' where name=%s", (name, ))
def show_user(store, name): user = store.get_user(name) if not user: sys.exit('user %r does not exist' % name) for key in user.keys(): print '%s: %s' % (key, user[key]) for p in store.get_user_packages(name): print '%s: %s' % (p['package_name'], p['role_name'])
def remove_spammer(store, name, confirm=False): user = store.get_user(name) if not user: sys.exit('user %r does not exist' % name) cursor = st.get_cursor() cursor.execute(""" select distinct(submitted_from) from journals where submitted_by = %s """, (name,)) print 'IP addresses of spammers to possibly block:' for (ip,) in cursor.fetchall(): print ' ', ip for p in store.get_user_packages(name): print p['package_name'] if confirm: store.remove_package(p['package_name']) if confirm: cursor.execute("update accounts_user set password='******' where name=%s", (name,))