github.com/dolthub/go-mysql-server@v0.18.0/_integration/ruby/mysql_test.rb (about)

     1  require "minitest/autorun"
     2  require "mysql"
     3  
     4  class TestMySQL < Minitest::Test
     5      def test_can_connect
     6          conn = Mysql::new("127.0.0.1", "root", "", "mydb")
     7          res = conn.query "SELECT name, email FROM mytable ORDER BY name, email"
     8  
     9          expected = [
    10              ["Evil Bob", "evilbob@gmail.com"],
    11              ["Jane Doe", "jane@doe.com"],
    12              ["John Doe", "john@doe.com"],
    13              ["John Doe", "johnalt@doe.com"]
    14          ]
    15  
    16          rows = res.map do |row| [row[0], row[1]] end
    17          assert_equal rows, expected
    18  
    19          conn.close()
    20      end
    21  end