Method DeleteWorkSheet

backend/store/worksheet.go:272–282

DeleteWorkSheet deletes an existing sheet by resource ID. The worksheet_organizer rows are cascade-deleted via FK on worksheet(resource_id).

(ctx context.Context, resourceID string)

// DeleteWorkSheet deletes an existing sheet by resource ID.
// The worksheet_organizer rows are cascade-deleted via FK on worksheet(resource_id).
func (s *Store) DeleteWorkSheet(ctx context.Context, resourceID string) error {
	q := qb.Q().Space(`DELETE FROM worksheet WHERE resource_id = ?`, resourceID)
	query, args, err := q.ToSQL()
	if err != nil {
		return errors.Wrapf(err, "failed to build sql")
	}
	if _, err := s.GetDB().ExecContext(ctx, query, args...); err != nil {
		return err
	}
	return nil
}

// WorksheetOrganizerMessage is the store message for worksheet organizer.
type WorksheetOrganizerMessage struct {