query_hql.po

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

"<literal>str()</literal> pour convertir des valeurs numériques ou "
"temporelles vers une chaîne de caractères lisible"

#. Tag: para
#: query_hql.xml:591
#, no-c-format
msgid ""
"<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>, où le second argument est le nom d'un "
"type Hibernate, et <literal>extract(... from ...)</literal> si le "
"<literal>cast()</literal> ANSI et <literal>extract()</literal> sont "
"supportés par la base de données sous-jacente"

#. Tag: para
#: query_hql.xml:599
#, no-c-format
msgid ""
"the HQL <literal>index()</literal> function, that applies to aliases of a "
"joined indexed collection"
msgstr ""
"La fonction HQL <literal>index()</literal>, qui s'applique aux alias d'une "
"collection indexée jointe"

#. Tag: para
#: query_hql.xml:605
#, no-c-format
msgid ""
"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> "
"functions which may be quantified using <literal>some, all, exists, any, in</"
"literal>."
msgstr ""
"Les fonctions HQL qui s'appliquent expressions représentant des "
"collections : <literal>size(), minelement(), maxelement(), minindex(), "
"maxindex()</literal>, ainsi que les fonctions spéciales <literal>elements()</"
"literal> et <literal>indices</literal> qui peuvent être quantifiées en "
"utilisant <literal>some, all, exists, any, in</literal>."

#. Tag: para
#: query_hql.xml:613
#, no-c-format
msgid ""
"Any database-supported SQL scalar function like <literal>sign()</literal>, "
"<literal>trunc()</literal>, <literal>rtrim()</literal>, <literal>sin()</"
"literal>"
msgstr ""
"N'importe quelle fonction scalaire supportée par la base de données comme "
"<literal>sign()</literal>, <literal>trunc()</literal>, <literal>rtrim()</"
"literal>, <literal>sin()</literal>"

#. Tag: para
#: query_hql.xml:619
#, no-c-format
msgid "JDBC-style positional parameters <literal>?</literal>"
msgstr "Les paramètres positionnels de JDBC <literal>?</literal>"

#. Tag: para
#: query_hql.xml:624
#, no-c-format
msgid ""
"named parameters <literal>:name</literal>, <literal>:start_date</literal>, "
"<literal>:x1</literal>"
msgstr ""
"paramètres nommés <literal>:name</literal>, <literal>:start_date</literal>, "
"<literal>:x1</literal>"

#. Tag: para
#: query_hql.xml:629
#, no-c-format
msgid ""
"SQL literals <literal>'foo'</literal>, <literal>69</literal>, <literal>6.66E"
"+2</literal>, <literal>'1970-01-01 10:00:01.0'</literal>"
msgstr ""
"littéral SQL <literal>'foo'</literal>, <literal>69</literal>, <literal>'1970-"
"01-01 10:00:01.0'</literal>"

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

#. Tag: para
#: query_hql.xml:641
#, no-c-format
msgid ""
"<literal>in</literal> and <literal>between</literal> may be used as follows:"
msgstr ""
"<literal>in</literal> et <literal>between</literal> peuvent être utilisés "
"comme suit :"

#. Tag: programlisting
#: query_hql.xml:645
#, no-c-format
msgid "<![CDATA[from DomesticCat cat where cat.name between 'A' and 'B']]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:647
#, no-c-format
msgid ""
"<![CDATA[from DomesticCat cat where cat.name in ( 'Foo', 'Bar', 'Baz' )]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:649
#, no-c-format
msgid "and the negated forms may be written"
msgstr "et la forme négative peut être écrite"

#. Tag: programlisting
#: query_hql.xml:653
#, no-c-format
msgid "<![CDATA[from DomesticCat cat where cat.name not between 'A' and 'B']]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:655
#, no-c-format
msgid ""
"<![CDATA[from DomesticCat cat where cat.name not in ( 'Foo', 'Bar', 'Baz' )]]"
">"
msgstr ""

#. Tag: para
#: query_hql.xml:657
#, no-c-format
msgid ""
"Likewise, <literal>is null</literal> and <literal>is not null</literal> may "
"be used to test for null values."
msgstr ""
"De même, <literal>is null</literal> et <literal>is not null</literal> "
"peuvent être utilisés pour tester les valeurs nulle."

#. Tag: para
#: query_hql.xml:662
#, no-c-format
msgid ""
"Booleans may be easily used in expressions by declaring HQL query "
"substitutions in Hibernate configuration:"
msgstr ""
"Les booléens peuvent être facilement utilisés en déclarant les substitutions "
"de requêtes dans la configuration Hibernate :"

#. Tag: programlisting
#: query_hql.xml:667
#, no-c-format
msgid ""
"<![CDATA[<property name=\"hibernate.query.substitutions\">true 1, false 0</"
"property>]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:669
#, no-c-format
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 ""
"Ce qui remplacera les mots clés <literal>true</literal> et <literal>false</"
"literal> par <literal>1</literal> et <literal>0</literal> dans la traduction "
"SQL du HQL suivant :"

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

#. Tag: para
#: query_hql.xml:676
#, no-c-format
msgid ""
"You may test the size of a collection with the special property "
"<literal>size</literal>, or the special <literal>size()</literal> function."
msgstr ""
"Vous pouvez tester la taille d'une collection par la propriété spéciale "
"<literal>size</literal>, ou la fonction spéciale <literal>size()</literal>."

#. Tag: programlisting
#: query_hql.xml:681
#, no-c-format
msgid "<![CDATA[from Cat cat where cat.kittens.size > 0]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:683
#, no-c-format
msgid "<![CDATA[from Cat cat where size(cat.kittens) > 0]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:685
#, no-c-format
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 ""
"Pour les collections indexées, vous pouvez faire référence aux indices "
"minimum et maximum en utilisant les fonctions <literal>minindex</literal> "
"and <literal>maxindex</literal>. De manière similaire, vous pouvez faire "
"référence aux éléments minimum et maximum d'une collection de type basiques "
"en utilisant les fonctions <literal>minelement</literal> et "
"<literal>maxelement</literal>."

#. Tag: programlisting
#: query_hql.xml:693
#, no-c-format
msgid ""
"<![CDATA[from Calendar cal where maxelement(cal.holidays) > current_date]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:695
#, no-c-format
msgid "<![CDATA[from Order order where maxindex(order.items) > 100]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:697
#, no-c-format
msgid "<![CDATA[from Order order where minelement(order.items) > 10000]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:699
#, no-c-format
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 ""
"Les fonctions SQL <literal>any, some, all, exists, in</literal> supportent "
"que leur soient passées l'élément, l'index d'une collection (fonctions "
"<literal>elements</literal> et <literal>indices</literal>) ou le résultat "
"d'une sous requête (voir ci dessous)."

#. Tag: programlisting
#: query_hql.xml:705
#, no-c-format
msgid ""
"<![CDATA[select mother from Cat as mother, Cat as kit\n"
"where kit in elements(foo.kittens)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:707
#, no-c-format
msgid ""
"<![CDATA[select p from NameList list, Person p\n"
"where p.name = some elements(list.names)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:709
#, no-c-format
msgid "<![CDATA[from Cat cat where exists elements(cat.kittens)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:711
#, no-c-format
msgid "<![CDATA[from Player p where 3 > all elements(p.scores)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:713
#, no-c-format
msgid "<![CDATA[from Show show where 'fizard' in indices(show.acts)]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:715
#, no-c-format
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 ""
"Notez que l'écriture de - <literal>size</literal>, <literal>elements</"
"literal>, <literal>indices</literal>, <literal>minindex</literal>, "
"<literal>maxindex</literal>, <literal>minelement</literal>, "
"<literal>maxelement</literal> - peuvent seulement être utilisée dans la "
"clause where dans Hibernate3."

#. Tag: para
#: query_hql.xml:722
#, no-c-format
msgid ""
"Elements of indexed collections (arrays, lists, maps) may be referred to by "
"index (in a where clause only):"
msgstr ""
"Les éléments de collections indexées (arrays, lists, maps) peuvent être "
"référencés via index (dans une clause where seulement) :"

#. Tag: programlisting
#: query_hql.xml:727
#, no-c-format
msgid "<![CDATA[from Order order where order.items[0].id = 1234]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:729
#, no-c-format
msgid ""
"<![CDATA[select person from Person person, Calendar calendar\n"
"where calendar.holidays['national day'] = person.birthDay\n"
"    and person.nationality.calendar = calendar]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:731
#, no-c-format
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ order.deliveredItemIndices[0] ] = item and order.id = 11]]"
">"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:733
#, no-c-format
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ maxindex(order.items) ] = item and order.id = 11]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:735
#, no-c-format
msgid ""
"The expression inside <literal>[]</literal> may even be an arithmetic "
"expression."
msgstr ""
"L'expression entre <literal>[]</literal> peut même être une expression "
"arithmétique."

#. Tag: programlisting
#: query_hql.xml:739
#, no-c-format
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ size(order.items) - 1 ] = item]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:741
#, no-c-format
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 propose aussi une fonction <literal>index()</literal> interne, pour les "
"éléments d'une association one-to-many ou d'une collections de valeurs."

#. Tag: programlisting
#: query_hql.xml:746
#, no-c-format
msgid ""
"<![CDATA[select item, index(item) from Order order\n"
"    join order.items item\n"
"where index(item) < 5]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:748
#, no-c-format
msgid "Scalar SQL functions supported by the underlying database may be used"
msgstr ""
"Les fonctions SQL scalaires supportées par la base de données utilisée "
"peuvent être utilisées"

#. Tag: programlisting
#: query_hql.xml:752
#, no-c-format
msgid "<![CDATA[from DomesticCat cat where upper(cat.name) like 'FRI%']]>"
msgstr ""

#. Tag: para
#: query_hql.xml:754
#, no-c-format
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 vous n'êtes pas encore convaincu par tout cela, imaginez la taille et "
"l'illisibilité qui caractériseraient la transformation SQL de la requête HQL "
"suivante :"

#. Tag: programlisting
#: query_hql.xml:759
#, no-c-format
msgid ""
"<![CDATA[select cust\n"
"from Product prod,\n"
"    Store store\n"
"    inner join store.customers cust\n"
"where prod.name = 'widget'\n"