TechDivision\Import\Product\Magic360\Utils\SqlStatements

Complexity

Total Complexity

2

Size/Duplication

Total Lines	119
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	8	2

<?php

/**
 * TechDivision\Import\Product\Magic360\Utils\SqlStatements
 *
 * 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>
 * @author    Bernhard Wick <b.wick@techdivision.com>
 * @copyright 2017 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-magic360
 * @link      http://www.techdivision.com
 */

namespace TechDivision\Import\Product\Magic360\Utils;

use TechDivision\Import\Utils\AbstractSqlStatements;

/**
 * Collection of SQL statements used for data manipulation.
 *
 * @author    Tim Wagner <t.wagner@techdivision.com>
 * @author    Bernhard Wick <b.wick@techdivision.com>
 * @copyright 2017 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-magic360
 * @link      http://www.techdivision.com
 */
class SqlStatements extends AbstractSqlStatements
{

    /**
     * The SQL statement to load an existing magic360 gallery byproduct ID and position.
     *
     * @var string MAGIC360_GALLERY
     */
    const MAGIC360_GALLERY = 'magic360_gallery';

    /**
     * The SQL statement to load an existing magic360 column by product ID.
     *
     * @var string MAGIC360_COLUMNS
     */
    const MAGIC360_COLUMNS = 'magic360_colums';

    /**
     * The SQL statement to create a new magic360 gallery entry.
     *
     * @var string CREATE_MAGIC360_GALLERY
     */
    const CREATE_MAGIC360_GALLERY = 'create.magic360_gallery';

    /**
     * The SQL statement to update an existing magic360 gallery entry.
     *
     * @var string UPDATE_MAGIC360_GALLERY
     */
    const UPDATE_MAGIC360_GALLERY = 'update.magic360_gallery';

    /**
     * The SQL statement to delete an existing magic360 gallery entry.
     *
     * @var string DELETE_MAGIC360_GALLERY
     */
    const DELETE_MAGIC360_GALLERY = 'delete.magic360_gallery';

    /**
     * The SQL statement to create a new magic360 column entry.
     *
     * @var string CREATE_MAGIC360_COLUMNS
     */
    const CREATE_MAGIC360_COLUMNS = 'create.magic360_columns';

    /**
     * The SQL statement to update an existing magic360 column entry.
     *
     * @var string UPDATE_MAGIC360_COLUMNS
     */
    const UPDATE_MAGIC360_COLUMNS = 'update.magic360_columns';

    /**
     * The SQL statement to update an existing magic360 column entry.
     *
     * @var string DELETE_MAGIC360_COLUMNS
     */
    const DELETE_MAGIC360_COLUMNS = 'delete.magic360_columns';

    /**
     * The SQL statements.
     *
     * @var array
     */
    private $statements = array(
        SqlStatements::MAGIC360_GALLERY =>
            'SELECT *
               FROM magic360_gallery
              WHERE product_id = :product_id
                AND position = :position',
        SqlStatements::MAGIC360_COLUMNS =>
            'SELECT *
               FROM magic360_columns
              WHERE product_id = :product_id',
        SqlStatements::CREATE_MAGIC360_GALLERY =>
            'INSERT
               INTO magic360_gallery
                    (product_id,
                     position,
                     file)
             VALUES (:product_id,
                     :position,
                     :file)',
        SqlStatements::UPDATE_MAGIC360_GALLERY =>
            'UPDATE magic360_gallery
                SET product_id = :product_id,
                    position = :position,
                    file = :file
              WHERE id = :id',
        SqlStatements::DELETE_MAGIC360_GALLERY =>
            'DELETE FROM magic360_gallery WHERE product_id = :product_id',
        SqlStatements::CREATE_MAGIC360_COLUMNS =>
            'INSERT
               INTO magic360_columns
                    (product_id,
                     columns)
             VALUES (:product_id,
                     :columns)',
        SqlStatements::UPDATE_MAGIC360_COLUMNS =>
            'UPDATE magic360_columns
                SET product_id = :product_id,
                    columns = :columns
              WHERE product_id = :product_id',
        SqlStatements::DELETE_MAGIC360_COLUMNS =>
            'DELETE FROM magic360_columns WHERE product_id = :product_id',
    );

    /**
     * Initialize the the SQL statements.
     */
    public function __construct()
    {

        // merge the class statements
        foreach ($this->statements as $key => $statement) {
            $this->preparedStatements[$key] = $statement;
        }
    }
}