def METHOD_NAME(aggregator, instance_basic, dd_run_check, executor_value, expected_status):
    check = get_check(instance_basic)
    con = mock.MagicMock()
    cursor = mock.MagicMock()
    con.cursor.return_value = cursor
    check.connect = con
    check._query_manager = create_query_manager(
        {
            'name': 'test query',
            'query': 'foo',
            'columns': [
                {
                    'name': 'proxysql.backend.status',
                    'type': 'service_check',
                    'status_map': {
                        'ONLINE': 'OK',
                        'SHUNNED': 'CRITICAL',
                        'OFFLINE_SOFT': 'WARNING',
                        'OFFLINE_HARD': 'CRITICAL',
                        'SHUNNED_REPLICATION_LAG': 'CRITICAL',
                    },
                },
            ],
        },
        executor=mock_executor([[executor_value]]),
    )
    check._query_manager.compile_queries()
    dd_run_check(check)
    aggregator.assert_service_check("proxysql.backend.status", expected_status)