query_hql.po

hibernate 开源框架的代码 jar包希望大家能喜欢

"functions which may be quantified using <literal>some, all, exists, any, in</"
"literal>."
msgstr ""
"funciones de HQL que tomen expresiones de ruta valuadas en colecciones: "
"<literal>size(), minelement(), maxelement(), minindex(), maxindex()</"
"literal>, junto a las funciones especiales <literal>elements()</literal> and "
"<literal>indices</literal> que pueden ser cuantificadas usando "
"<literal>some, all, exists, any, in</literal>."

#: index.docbook:613
msgid ""
"Any database-supported SQL scalar function like <literal>sign()</literal>, "
"<literal>trunc()</literal>, <literal>rtrim()</literal>, <literal>sin()</"
"literal>"
msgstr ""
"Cualquier funci&#x00f3;n escalar SQL soportada por la base de datos como "
"<literal>sign()</literal>, <literal>trunc()</literal>, <literal>rtrim()</"
"literal>, <literal>sin()</literal>"

#: index.docbook:619
msgid "JDBC-style positional parameters <literal>?</literal>"
msgstr "par&#x00e1;metros posicionales JDBC <literal>?</literal>"

#: index.docbook:624
msgid ""
"named parameters <literal>:name</literal>, <literal>:start_date</literal>, "
"<literal>:x1</literal>"
msgstr ""
"par&#x00e1;metros con nombre <literal>:name</literal>, <literal>:start_date</"
"literal>, <literal>:x1</literal>"

#: index.docbook:629
msgid ""
"SQL literals <literal>'foo'</literal>, <literal>69</literal>, <literal>6.66E"
"+2</literal>, <literal>'1970-01-01 10:00:01.0'</literal>"
msgstr ""
"literales SQL <literal>'foo'</literal>, <literal>69</literal>, <literal>6.66E"
"+2</literal>, <literal>'1970-01-01 10:00:01.0'</literal>"

#: index.docbook:635
msgid ""
"Java <literal>public static final</literal> constants <literal>eg.Color."
"TABBY</literal>"
msgstr ""
"constantes Java <literal>public static final</literal> <literal>eg.Color."
"TABBY</literal>"

#: index.docbook:641
msgid ""
"<literal>in</literal> and <literal>between</literal> may be used as follows:"
msgstr ""
"<literal>in</literal> y <literal>between</literal> pueden usarse como sigue:"

#: index.docbook:645
msgid "<![CDATA[from DomesticCat cat where cat.name between 'A' and 'B']]>"
msgstr "<![CDATA[from DomesticCat cat where cat.name between 'A' and 'B']]>"

#: index.docbook:647
msgid ""
"<![CDATA[from DomesticCat cat where cat.name in ( 'Foo', 'Bar', 'Baz' )]]>"
msgstr ""
"<![CDATA[from DomesticCat cat where cat.name in ( 'Foo', 'Bar', 'Baz' )]]>"

#: index.docbook:649
msgid "and the negated forms may be written"
msgstr "y pueden escribirse las formas negadas"

#: index.docbook:653
msgid "<![CDATA[from DomesticCat cat where cat.name not between 'A' and 'B']]>"
msgstr ""
"<![CDATA[from DomesticCat cat where cat.name not between 'A' and 'B']]>"

#: index.docbook:655
msgid ""
"<![CDATA[from DomesticCat cat where cat.name not in ( 'Foo', 'Bar', 'Baz' )]]"
">"
msgstr ""
"<![CDATA[from DomesticCat cat where cat.name not in ( 'Foo', 'Bar', 'Baz' )]]"
">"

#: index.docbook:657
msgid ""
"Likewise, <literal>is null</literal> and <literal>is not null</literal> may "
"be used to test for null values."
msgstr ""
"Asimismo, <literal>is null</literal> y <literal>is not null</literal> pueden "
"ser usadas para comprobar valores nulos."

#: index.docbook:662
msgid ""
"Booleans may be easily used in expressions by declaring HQL query "
"substitutions in Hibernate configuration:"
msgstr ""
"Los booleanos pueden ser f&#x00e1;cilmente usados en expresiones declarando "
"substituciones de consulta HQL en la configuraci&#x00f3;n de Hibernate:"

#: index.docbook:667
msgid ""
"<![CDATA[<property name=\"hibernate.query.substitutions\">true 1, false 0</"
"property>]]>"
msgstr ""
"<![CDATA[<property name=\"hibernate.query.substitutions\">true 1, false 0</"
"property>]]>"

#: index.docbook:669
msgid ""
"This will replace the keywords <literal>true</literal> and <literal>false</"
"literal> with the literals <literal>1</literal> and <literal>0</literal> in "
"the translated SQL from this HQL:"
msgstr ""
"Esto remplazar&#x00e1; las palabras clave <literal>true</literal> y "
"<literal>false</literal> con los literales <literal>1</literal> y "
"<literal>0</literal> en el SQL traducido de este HQL:"

#: index.docbook:674
msgid "<![CDATA[from Cat cat where cat.alive = true]]>"
msgstr "<![CDATA[from Cat cat where cat.alive = true]]>"

#: index.docbook:676
msgid ""
"You may test the size of a collection with the special property "
"<literal>size</literal>, or the special <literal>size()</literal> function."
msgstr ""
"Puedes comprobar el tama&#x00f1;o de una colecci&#x00f3;n con la propiedad "
"especial <literal>size</literal>, o la funci&#x00f3;n especial <literal>size"
"()</literal>."

#: index.docbook:681
msgid "<![CDATA[from Cat cat where cat.kittens.size > 0]]>"
msgstr "<![CDATA[from Cat cat where cat.kittens.size > 0]]>"

#: index.docbook:683
msgid "<![CDATA[from Cat cat where size(cat.kittens) > 0]]>"
msgstr "<![CDATA[from Cat cat where size(cat.kittens) > 0]]>"

#: index.docbook:685
msgid ""
"For indexed collections, you may refer to the minimum and maximum indices "
"using <literal>minindex</literal> and <literal>maxindex</literal> functions. "
"Similarly, you may refer to the minimum and maximum elements of a collection "
"of basic type using the <literal>minelement</literal> and "
"<literal>maxelement</literal> functions."
msgstr ""
"Para colecciones indexadas, puedes referirte a los &#x00ed;ndices m&#x00e1;"
"ximo y m&#x00ed;nimo usando las funciones <literal>minindex</literal> y "
"<literal>maxindex</literal>. Similarmente, puedes referirte a los elementos "
"m&#x00e1;ximo y m&#x00ed;nimo de una colecci&#x00f3;n de tipo b&#x00e1;sico "
"usando las funciones <literal>minelement</literal> y <literal>maxelement</"
"literal>."

#: index.docbook:693
msgid ""
"<![CDATA[from Calendar cal where maxelement(cal.holidays) > current_date]]>"
msgstr ""
"<![CDATA[from Calendar cal where maxelement(cal.holidays) > current_date]]>"

#: index.docbook:695
msgid "<![CDATA[from Order order where maxindex(order.items) > 100]]>"
msgstr "<![CDATA[from Order order where maxindex(order.items) > 100]]>"

#: index.docbook:697
msgid "<![CDATA[from Order order where minelement(order.items) > 10000]]>"
msgstr "<![CDATA[from Order order where minelement(order.items) > 10000]]>"

#: index.docbook:699
msgid ""
"The SQL functions <literal>any, some, all, exists, in</literal> are "
"supported when passed the element or index set of a collection "
"(<literal>elements</literal> and <literal>indices</literal> functions) or "
"the result of a subquery (see below)."
msgstr ""
"Las funciones SQL <literal>any, some, all, exists, in</literal> est&#x00e1;n "
"soportadas cuando se les pasa el conjunto de elementos o &#x00ed;ndices de "
"una colecci&#x00f3;n (funciones <literal>elements</literal> y "
"<literal>indices</literal>) o el resultado de una subconsulta (ver debajo)."

#: index.docbook:705
msgid ""
"<![CDATA[select mother from Cat as mother, Cat as kit\n"
"where kit in elements(foo.kittens)]]>"
msgstr ""
"<![CDATA[select mother from Cat as mother, Cat as kit\n"
"where kit in elements(foo.kittens)]]>"

#: index.docbook:707
msgid ""
"<![CDATA[select p from NameList list, Person p\n"
"where p.name = some elements(list.names)]]>"
msgstr ""
"<![CDATA[select p from NameList list, Person p\n"
"where p.name = some elements(list.names)]]>"

#: index.docbook:709
msgid "<![CDATA[from Cat cat where exists elements(cat.kittens)]]>"
msgstr "<![CDATA[from Cat cat where exists elements(cat.kittens)]]>"

#: index.docbook:711
msgid "<![CDATA[from Player p where 3 > all elements(p.scores)]]>"
msgstr "<![CDATA[from Player p where 3 > all elements(p.scores)]]>"

#: index.docbook:713
msgid "<![CDATA[from Show show where 'fizard' in indices(show.acts)]]>"
msgstr "<![CDATA[from Show show where 'fizard' in indices(show.acts)]]>"

#: index.docbook:715
msgid ""
"Note that these constructs - <literal>size</literal>, <literal>elements</"
"literal>, <literal>indices</literal>, <literal>minindex</literal>, "
"<literal>maxindex</literal>, <literal>minelement</literal>, "
"<literal>maxelement</literal> - may only be used in the where clause in "
"Hibernate3."
msgstr ""
"Nota que estas construcciones - <literal>size</literal>, <literal>elements</"
"literal>, <literal>indices</literal>, <literal>minindex</literal>, "
"<literal>maxindex</literal>, <literal>minelement</literal>, "
"<literal>maxelement</literal> - pueden ser usadas solamente en la cl&#x00e1;"
"usula where en Hibernate3."

#: index.docbook:722
msgid ""
"Elements of indexed collections (arrays, lists, maps) may be referred to by "
"index (in a where clause only):"
msgstr ""
"Los elementos de colecciones indexadas (arrays, listas, mapas) pueden ser "
"referidos por &#x00ed;ndice (en una cl&#x00e1;usula where solamente):"

#: index.docbook:727
msgid "<![CDATA[from Order order where order.items[0].id = 1234]]>"
msgstr "<![CDATA[from Order order where order.items[0].id = 1234]]>"

#: index.docbook:729
msgid ""
"<![CDATA[select person from Person person, Calendar calendar\n"
"where calendar.holidays['national day'] = person.birthDay\n"
"    and person.nationality.calendar = calendar]]>"
msgstr ""
"<![CDATA[select person from Person person, Calendar calendar\n"
"where calendar.holidays['national day'] = person.birthDay\n"
"    and person.nationality.calendar = calendar]]>"

#: index.docbook:731
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ order.deliveredItemIndices[0] ] = item and order.id = 11]]"
">"
msgstr ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ order.deliveredItemIndices[0] ] = item and order.id = 11]]"
">"

#: index.docbook:733
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ maxindex(order.items) ] = item and order.id = 11]]>"
msgstr ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ maxindex(order.items) ] = item and order.id = 11]]>"

#: index.docbook:735
msgid ""
"The expression inside <literal>[]</literal> may even be an arithmetic "
"expression."
msgstr ""
"La expresi&#x00f3;n dentro de <literal>[]</literal> puede incluso ser una "
"expresi&#x00f3;n aritm&#x00e9;tica."

#: index.docbook:739
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ size(order.items) - 1 ] = item]]>"
msgstr ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ size(order.items) - 1 ] = item]]>"

#: index.docbook:741
msgid ""
"HQL also provides the built-in <literal>index()</literal> function, for "
"elements of a one-to-many association or collection of values."
msgstr ""
"HQL provee adem&#x00e1;s el funci&#x00f3;n prefabricada <literal>index()</"
"literal>, para elementos de una asociaci&#x00f3;n uno-a-muchos o "
"colecci&#x00f3;n de valores."

#: index.docbook:746
msgid ""
"<![CDATA[select item, index(item) from Order order\n"
"    join order.items item\n"
"where index(item) < 5]]>"
msgstr ""
"<![CDATA[select item, index(item) from Order order \n"
"    join order.items item\n"
"where index(item) < 5]]>"

#: index.docbook:748
msgid "Scalar SQL functions supported by the underlying database may be used"
msgstr ""
"Pueden usarse las funciones SQL escalares soportadas por la base de datos "
"subyacente"

#: index.docbook:752
msgid "<![CDATA[from DomesticCat cat where upper(cat.name) like 'FRI%']]>"
msgstr "<![CDATA[from DomesticCat cat where upper(cat.name) like 'FRI%']]>"

#: index.docbook:754
msgid ""
"If you are not yet convinced by all this, think how much longer and less "
"readable the following query would be in SQL:"
msgstr ""
"Si a&#x00fa;n no est&#x00e1;s convencido de todo esto, piensa cu&#x00e1;nto "
"m&#x00e1;s largo y menos le&#x00ed;ble ser&#x00ed;a la siguiente consulta en "
"SQL:"

#: index.docbook:759
msgid ""
"<![CDATA[select cust\n"
"from Product prod,\n"
"    Store store\n"
"    inner join store.customers cust\n"
"where prod.name = 'widget'\n"
"    and store.location.name in ( 'Melbourne', 'Sydney' )\n"
"    and prod = all elements(cust.currentOrder.lineItems)]]>"
msgstr ""
"<![CDATA[select cust\n"
"from Product prod,\n"
"    Store store\n"
"    inner join store.customers cust\n"
"where prod.name = 'widget'\n"
"    and store.location.name in ( 'Melbourne', 'Sydney' )\n"
"    and prod = all elements(cust.currentOrder.lineItems)]]>"

#: index.docbook:761
msgid "<emphasis>Hint:</emphasis> something like"
msgstr "<emphasis>Ayuda:</emphasis> algo como"

#: index.docbook:765
msgid ""
"<![CDATA[SELECT cust.name, cust.address, cust.phone, cust.id, cust."
"current_order\n"
"FROM customers cust,\n"
"    stores store,\n"
"    locations loc,\n"
"    store_customers sc,\n"
"    product prod\n"
"WHERE prod.name = 'widget'\n"
"    AND store.loc_id = loc.id\n"
"    AND loc.name IN ( 'Melbourne', 'Sydney' )\n"
"    AND sc.store_id = store.id\n"
"    AND sc.cust_id = cust.id\n"
"    AND prod.id = ALL(\n"
"        SELECT item.prod_id\n"
"        FROM line_items item, orders o\n"
"        WHERE item.order_id = o.id\n"
"            AND cust.current_order = o.id\n"
"    )]]>"
msgstr ""
"<![CDATA[SELECT cust.name, cust.address, cust.phone, cust.id, cust."
"current_order\n"