MySQL

go get gorm.io/driver/mysql

package main
 
import (
    "log"
    "github.com/MUKE-coder/gorm-studio/studio"
    "github.com/gin-gonic/gin"
    "gorm.io/driver/mysql"
    "gorm.io/gorm"
)
 
type Article struct {
    ID      uint   `gorm:"primarykey"`
    Title   string `gorm:"size:255"`
    Content string `gorm:"type:text"`
    Author  string `gorm:"size:100"`
}
 
func main() {
    dsn := "user:password@tcp(127.0.0.1:3306)/mydb?charset=utf8mb4&parseTime=True&loc=Local"
    db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
    if err != nil {
        log.Fatal("Failed to connect:", err)
    }
    db.AutoMigrate(&Article{})
 
    r := gin.Default()
    studio.Mount(r, db, []interface{}{&Article{}})
    r.Run(":8080")
}

user:password@tcp(host:port)/dbname?charset=utf8mb4&parseTime=True&loc=Local