Use the getFullTableName method in NewFilteredAdapterByDB to concatenate data tables with underscores

[chenxi2015]

My code:

prefix := "cn_"
tableName := "casbin_rule"
adapter, _ := gormadapter.NewFilteredAdapterByDB(db, prefix, tableName)

getFullTableName code:

func (a *Adapter) getFullTableName() string {
    if a.tablePrefix != "" {
        return a.tablePrefix + "_" + a.tableName
    }
    return a.tableName
}

My mysql connect code:

d, err := database.New(
        dbContainer(masterDsn),
        &gorm.Config{
            NamingStrategy: schema.NamingStrategy{
                TablePrefix:   prefix, // set prefix to cn_  is correct,but cn  is wrong in this
                SingularTable: true,
            },
            Logger: newLogger,
        },
        database.WithMaxIdleConn(vars.Config.GetInt("database.mysql.minIdleConn")),
        database.WithMaxOpenConn(vars.Config.GetInt("database.mysql.maxOpenConn")),
        database.WithConnMaxIdleTime(vars.Config.GetDuration("database.mysql.maxIdleTime")*time.Second),
        database.WithConnMaxLifetime(vars.Config.GetDuration("database.mysql.maxLifetime")*time.Minute),
    )

This parameter cannot be shared with the prefix configured in gorm If I set prefix to cn_, the table name of gorm concatenation will be determined cn_casbin_rule, but the table name of casbin is cncasbin_rule. Why do I need to concatenate with underscores like this? How can I fix it？

[chenxi2015]

hello ? Can anybody solve it ?

[hsluoyz]

@chenxi2015 plz make a PR to fix it

[chenxi2015]

240 I have already make a PR ，plz check it @hsluoyz

[hsluoyz]

@chenxi2015 the default behavior should not be modified. You are bringing trouble to all old users and give them incompatibility. Fix the problem by yourself in your code