Revize 9144b20e

Change sorting iteration from start date to name

src/main/java/cz/zcu/fav/kiv/antipatterndetectionapp/detecting/detectors/VaryingSprintLengthDetectorImpl.java

@@ -47 +47 @@
 
     /**
      * Postup detekce:
-     *      1) najít všechny iterace pro danný projekt seřazené dle start date
+     *      1) najít všechny iterace pro danný projekt seřazené dle name (start date má divné hodnoty a nejdou iterace po sobě)
      *      2) odebrání první a poslední iterace z důvodu možných výkyvů
      *      3) zjistit jejich délku (rozdíl mezi start date a end date)
      *      4) vždy porovnat dvě po sobě jdoucí iterace

src/main/resources/queries/too_long_sprint.sql

@@ -19 +19 @@
 /* Exclude first and last iteration? */
 set @excludeFirstAndLastIteration = false;
 /* Id of first iteration */
-set @idOfFirstIteration = (select id from iteration where iteration.superProjectId = @projectId order by startDate limit 1);
+set @idOfFirstIteration = (select id from iteration where iteration.superProjectId = @projectId order by name limit 1);
 /* Id of last iteration */
-set @idOfLastIteration = (select id from iteration where iteration.superProjectId = @projectId order by startDate desc limit 1);
+set @idOfLastIteration = (select id from iteration where iteration.superProjectId = @projectId order by name desc limit 1);
 /* Select all too long iterations */
-select datediff(iteration.endDate, iteration.startDate) as `iterationLength`, if(datediff(iteration.endDate, iteration.startDate) > @maxSprintLength, true, false) as `isTooLongSprint`, iteration.startDate as `iterationStartDate` from iteration where iteration.superProjectId = @projectId and iteration.id != if(@excludeFirstAndLastIteration = true, @idOfFirstIteration, -1) and iteration.id != if(@excludeFirstAndLastIteration = true, @idOfLastIteration, -1) order by iteration.startDate;
+select datediff(iteration.endDate, iteration.startDate) as `iterationLength`, if(datediff(iteration.endDate, iteration.startDate) > @maxSprintLength, true, false) as `isTooLongSprint`, iteration.startDate as `iterationStartDate` from iteration where iteration.superProjectId = @projectId and iteration.id != if(@excludeFirstAndLastIteration = true, @idOfFirstIteration, -1) and iteration.id != if(@excludeFirstAndLastIteration = true, @idOfLastIteration, -1) order by iteration.name;

src/main/resources/queries/varying_sprint_length.sql

@@ -20 +20 @@
 /* Exclude first and last iteration? */
 set @excludeFirstAndLastIteration = true;
 /* Id of first iteration */
-set @idOfFirstIteration = (select id from iteration where iteration.superProjectId = @projectId order by startDate limit 1);
+set @idOfFirstIteration = (select id from iteration where iteration.superProjectId = @projectId order by name limit 1);
 /* Id of last iteration */
-set @idOfLastIteration = (select id from iteration where iteration.superProjectId = @projectId order by startDate desc limit 1);
+set @idOfLastIteration = (select id from iteration where iteration.superProjectId = @projectId order by name desc limit 1);
 /* Select all iterations with their length */
-select datediff(endDate, startDate) as `iterationLength` from iteration where iteration.superProjectId = @projectId and iteration.id != if(@excludeFirstAndLastIteration = true, @idOfFirstIteration, -1) and iteration.id != if(@excludeFirstAndLastIteration = true, @idOfLastIteration, -1) order by iteration.startDate;
+select datediff(endDate, startDate) as `iterationLength` from iteration where iteration.superProjectId = @projectId and iteration.id != if(@excludeFirstAndLastIteration = true, @idOfFirstIteration, -1) and iteration.id != if(@excludeFirstAndLastIteration = true, @idOfLastIteration, -1) order by iteration.name;