dongzhila3786
2019-01-16 10:08
浏览 93
已采纳

如何使用gorm在特定的数据库模式中编写?

I am new at golang. I am trying to write in a specific database schema using GORM and database/sql package. Here is my struct

type Person struct {
gorm.Model
Name                string    
Age                 int    
}

and my function to write in db is:

func writedb(){

psqlInfo := fmt.Sprintf("host=%s port=%d user=%s "+" password=%s dbname=%s sslmode=disable", host, port, user, password, dbname)
    db, err := gorm.Open("postgres", psqlInfo)
    if err != nil {
        panic(err)
        fmt.Println("Não conectou-se ao BANCO DE DADOS")
    }
    defer db.Close()

    db.AutoMigrate(&Person{})

    //t := time.Now()
    //ts := t.Format("2006-01-02 15:04:05")

    db.Create(&Person{Name : "alex", Age: 20})


}

My db is structured like this databaseName --schemaPeople --schemaVehicle --schemaPublic

When I compile, the data inserted goes to an new table in public schema, I want to insert an row in people schema. What am I doing wrong? Am I declaring the struct wrong? How I set the specific schema??

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douniani679741 2019-01-16 10:29
    已采纳

    In the gorm you can denote the schema in the TableName() method of your struct, for example:

    type Person struct {
        gorm.Model
        Name string
        Age  int
    }
    
    func (Person) TableName() string {
        return "people.persons"
    }
    
    已采纳该答案
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题