英文:
`gorm` Ignoring `sql:"index"` Tags
问题
为什么gorm
忽略了sql:"index"
标签?没有创建索引。
这里使用的数据库是PostgreSQL(导入_ "github.com/lib/pq"
)。使用了以下Model
结构体(因为默认的gorm.Model
使用自增数字 - serial
- 作为主键,而我想自己设置id
):
type Model struct {
ID int64 `sql:"type:bigint PRIMARY KEY;default:0"`
CreatedAt time.Time
UpdatedAt time.Time
DeletedAt *time.Time `sql:"index"`
}
其中一个实际的模型是:
type TUHistory struct {
Model
TUID int64 `json:"tu_id,string" gorm:"column:tu_id" sql:"index"`
}
func (x *TUHistory) TableName() string {
return "tu_history"
}
通过db.CreateTable(&TUHistory{})
创建表,除了索引之外,表被正确创建。
作为临时解决方法,我使用db.Model(&TUHistory{}).AddIndex("ix_tuh_tu_id", "tu_id")
来创建索引。
英文:
Why gorm
is ignoring sql:"index"
tags? No indexes got created.
Database in use here is PostgreSQL (importing _ "github.com/lib/pq"
). This Model
struct is used (because default gorm.Model
uses an auto increment number - serial
- as primary key and I wanted to set id
myself):
type Model struct {
ID int64 `sql:"type:bigint PRIMARY KEY;default:0"`
CreatedAt time.Time
UpdatedAt time.Time
DeletedAt *time.Time `sql:"index"`
}
And one of actual models is:
type TUHistory struct {
Model
TUID int64 `json:"tu_id,string" gorm:"column:tu_id" sql:"index"`
}
func (x *TUHistory) TableName() string {
return "tu_history"
}
And the table is created by db.CreateTable(&TUHistory{})
which creates the table correctly except for indexes.
As a temporary work around, I do db.Model(&TUHistory{}).AddIndex("ix_tuh_tu_id", "tu_id")
to create indexes.
答案1
得分: 2
根据我的经验,db.CreateTable
只会创建表和字段。你最好使用 AutoMigrate
函数来迁移你想要的模型结构:
db, err := gorm.Open("postgres", connectionString)
...
// 错误检查
...
db.AutoMigrate(&Model)
另外,我尝试使用你发布的模型进行自动迁移,但是出现了一个错误,提示不允许有多个主键,所以我将模型更改为:
type Model struct {
Id int64 `sql:"type:bigint;default:0"`
CreatedAt time.Time
UpdatedAt time.Time
DeletedAt *time.Time `sql:"index"`
}
然后,AutoMigrate
成功地创建了所有的主键和索引。
编辑:
查看 GORM 的 README,在这个示例中,Email 结构如下:
type Email struct {
ID int
UserID int `sql:"index"` // 外键(属于),tag `index` 会在使用 AutoMigrate 时为该字段创建索引
Email string `sql:"type:varchar(100);unique_index"` // 设置字段的 SQL 类型,tag `unique_index` 会创建唯一索引
Subscribed bool
}
注意 UserId 字段的注释,它表示在使用 AutoMigrate 时会创建索引。
另外,值得一提的是,我们可以看一下 AutoMigrate 是如何工作的:
// 自动迁移
db.AutoMigrate(&User{})
db.Set("gorm:table_options", "ENGINE=InnoDB").AutoMigrate(&User{})
db.AutoMigrate(&User{}, &Product{}, &Order{})
// 随意更改你的结构,AutoMigrate 会保持你的数据库是最新的。
// AutoMigrate 只会添加*新的列*和*新的索引*,
// 不会更新当前列的类型或删除未使用的列,以保护你的数据。
// 如果表不存在,AutoMigrate 会自动创建表。
[1]: https://github.com/jinzhu/gorm#define-models-structs
[2]: https://github.com/jinzhu/gorm#migration
英文:
From my experience, the db.CreateTable only creates the table and it's fields. You are better off using the AutoMigrate function with the model structure that you want to migrate:
db, err := gorm.Open("postgres", connectionString)
...
// error checking
...
db.AutoMigrate(&Model)
Also, I tried AutoMigrating the model you posted and got an error saying that multiple primary keys are not allowed, so I changed the model to:
type Model struct {
Id int64 `sql:"type:bigint;default:0"`
CreatedAt time.Time
UpdatedAt time.Time
DeletedAt *time.Time `sql:"index"`
}
and the AutoMigration created all PKs and indexes just fine.
Edit:
Checking the GORM's README, on this example, the Email structure goes as:
type Email struct {
ID int
UserID int `sql:"index"` // Foreign key (belongs to), tag `index` will create index for this field when using AutoMigrate
Email string `sql:"type:varchar(100);unique_index"` // Set field's sql type, tag `unique_index` will create unique index
Subscribed bool
}
Notice the comment on the UserId field saying it will create the index when using AutoMigrate.
Also, it's worth taking a look at how the AutoMigrate does it's job:
// Automating Migration
db.AutoMigrate(&User{})
db.Set("gorm:table_options", "ENGINE=InnoDB").AutoMigrate(&User{})
db.AutoMigrate(&User{}, &Product{}, &Order{})
// Feel free to change your struct, AutoMigrate will keep your database up-to-date.
// AutoMigrate will ONLY add *new columns* and *new indexes*,
// WON'T update current column's type or delete unused columns, to protect your data.
// If the table is not existing, AutoMigrate will create the table automatically.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论