Method Update

structable.go:453–466

Update updates the values on an existing entry. This updates records where the Record's primary keys match the record in the database. Essentially, it runs `UPDATE table SET names=values WHERE id=?` If no entry is found, update will NOT create (INSERT) a new record.

()

//
// If no entry is found, update will NOT create (INSERT) a new record.
func (s *DbRecorder) Update() error {

	whereParts := s.whereIds()

	cols, vals := s.colValLists(false, true)

	q := s.builder.Update(s.table)
	for i := range cols {
		q = q.Set(cols[i], vals[i])
	}

	_, err := q.Where(whereParts).Exec()
	return err
}

// colList gets a list of column names. If withKeys is false, columns that are
// designated as primary keys will not be returned in this list.