go-test-database

What this package does?

This package creates up and running mysql container(using docker sdk) for your applications and returns a connection to the created database, so you can easily query the test database.

Requirements

• :3305 port must not be used
• docker

INSTALL

go get github.com/dogukanayd/go-test-database

USAGE

Let's say you have a package named greetings also in this package you have a function named Hello and this function send some query to the database, well from at this point you need a database separated from your local database. Here is all you need to do.

connection, def := mysql_unit.NewUnit()

and below you can find full dummy example

package greetings

import (
	mysql_unit "github.com/dogukanayd/go-test-database/mysql-unit"
	"log"
	"testing"
)

func TestHello(t *testing.T) {
	connection, def := mysql_unit.NewUnit()

	q := `CREATE TABLE test_table(id int(11),name varchar(500)) ENGINE = InnoDB  DEFAULT CHARSET = utf8;`
	_, err := connection.Query(q)
	if err != nil {
		log.Fatal(err)
	}

	defer def()

	t.Log("ping success")
}

When you call the NewUnit function;

connection, tearDown := NewUnit()

it's return two parameters;

• connection: *sql.DB // connection that allows you to query the database
• tearDown

here is the defination of the NewUnit function;

func NewUnit() (*sql.DB, func()) {}