[Question] Customizing casbin_rule table name

[arafat-java]

What's your scenario? What do you want to achieve?
We are working on a cloud based offering and planning to use casbin.
In that we would like to segregate tenant's data and for that we would like to create separate casbin_rules tables for each tenant.
I know that we have the provision for seperate databases and that we can pass in the connection string
But we don't want to have that many databases.

So our requirement is that instead of the default table name casbin_rule how can we have that table name customized to something like tenant1_casbin_rule, tenant1_casbin_rule... tenantn_casbin_rule

[hsluoyz]

@arafat-java what adapter do you use? Customizing casbin_rule table name is usually provided by each adapter instead of the main lib.

[arafat-java]

We are using https://github.com/casbin/gorm-adapter

[hsluoyz]

@arafat-java see:

gorm-adapter/adapter.go

Lines 158 to 177 in d4ad5d9

	// NewAdapterByDBUseTableName creates gorm-adapter by an existing Gorm instance and the specified table prefix and table name
	// Example: gormadapter.NewAdapterByDBUseTableName(&db, "cms", "casbin") Automatically generate table name like this "cms_casbin"
	func NewAdapterByDBUseTableName(db *gorm.DB, prefix string, tableName string) (*Adapter, error) {
	if len(tableName) == 0 {
	tableName = defaultTableName
	}
	a := &Adapter{
	tablePrefix: prefix,
	tableName: tableName,
	}
	a.db = db.Scopes(a.casbinRuleTable()).Session(&gorm.Session{Context: db.Statement.Context})
	err := a.createTable()
	if err != nil {
	return nil, err
	}
	return a, nil
	}