CREATE TABLE blog_posts (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    title VARCHAR(255),
    author VARCHAR(255),
    contents TEXT,
    created_at TIMESTAMP DEFAULT now()
);

<?php declare(strict_types=1);

namespace Cspray\DatabaseTestCase\BlogPostDemo;

use Cspray\DatabaseTestCase\DatabaseTestCase;
use Cspray\DatabaseTestCase\LoadFixture;
use Cspray\DatabaseTestCase\SingleRecordFixture;
use Cspray\DatabaseTestCase\DatabaseRepresentation\Row;
use PDO;

final class BlogPostsTestCase extends DatabaseTestCase {

    protected static function getConnectionAdapter() : ConnectionAdapter {
        return new PdoConnectionAdapter(
            new ConnectionAdapterConfig(
                database: 'postgres',
                host: 'localhost',
                port: 5432,
                user: 'postgres',
                password: 'password'
            ),
            PdoDriver::Postgresql
        );
    }

    public function testUnderlyingConnectionInstanceOfPdo() : void {
        // Pass this to your own code under test that expects a PDO instance!
        self::assertInstanceOf(PDO::class, self::getUnderlyingConnection());
    }

    public function testGettingTableRepresentationForAssertingOn() : void {
        // An immutable representation of every row in the given table at a given point
        $table = $this->getTable('blog_posts');

        // The $table is countable and will return the number of rows it currently has
        self::assertCount(0, $table);
    }

    // Load data into the database before your test starts
    // Pass as many Fixture instances as you want!
    #[LoadFixture(
        new SingleRecordFixture(
            'blog_posts',
            ['title' => 'My blog post', 'author' => 'cspray', 'contents' => 'Test all the things']
        ),
        new SingleRecordFixture(
            'blog_posts',
            ['title' => 'Another post', 'author' => 'cspray', 'contents' => 'Something, something testing databases']
        )
    )]
    public function testLoadingFixtureDataForSingleTest() : void {
        $table = $this->getTable('blog_posts');

        self::assertCount(2, $table);

        // You can iterate over $table to get access to each Row present
        $expectedTitles = ['My blog post', 'Another post'];
        $actualTitles = array_map(
            static fn(Row $row) => $row->get('title'),
            iterator_to_array($table)
        );
        self::assertSame($expectedTitles, $actualTitles);

        // Or you could get a specific row and assert on that
        $anotherPost = $table->getRow(1);
        self::assertSame('Something, something testing databases', $anotherPost->get('contents'));
    }

    public function testRefetchingTableAfterPersistence() : void {
        // In database tests it is common to assert that your table is empty...
        $beforePersist = $this->getTable('blog_posts');
        self::assertCount(0, $beforePersist);

        // perform some code that persists something ...
        yourCodeThatTakesPdoInstanceAndPersistsOneRecord(
            self::getUnderlyingConnection()
        );

        // and assert on post conditions. Remember to refetch a new table!
        $afterPersist = $this->getTable('blog_posts');

        self::assertCount(1, $afterPersist);
        self::assertCount(0, $beforePersist);
    }

}