TechDivision\Import\Product\Magic360\Utils\SqlStatements

Complexity

Total Complexity

2

Size/Duplication

Total Lines	102
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	__clone()	0	3	1

<?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;

/**
 * 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
{

    /**
     * This is a utility class, so protect it against direct
     * instantiation.
     */
    private function __construct()
    {
    }

    /**
     * This is a utility class, so protect it against cloning.
     *
     * @return void
     */
    private function __clone()
    {
    }

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

    /**
     * The SQL statement to load an existing magic360 column by product ID.
     *
     * @var string MAGIC360_COLUMNS
     */
    const MAGIC360_COLUMNS = 'SELECT *
                                           FROM magic360_columns
                                          WHERE product_id = :product_id';

    /**
     * The SQL statement to create a new magic360 gallery entry.
     *
     * @var string CREATE_MAGIC360_GALLERY
     */
    const CREATE_MAGIC360_GALLERY = 'INSERT
                                            INTO magic360_gallery (
                                                     product_id,
                                                     position,
                                                     file
                                                   )
                                            VALUES (:product_id,
                                                    :position,
                                                    :file)';

    /**
     * The SQL statement to update an existing magic360 gallery entry.
     *
     * @var string UPDATE_MAGIC360_GALLERY
     */
    const UPDATE_MAGIC360_GALLERY = 'UPDATE magic360_gallery
                                             SET product_id = :product_id,
                                                 position = :position,
                                                 file = :file
                                           WHERE id = :id';

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

    /**
     * The SQL statement to create a new magic360 column entry.
     *
     * @var string CREATE_MAGIC360_COLUMNS
     */
    const CREATE_MAGIC360_COLUMNS = 'INSERT
                                                  INTO magic360_columns (
                                                           product_id,
                                                           columns
                                                       )
                                                VALUES (:product_id,
                                                        :columns)';

    /**
     * The SQL statement to update an existing magic360 column entry.
     *
     * @var string UPDATE_MAGIC360_COLUMNS
     */
    const UPDATE_MAGIC360_COLUMNS = 'UPDATE magic360_columns
                                                   SET product_id = :product_id,
                                                       columns = :columns
                                                 WHERE product_id = :product_id';

    /**
     * The SQL statement to update an existing magic360 column entry.
     *
     * @var string DELETE_MAGIC360_COLUMNS
     */
    const DELETE_MAGIC360_COLUMNS = 'DELETE FROM magic360_columns WHERE product_id = :product_id';
}