@@ 16-86 (lines=71) @@ | ||
13 | /** |
|
14 | * @mixin SelectAs |
|
15 | */ |
|
16 | class SelectAsSpec extends ObjectBehavior |
|
17 | { |
|
18 | private $field = 'foo'; |
|
19 | ||
20 | private $alias = 'bar'; |
|
21 | ||
22 | public function let() |
|
23 | { |
|
24 | $this->beConstructedWith($this->field, $this->alias); |
|
25 | } |
|
26 | ||
27 | public function it_is_a_select_as() |
|
28 | { |
|
29 | $this->shouldBeAnInstanceOf('Happyr\DoctrineSpecification\Query\Selection\SelectAs'); |
|
30 | } |
|
31 | ||
32 | public function it_is_a_selection() |
|
33 | { |
|
34 | $this->shouldBeAnInstanceOf('Happyr\DoctrineSpecification\Query\Selection\Selection'); |
|
35 | } |
|
36 | ||
37 | public function it_is_transformable(QueryBuilder $qb) |
|
38 | { |
|
39 | $dqlAlias = 'a'; |
|
40 | $expression = '(a.foo) AS bar'; |
|
41 | ||
42 | $this->transform($qb, $dqlAlias)->shouldReturn($expression); |
|
43 | } |
|
44 | ||
45 | public function it_is_transformable_field(QueryBuilder $qb) |
|
46 | { |
|
47 | $dqlAlias = 'a'; |
|
48 | $expression = '(a.foo) AS bar'; |
|
49 | $field = new Field('foo'); |
|
50 | ||
51 | $this->beConstructedWith($field, $this->alias); |
|
52 | $this->transform($qb, $dqlAlias)->shouldReturn($expression); |
|
53 | } |
|
54 | ||
55 | public function it_is_transformable_value(QueryBuilder $qb, ArrayCollection $parameters) |
|
56 | { |
|
57 | $dqlAlias = 'a'; |
|
58 | $expression = '(:comparison_10) AS bar'; |
|
59 | $value = new Value('foo'); |
|
60 | ||
61 | $this->beConstructedWith($value, $this->alias); |
|
62 | ||
63 | $qb->getParameters()->willReturn($parameters); |
|
64 | $parameters->count()->willReturn(10); |
|
65 | ||
66 | $qb->setParameter('comparison_10', 'foo', null)->shouldBeCalled(); |
|
67 | ||
68 | $this->transform($qb, $dqlAlias)->shouldReturn($expression); |
|
69 | } |
|
70 | ||
71 | public function it_is_transformable_filter(QueryBuilder $qb, ArrayCollection $parameters) |
|
72 | { |
|
73 | $dqlAlias = 'a'; |
|
74 | $expression = '(a.foo = :comparison_10) AS bar'; |
|
75 | $filter = new Equals('foo', 'bar'); |
|
76 | ||
77 | $this->beConstructedWith($filter, $this->alias); |
|
78 | ||
79 | $qb->getParameters()->willReturn($parameters); |
|
80 | $parameters->count()->willReturn(10); |
|
81 | ||
82 | $qb->setParameter('comparison_10', 'bar', null)->shouldBeCalled(); |
|
83 | ||
84 | $this->transform($qb, $dqlAlias)->shouldReturn($expression); |
|
85 | } |
|
86 | } |
|
87 |
@@ 16-86 (lines=71) @@ | ||
13 | /** |
|
14 | * @mixin SelectHiddenAs |
|
15 | */ |
|
16 | class SelectHiddenAsSpec extends ObjectBehavior |
|
17 | { |
|
18 | private $field = 'foo'; |
|
19 | ||
20 | private $alias = 'bar'; |
|
21 | ||
22 | public function let() |
|
23 | { |
|
24 | $this->beConstructedWith($this->field, $this->alias); |
|
25 | } |
|
26 | ||
27 | public function it_is_a_select_as() |
|
28 | { |
|
29 | $this->shouldBeAnInstanceOf('Happyr\DoctrineSpecification\Query\Selection\SelectHiddenAs'); |
|
30 | } |
|
31 | ||
32 | public function it_is_a_selection() |
|
33 | { |
|
34 | $this->shouldBeAnInstanceOf('Happyr\DoctrineSpecification\Query\Selection\Selection'); |
|
35 | } |
|
36 | ||
37 | public function it_is_transformable(QueryBuilder $qb) |
|
38 | { |
|
39 | $dqlAlias = 'a'; |
|
40 | $expression = '(a.foo) AS HIDDEN bar'; |
|
41 | ||
42 | $this->transform($qb, $dqlAlias)->shouldReturn($expression); |
|
43 | } |
|
44 | ||
45 | public function it_is_transformable_field(QueryBuilder $qb) |
|
46 | { |
|
47 | $dqlAlias = 'a'; |
|
48 | $expression = '(a.foo) AS HIDDEN bar'; |
|
49 | $field = new Field('foo'); |
|
50 | ||
51 | $this->beConstructedWith($field, $this->alias); |
|
52 | $this->transform($qb, $dqlAlias)->shouldReturn($expression); |
|
53 | } |
|
54 | ||
55 | public function it_is_transformable_value(QueryBuilder $qb, ArrayCollection $parameters) |
|
56 | { |
|
57 | $dqlAlias = 'a'; |
|
58 | $expression = '(:comparison_10) AS HIDDEN bar'; |
|
59 | $value = new Value('foo'); |
|
60 | ||
61 | $this->beConstructedWith($value, $this->alias); |
|
62 | ||
63 | $qb->getParameters()->willReturn($parameters); |
|
64 | $parameters->count()->willReturn(10); |
|
65 | ||
66 | $qb->setParameter('comparison_10', 'foo', null)->shouldBeCalled(); |
|
67 | ||
68 | $this->transform($qb, $dqlAlias)->shouldReturn($expression); |
|
69 | } |
|
70 | ||
71 | public function it_is_transformable_filter(QueryBuilder $qb, ArrayCollection $parameters) |
|
72 | { |
|
73 | $dqlAlias = 'a'; |
|
74 | $expression = '(a.foo = :comparison_10) AS HIDDEN bar'; |
|
75 | $filter = new Equals('foo', 'bar'); |
|
76 | ||
77 | $this->beConstructedWith($filter, $this->alias); |
|
78 | ||
79 | $qb->getParameters()->willReturn($parameters); |
|
80 | $parameters->count()->willReturn(10); |
|
81 | ||
82 | $qb->setParameter('comparison_10', 'bar', null)->shouldBeCalled(); |
|
83 | ||
84 | $this->transform($qb, $dqlAlias)->shouldReturn($expression); |
|
85 | } |
|
86 | } |
|
87 |