How to create a general select repository to fit all kinds of query?

[spencerchang]

I noticed that kataras from iris/v12/_examples/mvc/login/repositories/user_repository.go
Used Exec, Select, SelectMany to select diff kind of queries but seems missing some common ways?

It seems very smart way to fit many kind of queries and could be reused in every table's repositories.

But i have question is:
How to handle sorting and only limited columns need to query like (select id from table) not (select * from table)?

Thanks.

[spencerchang]

My idea is very close to this PHP framework Laravel's software package
https://github.com/andersao/l5-repository

[kataras]

Hello @spencerchang,

The login/repositories/user_repository.go is just an example you can motivated from it.

There are many ORMs available in Go language, you don't need to re-invert the wheel, just google "golang database orm package".