[Topia-users] utilisation de TopiaQuery

23 Jul 2010

      Bonjour,

je rencontre un problème avec une TopiaQuery récalcitrante :

J'ai la requête SQL suivante :

SELECT title, over, runtime, (SELECT COUNT(TOPIAID) FROM EPISODE where 
SEASON IN (SELECT TOPIAID FROM SEASON WHERE SHOW = S.TOPIAID)) FROM SHOW 
S ORDER BY title

Cette requête passe dans H2 et me donne le résultat escompté.

J'essaie de transformer ça en TopiaQuery sans succès.

Voici différents codes essayés :

             TopiaQuery query = showDAO.createQuery("S");
             query.addFrom(Episode.class, "E");
             query.addFrom(Season.class, "SE");
             query.addSelect(Show.TITLE);
             query.addSelect(Show.OVER);
             query.addSelect(Show.RUNTIME);
             String episodeSeasonProperty = 
TopiaQuery.getProperty(Episode.SEASON);
             String seasonTopiaIdProperty = 
TopiaQuery.getProperty(Season.TOPIA_ID);
             String seasonShowProperty = 
TopiaQuery.getProperty(Season.SHOW);
             String showTopiaIdProperty = 
TopiaQuery.getProperty(Show.TOPIA_ID);
             String episodeWatchedProperty = 
TopiaQuery.getProperty(Episode.VIEWED);
             query.addSelect("(SELECT COUNT(E) where 
"+episodeWatchedProperty+" AND "+episodeSeasonProperty+" IN (SELECT 
"+seasonTopiaIdProperty+" WHERE "+seasonShowProperty+" = 
"+showTopiaIdProperty+"))");
             query.addOrder(Show.TITLE);

             TopiaQuery query = showDAO.createQuery("S");
             query.addSelect(Show.TITLE);
             query.addSelect(Show.OVER);
             query.addSelect(Show.RUNTIME);
             query.addSelect("(SELECT COUNT(TOPIAID) FROM EPISODE where 
SEASON IN (SELECT TOPIAID FROM SEASON WHERE SHOW = S.TOPIAID))");
             query.addOrder(Show.TITLE);

Quelqu'un aurait une piste pour faire fonctionner tout ça ?

[Topia-users] utilisation de TopiaQuery

Jean Couteau