Method RecordExternalTransaction

database/reconciliation.go:349–364

RecordExternalTransaction inserts a new external transaction into the database. It associates the transaction with an upload ID and records its details. Parameters: - ctx: Context for managing request and tracing. - tx: Pointer to the ExternalTransaction struct containing transaction data. - uploadI

(ctx context.Context, tx *model.ExternalTransaction, uploadID string)

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

	_, err := d.Conn.ExecContext(ctx,
		`INSERT INTO ledgerforge.external_transactions(
			id, amount, reference, currency, description, date, source, upload_id
		) VALUES ($1, $2, $3, $4, $5, $6, $7, $8)`,
		tx.ID, tx.Amount, tx.Reference, tx.Currency, tx.Description, tx.Date, tx.Source, uploadID,
	)
	if err != nil {
		return apierror.NewAPIError(apierror.ErrInternalServer, "Failed to record external transaction", err)
	}

	return nil
}

// GetExternalTransactionsByReconciliationID fetches all external transactions associated with a given reconciliation ID.
// Parameters: