# go-oauth2-mysql-imrenagi

**Repository Path**: korbenzhang/go-oauth2-mysql-imrenagi

## Basic Information

- **Project Name**: go-oauth2-mysql-imrenagi
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-01-26
- **Last Updated**: 2024-01-26

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# MySQL Storage for [OAuth 2.0](https://github.com/go-oauth2/oauth2)

[![Build][Build-Status-Image]][Build-Status-Url] [![Codecov][codecov-image]][codecov-url]  [![GoDoc][godoc-image]][godoc-url] [![License][license-image]][license-url]

## Install

```bash
$ go get -u -v github.com/imrenagi/go-oauth2-mysql
```

## MySQL drivers

The store accepts an `sqlx.DB` which interacts with the DB. `sqlx.DB` is a specific implementations from [`github.com/jmoiron/sqlx`](https://github.com/jmoiron/sqlx)

## Usage example

```go
package main

import (
	_ "github.com/go-sql-driver/mysql"
	mysql "github.com/imrenagi/go-oauth2-mysql"
	"github.com/jmoiron/sqlx"
)

func main() {
	db, err := sqlx.Connect("mysql", "user:password@tcp(127.0.0.1:3306)/oauth_db?parseTime=true")
	if err != nil {
		log.Fatalln(err)
	}

	clientStore, _ := mysql.NewClientStore(db, mysql.WithClientStoreTableName("custom_table_name"))
	tokenStore, _ := mysql.NewTokenStore(db)
}
```

## How to run tests

You will need running MySQL instance. E.g. the one running in docker and exposing a port to a host system

```bash
$ docker run -it  -p 3306:3306 -e MYSQL_ROOT_PASSWORD=oauth2 -d mysql
$ docker exec -it <container_id> bash
$ mysql -u root -poauth2
> create database oauth_db
```

```bash
$ MYSQL_URI=root:oauth2@tcp(127.0.0.1:3306)/oauth_db?parseTime=true go test .
```

## MIT License

```
Copyright (c) 2019 Imre Nagi
```

## Credits

- Oauth Postgres Implementation [`github.com/vgarvardt/go-pg-adapter`](https://github.com/vgarvardt/go-pg-adapter)


[Build-Status-Url]: https://travis-ci.org/imrenagi/go-oauth2-mysql
[Build-Status-Image]: https://travis-ci.org/imrenagi/go-oauth2-mysql.svg?branch=master
[codecov-url]: https://codecov.io/gh/imrenagi/go-oauth2-mysql
[codecov-image]: https://codecov.io/gh/imrenagi/go-oauth2-mysql/branch/master/graph/badge.svg
[godoc-url]: https://godoc.org/github.com/imrenagi/go-oauth2-mysql
[godoc-image]: https://godoc.org/github.com/imrenagi/go-oauth2-mysql?status.svg
[license-url]: http://opensource.org/licenses/MIT
[license-image]: https://img.shields.io/npm/l/express.svg