purge_resources.py

# set up the connection to an account that has delete permissions.
root_pw = parser["myapplication"]["root_password"]
ct_string = "mysql+pymysql://root:{}@localhost/mydatabase".format(root_pw)
eng = create_engine(ct_string)
conn = eng.connect()

# clear the learning resources
query_string = """delete from resources where id in (
  select resource_id from resource_deletions)"""
conn.execute(query_string)

# clear the deletion queue for resources
query_string = "delete from resource_deletions"
conn.execute(query_string)