DEV Community

Kashif Soofi
Kashif Soofi

Posted on

Integration Test MySQL Store with testcontainers-go

This is a continuation of an earlier post Integration Test MySQL Store (go). In this tutorial I will extend the sample to use testcontainers-go to spin up database container and apply migrations before executing our integration tests.

Prior to this sample, pre-requisite of running integration tests was that database server is running either on machine or in a container and migrations are applied. This update will remove that manual step.


We would need to start 2 containers before running our integration tests.

  • Database Container - hosting the database server
  • Migrations Container - container to apply database migrations

Database Container

Let's start by adding a new file containers.go under integrationtests folder. If there are multiple tests feel free to add a separate testhelper directory to add common code. When moving common code to separate package remember to make the types and methods public.

We will create a struct databaseContainer and embed mysql.MySQLContainer from testcontainers-go/modules/mysql module. We would also add a connectionString for convenience. Then we will add a new method that would start the container and set the connentionString before returning to caller.

package integrationtests

import (


type databaseContainer struct {
    connectionString string

func WithNetwork(network string) testcontainers.CustomizeRequestOption {
    return func(req *testcontainers.GenericContainerRequest) {
        req.Networks = []string{

func WithName(name string) testcontainers.CustomizeRequestOption {
    return func(req *testcontainers.GenericContainerRequest) {
        req.Name = name

func createDatabaseContainer(ctx context.Context) (*databaseContainer, error) {
    dbContainer, err := mysql.RunContainer(
    if err != nil {
        return nil, err
    connStr, err := dbContainer.ConnectionString(ctx, "parseTime=true")
    if err != nil {
        return nil, err

    return &databaseContainer{
        MySQLContainer:   dbContainer,
        connectionString: connStr,
    }, nil
Enter fullscreen mode Exit fullscreen mode

Migrations Cotnainer

We will add another method in containers.go file to create and run migrations container by passing database container's IP address. To make this work we would need to run it in the same network we are running our database container i.e. testcontainers-go. First step of the method is to create a connection string, we are using the same values except for the database container IP but all these can be made configureable. Instead of keeping migrations container running we will wait until it exits.

func createMigrationsContainer(ctx context.Context, dbHostIP string) (testcontainers.Container, error) {
    connectionString := fmt.Sprintf("mysql://root:Password123@tcp(%s:3306)/moviesdb", dbHostIP)
    req := testcontainers.ContainerRequest{
        FromDockerfile: testcontainers.FromDockerfile{
            Context:    "../db",
            Dockerfile: "Dockerfile",
        WaitingFor: wait.ForExit().WithExitTimeout(10 * time.Second),
        Cmd:        []string{connectionString, "up"},
        Networks:   []string{"testcontainers-go"},
        Name:       "movies.db.migrations",

    migrationsContainer, err := testcontainers.GenericContainer(ctx, testcontainers.GenericContainerRequest{
        ContainerRequest: req,
        Started:          true,
    if err != nil {
        return nil, err

    return migrationsContainer, nil
Enter fullscreen mode Exit fullscreen mode

Test Suite Changes

We will add 2 new fields in our test suite to hold reference to our database container and migrations container that we would start to run our integration tests.

type mysqlMoviesStoreTestSuite struct {
    dbContainer         *databaseContainer
    migrationsContainer testcontainers.Container
Enter fullscreen mode Exit fullscreen mode

We will update SetupSuite method to create both database and migration containers and use the connection string from our newly created database container to initialise sut and dbHelper. We are no longer loading database url from environment configuration.

func (suite *mysqlMoviesStoreTestSuite) SetupSuite() {
    suite.ctx = context.Background()

    dbContainer, err := createDatabaseContainer(suite.ctx)
    if err != nil {
    suite.dbContainer = dbContainer

    dbHostIP, _ := suite.dbContainer.ContainerIP(suite.ctx)
    migrationsContainer, err := createMigrationsContainer(suite.ctx, dbHostIP)
    if err != nil {
    suite.migrationsContainer = migrationsContainer

    suite.sut = store.NewMySqlMoviesStore(suite.dbContainer.connectionString)
    suite.dbHelper = newDatabaseHelper(suite.dbContainer.connectionString)
    suite.fake = faker.New()
Enter fullscreen mode Exit fullscreen mode

We will also update TearDownSuite method to terminate both migrations and database containers.

func (suite *mysqlMoviesStoreTestSuite) TearDownSuite() {
    if err := suite.migrationsContainer.Terminate(suite.ctx); err != nil {
        log.Fatalf("error terminating migrations container: %s", err)
    if err := suite.dbContainer.Terminate(suite.ctx); err != nil {
        log.Fatalf("error terminating database container: %s", err)
Enter fullscreen mode Exit fullscreen mode

Run Integration Tests

Run following go test command to run integration tests. Please note now we don't need to setup DATABASE_URL environment variable before running the tests as our setup takes care of starting up database server and getting connection string for that server and passing on to migrationsContainer, sut and dbHelper.

go test ./integrationtests
Enter fullscreen mode Exit fullscreen mode

Integration Tests in CI

I have also added GitHub Actions workflow to run these integration tests as part of the CI when a change is pushed to main branch.

We will use the standard steps defined in Building and testing Go guide. Running database server and migrations would be taken care by SetupSuite.

Here is the complete listing of the workflow.

name: Integration Test MySQL (testcontainers-go)

    branches: [ "main" ]
     - 'integration-test-mysql-with-testcontainers-go/**'

    runs-on: ubuntu-latest
        working-directory: integration-test-mysql-with-testcontainers-go

      - uses: actions/checkout@v3
      - name: Set up Go
        uses: actions/setup-go@v4
          go-version: '1.20'
      - name: Build
        run: go build -v ./...
      - name: Run integration tests
        run: TESTCONTAINERS_RYUK_DISABLED=true go test ./integrationtests
Enter fullscreen mode Exit fullscreen mode


Source code for the demo application is hosted on GitHub in blog-code-samples repository.

Source for Integration Test MySQL (testcontainers-go) workflow is in integration-test-mysql-testcontainers-go.yml.


In no particular order

Top comments (0)