Rajout de doctrine/orm

[zf2.biz/application_blanche.git] / vendor / doctrine / orm / tests / Doctrine / Tests / ORM / Mapping / yaml / Doctrine.Tests.Models.CMS.CmsUser.dcm.yml

diff --git a/vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Mapping/yaml/Doctrine.Tests.Models.CMS.CmsUser.dcm.yml b/vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Mapping/yaml/Doctrine.Tests.Models.CMS.CmsUser.dcm.yml
new file mode 100644 (file)
index 0000000..3a03dd6
--- /dev/null
+++ b/vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Mapping/yaml/Doctrine.Tests.Models.CMS.CmsUser.dcm.yml
@@ -0,0 +1,158 @@
+Doctrine\Tests\Models\CMS\CmsUser:
+  type: entity
+  table: cms_users
+  namedQueries:
+    all: SELECT u FROM __CLASS__ u
+  namedNativeQueries:
+    fetchIdAndUsernameWithResultClass:
+      resultClass: CmsUser
+      query: SELECT id, username FROM cms_users WHERE username = ?
+    fetchAllColumns:
+      name: fetchAllColumns
+      resultClass: CmsUser
+      query: SELECT * FROM cms_users WHERE username = ?
+    fetchJoinedAddress:
+      name: fetchJoinedAddress
+      resultSetMapping: mappingJoinedAddress
+      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 = ?
+    fetchJoinedPhonenumber:
+      name: fetchJoinedPhonenumber
+      resultSetMapping: mappingJoinedPhonenumber
+      query: SELECT id, name, status, phonenumber AS number FROM cms_users INNER JOIN cms_phonenumbers ON id = user_id WHERE username = ?
+    fetchUserPhonenumberCount:
+      name: fetchUserPhonenumberCount
+      resultSetMapping: mappingUserPhonenumberCount
+      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
+    fetchMultipleJoinsEntityResults:
+      name: fetchMultipleJoinsEntityResults
+      resultSetMapping: mappingMultipleJoinsEntityResults
+      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
+
+  sqlResultSetMappings:
+    mappingJoinedAddress:
+      entityResult:
+        0:
+          entityClass: __CLASS__
+          fieldResult:
+            0:
+              name: id
+            1:
+              name: name
+            2:
+              name: status
+            3:
+              name: address.zip
+            4:
+              name: address.city
+            5:
+              name: address.country
+            6:
+              name: address.id
+              column: a_id
+    mappingJoinedPhonenumber:
+      name: mappingJoinedPhonenumber
+      entityResult:
+        user:
+          entityClass: CmsUser
+          fieldResult:
+            0:
+              name: id
+            1:
+              name: name
+            2:
+              name: status
+            3:
+              name: phonenumbers.phonenumber
+              column: number
+    mappingUserPhonenumberCount:
+      name: mappingUserPhonenumberCount
+      columnResult:
+        0:
+          name: numphones
+      entityResult:
+        user_0:
+          entityClass: CmsUser
+          fieldResult:
+            0:
+              name: id
+            1:
+              name: name
+            2:
+              name: status
+    mappingMultipleJoinsEntityResults:
+      name: mappingMultipleJoinsEntityResults
+      columnResult:
+        0:
+          name: numphones
+      entityResult:
+        0:
+          entityClass: __CLASS__
+          fieldResult:
+            0:
+              name: id
+              column: u_id
+            1:
+              name: name
+              column: u_name
+            2:
+              name: status
+              column: u_status
+        1:
+          entityClass: CmsAddress
+          fieldResult:
+            0:
+              name: id
+              column: a_id
+            1:
+              name: zip
+              column: a_zip
+            2:
+              name: country
+              column: a_country
+  id:
+    id:
+      type: integer
+      generator:
+        strategy: AUTO
+  fields:
+    name:
+      type: string
+      length: 255
+    username:
+      type: string
+      length: 255
+      unique: true
+    status:
+      type: string
+      length: 50
+      unique: true
+  oneToOne:
+    address:
+      targetEntity: CmsAddress
+      orphanRemoval: true
+      inversedBy: user
+      joinColumn:
+        name: address_id
+        referencedColumnName: id
+      cascade: [ persist ]
+  oneToOne:
+    email:
+      targetEntity: CmsEmail
+      orphanRemoval: true
+      inversedBy: user
+      joinColumn:
+        nullable: true
+        referencedColumnName: id
+      cascade: [ persist ]
+  manyToMany:
+    groups:
+      targetEntity: CmsGroup
+      joinTable:
+        name: cms_users_groups
+        joinColumns:
+          user_id:
+            referencedColumnName: id
+        inverseJoinColumns:
+          group_id:
+            referencedColumnName: id
+      cascade: [ persist , detach, merge]
\ No newline at end of file