Add the library to the test section in your application's Gemfile:

group :test do
  gem "testcontainers-mariadb"
end

And then execute:

$ bundle install

Or install it yourself as:

$ gem install testcontainers-mariadb

To use the library, you first need to require it:

require "testcontainers/mariadb"

Create a new instance of the Testcontainers::MariadbContainer class:

container = Testcontainers::MariadbContainer.new

This creates a new container with the default MariaDB image, user, password, and database. You can customize these by passing arguments to the constructor:

container = Testcontainers::MariadbContainer.new("mariadb:10.10", username: "custom_user", password: "custom_pass", database: "custom_db")

Start the container:

container.start

Stop the container when you're done:

container.stop

Once the container is running, you can obtain the connection details using the following methods:

host = container.host
port = container.first_mapped_port

Or, you can generate a full database URL:

database_url = container.database_url

Use this URL to connect to the MariaDB container using your preferred MySQL client library.

You can also customize the container using the following methods:

container.with_database("custom_db")
container.with_username("custom_user")
container.with_password("custom_pass")

Here's a complete example of how to use testcontainers-mysdql to create a container, connect to it, and run a simple query:

require "testcontainers/mariadb"
require "mysql2"

container = Testcontainers::MariadbContainer.new
container.start

client = Mysql2::Client.new(url: container.database_url)

result = client.query("SELECT 1")
result.each do |row|
  puts row.inspect
end

client.close
container.stop

This example creates a MariaDB container, connects to it using the mysql2 gem, runs a simple SELECT 1 query, and then stops the container.

You can manage the container in the before(:suite) / after(:suite) blocks in your spec_helper.rb:

RSpec.configure do |config|
  # This helps us to have access to the `RSpec.configuration.mariadb_container` without using global variables.
  config.add_setting :mariadb_container, default: nil

  config.before(:suite) do
    config.mariadb_container = Testcontainers::MariadbContainer.new.start
    ENV["DATABASE_URL"] = config.mariadb_container.database_url(protocol: "mysql2") # or you can expose it to a fixed port and use database.yml for configuration
  end

  config.after(:suite) do
    config.mariadb_container&.stop
    config.mariadb_container&.remove
  end
end

Bug reports and pull requests are welcome on GitHub at https://github.com/testcontainers/testcontainers-ruby. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the code of conduct.

The gem is available as open source under the terms of the MIT License.

Everyone interacting in the Testcontainers project's codebases, issue trackers, chat rooms and mailing lists is expected to follow the code of conduct.