Skip to content
Snippets Groups Projects
EntryQueriesGeneratorsTest.php 2.01 KiB
Newer Older
  • Learn to ignore specific revisions
  • <?php
    
    
    namespace calderawp\CalderaFormsQuery\Tests\Integration;
    
    
    
    Josh Pollock's avatar
    Josh Pollock committed
    use calderawp\CalderaFormsQuery\SelectsCreatesSelect;
    use calderawp\CalderaFormsQuery\CreatesSelectQueries;
    
    use calderawp\CalderaFormsQuery\Select\EntryValues;
    use calderawp\CalderaFormsQuery\Tests\Traits\CanCreateEntryWithEmailField;
    use calderawp\CalderaFormsQuery\Tests\Traits\HasFactories;
    use calderawp\CalderaFormsQuery\Tests\Traits\UsersMockFormAsDBForm;
    
    class EntryQueriesGeneratorsTest extends IntegrationTestCase
    {
    	use CanCreateEntryWithEmailField;
    
    	/**
    	 * Test reset builder allows us to create new queries on generator
    	 *
    
    Josh Pollock's avatar
    Josh Pollock committed
    	 * @covers CreatesSelectQueries::getEntryValueGenerator()
    
    	 * @covers EntryValues::resetQuery()
    	 */
    	public function testReset()
    	{
    		$emailOne = 'one@email.com';
    		$entryIdOne = $this->createEntryWithEmail($emailOne);
    		$emailTwo = 'two@email.com';
    		$entryIdTwo = $this->createEntryWithEmail($emailTwo);
    		$entryQueries = $this->entryQueriesFactory();
    
    		//Email one by email
    		$results = $entryQueries
    			->getResults(
    				$entryQueries
    					->getEntryValueGenerator()
    					->queryByFieldValue(
    						$this->getEmailFieldSlug(),
    						$emailOne
    					)
    				->getPreparedSql()
    			);
    		$this->assertSame(1, count($results));
    
    		//Email one by entry_id
    		$results = $entryQueries
    			->getResults(
    				$entryQueries
    					->getEntryValueGenerator()
    					->queryByEntryId(
    						$entryIdOne
    					)
    					->getPreparedSql()
    			);
    		$this->assertSame(1, count($results));
    
    		$entryQueries
    			->getEntryValueGenerator()
    			->resetQuery();
    
    		//Email two by email
    		$results = $entryQueries
    			->getResults(
    				$entryQueries
    					->getEntryValueGenerator()
    					->queryByFieldValue(
    						$this->getEmailFieldSlug(),
    						$emailTwo
    					)
    					->getPreparedSql()
    			);
    		$this->assertSame(1, count($results));
    
    		//Email two by entry_id
    		$results = $entryQueries
    			->getResults(
    				$entryQueries
    					->getEntryValueGenerator()
    					->queryByEntryId(
    						$entryIdTwo
    					)
    					->getPreparedSql()
    			);
    		$this->assertSame(1, count($results));
    
    	}
    
    }