Example #1
0
  @Test
  public void AddAndCountTest() {

    EntityCommon teamStage = new TeamStage("team1", "stage1", 1);
    EMF.add(teamStage);

    assertNull(TeamStage.getLastTeamStage("team2"));

    teamStage = new TeamStage("team2", "stage2", 1);
    EMF.add(teamStage);
    assertEquals("stage2", TeamStage.getLastTeamStage("team2").getStageName());

    teamStage = new TeamStage("team2", "stage3", 3);
    EMF.add(teamStage);

    assertEquals("stage3", TeamStage.getLastTeamStage("team2").getStageName());

    teamStage = new TeamStage("team2", "stage3", 3);
    EMF.add(teamStage);

    teamStage = new TeamStage("team1", "stage1", 1);
    EMF.add(teamStage);
    teamStage = new TeamStage();
    assertEquals(3, teamStage.count());

    List<? extends EntityCommon> allTeamsAndStages = teamStage.getList();
    for (EntityCommon teamStageForPrint : allTeamsAndStages) {
      System.out.println(teamStageForPrint);
    }
  }
Example #2
0
 /* (non-Javadoc)
  * @see cz.plsi.webInfo.shared.dataStore.entities.EntityCommon#exists()
  */
 @Override
 public boolean exists() {
   EntityManager em = EMF.getInstance().createEntityManager();
   Query query =
       em.createQuery(
           "SELECT ts FROM "
               + TeamStage.class.getName()
               + " ts "
               + "where ts.teamName=:teamName "
               + "and ts.stageName=:stageName");
   query.setParameter("teamName", this.getTeamName());
   query.setParameter("stageName", this.getStageName());
   query.setMaxResults(1);
   return !query.getResultList().isEmpty();
 }
Example #3
0
  public static TeamStage getTeamStage(Key id) {
    EntityManager em = EMF.getInstance().createEntityManager();
    TypedQuery<TeamStage> query =
        em.createQuery(
            "SELECT ts FROM " + TeamStage.class.getName() + " ts " + "where ts.id=:id",
            TeamStage.class);
    query.setParameter("id", id);
    query.setMaxResults(1);
    List<TeamStage> resultList = query.getResultList();
    if (resultList.isEmpty()) {
      return null;
    }

    return resultList.get(0);
  }
Example #4
0
  @Override
  public List<TeamStage> getList() {
    EntityManager em = EMF.getInstance().createEntityManager();
    CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
    CriteriaQuery<TeamStage> cq = criteriaBuilder.createQuery(TeamStage.class);
    Root<TeamStage> teamStage = cq.from(TeamStage.class);

    Predicate criteria = null;
    if (this.teamName != null) {
      criteria = criteriaBuilder.equal(teamStage.get("teamName"), this.teamName);
    }

    if (this.stageName != null) {
      criteria =
          criteriaBuilder.and(
              criteria, criteriaBuilder.equal(teamStage.get("stageName"), this.stageName));
    }

    if (this.stageBranch != null) {
      criteria =
          criteriaBuilder.and(
              criteria, criteriaBuilder.equal(teamStage.get("stageBranch"), this.stageBranch));
    }

    if (this.stageOrder == TEAM_ENDED_GAME) {
      Predicate equalEnded = criteriaBuilder.equal(teamStage.get("stageOrder"), this.stageOrder);
      criteria = criteria != null ? criteriaBuilder.and(criteria, equalEnded) : equalEnded;
    } else {
      Predicate notEqualOrder =
          criteriaBuilder.notEqual(teamStage.get("stageOrder"), TEAM_ENDED_GAME);
      criteria = criteria != null ? criteriaBuilder.and(criteria, notEqualOrder) : notEqualOrder;
    }

    if (criteria != null) {
      cq.where(criteria);
    }

    cq.select(teamStage);
    cq.orderBy(
        criteriaBuilder.desc(teamStage.get("stageOrder")),
        criteriaBuilder.asc(teamStage.get("stageDate")));

    em.getTransaction().begin();
    List<TeamStage> resultList = em.createQuery(cq).getResultList();
    em.getTransaction().commit();
    return resultList;
  }
Example #5
0
  /* (non-Javadoc)
   * @see cz.plsi.webInfo.shared.dataStore.entities.EntityCommon#count()
   */
  @Override
  public long count() {
    EntityManager em = EMF.getInstance().createEntityManager();
    StringBuilder queryBuilder = new StringBuilder();
    queryBuilder.append("SELECT COUNT(ts) FROM ");
    queryBuilder.append(TeamStage.class.getName());
    queryBuilder.append(" ts");
    if (this.teamName != null) {
      queryBuilder.append(" where ts.teamName=:teamName");
    }
    TypedQuery<Long> query = em.createQuery(queryBuilder.toString(), Long.class);
    if (this.teamName != null) {
      query.setParameter("teamName", this.teamName);
    }

    return query.getSingleResult();
  }
Example #6
0
  // TODO refaktor z team name na team code
  public static TeamStage getLastTeamStage(String team) {
    EntityManager em = EMF.getInstance().createEntityManager();
    TypedQuery<TeamStage> query =
        em.createQuery(
            "SELECT ts FROM "
                + TeamStage.class.getName()
                + " ts "
                + "where ts.teamName=:teamName "
                + "ORDER BY ts.stageDate DESC",
            TeamStage.class);
    query.setParameter("teamName", team);
    query.setMaxResults(1);
    List<TeamStage> resultList = query.getResultList();
    if (resultList.isEmpty()) {
      return null;
    }

    return resultList.get(0);
  }