bytic / database

tests/Query/InsertTest.php

<?php

namespace Nip\Database\Tests\Query;

use Mockery as m;
use Nip\Database\Connections\Connection;
use Nip\Database\Query\Insert;
use Nip\Database\Tests\AbstractTest;

/**
 * Class InsertTest
 * @package Nip\Database\Tests\Query
 */
class InsertTest extends AbstractTest
{
    /**
     * @var \UnitTester

The type UnitTester was not found. Maybe you did not declare it correctly or list all dependencies?

     */
    protected $tester;

    /**
     * @var Insert
     */
    protected $object;

    public function test_null()
    {
        $this->object->table("table");

'table' of type string is incompatible with the type array expected by parameter $| of Nip\Database\Query\AbstractQuery::table().

        $this->object->data(["id" => 3, "name" => null]);

        static::assertEquals(
            "INSERT INTO `table` (`id`,`name`) VALUES (3, NULL)",
            $this->object->assemble()
        );
    }

    public function testOnDuplicate()
    {
        $this->object->table("table");

'table' of type string is incompatible with the type array expected by parameter $| of Nip\Database\Query\AbstractQuery::table().

        $this->object->data(["id" => 3, "name" => "Lorem Ipsum"]);
        $this->object->onDuplicate([
            "id" => ["VALUES(`id`)", false],
            "name" => ["VALUES(`name`)", false]
        ]);

        static::assertEquals(
            "INSERT INTO `table` (`id`,`name`) VALUES (3, 'Lorem Ipsum') ON DUPLICATE KEY UPDATE `id` = VALUES(`id`), `name` = VALUES(`name`)",
            $this->object->assemble()
        );
    }

    public function testMultiple()
    {
        $this->object->table("table");

'table' of type string is incompatible with the type array expected by parameter $| of Nip\Database\Query\AbstractQuery::table().

        $items = [
            ["name" => "Lorem Ipsum", "telephone" => 1234],
            ["name" => "Dolor sit amet", "telephone" => 5678]
        ];

        foreach ($items as $item) {
            $this->object->data($item);
        }

        static::assertEquals(
            "INSERT INTO `table` (`name`,`telephone`) VALUES ('Lorem Ipsum', 1234), ('Dolor sit amet', 5678)",
            $this->object->assemble()
        );
    }

    protected function setUp(): void
    {
        parent::setUp();
        $this->object = new Insert();

        $adapterMock = m::mock('Nip\Database\Adapters\MySQLi')->shouldDeferMissing();

The function Mockery\LegacyMockInterface::shouldDeferMissing() has been deprecated: 2.0.0 Please use makePartial() instead

        $adapterMock->shouldReceive('cleanData')->andReturnUsing(function ($data) {
            return $data;
        });
        $manager = new Connection(false);

false of type false is incompatible with the type Closure|PDO expected by parameter $pdo of Nip\Database\Connections\Connection::__construct().

        $manager->setAdapter($adapterMock);
        $this->object->setManager($manager);
    }
}