EntryTest.php

<?php


namespace  calderawp\CalderaFormsQuery\Tests\Unit\Select;

use calderawp\CalderaFormsQuery\Select\Entry;
use calderawp\CalderaFormsQuery\Tests\Unit\TestCase;

class EntryTest extends TestCase
{

	/**
	 * Test query by form ID
	 *
	 * @covers Entry::queryByFormsId()
	 */
	public function testQueryByFormsId()
	{
		$expectedSql = "SELECT `{$this->entryTableName()}`.* FROM `wp_cf_form_entries` WHERE (`{$this->entryTableName()}`.`form_id` = 'cf12345')";
		$entryGenerator = $this->entryGeneratorFactory();
		$generator = $entryGenerator->queryByFormsId('cf12345');
		$this->assertTrue($this->isAEntry($generator));

		$actualSql = $entryGenerator->getPreparedSql();
		$this->assertEquals($expectedSql, $actualSql);
	}

    /**
     * Test query by form ID
     *
     * @covers Entry::queryByFormsId()
     * @covers \calderawp\CalderaFormsQuery\addPagination::()
     */
    public function testQueryByFormsIdPaginated()
    {
        $expectedSql = "SELECT `{$this->entryTableName()}`.* FROM `wp_cf_form_entries` WHERE (`{$this->entryTableName()}`.`form_id` = 'cf12345') LIMIT '26', '50'";
        $actualSql = $this
            ->entryGeneratorFactory()
            ->queryByFormsId('cf12345')
            ->addPagination(2,25 )
            ->getPreparedSql();
        $this->assertEquals($expectedSql, $actualSql);
    }

	/**
	 * Test query by entry ID
	 *
	 * @covers Entry::queryByEntryId()
	 */
	public function testQueryByEntryId()
	{
		$expectedSql = "SELECT `{$this->entryTableName()}`.* FROM `{$this->entryTableName()}` WHERE (`{$this->entryTableName()}`.`id` = '42')";
		$entryGenerator = $this->entryGeneratorFactory();
		$generator = $entryGenerator->queryByEntryId(42);
		$this->assertTrue($this->isAEntry($generator));

		$actualSql = $entryGenerator->getPreparedSql();
		$this->assertEquals($expectedSql, $actualSql);
	}

	/**
	 * Test query by user ID
	 *
	 * @covers Entry::queryByUserId()
	 */
	public function testQueryByUserId()
	{
		$expectedSql = "SELECT `{$this->entryTableName()}`.* FROM `{$this->entryTableName()}` WHERE (`{$this->entryTableName()}`.`user_id` = '42')";
		$entryGenerator = $this->entryGeneratorFactory();
		$generator = $entryGenerator->queryByUserId(42);
		$this->assertTrue($this->isAEntry($generator));

		$actualSql = $entryGenerator->getPreparedSql();
		$this->assertEquals($expectedSql, $actualSql);
	}




	/**
	 * @param $generator
	 * @return bool
	 */
	protected function isAEntry($generator)
	{
		return is_a($generator, '\calderawp\CalderaFormsQuery\Select\Entry');
	}
}