query_hql.po

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

msgid ""
"The interface <literal>Named</literal> might be implemented by various "
"persistent classes:"
msgstr ""
"L'interface <literal>Named</literal> peut être implémentée par plusieurs "
"classes persistantes :"

#. Tag: programlisting
#: query_hql.xml:389
#, no-c-format
msgid "<![CDATA[from Named n, Named m where n.name = m.name]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:391
#, no-c-format
msgid ""
"Note that these last two queries will require more than one SQL "
"<literal>SELECT</literal>. This means that the <literal>order by</literal> "
"clause does not correctly order the whole result set. (It also means you "
"can't call these queries using <literal>Query.scroll()</literal>.)"
msgstr ""
"Notez que ces deux dernières requêtes nécessitent plus d'un <literal>SELECT</"
"literal> SQL. Ce qui signifie que la clause <literal>order by</literal> ne "
"trie pas correctement la totalité des résultats (cela signifie aussi que "
"vous ne pouvez exécuter ces requêtes en appelant <literal>Query.scroll()</"
"literal>)."

#. Tag: title
#: query_hql.xml:400
#, no-c-format
msgid "The where clause"
msgstr "La clause where"

#. Tag: para
#: query_hql.xml:402
#, no-c-format
msgid ""
"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 clause <literal>where</literal> vous permet de réduire la liste des "
"instances retournées. Si aucun alias n'existe, vous pouvez vous référer aux "
"propriétés par leur nom :"

#. Tag: programlisting
#: query_hql.xml:407
#, no-c-format
msgid "<![CDATA[from Cat where name='Fritz']]>"
msgstr ""

#. Tag: para
#: query_hql.xml:409
#, no-c-format
msgid "If there is an alias, use a qualified property name:"
msgstr "S'il y a un alias, utilisez un nom de propriété qualifié :"

#. Tag: programlisting
#: query_hql.xml:413
#, no-c-format
msgid "<![CDATA[from Cat as cat where cat.name='Fritz']]>"
msgstr ""

#. Tag: para
#: query_hql.xml:415
#, no-c-format
msgid "returns instances of <literal>Cat</literal> named 'Fritz'."
msgstr ""
"retourne les instances de <literal>Cat</literal> dont name est égale à "
"'Fritz'."

#. Tag: programlisting
#: query_hql.xml:419
#, no-c-format
msgid ""
"<![CDATA[select foo\n"
"from Foo foo, Bar bar\n"
"where foo.startDate = bar.date]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:421
#, no-c-format
msgid ""
"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 ""
"retournera les instances de <literal>Foo</literal> pour lesquelles il existe "
"une instance de <literal>bar</literal> avec la propriété <literal>date</"
"literal> est égale à la propriété <literal>startDate</literal> de "
"<literal>Foo</literal>. Les expressions utilisant la navigation rendent la "
"clause <literal>where</literal> extrêmement puissante. Soit :"

#. Tag: programlisting
#: query_hql.xml:430
#, no-c-format
msgid "<![CDATA[from Cat cat where cat.mate.name is not null]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:432
#, no-c-format
msgid ""
"This query translates to an SQL query with a table (inner) join. If you were "
"to write something like"
msgstr ""
"Cette requête se traduit en SQL par une jointure interne à une table. Si "
"vous souhaitez écrire quelque chose comme :"

#. Tag: programlisting
#: query_hql.xml:437
#, no-c-format
msgid ""
"<![CDATA[from Foo foo\n"
"where foo.bar.baz.customer.address.city is not null]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:439
#, no-c-format
msgid ""
"you would end up with a query that would require four table joins in SQL."
msgstr ""
"vous finiriez avec une requête qui nécessiterait quatre jointures en SQL."

#. Tag: para
#: query_hql.xml:443
#, no-c-format
msgid ""
"The <literal>=</literal> operator may be used to compare not only "
"properties, but also instances:"
msgstr ""
"L'opérateur <literal>=</literal> peut être utilisé pour comparer aussi bien "
"des propriétés que des instances :"

#. Tag: programlisting
#: query_hql.xml:448
#, no-c-format
msgid "<![CDATA[from Cat cat, Cat rival where cat.mate = rival.mate]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:450
#, no-c-format
msgid ""
"<![CDATA[select cat, mate\n"
"from Cat cat, Cat mate\n"
"where cat.mate = mate]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:452
#, no-c-format
msgid ""
"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 propriété spéciale (en minuscule) <literal>id</literal> peut être "
"utilisée pour faire référence à l'identifiant d'un objet (vous pouvez aussi "
"utiliser le nom de cette propriété)."

#. Tag: programlisting
#: query_hql.xml:458
#, no-c-format
msgid ""
"<![CDATA[from Cat as cat where cat.id = 123\n"
"\n"
"from Cat as cat where cat.mate.id = 69]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:460
#, no-c-format
msgid "The second query is efficient. No table join is required!"
msgstr ""
"La seconde requête est particulièrement efficace. Aucune jointure n'est "
"nécessaire !"

#. Tag: para
#: query_hql.xml:464
#, no-c-format
msgid ""
"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 ""
"Les propriétés d'un identifiant composé peuvent aussi être utilisées. "
"Supposez que <literal>Person</literal> ait un identifiant composé de "
"<literal>country</literal> et <literal>medicareNumber</literal>."

#. Tag: programlisting
#: query_hql.xml:471
#, no-c-format
msgid ""
"<![CDATA[from bank.Person person\n"
"where person.id.country = 'AU'\n"
"    and person.id.medicareNumber = 123456]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:473
#, no-c-format
msgid ""
"<![CDATA[from bank.Account account\n"
"where account.owner.id.country = 'AU'\n"
"    and account.owner.id.medicareNumber = 123456]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:475
#, no-c-format
msgid "Once again, the second query requires no table join."
msgstr "Une fois de plus, la seconde requête ne nécessite pas de jointure."

#. Tag: para
#: query_hql.xml:479
#, no-c-format
msgid ""
"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 ""
"De même, la propriété spéciale <literal>class</literal> interroge la valeur "
"discriminante d'une instance dans le cas d'une persistance polymorphique. Le "
"nom d'une classe Java incorporée dans la clause where sera traduite par sa "
"valeur discriminante."

#. Tag: programlisting
#: query_hql.xml:485
#, no-c-format
msgid "<![CDATA[from Cat cat where cat.class = DomesticCat]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:487
#, no-c-format
msgid ""
"You may also use components or composite user types, or properties of said "
"component types. See <xref linkend=\"queryhql-components\"/> for more "
"details."
msgstr ""
"Vous pouvez aussi spécifier les propriétés des composants ou types "
"utilisateurs composés (components, composite user types etc). N'essayez "
"jamais d'utiliser un expression de navigation qui se terminerait par une "
"propriété de type composant (qui est différent d'une propriété d'un "
"composant). Par exemple, si <literal>store.owner</literal> est une entité "
"avec un composant <literal>address</literal>"

#. Tag: para
#: query_hql.xml:492
#, no-c-format
msgid ""
"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>&lt;any&gt;</literal>)."
msgstr ""
"Un type \"any\" possède les propriétés spéciales <literal>id</literal> et "
"<literal>class</literal>, qui nous permettent d'exprimer une jointure de la "
"manière suivante (où <literal>AuditLog.item</literal> est une propriété "
"mappée avec <literal>&lt;any&gt;</literal>)."

#. Tag: programlisting
#: query_hql.xml:498
#, no-c-format
msgid ""
"<![CDATA[from AuditLog log, Payment payment\n"
"where log.item.class = 'Payment' and log.item.id = payment.id]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:500
#, no-c-format
msgid ""
"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 ""
"Dans la requête précédente, notez que <literal>log.item.class</literal> et "
"<literal>payment.class</literal> feraient référence à des valeurs de "
"colonnes de la base de données complètement différentes."

#. Tag: title
#: query_hql.xml:508
#, no-c-format
msgid "Expressions"
msgstr "Expressions"

#. Tag: para
#: query_hql.xml:510
#, no-c-format
msgid ""
"Expressions allowed in the <literal>where</literal> clause include most of "
"the kind of things you could write in SQL:"
msgstr ""
"Les expressions permises dans la clause <literal>where</literal> incluent la "
"plupart des choses que vous pouvez utiliser en SQL :"

#. Tag: para
#: query_hql.xml:517
#, no-c-format
msgid "mathematical operators <literal>+, -, *, /</literal>"
msgstr "opérateurs mathématiques <literal>+, -, *, /</literal>"

#. Tag: para
#: query_hql.xml:522
#, no-c-format
msgid ""
"binary comparison operators <literal>=, &gt;=, &lt;=, &lt;&gt;, !=, like</"
"literal>"
msgstr ""
"opérateur de comparaison binaire <literal>=, &gt;=, &lt;=, &lt;&gt;, !=, "
"like</literal>"

#. Tag: para
#: query_hql.xml:527
#, no-c-format
msgid "logical operations <literal>and, or, not</literal>"
msgstr "opérateurs logiques <literal>and, or, not</literal>"

#. Tag: para
#: query_hql.xml:532
#, no-c-format
msgid "Parentheses <literal>( )</literal>, indicating grouping"
msgstr "Parenthèses <literal>( )</literal>, indiquant un regroupement"

#. Tag: para
#: query_hql.xml:537
#, no-c-format
msgid ""
"<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> and <literal>not member of</literal>"

#. Tag: para
#: query_hql.xml:550
#, no-c-format
msgid ""
"\"Simple\" case, <literal>case ... when ... then ... else ... end</literal>, "
"and \"searched\" case, <literal>case when ... then ... else ... end</literal>"
msgstr ""
"\"Simple\" case, <literal>case ... when ... then ... else ... end</literal>, "
"and \"searched\" case, <literal>case when ... then ... else ... end</literal>"

#. Tag: para
#: query_hql.xml:556
#, no-c-format
msgid ""
"string concatenation <literal>...||...</literal> or <literal>concat(...,...)"
"</literal>"
msgstr ""
"concatenation de chaîne de caractères <literal>...||...</literal> ou "
"<literal>concat(...,...)</literal>"

#. Tag: para
#: query_hql.xml:561
#, no-c-format
msgid ""
"<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>"

#. Tag: para
#: query_hql.xml:567
#, no-c-format
msgid ""
"<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>,"

#. Tag: para
#: query_hql.xml:574
#, no-c-format
msgid ""
"Any function or operator defined by EJB-QL 3.0: <literal>substring(), trim"
"(), lower(), upper(), length(), locate(), abs(), sqrt(), bit_length(), mod()"
"</literal>"
msgstr ""
"N'importe quel fonction ou opérateur défini par EJB-QL 3.0 : "
"<literal>substring(), trim(), lower(), upper(), length(), locate(), abs(), "
"sqrt(), bit_length(), mod()</literal>"

#. Tag: para
#: query_hql.xml:580
#, no-c-format
msgid "<literal>coalesce()</literal> and <literal>nullif()</literal>"
msgstr "<literal>coalesce()</literal> et <literal>nullif()</literal>"

#. Tag: para
#: query_hql.xml:585
#, no-c-format
msgid ""
"<literal>str()</literal> for converting numeric or temporal values to a "
"readable string"
msgstr ""