def METHOD_NAME(self):
    """
    Test all the steps related to the test connection automation workflow
    """
    new_workflow_request = CreateWorkflowRequest(
        name="test-connection-mysql",
        description="description",
        workflowType=WorkflowType.TEST_CONNECTION,
        request=TestServiceConnectionRequest(
            serviceType=ServiceType.Database,
            connectionType=MySQLType.Mysql.value,
            connection=DatabaseConnection(
                config=SERVICE_CONNECTION,
            ),
        ),
    )
    automation_workflow: Workflow = self.metadata.create_or_update(
        data=new_workflow_request
    )
    engine: Engine = get_connection(SERVICE_CONNECTION)
    test_connection_fn = get_test_connection_fn(SERVICE_CONNECTION)
    test_connection_fn(
        self.metadata, engine, SERVICE_CONNECTION, automation_workflow
    )
    final_workflow: Workflow = self.metadata.get_by_name(
        entity=Workflow, fqn="test-connection-mysql"
    )
    self.assertEqual(final_workflow.status, WorkflowStatus.Successful)
    self.assertEqual(len(final_workflow.response.steps), 4)
    self.assertEqual(
        final_workflow.response.status.value, StatusType.Successful.value
    )
    self.metadata.delete(
        entity=Workflow,
        entity_id=str(automation_workflow.id.__root__),
        hard_delete=True,
    )