素朴なSeederを作成してUnitテストの実装効率を上げた話

INSERT INTO company ("id", "name", "zip", "address", "phone", "industry_type",
										 "description", "cover_image", "logo_image")
VALUES (1, "株式会社テスト", "000-0000", "東京都", "000-0000-0000",
				"サービス業", "事業内容について", "/cover_image/test.png", "/logo_image/test.jpeg");

INSERT INTO press_release ("id", "company_id", "title", "sub_title", "body",
													 "thumbnail_image")
VALUES (1, 1, "タイトル", "サブタイトル", "本文", "/thumbnail_image/test.jpeg");

<?php

trait CompanyRepoTestDataTrait
{
    public function resetData(): void
    {
        // テスト用のデータベースと接続するPDOを取得
        $pdo = PDOFactory::getPDOInstance();

        // 上記のinit.sqlに記述されているSQLを取得
        $sql_path = __DIR__ . '/init.sql';
        $sql = file_get_contents($sql_path);

        // SQLを実行
        $pdo->exec($sql);
    }
}

class CompanyRepoTest extends TestCase
{
    use CompanyRepoTestDataTrait;

    public function setUp(): void
    {
        parent::setUp();

        $this->resetData();
    }

    public function testFindById(): void
    {
        $company = CompanyRepo::findById(1);

        $this->assertInstanceOf(Company::class, $company);
    }
}

<?php

declare(strict_types=1);

namespace PRTIMES\PrTimes\Seeder;

use Faker\Factory;
use PDO;
use PRTIMES\PrSql;

class CompanySeeder
{
    public static function seed(PDO $pdo, array $companyData, int $rowQuantity = 1): void
    {
        $faker = Factory::create("ja_JP");

        for ($i = 0; $i < $rowQuantity; $i++) {
            PrSql::execute($pdo, '
                INSERT INTO company (
                    id,
					name,
				    zip,
					address,
					phone,
					industry_type,
					description,
					cover_image,
				    logo_image
				) VALUES (
					:id@int,
					:name@string,
					:zip@string,
					:address@string,
					:phone@string,
					:industry_type@string,
					:description@string,
					:cover_image@string,
					:logo_image@string
				)
			', [
				':id' => $companyData['id'] ?? $faker->numberBetween(1, 999999999),
				':name' => $companyData['name'] ?? $faker->company,
				':zip' => $companyData['zip'] ?? $faker->postcode,
				':address' => $companyData['address'] ?? $faker->address,
				':phone' => $companyData['phone'] ?? $faker->phoneNumber,
				':industry_type' => $companyData['industry_type'] ?? $faker->word,
				':description' => $companyData['description'] ?? $faker->text,
				':cover_image' => $companyData['cover_image'] ?? $faker->url,
				':logo_image' => $companyData['logo_image'] ?? $faker->url
			]);
		}
	}
}

<?php

class CompanyRepoTest extends TestCase
{
	public function setUp(): void
	{
		parent::setUp();

		$pdo = PDOFactory::getPDOInstance();
		CompanySeeder::seed($pdo, [
		    'id' => 1,
			'name' => '株式会社Hoge'
		]);
	}

	public function testFindById(): void
	{
		$company = CompanyRepo::findById(1);

		$this->assertInstanceOf(Company::class, $company);
	}
}