Sqlxtx

Changes behavior between sqlx.DB and sqlx.Tx in runtime.

Installation

go get -u github.com/andresmijares/sqlxtx

Usage

// domain.go
type User struct {}

func (u *User) Create(username, password string) error {
    _, err := u.Client.NamedExec("INSERT INTO users (first_name, last_name) VALUES (:first_name, :last_name);",
		map[string]interface{}{
			"first_name": "Jhon",
			"last_name":  "Doe",
		})
	if err != nil {
		return err
	}
	return nil
}

type Events struct {}

func (u *Events) Create(name string) error {
    _, err := e.Client.NamedExec(`INSERT INTO events(name) VALUE (:name);`,
		map[string]interface{}{
			"name": name,
		})
	if err != nil {
		return err
	}
    return nil
}

// service.go
// Will manage each operation independently 
func init() {
    
}

func CreateUser () {
    if err := UserDao.Create(); err != nil {
		return err
	}

	if err := EventsDao.Create("userCreated"); err != nil {
		return err
	}

	return nil
}

// Will run a transaction, not need to modify the underline implementation
func CreateUserWithTx () {
    if err := db.WithTx.Exec(func() error {
		if err := UserDao.Create(); err != nil {
			return err
		}

		if err := EventsDao.Create("userCreated"); err != nil {
			return err
		}

		return nil
	}); err != nil {
		return err
	}
	return nil
}

Test

Sample how to test this can be found in the sample folder.

Limitations

I've mocked only the most commons methods I use, for a more detailed list, please check sqltxmocks

Motivation

Transactions should be implementation details, it should not force developers to re-write code to support between Tx and DB. I couldn't find a solid way to decorate operations in my services, so I created this one.

I lot of motivation were found in this articles.

• sqlx
• detect-and-commit-rollback
• db-transaction-in-golang
• golang transactions api design
• A clean way to implement database transaction in golang
• Go Microservice with clean architecture: transaction support
• Isolation levels

I only added the methods I use, please, feel free to submit PR's to support more methods.

License

MIT