vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Mapping/xml/Doctrine.Tests.Models.CMS.CmsAddress.dcm.xml

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3 <doctrine-mapping xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping"
   4       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   5       xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping
   6                           http://www.doctrine-project.org/schemas/orm/doctrine-mapping.xsd">
   7
   8     <entity name="Doctrine\Tests\Models\CMS\CmsAddress" table="cms_users">
   9
  10         <named-native-queries>
  11             <named-native-query name="find-all" result-set-mapping="mapping-find-all">
  12                 <query>SELECT id, country, city FROM cms_addresses</query>
  13             </named-native-query>
  14
  15             <named-native-query name="find-by-id" result-class="CmsAddress">
  16                 <query>SELECT * FROM cms_addresses WHERE id = ?</query>
  17             </named-native-query>
  18
  19             <named-native-query name="count" result-set-mapping="mapping-count">
  20                 <query>SELECT COUNT(*) AS count FROM cms_addresses</query>
  21             </named-native-query>
  22         </named-native-queries>
  23
  24         <sql-result-set-mappings>
  25             <sql-result-set-mapping name="mapping-find-all">
  26                 <entity-result entity-class="CmsAddress">
  27                     <field-result name="id" column="id"/>
  28                     <field-result name="city" column="city"/>
  29                     <field-result name="country" column="country"/>
  30                 </entity-result>
  31             </sql-result-set-mapping>
  32
  33             <sql-result-set-mapping name="mapping-without-fields">
  34                 <entity-result entity-class="CmsAddress"/>
  35             </sql-result-set-mapping>
  36
  37             <sql-result-set-mapping name="mapping-count">
  38                 <column-result name="count"/>
  39             </sql-result-set-mapping>
  40         </sql-result-set-mappings>
  41
  42         <id name="id" type="integer" column="id">
  43             <generator strategy="AUTO"/>
  44         </id>
  45
  46         <field name="country" column="country" type="string" length="50"/>
  47         <field name="city" column="city" type="string" length="50"/>
  48         <field name="zip" column="zip" type="string" length="50"/>
  49
  50         <one-to-one field="user" target-entity="CmsUser" inversed-by="address">
  51             <join-column referenced-column-name="id" />
  52         </one-to-one>
  53
  54     </entity>
  55 </doctrine-mapping>