ozzo-dbx icon indicating copy to clipboard operation
ozzo-dbx copied to clipboard

[Advice] Chaining and Queries

Open euca01 opened this issue 5 years ago • 0 comments

Hi :),

I would like to chain a query though function. For example, i've :

err := db.Select("name").
	From("users").
	Where(dbx.HashExp{"UserId": 1}).
	One(&user)

And i would like to have something like that :

func ScopeByUserId( uID int ) {
    return Where(dbx.HashExp{"UserId": 1})
}

err := db.Select("name").
	From("users").
	ScopeByUserId( uID int ) .
	One(&user)

The idea is to be able to reuse the code. Is there a best pratice or advices for doing it ?

Thanks a lot for your help :)

euca01 avatar Mar 30 '20 19:03 euca01