path: root/internal/models/engagement.go

package models

import (
	"database/sql"
	"errors"
	"time"
)

type EngagementStrategy struct {
	ID        int
	ValidFrom time.Time
	ValidTo   time.Time
	Operation Operation
}

type EngagementStrategyModel struct {
	DB *sql.DB
}

func (m *EngagementStrategyModel) GetForOperation(id int) (EngagementStrategy, error) {
	stmt := `SELECT id, valid_from, valid_to FROM engagement_strategies
WHERE operation_id = ?`
	row := m.DB.QueryRow(stmt, id)

	var es EngagementStrategy

	err := row.Scan(&es.ID, &es.ValidFrom, &es.ValidTo)
	if err != nil {
		if errors.Is(err, sql.ErrNoRows) {
			return EngagementStrategy{}, ErrNoRecord
		} else {
			return EngagementStrategy{}, err
		}
	}
	return es, nil
}