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 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,))
