TechDivision\Import\Product\Media\Repositories\ProductMediaGalleryRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	75
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Test Coverage

Coverage

0%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	init()	0	12	1
A	findOneByAttributeIdAndValue()	0	13	1
A	findAllBySku()	0	10	1

<?php

/**
 * TechDivision\Import\Product\Media\Repositories\ProductMediaGalleryRepository
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is available through the world-wide-web at this URL:
 * http://opensource.org/licenses/osl-3.0.php
 *
 * PHP version 5
 *
 * @author    Tim Wagner <t.wagner@techdivision.com>
 * @copyright 2016 TechDivision GmbH <info@techdivision.com>
 * @license   http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
 * @link      https://github.com/techdivision/import-product-media
 * @link      http://www.techdivision.com
 */

namespace TechDivision\Import\Product\Media\Repositories;

use TechDivision\Import\Product\Media\Utils\MemberNames;
use TechDivision\Import\Repositories\AbstractRepository;

/**
 * Repository implementation to load product media gallery data.
 *
 * @author    Tim Wagner <t.wagner@techdivision.com>
 * @copyright 2016 TechDivision GmbH <info@techdivision.com>
 * @license   http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
 * @link      https://github.com/techdivision/import-product-media
 * @link      http://www.techdivision.com
 */
class ProductMediaGalleryRepository extends AbstractRepository
{

    /**
     * The prepared statement to load an existing product media gallery entity.
     *
     * @var \PDOStatement
     */
    protected $productMediaGalleryStmt;

    /**
     * The prepared statement to load the existing product media gallery entities by the given SKU.
     *
     * @var \PDOStatement
     */
    protected $productMediaGalleriesBySkuStmt;

    /**
     * Initializes the repository's prepared statements.
     *
     * @return void
     */
    public function init()
    {

        // load the utility class name
        $utilityClassName = $this->getUtilityClassName();

        // initialize the prepared statements
        $this->productMediaGalleryStmt =
            $this->getConnection()->prepare($this->getUtilityClass()->find($utilityClassName::PRODUCT_MEDIA_GALLERY));
        $this->productMediaGalleriesBySkuStmt =
            $this->getConnection()->prepare($this->getUtilityClass()->find($utilityClassName::PRODUCT_MEDIA_GALLERIES_BY_SKU));
    }

    /**
     * Load's the product media gallery with the passed attribute ID + value.
     *
     * @param integer $attributeId The attribute ID of the product media gallery to load
     * @param string  $value       The value of the product media gallery to load
     *
     * @return array The product media gallery
     */
    public function findOneByAttributeIdAndValue($attributeId, $value)
    {

        // initialize the params
        $params = array(
            MemberNames::ATTRIBUTE_ID => $attributeId,
            MemberNames::VALUE        => $value
        );

        // load and return the prodcut media gallery with the passed attribute ID + value
        $this->productMediaGalleryStmt->execute($params);
        return $this->productMediaGalleryStmt->fetch(\PDO::FETCH_ASSOC);
    }

    /**
     * Load's the product media gallery entities with the passed SKU.
     *
     * @param string $sku The SKU to load the media gallery entities for
     *
     * @return array The product media gallery entities
     */
    public function findAllBySku($sku)
    {

        // initialize the params
        $params = array(MemberNames::SKU => $sku);

        // load and return the prodcut media gallery entities with the passed SKU
        $this->productMediaGalleriesBySkuStmt->execute($params);
        return $this->productMediaGalleriesBySkuStmt->fetchAll(\PDO::FETCH_ASSOC);
    }
}