package main

import (
    "fmt"
    "gorm.io/driver/mysql"
    "gorm.io/gorm"
    "time"
)

type User struct {
    ID        uint   `gorm:"primaryKey"`
    Name      string `gorm:"column:username;size:100;not null"`
    Age       int    `gorm:"not null"`
    Email     string `gorm:"unique;not null"`
    Avatar    []byte
    CreatedAt time.Time `gorm:"autoCreateTime"`
    UpdatedAt time.Time `gorm:"autoUpdateTime"`
}

func main() {
    // 连接MySQL数据库
    dsn := "root:123456@tcp(127.0.0.1:3306)/test_db?charset=utf8mb4&parseTime=True&loc=Local"
    db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
    if err != nil {
        panic("Failed to connect to database!")
    }

    // 自动迁移模型
    err = db.AutoMigrate(&User{})
    if err != nil {
        panic("Failed to migrate model!")
    }

    // 插入数据
    user := User{
        Name:      "John",
        Age:       30,
        Email:     "john@example.com",
        Avatar:    []byte("avatar"),
        CreatedAt: time.Now(),
        UpdatedAt: time.Now(),
    }
    result := db.Create(&user)
    if result.Error != nil {
        panic("Failed to create user!")
    }
    fmt.Println("User created successfully!")
}