📄 example_mappings.po
字号:
" primary key (id)\n"")\n""\n""create table author_work (\n"" author_id BIGINT not null, \n"" work_id BIGINT not null, \n"" primary key (work_id, author_id)\n"")\n""\n""create table authors (\n"" id BIGINT not null generated by default as identity, \n"" alias VARCHAR(255), \n"" primary key (id)\n"")\n""\n""create table persons (\n"" id BIGINT not null generated by default as identity, \n"" name VARCHAR(255), \n"" primary key (id)\n"")\n""\n""alter table authors \n"" add constraint authorsFK0 foreign key (id) references persons\n""alter table author_work \n"" add constraint author_workFK0 foreign key (author_id) references ""authors\n""alter table author_work\n"" add constraint author_workFK1 foreign key (work_id) references works]]>"#: index.docbook:100msgid "Customer/Order/Product"msgstr "Cliente/Orden/Producto"#: index.docbook:102msgid """Now consider a model of the relationships between <literal>Customer</""literal>, <literal>Order</literal> and <literal>LineItem</literal> and ""<literal>Product</literal>. There is a one-to-many association between ""<literal>Customer</literal> and <literal>Order</literal>, but how should we ""represent <literal>Order</literal> / <literal>LineItem</literal> / ""<literal>Product</literal>? I've chosen to map <literal>LineItem</literal> ""as an association class representing the many-to-many association between ""<literal>Order</literal> and <literal>Product</literal>. In Hibernate, this ""is called a composite element."msgstr """Ahora considera un modelo de las relaciones entre <literal>Customer</""literal>, <literal>Order</literal> y <literal>LineItem</literal> y ""<literal>Product</literal>. Hay una asociación uno-a-muchos entre ""<literal>Customer</literal> y <literal>Order</literal>, pero, ¿""cómo deberíamos representar <literal>Order</literal> / ""<literal>LineItem</literal> / <literal>Product</literal>? He elegido mapear ""<literal>LineItem</literal> como una clase de asociación ""representando la asociación muchos-a-muchos entre <literal>Order</""literal> y <literal>Product</literal>. En Hibernate, esto se llama un ""elemento compuesto."#: index.docbook:122msgid "The mapping document:"msgstr "El documento de mapeo:"#: index.docbook:126msgid """<![CDATA[<hibernate-mapping>\n""\n"" <class name=\"Customer\" table=\"customers\">\n"" <id name=\"id\">\n"" <generator class=\"native\"/>\n"" </id>\n"" <property name=\"name\"/>\n"" <set name=\"orders\" inverse=\"true\">\n"" <key column=\"customer_id\"/>\n"" <one-to-many class=\"Order\"/>\n"" </set>\n"" </class>\n""\n"" <class name=\"Order\" table=\"orders\">\n"" <id name=\"id\">\n"" <generator class=\"native\"/>\n"" </id>\n"" <property name=\"date\"/>\n"" <many-to-one name=\"customer\" column=\"customer_id\"/>\n"" <list name=\"lineItems\" table=\"line_items\">\n"" <key column=\"order_id\"/>\n"" <list-index column=\"line_number\"/>\n"" <composite-element class=\"LineItem\">\n"" <property name=\"quantity\"/>\n"" <many-to-one name=\"product\" column=\"product_id\"/>\n"" </composite-element>\n"" </list>\n"" </class>\n""\n"" <class name=\"Product\" table=\"products\">\n"" <id name=\"id\">\n"" <generator class=\"native\"/>\n"" </id>\n"" <property name=\"serialNumber\"/>\n"" </class>\n""\n""</hibernate-mapping>]]>"msgstr """<![CDATA[<hibernate-mapping>\n""\n"" <class name=\"Customer\" table=\"customers\">\n"" <id name=\"id\">\n"" <generator class=\"native\"/>\n"" </id>\n"" <property name=\"name\"/>\n"" <set name=\"orders\" inverse=\"true\">\n"" <key column=\"customer_id\"/>\n"" <one-to-many class=\"Order\"/>\n"" </set>\n"" </class>\n""\n"" <class name=\"Order\" table=\"orders\">\n"" <id name=\"id\">\n"" <generator class=\"native\"/>\n"" </id>\n"" <property name=\"date\"/>\n"" <many-to-one name=\"customer\" column=\"customer_id\"/>\n"" <list name=\"lineItems\" table=\"line_items\">\n"" <key column=\"order_id\"/>\n"" <list-index column=\"line_number\"/>\n"" <composite-element class=\"LineItem\">\n"" <property name=\"quantity\"/>\n"" <many-to-one name=\"product\" column=\"product_id\"/>\n"" </composite-element>\n"" </list>\n"" </class>\n""\n"" <class name=\"Product\" table=\"products\">\n"" <id name=\"id\">\n"" <generator class=\"native\"/>\n"" </id>\n"" <property name=\"serialNumber\"/>\n"" </class>\n""\n""</hibernate-mapping>]]>"#: index.docbook:128msgid """<literal>customers</literal>, <literal>orders</literal>, ""<literal>line_items</literal> and <literal>products</literal> hold customer, ""order, order line item and product data respectively. <literal>line_items</""literal> also acts as an association table linking orders with products."msgstr """<literal>customers</literal>, <literal>orders</literal>, ""<literal>line_items</literal> y <literal>products</literal> tienen los datos ""de cliente, orden, ítem de línea de orden y producto ""respectivamente. Además <literal>line_items</literal> actúa ""como una tabla de asociación enlazando órdenes con productos."#: index.docbook:135msgid """<![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 """<![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]]>"#: index.docbook:140msgid "Miscellaneous example mappings"msgstr "Mapeos misceláneos de ejemplo"#: index.docbook:142msgid """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 """Todos estos ejemplos están tomados de la batería de pruebas de ""Hibernate. Encontrarás muchos otros mapeos de ejemplo útiles ""allí. Mira en la carpeta <literal>test</literal> de la ""distribución de Hibernate."#: index.docbook:148msgid "TODO: put words around this stuff"msgstr "POR HACER: poner palabras alrededor de este material"#: index.docbook:151msgid "\"Typed\" one-to-one association"msgstr "Asociación uno-a-uno \"Tipificada\""#: index.docbook:152msgid """<![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 """<![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>]]>"#: index.docbook:156msgid "Composite key example"msgstr "Ejemplo de clave compuesta"#: index.docbook:157msgid """<![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"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -