CmsBlockRepository.php

<?php
declare(strict_types=1);

/**
 * Copyright (c) 2025 TechDivision GmbH
 * All rights reserved
 *
 * This product includes proprietary software developed at TechDivision GmbH, Germany
 * For more information see https://www.techdivision.com/
 *
 * To obtain a valid license for using this software please contact us at
 * license@techdivision.com
 *
 * @copyright  Copyright (c) 2025 TechDivision GmbH (https://www.techdivision.com)
 * @author     TechDivision Team Zero <zero@techdivision.com>
 * @link       https://www.techdivision.com/
 */

namespace Firegento\ContentProvisioning\Model\Repository;

use Firegento\ContentProvisioning\Api\CmsBlockRepositoryInterface;
use Magento\Framework\App\ResourceConnection;

class CmsBlockRepository implements CmsBlockRepositoryInterface
{
    public const CMS_BLOCK_TABLE_NAME = 'cms_block';

    /**
     * @var ResourceConnection
     */
    private ResourceConnection $resource;

    /**
     * @param ResourceConnection $resource
     */
    public function __construct(
        ResourceConnection $resource
    ) {
        $this->resource = $resource;
    }

    /**
     * Get CMS Block data by its title.
     *
     * @param string $title
     * @return array
     */
    public function getByTitle(string $title): array
    {
        $connection = $this->resource->getConnection();
        $select =  $connection->select()
            ->from('cms_block')
            ->where('title = :title');

        $bind = ['title' => $title];
        return $connection->fetchRow($select, $bind);
    }
}