Failed Conditions
Pull Request — 2.6 (#7890)
by
unknown
10:05 queued 03:38
created

CmsAddress::getCity()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 2
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
eloc 1
c 1
b 0
f 0
dl 0
loc 2
rs 10
cc 1
nc 1
nop 0
1
<?php
2
3
namespace Doctrine\Tests\Models\CMSCustomId;
4
5
/**
6
 * CmsAddress
7
 *
8
 * @author Roman S. Borschel
9
 * @Entity
10
 * @Table(name="cms_addresses_customid")
11
 *
12
 * @NamedNativeQueries({
13
 *      @NamedNativeQuery(
14
 *          name                = "find-all",
15
 *          resultSetMapping    = "mapping-find-all",
16
 *          query               = "SELECT id, country, city FROM cms_addresses"
17
 *      ),
18
 *      @NamedNativeQuery(
19
 *          name           = "find-by-id",
20
 *          resultClass    = "CmsAddress",
21
 *          query          = "SELECT * FROM cms_addresses WHERE id = ?"
22
 *      ),
23
 *      @NamedNativeQuery(
24
 *          name            = "count",
25
 *          resultSetMapping= "mapping-count",
26
 *          query           = "SELECT COUNT(*) AS count FROM cms_addresses"
27
 *      )
28
 * })
29
 *
30
 * @SqlResultSetMappings({
31
 *      @SqlResultSetMapping(
32
 *          name    = "mapping-find-all",
33
 *          entities= {
34
 *              @EntityResult(
35
 *                  entityClass = "CmsAddress",
36
 *                  fields      = {
37
 *                      @FieldResult(name = "id",       column="id"),
38
 *                      @FieldResult(name = "city",     column="city"),
39
 *                      @FieldResult(name = "country",  column="country")
40
 *                  }
41
 *              )
42
 *          }
43
 *      ),
44
 *      @SqlResultSetMapping(
45
 *          name    = "mapping-without-fields",
46
 *          entities= {
47
 *              @EntityResult(
48
 *                  entityClass = "__CLASS__"
49
 *              )
50
 *          }
51
 *      ),
52
 *      @SqlResultSetMapping(
53
 *          name    = "mapping-count",
54
 *          columns = {
55
 *              @ColumnResult(
56
 *                  name = "count"
57
 *              )
58
 *          }
59
 *      )
60
 * })
61
 *
62
 * @EntityListeners({"CmsAddressListener"})
63
 */
64
class CmsAddress
65
{
66
    /**
67
     * @Id
68
     * @Column(type="CustomIdObject")
69
     * @GeneratedValue(strategy="NONE")
70
     */
71
    public $id;
72
73
    /**
74
     * @Column(length=50)
75
     */
76
    public $country;
77
78
    /**
79
     * @Column(length=50)
80
     */
81
    public $zip;
82
83
    /**
84
     * @Column(length=50)
85
     */
86
    public $city;
87
88
    /**
89
     * Testfield for Schema Updating Tests.
90
     */
91
    public $street;
92
93
    /**
94
     * @OneToOne(targetEntity="CmsUser", inversedBy="address")
95
     * @JoinColumn(referencedColumnName="id")
96
     */
97
    public $user;
98
99
    public function getId() {
100
        return $this->id;
101
    }
102
103
    public function getUser() {
104
        return $this->user;
105
    }
106
107
    public function getCountry() {
108
        return $this->country;
109
    }
110
111
    public function getZipCode() {
112
        return $this->zip;
113
    }
114
115
    public function getCity() {
116
        return $this->city;
117
    }
118
119
    public function setUser(CmsUser $user) {
120
        if ($this->user !== $user) {
121
            $this->user = $user;
122
            $user->setAddress($this);
123
        }
124
    }
125
126
    public static function loadMetadata(\Doctrine\ORM\Mapping\ClassMetadataInfo $metadata)
127
    {
128
        $metadata->setPrimaryTable(
129
            [
130
           'name' => 'company_person',
131
            ]
132
        );
133
134
        $metadata->mapField(
135
            [
136
            'id'        => true,
137
            'fieldName' => 'id',
138
            'type'      => 'integer',
139
            ]
140
        );
141
142
        $metadata->mapField(
143
            [
144
            'fieldName' => 'zip',
145
            'length'    => 50,
146
            ]
147
        );
148
149
        $metadata->mapField(
150
            [
151
            'fieldName' => 'city',
152
            'length'    => 50,
153
            ]
154
        );
155
156
        $metadata->mapOneToOne(
157
            [
158
            'fieldName'     => 'user',
159
            'targetEntity'  => 'CmsUser',
160
            'joinColumns'   => [['referencedColumnName' => 'id']]
161
            ]
162
        );
163
164
        $metadata->addNamedNativeQuery(
165
            [
166
            'name'              => 'find-all',
167
            'query'             => 'SELECT id, country, city FROM cms_addresses_customid',
168
            'resultSetMapping'  => 'mapping-find-all',
169
            ]
170
        );
171
172
        $metadata->addNamedNativeQuery(
173
            [
174
            'name'              => 'find-by-id',
175
            'query'             => 'SELECT * FROM cms_addresses_customid WHERE id = ?',
176
            'resultClass'       => CmsAddress::class,
177
            ]
178
        );
179
180
        $metadata->addNamedNativeQuery(
181
            [
182
            'name'              => 'count',
183
            'query'             => 'SELECT COUNT(*) AS count FROM cms_addresses_customid',
184
            'resultSetMapping'  => 'mapping-count',
185
            ]
186
        );
187
188
        $metadata->addSqlResultSetMapping(
189
            [
190
            'name'      => 'mapping-find-all',
191
            'columns'   => [],
192
            'entities'  => [
193
                [
194
                'fields' => [
195
                  [
196
                    'name'      => 'id',
197
                    'column'    => 'id',
198
                  ],
199
                  [
200
                    'name'      => 'city',
201
                    'column'    => 'city',
202
                  ],
203
                  [
204
                    'name'      => 'country',
205
                    'column'    => 'country',
206
                  ],
207
                ],
208
                'entityClass' => CmsAddress::class,
209
                ],
210
            ],
211
            ]
212
        );
213
214
        $metadata->addSqlResultSetMapping(
215
            [
216
            'name'      => 'mapping-without-fields',
217
            'columns'   => [],
218
            'entities'  => [
219
                [
220
                'entityClass' => CmsAddress::class,
221
                'fields' => []
222
                ]
223
            ]
224
            ]
225
        );
226
227
        $metadata->addSqlResultSetMapping(
228
            [
229
            'name' => 'mapping-count',
230
            'columns' => [
231
                [
232
                    'name' => 'count',
233
                ],
234
            ]
235
            ]
236
        );
237
238
        $metadata->addEntityListener(\Doctrine\ORM\Events::postPersist, 'CmsAddressListener', 'postPersist');
239
        $metadata->addEntityListener(\Doctrine\ORM\Events::prePersist, 'CmsAddressListener', 'prePersist');
240
241
        $metadata->addEntityListener(\Doctrine\ORM\Events::postUpdate, 'CmsAddressListener', 'postUpdate');
242
        $metadata->addEntityListener(\Doctrine\ORM\Events::preUpdate, 'CmsAddressListener', 'preUpdate');
243
244
        $metadata->addEntityListener(\Doctrine\ORM\Events::postRemove, 'CmsAddressListener', 'postRemove');
245
        $metadata->addEntityListener(\Doctrine\ORM\Events::preRemove, 'CmsAddressListener', 'preRemove');
246
247
        $metadata->addEntityListener(\Doctrine\ORM\Events::preFlush, 'CmsAddressListener', 'preFlush');
248
        $metadata->addEntityListener(\Doctrine\ORM\Events::postLoad, 'CmsAddressListener', 'postLoad');
249
    }
250
}
251