ParcelControllerIntegrationTests.cs

using System;
using System.Collections.Generic;
using System.Net.Http;
using System.Net.Http.Json;
using System.Threading.Tasks;
using FluentAssertions;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Mvc.Testing;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using ParcelTracking.Infrastructure.Data;
using ParcelTracking.Application.DTOs.Parcels.Requests;
using ParcelTracking.Application.DTOs.Common;
using ParcelTracking.Domain.Enums;
using ParcelTracking.Domain.Entities;
using Xunit;

namespace ParcelTracking.API.IntegrationTests
{
    /// <summary>
    /// Integration tests for the Parcels Controller endpoints.
    /// 
    /// These tests require a PostgreSQL database. To run with Docker:
    /// docker run -d --name parceltrack-test-db -e POSTGRES_USER=test -e POSTGRES_PASSWORD=test -e POSTGRES_DB=parceltracking_test -p 5433:5432 postgres:15
    /// 
    /// Then update the connection string in this test class to point to your database instance.
    /// </summary>
    public class ParcelApiTests : IAsyncLifetime
    {
        private WebApplicationFactory<Program>? _factory;
        private HttpClient? _client;
        private string? _connectionString;

        public async Task InitializeAsync()
        {
            // Use a connection string pointing to a running Postgres instance
            // Set via environment variable or hardcode for testing (NOT RECOMMENDED for production)
            _connectionString = Environment.GetEnvironmentVariable("PARCELTRACK_TEST_DB") 
                ?? "Host=localhost;Port=5433;Database=parceltracking_test;Username=test;Password=test;Pooling=false;";

            // Attempt to create the factory with the test database
            try
            {
                _factory = new WebApplicationFactory<Program>()
                    .WithWebHostBuilder(builder =>
                    {
                        builder.ConfigureAppConfiguration((context, cfg) =>
                        {
                            var inMemConfig = new Dictionary<string, string?>
                            {
                                {"ConnectionStrings:DefaultConnection", _connectionString}
                            };
                            cfg.AddInMemoryCollection(inMemConfig);
                        });
                    });

                _client = _factory.CreateClient();

                // Ensure database is created and migrated
                var options = new DbContextOptionsBuilder<ParcelTrackingDbContext>()
                    .UseNpgsql(_connectionString)
                    .Options;

                using (var db = new ParcelTrackingDbContext(options))
                {
                    db.Database.EnsureCreated();
                }
            }
            catch (Exception)
            {
                // If Docker PostgreSQL is not available, silently skip this test
                // This allows the unit tests to pass on systems without Docker
                _connectionString = null;
                _factory?.Dispose();
                _factory = null;
                _client = null;
            }
        }

        public async Task DisposeAsync()
        {
            _client?.Dispose();
            _factory?.Dispose();
        }

        [Fact]
        public async Task RegisterParcel_ReturnsCreatedAndEstimatedDeliveryHasLocal1700()
        {
            // Skip test if Docker database is not available
            if (_client == null || _connectionString == null)
            {
                throw new SkipTestException("PostgreSQL database not available. Start Docker container with: docker run -d --name parceltrack-test-db -e POSTGRES_USER=test -e POSTGRES_PASSWORD=test -e POSTGRES_DB=parceltracking_test -p 5433:5432 postgres:15");
            }

            // Arrange: seed addresses
            var options = new DbContextOptionsBuilder<ParcelTrackingDbContext>()
                .UseNpgsql(_connectionString)
                .Options;

            Guid shipperId, recipientId;
            using (var db = new ParcelTrackingDbContext(options))
            {
                db.Database.EnsureCreated();

                var shipper = new Address { Id = Guid.NewGuid(), CountryCode = "US", City = "NYC", Street1 = "S" };
                var recipient = new Address { Id = Guid.NewGuid(), CountryCode = "US", City = "Boston", Street1 = "R" };
                db.Addresses.Add(shipper);
                db.Addresses.Add(recipient);
                await db.SaveChangesAsync();
                shipperId = shipper.Id;
                recipientId = recipient.Id;
            }

            var req = new RegisterParcelRequest
            {
                ShipperAddressId = shipperId,
                RecipientAddressId = recipientId,
                ServiceType = ServiceType.Standard,
                Weight = new WeightDto { Value = 1m, Unit = Domain.Enums.WeightUnit.Kg },
                Dimensions = new DimensionsDto { Length = 1, Width = 1, Height = 1, Unit = Domain.Enums.DimensionUnit.Cm },
                DeclaredValue = new DeclaredValueDto { Amount = 1m, Currency = "USD" }
            };

            // Act
            var response = await _client!.PostAsJsonAsync("api/v1/Parcels", req);

            // Assert
            response.StatusCode.Should().Be(System.Net.HttpStatusCode.Created);

            var created = await response.Content.ReadFromJsonAsync<ParcelTracking.Application.DTOs.Parcels.ParcelDto>();
            created.Should().NotBeNull();
            created!.EstimatedDeliveryDate.Hour.Should().Be(17);
        }
    }

    /// <summary>
    /// Custom exception to skip integration tests when infrastructure is not available.
    /// </summary>
    public class SkipTestException : Exception
    {
        public SkipTestException(string message) : base(message) { }
    }
}