📄 query_hql.po
字号:
"can't call these queries using <literal>Query.scroll()</literal>.)"msgstr """Nota que estas dos últimas consultas requerirán más de ""un <literal>SELECT</literal> SQL. Esto significa que la cláusula ""<literal>order by</literal> no ordenará correctamente todo el ""conjunto resultado. (Significa además que no puedes llamar estas ""consulta usando <literal>Query.scroll()</literal>.)"#: index.docbook:400msgid "The where clause"msgstr "La cláusula where"#: index.docbook:402msgid """The <literal>where</literal> clause allows you to narrow the list of ""instances returned. If no alias exists, you may refer to properties by name:"msgstr """La cláusula where te permite estrechar la lista de instancias ""devueltas. Si no existe ningún alias. puedes referirte a las ""propiedades por nombre:"#: index.docbook:407msgid "<![CDATA[from Cat where name='Fritz']]>"msgstr "<![CDATA[from Cat where name='Fritz']]>"#: index.docbook:409msgid "If there is an alias, use a qualified property name:"msgstr "Si existe un alias, usan un nombre cualificado de propiedad:"#: index.docbook:413msgid "<![CDATA[from Cat as cat where cat.name='Fritz']]>"msgstr "<![CDATA[from Cat as cat where cat.name='Fritz']]>"#: index.docbook:415msgid "returns instances of <literal>Cat</literal> named 'Fritz'."msgstr "devuelve las instancias de <literal>Cat</literal> llamadas 'Fritz'."#: index.docbook:419msgid """<![CDATA[select foo\n""from Foo foo, Bar bar\n""where foo.startDate = bar.date]]>"msgstr """<![CDATA[select foo \n""from Foo foo, Bar bar\n""where foo.startDate = bar.date]]>"#: index.docbook:421msgid """will return all instances of <literal>Foo</literal> for which there exists ""an instance of <literal>bar</literal> with a <literal>date</literal> ""property equal to the <literal>startDate</literal> property of the ""<literal>Foo</literal>. Compound path expressions make the <literal>where</""literal> clause extremely powerful. Consider:"msgstr """devolverá todas las instancias de <literal>Foo</literal> para las ""cuales exista una instancia de <literal>bar</literal> con una propiedad ""<literal>date</literal> igual a la propiedad <literal>startDate</literal> ""del <literal>Foo</literal>. Las expresiones de ruta compuestas hacen la ""cláusula <literal>where</literal> extremadamente potente. Considera:"#: index.docbook:430msgid "<![CDATA[from Cat cat where cat.mate.name is not null]]>"msgstr "<![CDATA[from Cat cat where cat.mate.name is not null]]>"#: index.docbook:432msgid """This query translates to an SQL query with a table (inner) join. If you were ""to write something like"msgstr """Esta consulta se traduce en una consulta SQL con una unión de tabla ""(interna). Si fueses a escribir algo como"#: index.docbook:437msgid """<![CDATA[from Foo foo\n""where foo.bar.baz.customer.address.city is not null]]>"msgstr """<![CDATA[from Foo foo \n""where foo.bar.baz.customer.address.city is not null]]>"#: index.docbook:439msgid """you would end up with a query that would require four table joins in SQL."msgstr """terminarías con una consulta que requeriría cuatro uniones de ""tablas en SQL."#: index.docbook:443msgid """The <literal>=</literal> operator may be used to compare not only ""properties, but also instances:"msgstr """El operador <literal>=</literal> puede ser usado para comparar no só""lo propiedades, sino también instancias:"#: index.docbook:448msgid "<![CDATA[from Cat cat, Cat rival where cat.mate = rival.mate]]>"msgstr "<![CDATA[from Cat cat, Cat rival where cat.mate = rival.mate]]>"#: index.docbook:450msgid """<![CDATA[select cat, mate\n""from Cat cat, Cat mate\n""where cat.mate = mate]]>"msgstr """<![CDATA[select cat, mate \n""from Cat cat, Cat mate\n""where cat.mate = mate]]>"#: index.docbook:452msgid """The special property (lowercase) <literal>id</literal> may be used to ""reference the unique identifier of an object. See <xref linkend=\"queryhql-""identifier-property\"/> for more information."msgstr """La propiedad especial (en minúsculas) <literal>id</literal> puede ser ""usada para referenciar el identificador único de un objeto. ""(También puedes usar su nombre de propiedad.)"#: index.docbook:458msgid """<![CDATA[from Cat as cat where cat.id = 123\n""\n""from Cat as cat where cat.mate.id = 69]]>"msgstr """<![CDATA[from Cat as cat where cat.id = 123\n""\n""from Cat as cat where cat.mate.id = 69]]>"#: index.docbook:460msgid "The second query is efficient. No table join is required!"msgstr """La segunda consulta es eficiente. ¡No se requiere ninguna unió""n de tablas!"#: index.docbook:464msgid """Properties of composite identifiers may also be used. Suppose ""<literal>Person</literal> has a composite identifier consisting of ""<literal>country</literal> and <literal>medicareNumber</literal>. Again, see ""<xref linkend=\"queryhql-identifier-property\"/> for more information ""regarding referencing identifier properties."msgstr """También pueden ser usadas las propiedades de identificadores ""compuestos. Supón que <literal>Person</literal> tiene un ""identificador compuesto consistente en <literal>country</literal> y ""<literal>medicareNumber</literal>."#: index.docbook:471msgid """<![CDATA[from bank.Person person\n""where person.id.country = 'AU'\n"" and person.id.medicareNumber = 123456]]>"msgstr """<![CDATA[from bank.Person person\n""where person.id.country = 'AU' \n"" and person.id.medicareNumber = 123456]]>"#: index.docbook:473msgid """<![CDATA[from bank.Account account\n""where account.owner.id.country = 'AU'\n"" and account.owner.id.medicareNumber = 123456]]>"msgstr """<![CDATA[from bank.Account account\n""where account.owner.id.country = 'AU' \n"" and account.owner.id.medicareNumber = 123456]]>"#: index.docbook:475msgid "Once again, the second query requires no table join."msgstr """Una vez más, la segunda consulta no requiere ninguna unión de ""tablas."#: index.docbook:479msgid """Likewise, the special property <literal>class</literal> accesses the ""discriminator value of an instance in the case of polymorphic persistence. A ""Java class name embedded in the where clause will be translated to its ""discriminator value."msgstr """Asimismo, la propiedad especial <literal>class</literal> acccede al valor ""discriminador de una instancia en el caso de persistencia polimó""rfica. Un nombre de clase Java embebido en la cláusula where ""será traducido a su valor discriminador."#: index.docbook:485msgid "<![CDATA[from Cat cat where cat.class = DomesticCat]]>"msgstr "<![CDATA[from Cat cat where cat.class = DomesticCat]]>"#: index.docbook:487msgid """You may also use components or composite user types, or properties of said ""component types. See <xref linkend=\"queryhql-components\"/> for more ""details."msgstr """You may also use components or composite user types, or properties of said ""component types. See <xref linkend=\"queryhql-components\"/> for more ""details."#: index.docbook:492msgid """An \"any\" type has the special properties <literal>id</literal> and ""<literal>class</literal>, allowing us to express a join in the following way ""(where <literal>AuditLog.item</literal> is a property mapped with ""<literal><any></literal>)."msgstr """Un tipo \"any\" tiene las propiedades especiales <literal>id</literal> y ""<literal>class</literal>, permiténdonos expresar un join en la ""siguiente forma (donde <literal>AuditLog.item</literal> es una propiedad ""mapeada con <literal><any></literal>)."#: index.docbook:498msgid """<![CDATA[from AuditLog log, Payment payment\n""where log.item.class = 'Payment' and log.item.id = payment.id]]>"msgstr """<![CDATA[from AuditLog log, Payment payment \n""where log.item.class = 'Payment' and log.item.id = payment.id]]>"#: index.docbook:500msgid """Notice that <literal>log.item.class</literal> and <literal>payment.class</""literal> would refer to the values of completely different database columns ""in the above query."msgstr """Nota que <literal>log.item.class</literal> y <literal>payment.class</""literal> harían referencia a los valores de columnas de base de datos ""completamente diferentes en la consulta anterior."#: index.docbook:508msgid "Expressions"msgstr "Expresiones"#: index.docbook:510msgid """Expressions allowed in the <literal>where</literal> clause include most of ""the kind of things you could write in SQL:"msgstr """Las expresiones permitidas en la cláusula <literal>where</literal> ""incluyen la mayoría del tipo de cosas que podrías escribir en ""SQL:"#: index.docbook:517msgid "mathematical operators <literal>+, -, *, /</literal>"msgstr "operadores matemáticos <literal>+, -, *, /</literal>"#: index.docbook:522msgid """binary comparison operators <literal>=, >=, <=, <>, !=, like</""literal>"msgstr """operadores de comparación binarios <literal>=, >=, <=, <"">, !=, like</literal>"#: index.docbook:527msgid "logical operations <literal>and, or, not</literal>"msgstr "operadores lógicos <literal>and, or, not</literal>"#: index.docbook:532msgid "Parentheses <literal>( )</literal>, indicating grouping"msgstr "Paréntesis <literal>( )</literal>, indicando agrupación"#: index.docbook:537msgid """<literal>in</literal>, <literal>not in</literal>, <literal>between</""literal>, <literal>is null</literal>, <literal>is not null</literal>, ""<literal>is empty</literal>, <literal>is not empty</literal>, ""<literal>member of</literal> and <literal>not member of</literal>"msgstr """<literal>in</literal>, <literal>not in</literal>, <literal>between</""literal>, <literal>is null</literal>, <literal>is not null</literal>, ""<literal>is empty</literal>, <literal>is not empty</literal>, ""<literal>member of</literal> y <literal>not member of</literal>"#: index.docbook:550msgid """\"Simple\" case, <literal>case ... when ... then ... else ... end</literal>, ""and \"searched\" case, <literal>case when ... then ... else ... end</literal>"msgstr """Caso \"simple\", <literal>case ... when ... then ... else ... end</literal>, ""y caso \"buscado\", <literal>case when ... then ... else ... end</literal>"#: index.docbook:556msgid """string concatenation <literal>...||...</literal> or <literal>concat(...,...)""</literal>"msgstr """concatenación de cadenas <literal>...||...</literal> o <literal>concat""(...,...)</literal>"#: index.docbook:561msgid """<literal>current_date()</literal>, <literal>current_time()</literal>, ""<literal>current_timestamp()</literal>"msgstr """<literal>current_date()</literal>, <literal>current_time()</literal>, ""<literal>current_timestamp()</literal>"#: index.docbook:567msgid """<literal>second(...)</literal>, <literal>minute(...)</literal>, <literal>hour""(...)</literal>, <literal>day(...)</literal>, <literal>month(...)</literal>, ""<literal>year(...)</literal>,"msgstr """<literal>second(...)</literal>, <literal>minute(...)</literal>, <literal>hour""(...)</literal>, <literal>day(...)</literal>, <literal>month(...)</literal>, ""<literal>year(...)</literal>,"#: index.docbook:574msgid """Any function or operator defined by EJB-QL 3.0: <literal>substring(), trim""(), lower(), upper(), length(), locate(), abs(), sqrt(), bit_length(), mod()""</literal>"msgstr """Cualquier función u operador definido por EJB-QL 3.0: ""<literal>substring(), trim(), lower(), upper(), length(), locate(), abs(), ""sqrt(), bit_length(), mod()</literal>"#: index.docbook:580msgid "<literal>coalesce()</literal> and <literal>nullif()</literal>"msgstr "<literal>coalesce()</literal> y <literal>nullif()</literal>"#: index.docbook:585msgid """<literal>str()</literal> for converting numeric or temporal values to a ""readable string"msgstr """<literal>str()</literal> para convertir valores numéricos o ""temporales a una cadena legible."#: index.docbook:591msgid """<literal>cast(... as ...)</literal>, where the second argument is the name ""of a Hibernate type, and <literal>extract(... from ...)</literal> if ANSI ""<literal>cast()</literal> and <literal>extract()</literal> is supported by ""the underlying database"msgstr """<literal>cast(... as ...)</literal>, donde el segundo argumento es el nombre ""de un tipo Hibernate , y <literal>extract(... from ...)</literal> si ""<literal>cast()</literal> y <literal>extract()</literal> fuesen soportados ""por la base de datos subyacente."#: index.docbook:599msgid """the HQL <literal>index()</literal> function, that applies to aliases of a ""joined indexed collection"msgstr """la función <literal>index()</literal> de HQL, que se aplica a alias ""de una colección indexada unida."#: index.docbook:605msgid """HQL functions that take collection-valued path expressions: <literal>size(), ""minelement(), maxelement(), minindex(), maxindex()</literal>, along with the ""special <literal>elements()</literal> and <literal>indices</literal> "
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -