def migrate_subreddit_status():
sql = 'UPDATE subreddits SET status="silent" WHERE status="hostile"'
MYCURSOR.execute(sql)
MYDB.commit()
sql = 'UPDATE subreddits SET status="full" WHERE status="friendly"'
MYCURSOR.execute(sql)
MYDB.commit()
def pull_history(u, n):
"""
Pulls n number of records for username u
:param u:
:param n:
:return:
"""
sql = "SELECT id, username, sql_time, action, amount, comment_id, notes, recipient_username, recipient_address, return_status, comment_text, subreddit FROM history WHERE username=%s ORDER BY id DESC limit %s"
val = (u, n)
if u is None:
sql = "SELECT id, username, sql_time, action, amount, comment_id, notes, recipient_username, recipient_address, return_status, comment_text, subreddit FROM history ORDER BY id DESC limit %s"
val = (n,)
MYCURSOR.execute(sql, val)
results = MYCURSOR.fetchall()
if len(results) == 0:
LOGGER.info("Username %s not found." % u)
MYDB.commit()
LOGGER.info(
"Printing results: Username, Datetime, action, amount, comment_id, notes_recipient_username, recipient_address, subreddit"
)
for result in results:
LOGGER.info(result)
def modify_history(id):
sql = "UPDATE history SET sql_time='2020-06-10 09:21:28' WHERE id=%s"
MYCURSOR.execute(sql, (id,))
MYDB.commit()
def list_users(u):
sql = "SELECT username FROM accounts"
MYCURSOR.execute(sql)
results = MYCURSOR.fetchall()
for result in results:
LOGGER.info(result)
def delete_user(u):
sql = "DELETE FROM accounts WHERE username = %s"
val = (u,)
MYCURSOR.execute(sql, val)
MYDB.commit()