skillifier/src/main/java/rage/models/daos/SkillDao.java
@Query("SELECT s FROM Course c, Week w, Theme t, Skill s"
            + " WHERE s.theme = t.id AND t.week = w.id AND w.course = c.id"
            + " AND w.weekNumber = :weekNumber AND c.name = :courseName")
    public List<Skill> findByCourseAndWeek(
            @Param("courseName") String courseName, @Param("weekNumber") int weekNumber);
/**
     * Find and return a list of Skills relating to a Week of a specified Course.
     * @param courseName The Course's mame that includes the Week.
     * @param weekNumber The specified Week of the Course.
     * @return (List of type Skill) A list of Skills related to the specified Course and Week.
     */
Find and return a list of Skills relating to a Week of a specified Course.
@param courseName The Course's mame that includes the Week.
@param weekNumber The specified Week of the Course.
@return (List of type Skill) A list of Skills related to the specified Course and Week.
Find and return a list of Skills relating to a Week of a specified Course . @param courseName The Course ' s mame that includes the Week . @param weekNumber The specified Week of the Course . @return ( List of type Skill ) A list of Skills related to the specified Course and Week .
@Query("SELECT s FROM Course c, Week w, Theme t, Skill s"
            + " WHERE s.theme = t.id AND t.week = w.id AND w.course = c.id"
            + " AND w.weekNumber = :weekNumber AND c.name = :courseName")
    public List<Skill> findByCourseAndWeek(
            @Param("courseName") String courseName, @Param("weekNumber") int weekNumber);
@ Query ( "SELECT s FROM Course c, Week w, Theme t, Skill s" + " WHERE s.theme = t.id AND t.week = w.id AND w.course = c.id" + " AND w.weekNumber = :weekNumber AND c.name = :courseName" ) public List < Skill > findByCourseAndWeek ( @ Param ( "courseName" ) String courseName , @ Param ( "weekNumber" ) int weekNumber ) ;
Find and return a list of Skills relating to a Week of a specified Course.
Find and return a list of Skills relating to a Week of a specified Course .