text: import pymysql.connections
  from model.project import Project
  
  
  class DbFixture:
  
      def __init__(self, host, name, user, password):
          self.host = host
          self.name = name
          self.user = user
          self.password = password
          self.connection = pymysql.connect(host=host, database=name, user=user, password=password, autocommit=True)
  
      def get_project_list(self):
          project_list = []
          cursor = self.connection.cursor()
          try:
              cursor.execute("select id, name, status, view_state, description from mantis_project_table")
              for row in cursor:
                  (id, name, status, view_state, description) = row
                  project_list.append(Project(id=str(id), name=name, status=status, view_status=view_state,
                                              description=description))
          finally:
              cursor.close()
          return project_list
  
      def destroy(self):
          self.connection.close()
  
  