db.Model和db.Table查询之间的go-gorm差异

package main

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

type User struct {
    ID   uint
    Name string
    Age  int
}

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

    // 自动迁移模式
    db.AutoMigrate(&User{})

    // 创建记录
    db.Create(&User{Name: "John", Age: 25})

    // 使用 db.Model 进行查询
    var user User
    db.Model(&User{}).Where("name = ?", "John").First(&user)
    fmt.Println(user)
}

package main

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

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

    // 创建记录
    db.Exec("INSERT INTO users (name, age) VALUES (?, ?)", "Jane", 30)

    // 使用 db.Table 进行查询
    var result map[string]interface{}
    db.Table("users").Where("name = ?", "Jane").First(&result)
    fmt.Println(result)
}