Automatic updated_at with usage of Column()

[nanmu42]

Hi, I am using automatic timestamps discribed in the doc and I found when my update query contains Column(), updated_at does not get updated as the generated SQL does not contains it.

// times has now as its default on inserting and updating
type times struct {
	CreatedAt time.Time `bun:",nullzero,notnull,default:current_timestamp" json:"createdAt"`
	UpdatedAt time.Time `bun:",nullzero,notnull,default:current_timestamp" json:"updatedAt"`
}

var _ bun.BeforeAppendModelHook = (*times)(nil)

func (t *times) BeforeAppendModel(ctx context.Context, query schema.Query) error {
	switch query.(type) {
	case *bun.UpdateQuery:
		t.UpdatedAt = time.Now()
	}

	return nil
}

type OAuth2State struct {
	ID string `json:"id" bun:",pk"`

	times

	Mode             OAuth2StateMode `json:"mode" bun:",notnull,nullzero"`
	Status           OAuth2Status    `json:"status" bun:",notnull"`
}

func (op Operator) UpdateOAuth2StateStatusByID(ctx context.Context, id string, status OAuth2Status) (err error) {
	state := OAuth2State{ID: id, Status: status}
	err = assertAffectedOneRow(op.db.NewUpdate().
		Model(&state).
		Column("status"). // only status appears in the SET section of the generated SQL
		WherePK().
		Exec(ctx))
	return
}

Did I miss something? Any idea would be appreciated.

Thanks.

[vmihailenco]

I found when my update query contains Column(), updated_at does not get updated as the generated SQL does not contains it.

This is the expected behavior, not a bug. Just include updated_at column to be updated.

[nasa1024]

thanks