Class MySQLTest

compatibility/mysql/csharp/MySQLTest.cs:7–179

using System.IO;

public class MySQLTest
{
    public class Tests
    {
        private MySqlConnection conn;
        private MySqlCommand cmd;
        private List<Test> tests = new List<Test>();

        public void Connect(string ip, int port, string user, string password)
        {
            string connectionString = $"Server={ip};Port={port};User Id={user};Password={password};";
            try
            {
                conn = new MySqlConnection(connectionString);
                conn.Open();
                cmd = conn.CreateCommand();
                cmd.CommandType = CommandType.Text;
            }
            catch (MySqlException e)
            {
                throw new Exception($"Error connecting to database: {e.Message}", e);
            }
        }

        public void Disconnect()
        {
            try
            {
                cmd.Dispose();
                conn.Close();
            }
            catch (MySqlException e)
            {
                throw new Exception(e.Message);
            }
        }

        public void AddTest(string query, string[][] expectedResults)
        {
            tests.Add(new Test(query, expectedResults));
        }

        public bool RunTests()
        {
            foreach (var test in tests)
            {
                if (!test.Run(cmd))
                {
                    return false;
                }
            }
            return true;
        }

        public void ReadTestsFromFile(string filename)
        {
            try
            {