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