vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Mapping/yaml/Doctrine.Tests.Models.CMS.CmsUser.dcm.yml

   1 Doctrine\Tests\Models\CMS\CmsUser:
   2   type: entity
   3   table: cms_users
   4   namedQueries:
   5     all: SELECT u FROM __CLASS__ u
   6   namedNativeQueries:
   7     fetchIdAndUsernameWithResultClass:
   8       resultClass: CmsUser
   9       query: SELECT id, username FROM cms_users WHERE username = ?
  10     fetchAllColumns:
  11       name: fetchAllColumns
  12       resultClass: CmsUser
  13       query: SELECT * FROM cms_users WHERE username = ?
  14     fetchJoinedAddress:
  15       name: fetchJoinedAddress
  16       resultSetMapping: mappingJoinedAddress
  17       query: SELECT u.id, u.name, u.status, a.id AS a_id, a.country, a.zip, a.city FROM cms_users u INNER JOIN cms_addresses a ON u.id = a.user_id WHERE u.username = ?
  18     fetchJoinedPhonenumber:
  19       name: fetchJoinedPhonenumber
  20       resultSetMapping: mappingJoinedPhonenumber
  21       query: SELECT id, name, status, phonenumber AS number FROM cms_users INNER JOIN cms_phonenumbers ON id = user_id WHERE username = ?
  22     fetchUserPhonenumberCount:
  23       name: fetchUserPhonenumberCount
  24       resultSetMapping: mappingUserPhonenumberCount
  25       query: SELECT id, name, status, COUNT(phonenumber) AS numphones FROM cms_users INNER JOIN cms_phonenumbers ON id = user_id WHERE username IN (?) GROUP BY id, name, status, username ORDER BY username
  26     fetchMultipleJoinsEntityResults:
  27       name: fetchMultipleJoinsEntityResults
  28       resultSetMapping: mappingMultipleJoinsEntityResults
  29       query: SELECT u.id AS u_id, u.name AS u_name, u.status AS u_status, a.id AS a_id, a.zip AS a_zip, a.country AS a_country, COUNT(p.phonenumber) AS numphones FROM cms_users u INNER JOIN cms_addresses a ON u.id = a.user_id INNER JOIN cms_phonenumbers p ON u.id = p.user_id GROUP BY u.id, u.name, u.status, u.username, a.id, a.zip, a.country ORDER BY u.username
  30
  31   sqlResultSetMappings:
  32     mappingJoinedAddress:
  33       entityResult:
  34         0:
  35           entityClass: __CLASS__
  36           fieldResult:
  37             0:
  38               name: id
  39             1:
  40               name: name
  41             2:
  42               name: status
  43             3:
  44               name: address.zip
  45             4:
  46               name: address.city
  47             5:
  48               name: address.country
  49             6:
  50               name: address.id
  51               column: a_id
  52     mappingJoinedPhonenumber:
  53       name: mappingJoinedPhonenumber
  54       entityResult:
  55         user:
  56           entityClass: CmsUser
  57           fieldResult:
  58             0:
  59               name: id
  60             1:
  61               name: name
  62             2:
  63               name: status
  64             3:
  65               name: phonenumbers.phonenumber
  66               column: number
  67     mappingUserPhonenumberCount:
  68       name: mappingUserPhonenumberCount
  69       columnResult:
  70         0:
  71           name: numphones
  72       entityResult:
  73         user_0:
  74           entityClass: CmsUser
  75           fieldResult:
  76             0:
  77               name: id
  78             1:
  79               name: name
  80             2:
  81               name: status
  82     mappingMultipleJoinsEntityResults:
  83       name: mappingMultipleJoinsEntityResults
  84       columnResult:
  85         0:
  86           name: numphones
  87       entityResult:
  88         0:
  89           entityClass: __CLASS__
  90           fieldResult:
  91             0:
  92               name: id
  93               column: u_id
  94             1:
  95               name: name
  96               column: u_name
  97             2:
  98               name: status
  99               column: u_status
 100         1:
 101           entityClass: CmsAddress
 102           fieldResult:
 103             0:
 104               name: id
 105               column: a_id
 106             1:
 107               name: zip
 108               column: a_zip
 109             2:
 110               name: country
 111               column: a_country
 112   id:
 113     id:
 114       type: integer
 115       generator:
 116         strategy: AUTO
 117   fields:
 118     name:
 119       type: string
 120       length: 255
 121     username:
 122       type: string
 123       length: 255
 124       unique: true
 125     status:
 126       type: string
 127       length: 50
 128       unique: true
 129   oneToOne:
 130     address:
 131       targetEntity: CmsAddress
 132       orphanRemoval: true
 133       inversedBy: user
 134       joinColumn:
 135         name: address_id
 136         referencedColumnName: id
 137       cascade: [ persist ]
 138   oneToOne:
 139     email:
 140       targetEntity: CmsEmail
 141       orphanRemoval: true
 142       inversedBy: user
 143       joinColumn:
 144         nullable: true
 145         referencedColumnName: id
 146       cascade: [ persist ]
 147   manyToMany:
 148     groups:
 149       targetEntity: CmsGroup
 150       joinTable:
 151         name: cms_users_groups
 152         joinColumns:
 153           user_id:
 154             referencedColumnName: id
 155         inverseJoinColumns:
 156           group_id:
 157             referencedColumnName: id
 158       cascade: [ persist , detach, merge]