Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
<?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 `wp_cf_form_entries`.* FROM `wp_cf_form_entries` WHERE (`wp_cf_form_entries`.`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 entry ID
*
* @covers Entry::queryByEntryId()
*/
public function testQueryByEntryId()
{
$expectedSql = "SELECT `wp_cf_form_entries`.* FROM `wp_cf_form_entries` WHERE (`wp_cf_form_entries`.`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 `wp_cf_form_entries`.* FROM `wp_cf_form_entries` WHERE (`wp_cf_form_entries`.`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');
}
}