code: def reset_mysql(self):
          
  
          confirm = self.no_confirm
  
          print("""
  Cleanup MySQL database:
      This will truncate all tables and reset the whole database.
  """)
  
          if not confirm:
              confirm = 'yes' in builtins.input(
                  """
      Do you really want to do this? Write 'yes' to confirm: {yes}"""
                      .format(yes='yes' if confirm else ''))
  
          if not confirm:
              print("Did not type yes. Thus aborting.")
              return
  
          print("Resetting database...")
  
          try:
              # initialize DB connection
              self.conn = pymysql.connect(host=self.mysql["host"],
                                          port=self.mysql["port"],
                                          db=self.mysql["db"],
                                          user=self.mysql["username"],
                                          passwd=self.mysql["password"])
              self.cursor = self.conn.cursor()
  
              self.cursor.execute("TRUNCATE TABLE CurrentVersions")
              self.cursor.execute("TRUNCATE TABLE ArchiveVersions")
              self.conn.close()
          except (pymysql.err.OperationalError, pymysql.ProgrammingError, pymysql.InternalError,
                  pymysql.IntegrityError, TypeError) as error:
              self.log.error("Database reset error: %s", error)
docs: Resets the MySQL database.