<?php

namespace KupShop\KupShopBundle\Tests;

class DatabaseTest extends \DatabaseTestCase
{
    /**
     * @dataProvider data_testAddToSet
     */
    public function testAddToSet($id_product, $result)
    {
        $this->assertEquals('', returnSQLResult('SELECT campaign FROM products WHERE id=7'));

        sqlQuery('UPDATE products SET campaign = ADD_TO_SET("N", campaign)');

        $this->assertEquals('N', returnSQLResult('SELECT campaign FROM products WHERE id=7'));
    }

    public function data_testAddToSet()
    {
        return [
            [7, 'N'],
            [1, 'N,L'],
            [2, 'N,D,L'],
        ];
    }

    /**
     * @dataProvider data_testRemoveFromSet
     */
    public function testRemoveFromSet()
    {
        $this->assertEquals('', returnSQLResult('SELECT campaign FROM products WHERE id=7'));

        sqlQuery('UPDATE products SET campaign = REMOVE_FROM_SET("N", campaign)');

        $this->assertEquals('', returnSQLResult('SELECT campaign FROM products WHERE id=7'));
    }

    public function data_testRemoveFromSet()
    {
        return [
            [7, ''],
            [1, 'L'],
            [2, 'D,L'],
            [8, ''],
        ];
    }
}