Closed
Description
i want change default v7 struct to v5 ,use NewAdapterByDBWithCustomTable is not work
type CasbinRule struct {
ID uint `gorm:"primaryKey;autoIncrement"`
Ptype string `gorm:"size:100;uniqueIndex:unique_index"`
V0 string `gorm:"size:100;uniqueIndex:unique_index"`
V1 string `gorm:"size:100;uniqueIndex:unique_index"`
V2 string `gorm:"size:100;uniqueIndex:unique_index"`
V3 string `gorm:"size:100;uniqueIndex:unique_index"`
V4 string `gorm:"size:100;uniqueIndex:unique_index"`
V5 string `gorm:"size:100;uniqueIndex:unique_index"`
}
func InitCasbin() {
mysqlc := common.CONFIG.Mysqls[0]
host, port, user, password, database := mysqlc.Host, mysqlc.Port, mysqlc.User, mysqlc.Password, mysqlc.Database
dsn := fmt.Sprintf("%s:%s@tcp(%s:%d)/%s?charset=utf8mb4&parseTime=True&loc=Local", user, password, host, port, database)
db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
if err != nil {
common.Log.Error(err.Error())
return
}
gormAdapter.TurnOffAutoMigrate(db)
a, err := gormAdapter.NewAdapterByDBWithCustomTable(db, &CasbinRule{}, "casbin_rule")
if err != nil {
common.Log.Error(err.Error())
return
}
//a, _ := gormAdapter.NewAdapter("mysql", dsn, true)
e, err := casbin.NewEnforcer(constants.CasbinModel, a)
if err != nil {
common.Log.Error(err.Error())
return
}
e.AddFunction("ParamsMatch", ParamsMatchFunc)
```
can you help me , is err here
Error 1054: Unknown column 'v6' in 'field list'
[73.947ms] [rows:0] INSERT INTO `casbin_rule` (`ptype`,`v0`,`v1`,`v2`,`v3`,`v4`,`v5`,`v6`,`v7`) VALUES ('g','develop','base','','','','','','')