Golang MySQL ORM Example

.env

MYSQL_USER="root"
MYSQL_PASSWORD=""
MYSQL_DBNAME="gorm_test"
MYSQL_PROTOCOL="tcp"
MYSQL_HOST="127.0.0.1"
MYSQL_PORT="3306"

README.md

Golang MySQL ORM Example

Setup:

1. Install Glide.
2. Clone this gist to a local directory.
3. Run glide install to resolve all the dependencies.
4. Run go run mysql_example.go

Dependencies:

• gorm
• Golang MySQL driver
• godotenv

glide.yaml

package: github.com/itsprdp/goorm-example
import:
- package: github.com/go-sql-driver/mysql
  version: ~1.3.0
- package: github.com/jinzhu/gorm
  version: ~1.0.0
- package: github.com/joho/godotenv
  version: ~1.0.0

mysql_example.go

package main

import (
	"fmt"
	"log"

	_ "github.com/go-sql-driver/mysql"
	"github.com/jinzhu/gorm"
	"github.com/joho/godotenv"
)

type User struct {
	gorm.Model
	FirstName      string
	LastName       string
	Email          string `gorm:"unique_index:user_email_index"`
	Password       string
	Token          string
	TokenExpiresAt uint
}

func main() {
	var appConfig map[string]string
	appConfig, err := godotenv.Read()

	if err != nil {
		log.Fatal("Error reading .env file")
	}

	// Ex: user:password@tcp(host:port)/dbname
	mysqlCredentials := fmt.Sprintf(
		"%s:%s@%s(%s:%s)/%s?charset=utf8&parseTime=True&loc=Local",
		appConfig["MYSQL_USER"],
		appConfig["MYSQL_PASSWORD"],
		appConfig["MYSQL_PROTOCOL"],
		appConfig["MYSQL_HOST"],
		appConfig["MYSQL_PORT"],
		appConfig["MYSQL_DBNAME"],
	)

	db, err := gorm.Open("mysql", mysqlCredentials)
	defer db.Close()

	if err != nil {
		fmt.Println(err)
		panic("Failed to connect to the database!")
	}

	if db.HasTable(&User{}) == false {
		db.CreateTable(&User{})
	}

	user := User{
		FirstName: "John",
		LastName:  "Doe",
		Email:     "[email protected]",
		Password:  "insecurepassword",
	}

	db.Create(&user)

	var users []User
	db.Find(&users)

	fmt.Println("There are", len(users), "user records in the table.")
}

Some more examples: http://motion-express.com/blog/gorm:-a-simple-guide-on-crud