Another HQL query to write...

wojski696969 · **Joined:** Mon Aug 11, 2008 3:17 pm **Posts:** 6

Hi.. i have got another "please write me a query" question. This time I have a collection of Teams in each Tournament.. How can I get all tournaments wich contains team with specified Id ?? I want to make it in only one HQL query without adding any special props in my entities section.

Here is my mapping:

Code:

  <class name="Team" table="Teams">

    <id name="Id" column="Id" type="String">
      <generator class="uuid.hex" />
    </id>


    <property name="Name" type="String" length="150">
      <column name="Name" />
    </property>

    <many-to-one name="LeaderId" class="User" cascade="all"  lazy="false" column="LeaderId"/>

    <bag name="Players" cascade="all" lazy="false">
      <key column="TeamId" />
      <one-to-many class="Player" />
    </bag>

  </class>

  
  <class name="Tournament" table="Tournaments">

    <id name="Id" column="Id" type="String">
      <generator class="uuid.hex" />
    </id>

    <many-to-one name="OwnerId" class="User" cascade="all"  lazy="false" column="OwnerId"/>
    
    <property name="Name" type="String" length="150">
      <column name="Name" />
    </property>

    <property name="Mode" type="Int32">
      <column name="Mode" />
    </property>

    <property name="Stages" type="Int32">
      <column name="Stages" />
    </property>
 
    <bag name="Teams" table="Teams_Tournaments" cascade="all" lazy="false">
      <key column="TournamentId" />
      <many-to-many class="Team" />
    </bag>

    <many-to-one name="Games" class="Game" cascade="all"  lazy="false" column="Games"/>

  </class>

Thanks a lot for all replies wich will come ;)

wolli · **Posted:** Wed Aug 13, 2008 11:10 am

Example from the doc:

Code:

select mother from Eg.Cat as mother, Eg.Cat as kit
where kit in elements(mother.Kittens)

replace Cat with Tournament, Kittens with Teams.

http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/queryhql.html#queryhql-expressions

wolli · **Posted:** Wed Aug 13, 2008 11:22 am

Sorry, has to be more like

select mother from Eg.Cat as mother
where :team in elements(mother.Kittens)

query.SetParameter("team", team);

wojski696969 · **Joined:** Mon Aug 11, 2008 3:17 pm **Posts:** 6

Thanks again.. I have no idea that object could be a parameter :)

Btw. there are so many HQL queries in the manual, but so little description tu them...