从yaml到go-gorm的自引用uuid

package main

import (
    "fmt"
    "io/ioutil"
    "log"

    "github.com/go-gorm/gorm"
    "gopkg.in/yaml.v2"
    "gorm.io/driver/mysql"
    "gorm.io/gorm"
)

type User struct {
    ID   string `gorm:"type:uuid;primaryKey"`
    Name string
}

func main() {
    // 读取YAML文件
    yamlFile, err := ioutil.ReadFile("data.yaml")
    if err != nil {
        log.Fatalf("Failed to read YAML file: %v", err)
    }

    // 解析YAML文件为结构体对象
    var user User
    err = yaml.Unmarshal(yamlFile, &user)
    if err != nil {
        log.Fatalf("Failed to unmarshal YAML: %v", err)
    }

    // 连接数据库
    dsn := "user:password@tcp(127.0.0.1:3306)/dbname?charset=utf8mb4&parseTime=True&loc=Local"
    db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
    if err != nil {
        log.Fatalf("Failed to connect to database: %v", err)
    }

    // 自动迁移结构体到数据库表
    err = db.AutoMigrate(&User{})
    if err != nil {
        log.Fatalf("Failed to migrate database: %v", err)
    }

    // 创建用户
    err = db.Create(&user).Error
    if err != nil {
        log.Fatalf("Failed to create user: %v", err)
    }

    // 查询用户
    var result User
    err = db.First(&result, "id = ?", user.ID).Error
    if err != nil {
        log.Fatalf("Failed to query user: %v", err)
    }

    fmt.Printf("User: %+v\n", result)
}