📚 PHP 최상급 - 6주차: 테스트 자동화 (단위/통합/E2E 테스트)- 02 통합 테스트 작성

<?php
// PostRepository.php (데이터베이스와 연동)
class PostRepository {
    private PDO $pdo;

    public function __construct(PDO $pdo) {
        $this->pdo = $pdo;
    }

    public function create(string $title, string $content): int {
        $stmt = $this->pdo->prepare("INSERT INTO posts (title, content) VALUES (:title, :content)");
        $stmt->execute([':title' => $title, ':content' => $content]);
        return (int)$this->pdo->lastInsertId();
    }

    public function find(int $id): ?array {
        $stmt = $this->pdo->prepare("SELECT * FROM posts WHERE id = :id");
        $stmt->execute([':id' => $id]);
        $post = $stmt->fetch(PDO::FETCH_ASSOC);
        return $post ?: null;
    }
}

<?php
use PHPUnitFrameworkTestCase;

// 테스트 전용 PDO 객체 (실제 DB 연결)
class TestDatabase
{
    private static ?PDO $pdo = null;

    public static function getConnection(): PDO
    {
        if (self::$pdo === null) {
            // .env.testing 등에서 DB_DSN, DB_USER, DB_PASS 불러오기
            $dsn = $_ENV['DB_DSN'] ?? 'sqlite::memory:'; 
            $user = $_ENV['DB_USER'] ?? null;
            $pass = $_ENV['DB_PASS'] ?? null;
            self::$pdo = new PDO($dsn, $user, $pass);
            self::$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            self::$pdo->exec("CREATE TABLE IF NOT EXISTS posts (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                title VARCHAR(255) NOT NULL,
                content TEXT NOT NULL
            )");
        }
        return self::$pdo;
    }

    public static function resetDatabase(): void
    {
        $pdo = self::getConnection();
        $pdo->exec("DELETE FROM posts");
        $pdo->exec("DELETE FROM sqlite_sequence WHERE name='posts'"); // SQLite AUTOINCREMENT 재설정
    }
}

class PostManagementTest extends TestCase
{
    private PostRepository $postRepository;

    protected function setUp(): void
    {
        parent::setUp();
        TestDatabase::resetDatabase(); // 각 테스트 전에 DB 초기화
        $this->postRepository = new PostRepository(TestDatabase::getConnection());
    }

    public function testPostCreationAndRetrieval(): void
    {
        // Arrange
        $title = "첫 번째 게시글";
        $content = "내용입니다.";

        // Act - 게시물 생성 및 조회 (PostRepository와 PDO가 함께 작동)
        $newPostId = $this->postRepository->create($title, $content);
        $retrievedPost = $this->postRepository->find($newPostId);

        // Assert
        $this->assertNotNull($retrievedPost);
        $this->assertEquals($title, $retrievedPost['title']);
        $this->assertEquals($content, $retrievedPost['content']);
        $this->assertEquals($newPostId, $retrievedPost['id']);
    }

    public function testNonExistentPostRetrieval(): void
    {
        // Act
        $retrievedPost = $this->postRepository->find(999); // 존재하지 않는 ID

        // Assert
        $this->assertNull($retrievedPost);
    }
}