Method Run

compatibility/mysql/csharp/MySQLTest.cs:100–156

(MySqlCommand cmd)

            }

            public bool Run(MySqlCommand cmd)
            {
                try
                {
                    Console.WriteLine("Running test: " + query);
                    cmd.CommandText = query;
                    using (var reader = cmd.ExecuteReader())
                    {
                        if (!reader.HasRows)
                        {
                            if (expectedResults.Length != 0)
                            {
                                Console.Error.WriteLine($"Expected {expectedResults.Length} rows, got 0");
                                return false;
                            }
                            Console.WriteLine("Returns 0 rows");
                            return true;
                        }
                        if (reader.FieldCount != expectedResults[0].Length)
                        {
                            Console.Error.WriteLine($"Expected {expectedResults[0].Length} columns, got {reader.FieldCount}");
                            return false;
                        }
                        int rows = 0;
                        while (reader.Read())
                        {
                            for (int col = 0; col < expectedResults[rows].Length; col++)
                            {
                                string result = reader.GetString(col);
                                if (expectedResults[rows][col] != result)
                                {
                                    Console.Error.WriteLine($"Expected:\n'{expectedResults[rows][col]}'");
                                    Console.Error.WriteLine($"Result:\n'{result}'\nRest of the results:");
                                    while (reader.Read())
                                    {
                                        Console.Error.WriteLine(reader.GetString(0));
                                    }
                                    return false;
                                }
                            }
                            rows++;
                        }
                        Console.WriteLine("Returns " + rows + " rows");
                        if (rows != expectedResults.Length)
                        {
                            Console.Error.WriteLine($"Expected {expectedResults.Length} rows");
                            return false;
                        }
                        return true;
                    }
                }
                catch (MySqlException e)
                {
                    Console.Error.WriteLine(e.Message);
                    return false;
                }
            }
        }