wcamarao / pmx Goto Github PK

I like the (very) lean premise of pmx, since it enables us to avoid bloated ORMs.

However, the fact that for e.g. an pmx.Update query there is no return value that enables us to see whether there was in fact an update (i.e. "RowsAffected") is problematic, since usually one would like to make this distinction (additionally to error/no-error).

So it would be better to have either (always/optionally?) commandTag returned, or have an additional Update wrapper that can be chosen to get more feedback.

Hi, I've stumbled over your library while searching for how to use the pgx struct tags with insert / update operations. In my opinion the pgx functionality is quite incomplete because it only allows for scanning. Don't you think it would be a better idea to try to upstream the functionality of your library to the pgx project?

If I'm calling Insert and passing a struct is it possible to get it to return with the autogenerated fields filled in?

type Request struct {
	ID        uuid.UUID `json:"-" generated:"auto" db:"id" table:"sign_request_user"`
	Request string    `json:"request" db:"request"`
	Created   time.Time `json:"-" generated:"auto" db:"-"`
	Updated   time.Time `json:"-" generated:"auto" db:"-"`
	Status    string    `json:"-" generated:"auto" db:"-"`

So I insert just the Request value into the struct and would get back filled in ID, Status and such.

type B struct {
	Type   string             `db:"type" table:"games_bets"`
	Game   Game               `db:"" table:"games"`
	User   storusermodel.User `db:"" table:"users"`
	Amount float64            `db:"amount"`
	Value  string             `db:"value"`
}

I have this struct, how i can scan into Game and User?