public function testMovePosition()
 {
     $tp = new TaskPosition($this->container);
     $tc = new TaskCreation($this->container);
     $tf = new TaskFinder($this->container);
     $p = new Project($this->container);
     $this->assertEquals(1, $p->create(array('name' => 'Project #1')));
     $counter = 1;
     $task_per_column = 5;
     foreach (array(1, 2, 3, 4) as $column_id) {
         for ($i = 1; $i <= $task_per_column; $i++, $counter++) {
             $task = array('title' => 'Task #' . $i . '-' . $column_id, 'project_id' => 1, 'column_id' => $column_id, 'owner_id' => 0);
             $this->assertEquals($counter, $tc->create($task));
             $task = $tf->getById($counter);
             $this->assertNotFalse($task);
             $this->assertNotEmpty($task);
             $this->assertEquals($i, $task['position']);
         }
     }
     // We move task id #4, column 1, position 4 to the column 2, position 3
     $this->assertTrue($tp->movePosition(1, 4, 2, 3));
     // We check the new position of the task
     $task = $tf->getById(4);
     $this->assertEquals(4, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(3, $task['position']);
     // The tasks before have the correct position
     $task = $tf->getById(3);
     $this->assertEquals(3, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals(3, $task['position']);
     $task = $tf->getById(7);
     $this->assertEquals(7, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(2, $task['position']);
     // The tasks after have the correct position
     $task = $tf->getById(5);
     $this->assertEquals(5, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals(4, $task['position']);
     $task = $tf->getById(8);
     $this->assertEquals(8, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(4, $task['position']);
     // The number of tasks per column
     $this->assertEquals($task_per_column - 1, $tf->countByColumnId(1, 1));
     $this->assertEquals($task_per_column + 1, $tf->countByColumnId(1, 2));
     $this->assertEquals($task_per_column, $tf->countByColumnId(1, 3));
     $this->assertEquals($task_per_column, $tf->countByColumnId(1, 4));
     // We move task id #1, column 1, position 1 to the column 4, position 6 (last position)
     $this->assertTrue($tp->movePosition(1, 1, 4, $task_per_column + 1));
     // We check the new position of the task
     $task = $tf->getById(1);
     $this->assertEquals(1, $task['id']);
     $this->assertEquals(4, $task['column_id']);
     $this->assertEquals($task_per_column + 1, $task['position']);
     // The tasks before have the correct position
     $task = $tf->getById(20);
     $this->assertEquals(20, $task['id']);
     $this->assertEquals(4, $task['column_id']);
     $this->assertEquals($task_per_column, $task['position']);
     // The tasks after have the correct position
     $task = $tf->getById(2);
     $this->assertEquals(2, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals(1, $task['position']);
     // The number of tasks per column
     $this->assertEquals($task_per_column - 2, $tf->countByColumnId(1, 1));
     $this->assertEquals($task_per_column + 1, $tf->countByColumnId(1, 2));
     $this->assertEquals($task_per_column, $tf->countByColumnId(1, 3));
     $this->assertEquals($task_per_column + 1, $tf->countByColumnId(1, 4));
     // Our previous moved task should stay at the same place
     $task = $tf->getById(4);
     $this->assertEquals(4, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(3, $task['position']);
     // Test wrong position number
     $this->assertFalse($tp->movePosition(1, 2, 3, 0));
     $this->assertFalse($tp->movePosition(1, 2, 3, -2));
     // Wrong column
     $this->assertFalse($tp->movePosition(1, 2, 22, 2));
     // Test position greater than the last position
     $this->assertTrue($tp->movePosition(1, 11, 1, 22));
     $task = $tf->getById(11);
     $this->assertEquals(11, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals($tf->countByColumnId(1, 1), $task['position']);
     $task = $tf->getById(5);
     $this->assertEquals(5, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals($tf->countByColumnId(1, 1) - 1, $task['position']);
     $task = $tf->getById(4);
     $this->assertEquals(4, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(3, $task['position']);
     $this->assertEquals($task_per_column - 1, $tf->countByColumnId(1, 1));
     $this->assertEquals($task_per_column + 1, $tf->countByColumnId(1, 2));
     $this->assertEquals($task_per_column - 1, $tf->countByColumnId(1, 3));
     $this->assertEquals($task_per_column + 1, $tf->countByColumnId(1, 4));
     // Our previous moved task should stay at the same place
     $task = $tf->getById(4);
     $this->assertEquals(4, $task['id']);
     $this->assertEquals(2, $task['column_id']);
     $this->assertEquals(3, $task['position']);
     // Test moving task to position 1
     $this->assertTrue($tp->movePosition(1, 14, 1, 1));
     $task = $tf->getById(14);
     $this->assertEquals(14, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals(1, $task['position']);
     $task = $tf->getById(2);
     $this->assertEquals(2, $task['id']);
     $this->assertEquals(1, $task['column_id']);
     $this->assertEquals(2, $task['position']);
     $this->assertEquals($task_per_column, $tf->countByColumnId(1, 1));
     $this->assertEquals($task_per_column + 1, $tf->countByColumnId(1, 2));
     $this->assertEquals($task_per_column - 2, $tf->countByColumnId(1, 3));
     $this->assertEquals($task_per_column + 1, $tf->countByColumnId(1, 4));
 }