gorm-one2many-example

gorm_one2many.go

package main

import (
	"fmt"
	"log"

	"github.com/jinzhu/gorm"
	_ "github.com/jinzhu/gorm/dialects/mysql"
)

// Student table
type Student struct {
	gorm.Model
	Name      string `gorm:"not null"`
	TeacherID uint
}

// Teacher table
type Teacher struct {
	gorm.Model
	Name     string
	Students []*Student
}

func main() {
	db, err := gorm.Open("mysql", "root:root@tcp(127.0.0.1:3306)/test?parseTime=true")
	if err != nil {
		log.Fatalln("failed to connect database", err)
	}
	defer db.Close()

	db.SingularTable(true)

	db.Debug().AutoMigrate(new(Student), new(Teacher))

	db.Debug().Create(&Teacher{Name: "te_0"})
	db.Debug().Create(&Student{Name: "st_0", TeacherID: 1})
	db.Debug().Create(&Student{Name: "st_1", TeacherID: 1})

	var t Teacher
	if db.Debug().First(&t, 1).RecordNotFound() {
		log.Fatal("Teacher not found")
	}

	db.Debug().Model(&t).Related(&t.Students)
	for _, item := range t.Students {
		fmt.Printf("%+v", item)
		fmt.Println()
	}
}