[Awesome Go] Use GORM package to make developer-friendly database ORM

GORM

The fantastic ORM library for Golang aims to be developer friendly.

Overview

  • Full-Featured ORM

  • Associations (Has One, Has Many, Belongs To, Many To Many, Polymorphism, Single-table inheritance)

  • Hooks (Before/After Create/Save/Update/Delete/Find)

  • Eager loading with Preload, Joins

  • Transactions, Nested Transactions, Save Point, RollbackTo to Saved Point

  • Context, Prepared Statement Mode, DryRun Mode

  • Batch Insert, FindInBatches, Find/Create with Map, CRUD with SQL Expr and Context Valuer

  • SQL Builder, Upsert, Locking, Optimizer/Index/Comment Hints, Named Argument, SubQuery

  • Composite Primary Key, Indexes, Constraints

  • Auto Migrations

  • Logger

  • Extendable, flexible plugin API: Database Resolver (Multiple Databases, Read/Write Splitting) / Prometheus…

  • Every feature comes with tests

  • Developer Friendly

Installation

1
2
3
$ go get -u gorm.io/gorm

$ go get -u gorm.io/driver/sqlite

Quick Start

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
package main

import (
"gorm.io/gorm"
"gorm.io/driver/sqlite"
)

type Product struct {
gorm.Model
Code string
Price uint
}

func main() {
db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
if err != nil {
panic("failed to connect database")
}

// Migrate the schema
db.AutoMigrate(&Product{})

// Create
db.Create(&Product{Code: "D42", Price: 100})

// Read
var product Product
db.First(&product, 1) // find product with integer primary key
db.First(&product, "code = ?", "D42") // find product with code D42

// Update - update product's price to 200
db.Model(&product).Update("Price", 200)
// Update - update multiple fields
db.Model(&product).Updates(Product{Price: 200, Code: "F42"}) // non-zero fields
db.Model(&product).Updates(map[string]interface{}{"Price": 200, "Code": "F42"})

// Delete - delete product
db.Delete(&product, 1)
}

References

[1] GORM Guides | GORM - The fantastic ORM library for Golang, aims to be developer friendly. - https://gorm.io/docs/

[2] GORM - The fantastic ORM library for Golang, aims to be developer friendly. - https://gorm.io/

[3] go-gorm/gorm: The fantastic ORM library for Golang, aims to be developer friendly - https://github.com/go-gorm/gorm

[4] gorm · pkg.go.dev - https://pkg.go.dev/gorm.io/gorm