test/unit/lib/AkActiveRecord/AkActsAsList.php

   1 <?php
   2
   3 defined('AK_TEST_DATABASE_ON') ? null : define('AK_TEST_DATABASE_ON', true);
   4 require_once(dirname(__FILE__).'/../../../fixtures/config/config.php');
   5
   6 if(!defined('AK_ACTIVE_RECORD_PROTECT_GET_RECURSION')){
   7     define('AK_ACTIVE_RECORD_PROTECT_GET_RECURSION', false);
   8 }
   9
  10 class AkActiveRecord_actsAsListTestCase extends  AkUnitTest
  11 {
  12
  13     function test_AkActiveRecord_actsAsList()
  14     {
  15         $this->installAndIncludeModels(array(
  16             'TodoItem'=>'id, position int, task text, due_time datetime, created_at, expires datetime, updated_at,new_position int'
  17         ));
  18     }
  19
  20     function Test_of_actsAsList_instatiation()
  21     {
  22         $TodoItems =& new TodoItem();
  23         $this->assertEqual($TodoItems->actsLike(), 'active record,list');
  24         $this->assertFalse(empty($TodoItems->list->column));
  25         $this->assertTrue(empty($TodoItems->list->scope));
  26
  27         $TodoItems =& new TodoItem();
  28         $this->assertErrorPattern('/not_available/',$TodoItems->actsAs('list', array('column'=>'not_available')));
  29
  30         $this->assertEqual($TodoItems->actsLike(), 'active record');
  31
  32     }
  33
  34     function Test_of_Test_of___construct()
  35     {
  36         $TodoItems =& new TodoItem();
  37         $TodoItems->actsAs('list',
  38         array(
  39         'column'=>'new_position', // Redefining the default column
  40         'scope'=>array('todo_list_id = ? AND completed = 0',$TodoItems->getId()),
  41         'custom_attribute'=>'This is not allowed here'));
  42         $this->assertEqual($TodoItems->list->column, 'new_position');
  43         $this->assertEqual($TodoItems->list->scope, array ( 0 => 'todo_list_id = ? AND completed = 0', 1 => null));
  44         $this->assertTrue(empty($TodoItems->list->custom_attribute));
  45     }
  46
  47     function Test_of__ensureIsActiveRecordInstance()
  48     {
  49         $TodoItems =& new TodoItem();
  50         $Object =& new AkObject();
  51         $this->assertErrorPattern('/is not an active record/',$TodoItems->list->_ensureIsActiveRecordInstance(&$Object));
  52     }
  53
  54     function Test_of_getType()
  55     {
  56         $TodoItems =& new TodoItem();
  57         $this->assertEqual($TodoItems->list->getType(), 'list');
  58     }
  59
  60     function Test_of_getScopeCondition_and_setScopeCondition()
  61     {
  62         $TodoItems =& new TodoItem();
  63         $this->assertEqual($TodoItems->list->getScopeCondition(), ($TodoItems->_db->type() == 'postgre') ? 'true' : '1');
  64         $TodoItems->list->setScopeCondition('true');
  65         $this->assertEqual($TodoItems->list->getScopeCondition(), 'true');
  66     }
  67
  68     function Test_of_getBottomItem_1()
  69     {
  70         $TodoItems =& new TodoItem();
  71         $this->assertFalse($TodoItems->list->getBottomItem());
  72     }
  73
  74     function Test_of_getBottomPosition_1()
  75     {
  76         $TodoItems =& new TodoItem();
  77         $this->assertIdentical($TodoItems->list->getBottomPosition(), 0);
  78     }
  79
  80     function Test_of__addToBottom_1()
  81     {
  82         $TodoItems =& new TodoItem();
  83         $TodoItems->List->_addToBottom();
  84         $this->assertIdentical($TodoItems->position, 1);
  85         $this->assertIdentical($TodoItems->List->_ActiveRecordInstance->position, 1);
  86     }
  87
  88     function Test_of_beforeCreate()
  89     {
  90         $TodoItems =& new TodoItem();
  91         $position = $TodoItems->getAttribute('position');
  92         $TodoItems->List->beforeCreate($TodoItems);
  93         $this->assertIdentical($TodoItems->getAttribute('position'),$position+1);
  94     }
  95
  96
  97     function Test_of_getBottomItem_2()
  98     {
  99         $TodoItems =& new TodoItem('task->','Email Hilario with new product specs','due_time->',Ak::getDate(Ak::time()+(60*60*24*7)));
 100         $this->assertPattern('/list/',$TodoItems->actsLike());
 101         $this->assertTrue($TodoItems->isNewRecord());
 102
 103         $this->assertTrue($TodoItems->save());
 104
 105         $this->assertTrue($getBottomItem = $TodoItems->List->getBottomItem());
 106         $this->assertEqual($getBottomItem->toString(), $TodoItems->toString());
 107
 108         $TodoItems =& new TodoItem('task->','Book COMDEX trip','due_time->',Ak::getDate(Ak::time()+(60*60*24*3)));
 109         $this->assertTrue($TodoItems->isNewRecord());
 110         $this->assertTrue($TodoItems->save());
 111         $this->assertTrue($getBottomItem = $TodoItems->List->getBottomItem());
 112
 113         $this->assertEqual($getBottomItem->toString(), $TodoItems->toString());
 114
 115         $TodoItems =& new TodoItem(1);
 116         $this->assertTrue($getBottomItem = $TodoItems->List->getBottomItem(2));
 117         $this->assertEqual($getBottomItem->toString(), $TodoItems->toString());
 118
 119     }
 120
 121     function Test_of_getBottomPosition_2()
 122     {
 123         $TodoItems =& new TodoItem();
 124         $this->assertEqual($TodoItems->list->getBottomPosition(), 2);
 125
 126         $TodoItem = $TodoItems->find(2);
 127         $this->assertEqual($TodoItem->list->getBottomPosition(), 2);
 128     }
 129
 130     function Test_of__addToBottom_2()
 131     {
 132         $TodoItems =& new TodoItem();
 133         $TodoItems->list->_addToBottom();
 134         $this->assertIdentical($TodoItems->position, 3);
 135         $this->assertIdentical($TodoItems->list->_ActiveRecordInstance->position, 3);
 136     }
 137
 138
 139     function Test_of_isInList()
 140     {
 141         $TodoItems =& new TodoItem();
 142         $this->assertFalse($TodoItems->list->isInList());
 143
 144         $TodoItems =& new TodoItem(1);
 145         $this->assertTrue($TodoItems->list->isInList());
 146     }
 147
 148
 149     function Test_of_populate_todo_list()
 150     {
 151         for ($i = 0; $i <= 30; $i++){
 152             $attributes = array('task'=>'Task number '.($i+3),'due_time'=>Ak::getDate(Ak::time()+(60*60*24*$i)));
 153             $TodoTask =& new TodoItem($attributes);
 154             $this->assertTrue($TodoTask->save());
 155             $this->assertTrue(($TodoTask->task == $attributes['task']) && $TodoTask->due_time == $attributes['due_time']);
 156         }
 157     }
 158
 159
 160     function Test_of_decrementPositionsOnLowerItems()
 161     {
 162         $TodoItems =& new TodoItem();
 163         $TodoItems->transactionStart();
 164         $this->assertFalse($TodoItems->list->decrementPositionsOnLowerItems());
 165
 166         $todo_list = $this->_getTodoList();
 167         $this->assertEqual($todo_list[10] , 'Task number 10');
 168         $TodoItems =& new TodoItem(10);
 169
 170         $this->assertTrue($TodoItems->list->decrementPositionsOnLowerItems());
 171         $todo_list = $this->_getTodoList();
 172
 173         $this->assertEqual($todo_list[10] , 'Task number 11');
 174         $this->assertFalse(in_array('Task number 10',$todo_list));
 175
 176         $TodoItems->transactionFail();
 177         $TodoItems->transactionComplete();
 178
 179         $todo_list = $this->_getTodoList();
 180         $this->assertEqual($todo_list[10] , 'Task number 10','Test failed because a database transaction was not performed correctly');
 181     }
 182
 183     function Test_of_removeFromList()
 184     {
 185         $TodoItems =& new TodoItem(10);
 186
 187         $TodoItems->transactionStart();
 188         $this->assertTrue($TodoItems->list->removeFromList());
 189         $this->assertFalse($TodoItems->list->isInList());
 190         $TodoItems->transactionFail();
 191         $TodoItems->transactionComplete();
 192         $todo_list = $this->_getTodoList();
 193         $this->assertEqual($todo_list[10] , 'Task number 10','Test failed because a database transaction was not performed correctly');
 194     }
 195
 196
 197     function Test_of_afterDestroy_and_beforeDestroy()
 198     {
 199         $TodoItems =& new TodoItem(10);
 200
 201         $TodoItems->transactionStart();
 202
 203         $TodoItems->destroy();
 204         $this->assertFalse($TodoItems->list->isInList());
 205
 206         $todo_list = $this->_getTodoList();
 207         $this->assertEqual($todo_list[10] , 'Task number 11');
 208
 209         $this->assertEqual($todo_list[14] , 'Task number 15');
 210
 211         $TodoItems->destroy(array(15,16));
 212
 213         $todo_list = $this->_getTodoList();
 214         $this->assertEqual($todo_list[13] , 'Task number 14');
 215         $this->assertEqual($todo_list[14] , 'Task number 17');
 216         $this->assertEqual($todo_list[15] , 'Task number 18');
 217
 218         $TodoItems->transactionFail();
 219         $TodoItems->transactionComplete();
 220         $todo_list = $this->_getTodoList();
 221         $this->assertEqual($todo_list[10] , 'Task number 10','Test failed because a database transaction was not performed correctly');
 222
 223     }
 224
 225     function Test_of_getLowerItem()
 226     {
 227         $TodoItems =& new TodoItem();
 228         $this->assertFalse($TodoItems->list->getLowerItem());
 229         $TodoItem = $TodoItems->find(10);
 230
 231         $LowerItem = $TodoItem->list->getLowerItem();
 232         $this->assertEqual($LowerItem->task, 'Task number 11');
 233
 234         $TodoItem = $TodoItems->find(33);
 235         $this->assertFalse($TodoItem->list->getLowerItem());
 236
 237
 238         $TodoItems =& new TodoItem();
 239         $TodoItems->transactionStart();
 240         $this->assertTrue($TodoItems->deleteAll());
 241
 242         $this->assertFalse($TodoItems->list->getLowerItem());
 243
 244         $TodoItems->transactionFail();
 245         $TodoItems->transactionComplete();
 246     }
 247
 248     function Test_of_decrementPosition()
 249     {
 250         $TodoItems =& new TodoItem(10);
 251         $TodoItems->transactionStart();
 252
 253         $this->assertTrue($TodoItems->list->decrementPosition());
 254
 255         $TodoItems->transactionFail();
 256         $TodoItems->transactionComplete();
 257     }
 258
 259     function Test_of_incrementPosition()
 260     {
 261         $TodoItems =& new TodoItem(10);
 262         $TodoItems->transactionStart();
 263
 264         $this->assertTrue($TodoItems->list->incrementPosition());
 265
 266         $TodoItems->transactionFail();
 267         $TodoItems->transactionComplete();
 268     }
 269
 270     function Test_of_moveLower()
 271     {
 272         $TodoItems =& new TodoItem();
 273         $this->assertFalse($TodoItems->list->moveLower());
 274
 275         $todo_list = $this->_getTodoList();
 276         $this->assertEqual($todo_list[10] , 'Task number 10');
 277         $this->assertEqual($todo_list[11] , 'Task number 11');
 278
 279         $TodoItems =& new TodoItem(10);
 280         $TodoItems->transactionStart();
 281
 282         $this->assertTrue($TodoItems->list->moveLower());
 283
 284         $todo_list = $this->_getTodoList();
 285         $this->assertEqual($todo_list[10] , 'Task number 11');
 286         $this->assertEqual($todo_list[11] , 'Task number 10');
 287
 288         $TodoItems =& new TodoItem(33);
 289         $this->assertFalse($TodoItems->list->moveLower());
 290
 291         $TodoItems->transactionFail();
 292         $TodoItems->transactionComplete();
 293
 294     }
 295
 296     function Test_of_getHigherItem()
 297     {
 298         $TodoItems =& new TodoItem();
 299         $this->assertFalse($TodoItems->list->getHigherItem());
 300
 301         $TodoItem = $TodoItems->find(10);
 302         $HigherItem = $TodoItem->list->getHigherItem();
 303         $this->assertEqual($HigherItem->task, 'Task number 9');
 304
 305         $TodoItem = $TodoItems->find(1);
 306         $this->assertFalse($TodoItem->list->getHigherItem());
 307
 308
 309         $TodoItems =& new TodoItem();
 310         $TodoItems->transactionStart();
 311         $this->assertTrue($TodoItems->deleteAll());
 312
 313         $this->assertFalse($TodoItems->list->getHigherItem());
 314
 315         $TodoItems->transactionFail();
 316         $TodoItems->transactionComplete();
 317     }
 318
 319
 320     function Test_of_moveHigher()
 321     {
 322         $TodoItems =& new TodoItem();
 323         $this->assertFalse($TodoItems->list->moveHigher());
 324
 325         $todo_list = $this->_getTodoList();
 326         $this->assertEqual($todo_list[9] , 'Task number 9');
 327         $this->assertEqual($todo_list[10] , 'Task number 10');
 328
 329         $TodoItems =& new TodoItem(10);
 330         $TodoItems->transactionStart();
 331
 332         $this->assertTrue($TodoItems->list->moveHigher());
 333
 334         $todo_list = $this->_getTodoList();
 335         $this->assertEqual($todo_list[9] , 'Task number 10');
 336         $this->assertEqual($todo_list[10] , 'Task number 9');
 337
 338         $TodoItems =& new TodoItem(1);
 339         $this->assertFalse($TodoItems->list->moveHigher());
 340
 341         $TodoItems->transactionFail();
 342         $TodoItems->transactionComplete();
 343     }
 344
 345     function Test_of_assumeBottomPosition()
 346     {
 347         $todo_list = $this->_getTodoList();
 348         $this->assertEqual($todo_list[10] , 'Task number 10');
 349
 350         $TodoItems =& new TodoItem(10);
 351         $TodoItems->transactionStart();
 352
 353         $this->assertTrue($TodoItems->list->assumeBottomPosition());
 354
 355         $todo_list = $this->_getTodoList();
 356         $this->assertEqual($todo_list[34] , 'Task number 10');
 357
 358         $TodoItems->transactionFail();
 359         $TodoItems->transactionComplete();
 360     }
 361
 362     function Test_of_moveToBottom()
 363     {
 364         $todo_list = $this->_getTodoList();
 365         $this->assertEqual($todo_list[10] , 'Task number 10');
 366
 367         $TodoItems =& new TodoItem();
 368         $this->assertFalse($TodoItems->list->moveToBottom());
 369
 370         $TodoItems =& new TodoItem(10);
 371         $TodoItems->transactionStart();
 372
 373         $this->assertTrue($TodoItems->list->moveToBottom());
 374
 375         $todo_list = $this->_getTodoList();
 376         $this->assertEqual($todo_list[10] , 'Task number 11');
 377         $this->assertEqual($todo_list[32] , 'Task number 33');
 378         $this->assertEqual($todo_list[33] , 'Task number 10');
 379
 380         $TodoItems->transactionFail();
 381         $TodoItems->transactionComplete();
 382
 383         $TodoItems =& new TodoItem(33);
 384         $TodoItems->transactionStart();
 385
 386         $this->assertTrue($TodoItems->list->moveToBottom());
 387
 388         $todo_list = $this->_getTodoList();
 389         $this->assertEqual($todo_list[33] , 'Task number 33');
 390
 391         $TodoItems->transactionFail();
 392         $TodoItems->transactionComplete();
 393     }
 394
 395     function Test_of_incrementPositionsOnHigherItems()
 396     {
 397         $TodoItems =& new TodoItem();
 398         $TodoItems->transactionStart();
 399         $this->assertFalse($TodoItems->list->incrementPositionsOnHigherItems());
 400
 401         $todo_list = $this->_getTodoList();
 402         $this->assertEqual($todo_list[10] , 'Task number 10');
 403         $TodoItems =& new TodoItem(10);
 404         $this->assertTrue($TodoItems->list->incrementPositionsOnHigherItems());
 405         $todo_list = $this->_getTodoList();
 406         $this->assertEqual($todo_list[9] , 'Task number 8');
 407         $this->assertEqual($todo_list[10] , 'Task number 10');  // Task 9&10 are on position 10, so this is ambigious; last one returned by find wins
 408         $TodoItems->transactionFail();
 409         $TodoItems->transactionComplete();
 410     }
 411
 412
 413     function Test_of_assumeTopPosition()
 414     {
 415         $TodoItems =& new TodoItem();
 416         $TodoItems->transactionStart();
 417
 418         $todo_list = $this->_getTodoList();
 419         $this->assertEqual($todo_list[10] , 'Task number 10');
 420         $TodoItems =& new TodoItem(10);
 421         $this->assertTrue($TodoItems->list->assumeTopPosition());
 422         $todo_list = $this->_getTodoList();
 423         $this->assertEqual($todo_list[1] , 'Task number 10');
 424         $TodoItems->transactionFail();
 425         $TodoItems->transactionComplete();
 426     }
 427
 428     function Test_of_moveToTop()
 429     {
 430         $todo_list = $this->_getTodoList();
 431         $this->assertEqual($todo_list[10] , 'Task number 10');
 432
 433         $TodoItems =& new TodoItem();
 434         $this->assertFalse($TodoItems->list->moveToTop());
 435
 436         $TodoItems =& new TodoItem(10);
 437         $TodoItems->transactionStart();
 438
 439         $this->assertTrue($TodoItems->list->moveToTop());
 440
 441         $todo_list = $this->_getTodoList();
 442         $this->assertEqual($todo_list[10] , 'Task number 9');
 443         $this->assertEqual($todo_list[2] , 'Email Hilario with new product specs');
 444         $this->assertEqual($todo_list[1] , 'Task number 10');
 445
 446         $TodoItems->transactionFail();
 447         $TodoItems->transactionComplete();
 448
 449         $TodoItems =& new TodoItem(1);
 450         $TodoItems->transactionStart();
 451
 452         $this->assertTrue($TodoItems->list->moveToTop());
 453
 454         $todo_list = $this->_getTodoList();
 455         $this->assertEqual($todo_list[1] , 'Email Hilario with new product specs');
 456
 457         $TodoItems->transactionFail();
 458         $TodoItems->transactionComplete();
 459     }
 460
 461     function Test_of_isFirst()
 462     {
 463         $TodoItems =& new TodoItem(1);
 464
 465         $this->assertTrue($TodoItems->list->isFirst());
 466
 467         $TodoItems =& new TodoItem(2);
 468         $this->assertFalse($TodoItems->list->isFirst());
 469
 470         $TodoItems =& new TodoItem();
 471         $this->assertFalse($TodoItems->list->isFirst());
 472     }
 473
 474
 475     function Test_of_isLast()
 476     {
 477         $TodoItems =& new TodoItem(33);
 478         $this->assertTrue($TodoItems->list->isLast());
 479
 480         $TodoItems =& new TodoItem(1);
 481         $this->assertFalse($TodoItems->list->isLast());
 482
 483         $TodoItems =& new TodoItem();
 484         $this->assertFalse($TodoItems->list->isLast());
 485     }
 486
 487
 488     function Test_of_incrementPositionsOnLowerItems()
 489     {
 490         $TodoItems =& new TodoItem();
 491         $TodoItems->transactionStart();
 492
 493         $todo_list = $this->_getTodoList();
 494         $this->assertEqual($todo_list[10] , 'Task number 10');
 495         $TodoItems =& new TodoItem(10);
 496         $this->assertTrue($TodoItems->list->incrementPositionsOnLowerItems(10));
 497         $todo_list = $this->_getTodoList();
 498         $this->assertEqual($todo_list[9] , 'Task number 9');
 499         $this->assertEqual($todo_list[11] , 'Task number 10');
 500         $this->assertEqual($todo_list[34] , 'Task number 33');
 501         $TodoItems->transactionFail();
 502         $TodoItems->transactionComplete();
 503
 504     }
 505     function Test_of_insertAtPosition()
 506     {
 507         $TodoItems =& new TodoItem(10);
 508         $TodoItems->transactionStart();
 509
 510         $TodoItems->list->insertAtPosition(1);
 511         $todo_list = $this->_getTodoList();
 512         $this->assertEqual($todo_list[1] , 'Task number 10');
 513
 514
 515         $TodoItems =& new TodoItem('task->','ship new InmoEasy version');
 516         $TodoItems->list->insertAtPosition(1);
 517         $todo_list = $this->_getTodoList();
 518         $this->assertEqual($todo_list[1] , 'ship new InmoEasy version');
 519
 520         $TodoItems =& new TodoItem(10);
 521         $TodoItems->list->insertAtPosition(10);
 522         $todo_list = $this->_getTodoList();
 523         $this->assertEqual($todo_list[10] , 'Task number 10');
 524
 525         $TodoItems =& new TodoItem(33);
 526         $TodoItems->list->insertAtPosition(40);
 527         $todo_list = $this->_getTodoList();
 528         $this->assertEqual($todo_list[40] , 'Task number 33');
 529
 530         $TodoItems->transactionFail();
 531         $TodoItems->transactionComplete();
 532     }
 533     function Test_of_insertAt(){} //Alias for insertAtPosition but with default value to 1
 534
 535
 536     function Test_of_incrementPositionsOnAllItems()
 537     {
 538         $TodoItems =& new TodoItem();
 539         $TodoItems->transactionStart();
 540
 541         $this->assertTrue($TodoItems->list->incrementPositionsOnAllItems());
 542
 543         $todo_list = $this->_getTodoList();
 544         $this->assertEqual($todo_list[2] , 'Email Hilario with new product specs');
 545         $this->assertEqual($todo_list[34] , 'Task number 33');
 546
 547         $TodoItems->transactionFail();
 548         $TodoItems->transactionComplete();
 549     }
 550
 551     function Test_of_addToListTop(){} // same as incrementPositionsOnAllItems()
 552
 553     function Test_of_decrementPositionsOnHigherItems()
 554     {
 555         $TodoItems =& new TodoItem();
 556         $TodoItems->transactionStart();
 557
 558         $this->assertTrue($TodoItems->list->decrementPositionsOnHigherItems(10));
 559
 560         $todo_list = $this->_getTodoList();
 561
 562         $this->assertEqual($todo_list[0] , 'Email Hilario with new product specs');
 563         $this->assertEqual($todo_list[9] , 'Task number 10');
 564
 565         $TodoItems->transactionFail();
 566         $TodoItems->transactionComplete();
 567     }
 568
 569     function _getTodoList($use_id_as_index = false)
 570     {
 571         $TodoItems = new TodoItem();
 572         $TodoItems = $TodoItems->find('all',array('order'=>'id ASC'));
 573         $list = array();
 574         foreach ($TodoItems as $TodoItem){
 575             if($use_id_as_index){
 576                 $list[$TodoItem->id] = $TodoItem->position.') '.$TodoItem->task;
 577             }else{
 578                 $list[$TodoItem->position] = $TodoItem->task;
 579             }
 580         }
 581         return $list;
 582     }
 583
 584     function test_should_move_up_the_item_with_the_same_position_as_the_inserted()
 585     {
 586         $this->installAndIncludeModels(array('TodoList', 'TodoTask'));
 587
 588         $ListA =& new TodoList(array('name' => 'A'));
 589         $this->assertTrue($ListA->save());
 590
 591         $ListA->task->create(array('details' => 1));
 592
 593         $ListB =& new TodoList(array('name' => 'B'));
 594         $this->assertTrue($ListB->save());
 595         $ListB->task->create(array('details' => 2));
 596         $TodoTask =& $ListB->task->create(array('details' => 3));
 597
 598         $Task1 =& $TodoTask->find('first',array('details'=>1));
 599
 600         $Task1->list->removeFromList();
 601         $this->assertTrue($Task1->save());
 602         $Task1->todo_list->assign($ListB);
 603         $this->assertTrue($Task1->save());
 604         $Task1->list->insertAt(2);
 605
 606         $ListB =& $ListB->find('first',array('name'=>'B'), array('include'=>'tasks'));
 607
 608         foreach (array_keys($ListB->tasks) as $k){
 609             $this->assertEqual($ListB->tasks[$k]->get('position'), $k+1);
 610         }
 611     }
 612     /**//**//**/
 613
 614 }
 615
 616 ak_test('AkActiveRecord_actsAsListTestCase',true);
 617
 618 ?>