Method RecordMatch

database/reconciliation.go:279–294

RecordMatch inserts a single match into the database. It is used to record the match between external and internal transactions during reconciliation. Parameters: - ctx: Context for managing request and tracing. - match: A pointer to the Match struct containing details of the external and internal t

(ctx context.Context, match *model.Match)

// Returns:
// - An error if the operation fails, wrapped in an APIError for consistency.
func (d Datasource) RecordMatch(ctx context.Context, match *model.Match) error {
	ctx, span := otel.Tracer("reconciliation.database").Start(ctx, "Saving match to db")
	defer span.End()

	_, err := d.Conn.ExecContext(ctx,
		`INSERT INTO ledgerforge.matches(
			external_transaction_id, internal_transaction_id, reconciliation_id, amount, date
		) VALUES ($1, $2, $3, $4, $5)`,
		match.ExternalTransactionID, match.InternalTransactionID, match.ReconciliationID, match.Amount, match.Date,
	)
	if err != nil {
		return apierror.NewAPIError(apierror.ErrInternalServer, "Failed to record match", err)
	}

	return nil
}

// GetMatchesByReconciliationID retrieves all matches associated with a given reconciliation ID.
// It joins the matches table with external transactions to filter matches by reconciliation ID.