beego QueryTable table name: `cpes` not exists

Question

I have this pice of code in beego:

o := orm.NewOrm()
qs := o.QueryTable("cpes")

and I now that beego connects well with the database, and the database have the 'cpes' table, but I keep getting an error becouse beego don't find the table.

¿How can I debug this further?

score 2 · Answer 1 · edited Dec 07 '16 at 11:21

2

You must define model Cpes and register model 'cpes'.

Like:

type Cpes struct {
    Id int
}

func (u *Cpes) TableName() string {
    // db table name
    return "cpes"
}

func init() {
    orm.RegisterModel(new(Cpes))
}

edited Dec 07 '16 at 11:21

3N1GM4

3,372
3
19
40

answered Dec 07 '16 at 09:33

alienxt

21
3

score 1 · Answer 2 · answered Apr 09 '17 at 04:32

I had the same problem. In my case, it was because I didn't register the model.

orm.RegisterModel(new(Member), new(Bank), new(Queue), new(Payment))

Make sure you registered all your models with beego. The error message should have been more explicit though

score 0 · Answer 3 · answered Sep 05 '16 at 10:33

I had the same problem a few weeks ago. The answer is in how Beego is translating the table name in the ORM.

The quick fix is to use

qs := o.QueryTable(new(cpes))

Where cpes is the model struct.

If you want to see this in action or this solution does not work for you try using the bee generate api command on your database. This will give you the models in a pre-made fashion as well as a bunch of code examples on how to use them.

Best of luck!

beego QueryTable table name: `cpes` not exists

3 Answers3