example_mappings.po

hibernate-distribution-3.3.1.GA-dist.zip源码

#. Tag: programlisting
#: example_mappings.xml:144
#, no-c-format
msgid ""
"<![CDATA[create table customers (\n"
"    id BIGINT not null generated by default as identity, \n"
"    name VARCHAR(255), \n"
"    primary key (id)\n"
")\n"
"\n"
"create table orders (\n"
"    id BIGINT not null generated by default as identity, \n"
"    customer_id BIGINT, \n"
"    date TIMESTAMP, \n"
"    primary key (id)\n"
")\n"
"\n"
"create table line_items (\n"
"    line_number INTEGER not null, \n"
"    order_id BIGINT not null, \n"
"    product_id BIGINT, \n"
"    quantity INTEGER, \n"
"    primary key (order_id, line_number)\n"
")\n"
"\n"
"create table products (\n"
"    id BIGINT not null generated by default as identity, \n"
"    serialNumber VARCHAR(255), \n"
"    primary key (id)\n"
")\n"
"\n"
"alter table orders \n"
"    add constraint ordersFK0 foreign key (customer_id) references customers\n"
"alter table line_items\n"
"    add constraint line_itemsFK0 foreign key (product_id) references "
"products\n"
"alter table line_items\n"
"    add constraint line_itemsFK1 foreign key (order_id) references orders]]>"
msgstr ""

#. Tag: title
#: example_mappings.xml:149
#, no-c-format
msgid "Miscellaneous example mappings"
msgstr "Divers mappings d'exemple"

#. Tag: para
#: example_mappings.xml:151
#, no-c-format
msgid ""
"These examples are all taken from the Hibernate test suite. You will find "
"many other useful example mappings there. Look in the <literal>test</"
"literal> folder of the Hibernate distribution."
msgstr ""
"Ces exemples sont tous pris de la suite de tests d'Hibernate. Vous en "
"trouverez beaucoup d'autres. Regardez dans le dossier <literal>test</"
"literal> de la distribution d'Hibernate."

#. Tag: para
#: example_mappings.xml:157
#, no-c-format
msgid "TODO: put words around this stuff"
msgstr "TODO: put words around this stuff"

#. Tag: title
#: example_mappings.xml:160
#, no-c-format
msgid "\"Typed\" one-to-one association"
msgstr "\"Typed\" one-to-one association"

#. Tag: programlisting
#: example_mappings.xml:161
#, no-c-format
msgid ""
"<![CDATA[<class name=\"Person\">\n"
"    <id name=\"name\"/>\n"
"    <one-to-one name=\"address\" \n"
"            cascade=\"all\">\n"
"        <formula>name</formula>\n"
"        <formula>'HOME'</formula>\n"
"    </one-to-one>\n"
"    <one-to-one name=\"mailingAddress\" \n"
"            cascade=\"all\">\n"
"        <formula>name</formula>\n"
"        <formula>'MAILING'</formula>\n"
"    </one-to-one>\n"
"</class>\n"
"\n"
"<class name=\"Address\" batch-size=\"2\" \n"
"        check=\"addressType in ('MAILING', 'HOME', 'BUSINESS')\">\n"
"    <composite-id>\n"
"        <key-many-to-one name=\"person\" \n"
"                column=\"personName\"/>\n"
"        <key-property name=\"type\" \n"
"                column=\"addressType\"/>\n"
"    </composite-id>\n"
"    <property name=\"street\" type=\"text\"/>\n"
"    <property name=\"state\"/>\n"
"    <property name=\"zip\"/>\n"
"</class>]]>"
msgstr ""

#. Tag: title
#: example_mappings.xml:165
#, no-c-format
msgid "Composite key example"
msgstr "Exemple de clef composée"

#. Tag: programlisting
#: example_mappings.xml:166
#, no-c-format
msgid ""
"<![CDATA[<class name=\"Customer\">\n"
"\n"
"    <id name=\"customerId\"\n"
"        length=\"10\">\n"
"        <generator class=\"assigned\"/>\n"
"    </id>\n"
"\n"
"    <property name=\"name\" not-null=\"true\" length=\"100\"/>\n"
"    <property name=\"address\" not-null=\"true\" length=\"200\"/>\n"
"\n"
"    <list name=\"orders\"\n"
"            inverse=\"true\"\n"
"            cascade=\"save-update\">\n"
"        <key column=\"customerId\"/>\n"
"        <index column=\"orderNumber\"/>\n"
"        <one-to-many class=\"Order\"/>\n"
"    </list>\n"
"\n"
"</class>\n"
"\n"
"<class name=\"Order\" table=\"CustomerOrder\" lazy=\"true\">\n"
"    <synchronize table=\"LineItem\"/>\n"
"    <synchronize table=\"Product\"/>\n"
"    \n"
"    <composite-id name=\"id\" \n"
"            class=\"Order$Id\">\n"
"        <key-property name=\"customerId\" length=\"10\"/>\n"
"        <key-property name=\"orderNumber\"/>\n"
"    </composite-id>\n"
"    \n"
"    <property name=\"orderDate\" \n"
"            type=\"calendar_date\"\n"
"            not-null=\"true\"/>\n"
"    \n"
"    <property name=\"total\">\n"
"        <formula>\n"
"            ( select sum(li.quantity*p.price) \n"
"            from LineItem li, Product p \n"
"            where li.productId = p.productId \n"
"                and li.customerId = customerId \n"
"                and li.orderNumber = orderNumber )\n"
"        </formula>\n"
"    </property>\n"
"    \n"
"    <many-to-one name=\"customer\"\n"
"            column=\"customerId\"\n"
"            insert=\"false\"\n"
"            update=\"false\" \n"
"            not-null=\"true\"/>\n"
"        \n"
"    <bag name=\"lineItems\"\n"
"            fetch=\"join\" \n"
"            inverse=\"true\"\n"
"            cascade=\"save-update\">\n"
"        <key>\n"
"            <column name=\"customerId\"/>\n"
"            <column name=\"orderNumber\"/>\n"
"        </key>\n"
"        <one-to-many class=\"LineItem\"/>\n"
"    </bag>\n"
"    \n"
"</class>\n"
"    \n"
"<class name=\"LineItem\">\n"
"    \n"
"    <composite-id name=\"id\" \n"
"            class=\"LineItem$Id\">\n"
"        <key-property name=\"customerId\" length=\"10\"/>\n"
"        <key-property name=\"orderNumber\"/>\n"
"        <key-property name=\"productId\" length=\"10\"/>\n"
"    </composite-id>\n"
"    \n"
"    <property name=\"quantity\"/>\n"
"    \n"
"    <many-to-one name=\"order\"\n"
"            insert=\"false\"\n"
"            update=\"false\" \n"
"            not-null=\"true\">\n"
"        <column name=\"customerId\"/>\n"
"        <column name=\"orderNumber\"/>\n"
"    </many-to-one>\n"
"    \n"
"    <many-to-one name=\"product\"\n"
"            insert=\"false\"\n"
"            update=\"false\" \n"
"            not-null=\"true\"\n"
"            column=\"productId\"/>\n"
"        \n"
"</class>\n"
"\n"
"<class name=\"Product\">\n"
"    <synchronize table=\"LineItem\"/>\n"
"\n"
"    <id name=\"productId\"\n"
"        length=\"10\">\n"
"        <generator class=\"assigned\"/>\n"
"    </id>\n"
"    \n"
"    <property name=\"description\" \n"
"        not-null=\"true\" \n"
"        length=\"200\"/>\n"
"    <property name=\"price\" length=\"3\"/>\n"
"    <property name=\"numberAvailable\"/>\n"
"    \n"
"    <property name=\"numberOrdered\">\n"
"        <formula>\n"
"            ( select sum(li.quantity) \n"
"            from LineItem li \n"
"            where li.productId = productId )\n"
"        </formula>\n"
"    </property>\n"
"    \n"
"</class>]]>"
msgstr ""

#. Tag: title
#: example_mappings.xml:170
#, no-c-format
msgid "Many-to-many with shared composite key attribute"
msgstr "Many-to-many avec une clef composée partagée"

#. Tag: programlisting
#: example_mappings.xml:171
#, no-c-format
msgid ""
"<![CDATA[<class name=\"User\" table=\"`User`\">\n"
"    <composite-id>\n"
"        <key-property name=\"name\"/>\n"
"        <key-property name=\"org\"/>\n"
"    </composite-id>\n"
"    <set name=\"groups\" table=\"UserGroup\">\n"
"        <key>\n"
"            <column name=\"userName\"/>\n"
"            <column name=\"org\"/>\n"
"        </key>\n"
"        <many-to-many class=\"Group\">\n"
"            <column name=\"groupName\"/>\n"
"            <formula>org</formula>\n"
"        </many-to-many>\n"
"    </set>\n"
"</class>\n"
"    \n"
"<class name=\"Group\" table=\"`Group`\">\n"
"    <composite-id>\n"
"        <key-property name=\"name\"/>\n"
"        <key-property name=\"org\"/>\n"
"    </composite-id>\n"
"    <property name=\"description\"/>\n"
"    <set name=\"users\" table=\"UserGroup\" inverse=\"true\">\n"
"        <key>\n"
"            <column name=\"groupName\"/>\n"
"            <column name=\"org\"/>\n"
"        </key>\n"
"        <many-to-many class=\"User\">\n"
"            <column name=\"userName\"/>\n"
"            <formula>org</formula>\n"
"        </many-to-many>\n"
"    </set>\n"
"</class>\n"
"]]>"
msgstr ""

#. Tag: title
#: example_mappings.xml:175
#, no-c-format
msgid "Content based discrimination"
msgstr "Contenu basé sur une discrimination"

#. Tag: programlisting
#: example_mappings.xml:176
#, no-c-format
msgid ""
"<![CDATA[<class name=\"Person\"\n"
"    discriminator-value=\"P\">\n"
"    \n"
"    <id name=\"id\" \n"
"        column=\"person_id\" \n"
"        unsaved-value=\"0\">\n"
"        <generator class=\"native\"/>\n"
"    </id>\n"
"    \n"
"            \n"
"    <discriminator \n"
"        type=\"character\">\n"
"        <formula>\n"
"            case \n"
"                when title is not null then 'E' \n"
"                when salesperson is not null then 'C' \n"
"                else 'P' \n"
"            end\n"
"        </formula>\n"
"    </discriminator>\n"
"\n"
"    <property name=\"name\" \n"
"        not-null=\"true\"\n"
"        length=\"80\"/>\n"
"        \n"
"    <property name=\"sex\" \n"
"        not-null=\"true\"\n"
"        update=\"false\"/>\n"
"    \n"
"    <component name=\"address\">\n"
"        <property name=\"address\"/>\n"
"        <property name=\"zip\"/>\n"
"        <property name=\"country\"/>\n"
"    </component>\n"
"    \n"
"    <subclass name=\"Employee\" \n"
"        discriminator-value=\"E\">\n"
"            <property name=\"title\"\n"
"                length=\"20\"/>\n"
"            <property name=\"salary\"/>\n"
"            <many-to-one name=\"manager\"/>\n"
"    </subclass>\n"
"    \n"
"    <subclass name=\"Customer\" \n"
"        discriminator-value=\"C\">\n"
"            <property name=\"comments\"/>\n"
"            <many-to-one name=\"salesperson\"/>\n"
"    </subclass>\n"
"    \n"
"</class>]]>"
msgstr ""

#. Tag: title
#: example_mappings.xml:180
#, no-c-format
msgid "Associations on alternate keys"
msgstr "Associations sur des clefs alternées"

#. Tag: programlisting
#: example_mappings.xml:181
#, no-c-format
msgid ""
"<![CDATA[<class name=\"Person\">\n"
"    \n"
"    <id name=\"id\">\n"
"        <generator class=\"hilo\"/>\n"
"    </id>\n"
"    \n"
"    <property name=\"name\" length=\"100\"/>\n"
"    \n"
"    <one-to-one name=\"address\" \n"
"        property-ref=\"person\"\n"
"        cascade=\"all\"\n"
"        fetch=\"join\"/>\n"
"    \n"
"    <set name=\"accounts\" \n"
"        inverse=\"true\">\n"
"        <key column=\"userId\"\n"
"            property-ref=\"userId\"/>\n"
"        <one-to-many class=\"Account\"/>\n"
"    </set>\n"
"    \n"
"    <property name=\"userId\" length=\"8\"/>\n"
"\n"
"</class>\n"
"\n"
"<class name=\"Address\">\n"
"\n"
"    <id name=\"id\">\n"
"        <generator class=\"hilo\"/>\n"
"    </id>\n"
"\n"
"    <property name=\"address\" length=\"300\"/>\n"
"    <property name=\"zip\" length=\"5\"/>\n"
"    <property name=\"country\" length=\"25\"/>\n"
"    <many-to-one name=\"person\" unique=\"true\" not-null=\"true\"/>\n"
"\n"
"</class>\n"
"\n"
"<class name=\"Account\">\n"
"    <id name=\"accountId\" length=\"32\">\n"
"        <generator class=\"uuid\"/>\n"
"    </id>\n"
"    \n"
"    <many-to-one name=\"user\"\n"
"        column=\"userId\"\n"
"        property-ref=\"userId\"/>\n"
"    \n"
"    <property name=\"type\" not-null=\"true\"/>\n"
"    \n"
"</class>]]>"
msgstr ""