How can I set a table prefix from config???

[maximniko]

I use github.com/qiangxue/golang-restful-starter-kit bun can`t find, how can I set table_prefix from config

server.go > buildRouter () {
...
artistDAO := daos.NewArtistDAO()
apis.ServeArtistResource(rg, services.NewArtistService(artistDAO))
}

Error:
level=error msg="Error 1146: Table 'db.table' doesn't exist"

I need set table-prefix from config by this query "SELECT * FROM db.prefixTable ..."

[kPshi]

You can set the whole table name by implementing the TableModel interface:

type TableModel interface {
    TableName() string
}

E.g. like

func (ArtistDAO) TableName() string {
    return "myprefix_artists";
}

or

    // snip
    return myDynamicPrefix()+"artists"

but I do agree with you that a prefix would be very helpful. Currently having the same prob here. Maybe one should implement it and make a pull request.

[kPshi]

About to implement that. One topic I'd like to discuss:
struct.go defines

251:  func GetTableName(a interface{}) string {
...:      // snip
268: }

as a static function. Is there a reason to implement it statically instead of an instance method of *DB for example? The latter would allow to configure it in a clean way and also allow to use ozzo-dbx multiple times in a single process, possibly connecting to the same database instance only using different table prefixes.
I'd personally prefer that latter implementation and would (if not suggested differently here) leave the old static method in for now so that software already using ozzo does not have to be changed.

Comments?

@qiangxue : maybe that topic could benefit by your opinion on that.

[kPshi]

Implemented with pull request #69