test/unit/lib/AkInstaller.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 require_once(AK_LIB_DIR.DS.'AkInstaller.php');
   7
   8 class Test_of_AkInstaller extends  AkUnitTest
   9 {
  10     /**/
  11
  12     function setup()
  13     {
  14         $this->Installer = new AkInstaller();
  15     }
  16
  17     function __tearDown()
  18     {
  19         global $ADODB_FETCH_MODE;
  20         $ADODB_FETCH_MODE = $this->_original_ADODB_FETCH_MODE;
  21     }
  22
  23     function Test_setup_expected_returns()
  24     {
  25         $db_type = $this->Installer->db->type();
  26
  27         switch ($db_type) {
  28             case 'postgre':
  29                 $this->expected_for_creating_table = array(
  30                 'ID' => array('type'=>'int4','not_null'=>1,'default_value'=>"nextval('test_pages_id_seq'::regclass)",'primary_key' => 1),
  31                 'TITLE' => array('max_length'=>255,'has_default'=>null,'type'=>'varchar'),
  32                 'BODY' => array('max_length'=>-1,'has_default'=>null,'type'=>'text'),
  33                 'PARENT_ID' => array('max_length'=>4,'has_default'=>1,'default_value'=>0,'not_null'=>1,'type'=>'int4'),
  34                 'CREATED_AT' => array('type'=>'timestamp', 'max_length'=> 8,'has_default'=>null),
  35                 'UPDATED_AT' => array('type'=>'timestamp', 'max_length'=> 8,'has_default'=>null),
  36                 );
  37
  38                 $this->expected_for_default_types = array(
  39                 'ID' => array('type'=>'int4','not_null'=>1, 'default_value' => "nextval('test_defaults_id_seq'::regclass)",'primary_key'=>1),
  40                 'NAME' => array('type'=>'varchar', 'max_length'=>255, 'has_default'=>null),
  41                 'SCREEN_NAME' => array('type'=>'varchar', 'max_length'=>255, 'has_default'=>null),
  42                 'DESCRIPTION' => array('max_length'=>-1,'has_default'=>null),
  43                 'EN_URL' => array('max_length'=>255,'has_default'=>null),
  44                 'ES_URL' => array('max_length'=>255,'has_default'=>null),
  45                 'OWNER_ID' => array('type'=>'int4', 'max_length'=>4),
  46                 'MODIFIED_AT' => array('type'=>'timestamp'),
  47                 'CREATED_ON' => array('type'=>'date'),
  48                 'IS_FEATURED' => array('max_length'=>1,'type'=>'bool'),
  49                 'POSITION' => array('max_length'=>4),
  50                 'LOCK_VERSION' => array('type'=>'int4', 'max_length'=>4,'default_value' => 1),
  51                 'EDIT_COUNT' => array('type'=>'int4', 'max_length'=>4,'default_value' => 0),
  52                 );
  53
  54
  55                 break;
  56
  57             case 'sqlite':
  58                 $this->expected_for_creating_table = array(
  59                 'ID' => array('type'=>'INTEGER', 'max_length'=>-1,'not_null'=>1,'auto_increment'=>1),
  60                 'TITLE' => array('max_length'=>255,'not_null'=>null),
  61                 'BODY' => array('max_length'=>-1,'not_null'=>null,'type'=>'TEXT'),
  62                 'PARENT_ID' => array('has_default'=>1,'default_value'=>0,'not_null'=>1),
  63                 'CREATED_AT' => array('type'=>'DATE'),
  64                 );
  65                 $this->expected_for_default_types = array(
  66                 'ID' => array('type'=>'INTEGER', 'max_length'=>-1,'not_null'=>1,'auto_increment'=>1,'primary_key'=>1),
  67                 'NAME' => array('max_length'=>255,'not_null'=>null),
  68                 'SCREEN_NAME' => array('max_length'=>255,'not_null'=>null),
  69                 'DESCRIPTION' => array('max_length'=>-1,'not_null'=>null),
  70                 'EN_URL' => array('max_length'=>255,'not_null'=>null),
  71                 'ES_URL' => array('max_length'=>255,'not_null'=>null),
  72                 'OWNER_ID' => array('type'=>'INTEGER', 'max_length'=>-1),
  73                 'MODIFIED_AT' => array('type'=>'DATE'),
  74                 'CREATED_ON' => array('type'=>'DATE'),
  75                 'IS_FEATURED' => array('max_length'=>-1,'type'=>'BOOLEAN'),
  76                 'POSITION' => array('max_length'=>-1),
  77                 'LOCK_VERSION' => array('type'=>'INTEGER', 'max_length'=>-1, 'default_value' => 1),
  78                 'EDIT_COUNT' => array('type'=>'INTEGER', 'max_length'=>-1,'default_value' => 0),
  79                 );
  80
  81                 break;
  82
  83             default:
  84                 $this->expected_for_creating_table = array(
  85                 'ID' => array('type'=>'int', 'max_length'=>11,'not_null'=>1,'auto_increment'=>1),
  86                 'TITLE' => array('max_length'=>255,'not_null'=>null),
  87                 'BODY' => array('max_length'=>-1,'not_null'=>null),
  88                 'PARENT_ID' => array('has_default'=>1,'default_value'=>0,'not_null'=>1),
  89                 'CREATED_AT' => array('type'=>'datetime'),
  90                 );
  91                 $this->expected_for_default_types = array(
  92                 'ID' => array('type'=>'int', 'max_length'=>11,'not_null'=>1,'auto_increment'=>1,'primary_key'=>1),
  93                 'NAME' => array('max_length'=>255,'not_null'=>null),
  94                 'SCREEN_NAME' => array('max_length'=>255,'not_null'=>null),
  95                 'DESCRIPTION' => array('max_length'=>-1,'not_null'=>null),
  96                 'EN_URL' => array('max_length'=>255,'not_null'=>null),
  97                 'ES_URL' => array('max_length'=>255,'not_null'=>null),
  98                 'OWNER_ID' => array('type'=>'int', 'max_length'=>11),
  99                 'MODIFIED_AT' => array('type'=>'datetime'),
 100                 'CREATED_ON' => array('type'=>'date'),
 101                 'IS_FEATURED' => array('max_length'=>1),
 102                 'POSITION' => array('max_length'=>11),
 103                 'LOCK_VERSION' => array('type'=>'int', 'max_length'=>11,'default_value' => 1),
 104                 'EDIT_COUNT' => array('type'=>'int', 'max_length'=>11,'default_value' => 0),
 105                 );
 106                 break;
 107         }
 108     }
 109
 110
 111     function Test_for_creating_table()
 112     {
 113         $this->Installer->createTable('test_pages', "
 114             id integer not null auto_increment primary_key,
 115             title string(255),
 116             body text,
 117             parent_id integer not null default '0',
 118             created_at datetime,
 119             updated_at datetime
 120         ");
 121
 122         $from_datadict = $this->Installer->db->getColumnDetails('test_pages');
 123
 124         foreach ($this->expected_for_creating_table as $column=>$details){
 125             foreach ($details as $index=>$value) {
 126                 $this->assertEqual($this->expected_for_creating_table[$column][$index], $from_datadict[$column]->$index);
 127             }
 128         }
 129
 130         $this->Installer->createTable('test_categories', "
 131             id integer not null auto_increment primary_key,
 132             name string(255),
 133             description text,
 134             parent_id integer not null default '0'
 135         ", array('timestamp'=>false));
 136
 137
 138         $this->Installer->createTable('test_categories_pages', "
 139             category_id integer not null,
 140             page_id integer not null
 141         ", array('timestamp'=>false));
 142
 143         $this->Installer->createTable('test_nice_urls', "
 144             id integer not null auto_increment primary_key,
 145             url string(255),
 146             context_id integer not null,
 147             context string(255) not null default 'page'
 148         ", array('timestamp'=>false));
 149
 150
 151         $this->Installer->dropTables('test_pages','test_categories');
 152         $this->Installer->dropTables('test_categories_pages,test_nice_urls');
 153     }
 154
 155
 156     function Test_of_createTable()
 157     {
 158         $this->Installer = new AkInstaller();
 159
 160         $this->assertFalse($this->Installer->tableExists('test_1'));
 161
 162         $this->Installer->createTable('test_1','id int auto key,body string(32) index,author string(32)');
 163         $this->assertTrue($this->Installer->tableExists('test_1'));
 164
 165         $avail_indices = $this->Installer->db->getIndexes('test_1');
 166         $this->assertTrue(isset($avail_indices['idx_test_1_body']));
 167         $this->assertFalse($avail_indices['idx_test_1_body']['unique']);
 168         $this->assertTrue($avail_indices['idx_test_1_body']['columns'][0]=='body');
 169
 170         $this->Installer->dropTable('test_1');
 171
 172         $this->Installer->createTable('test_1','id int auto key,body string(32) index');
 173         $this->assertTrue($this->Installer->tableExists('test_1'));
 174
 175         $avail_indices = $this->Installer->db->getIndexes('test_1');
 176         $this->assertTrue(isset($avail_indices['idx_test_1_body']));
 177         $this->assertFalse($avail_indices['idx_test_1_body']['unique']);
 178         $this->assertTrue($avail_indices['idx_test_1_body']['columns'][0]=='body');
 179
 180         $this->Installer->dropTable('test_1');
 181         $this->assertFalse($this->Installer->tableExists('test_1'));
 182
 183         $this->Installer->createTable('test_1','id int auto key,body string(32) unique');
 184         $this->assertTrue($this->Installer->tableExists('test_1'));
 185
 186         $avail_indices = $this->Installer->db->getIndexes('test_1');
 187         $this->assertTrue(isset($avail_indices['idx_test_1_body UNIQUE']));
 188         $this->assertTrue($avail_indices['idx_test_1_body UNIQUE']['unique']);
 189         $this->assertTrue($avail_indices['idx_test_1_body UNIQUE']['columns'][0]=='body');
 190
 191         $this->Installer->dropTable('test_1');
 192         $this->assertFalse($this->Installer->tableExists('test_1'));
 193
 194         $this->Installer->createTable('test_1','id int auto key,body string(32) full_text',array('mysql'=>'Type=MyISAM'));
 195         $this->assertTrue($this->Installer->tableExists('test_1'));
 196         $this->Installer->dropTable('test_1');
 197
 198     }
 199
 200     function Test_of_add_and_remove_Indices()
 201     {
 202         $this->Installer = new AkInstaller();
 203
 204         $this->Installer->createTable('test_1','id int auto key,free string(32),beer string(23)');
 205
 206         $avail_indices = $this->Installer->db->getIndexes('test_1');
 207
 208         $this->assertFalse($this->_hasIndexes($avail_indices));
 209
 210         $this->Installer->addIndex('test_1','beer, free UNIQUE');
 211         $avail_indices = $this->Installer->db->getIndexes('test_1');
 212         $this->assertTrue($this->_hasIndexes($avail_indices));
 213         $this->assertTrue($this->_hasIndexes($avail_indices, 'idx_test_1_beer, free UNIQUE'));
 214         $this->assertTrue($avail_indices['idx_test_1_beer, free UNIQUE']['unique']);
 215
 216         $this->Installer->removeIndex('test_1','beer, free UNIQUE');
 217         $avail_indices = $this->Installer->db->getIndexes('test_1');
 218         $this->assertFalse(isset($avail_indices['idx_test_1_beer, free UNIQUE']));
 219
 220         $this->Installer->addIndex('test_1','beer, free UNIQUE','freebeer');
 221         $avail_indices = $this->Installer->db->getIndexes('test_1');
 222         $this->assertTrue(isset($avail_indices['freebeer']));
 223         $this->assertTrue($avail_indices['freebeer']['unique']);
 224         $this->assertTrue($avail_indices['freebeer']['columns'][0]=='beer');
 225         $this->assertTrue($avail_indices['freebeer']['columns'][1]=='free');
 226
 227         $this->Installer->dropIndex('test_1','freebeer');
 228         $avail_indices = $this->Installer->db->getIndexes('test_1');
 229         $this->assertFalse($this->_hasIndexes($avail_indices));
 230
 231         $this->Installer->dropTable('test_1');
 232
 233     }
 234
 235     function Test_of_default_types()
 236     {
 237         $this->Installer = new AkInstaller();
 238         $this->Installer->createTable('test_defaults','id,name,screen_name string,description,*url,owner_id,modified_at,created_on,is_featured,position,lock_version,edit_count');
 239         $from_datadict = $this->Installer->db->getColumnDetails('test_defaults');
 240
 241         foreach ($this->expected_for_default_types as $column=>$details){
 242             foreach ($details as $index=>$value) {
 243                 $this->assertEqual($this->expected_for_default_types[$column][$index], $from_datadict[$column]->$index, "Column '$column', attribute $index = '{$from_datadict[$column]->$index}' instead of expected '{$this->expected_for_default_types[$column][$index]}'");
 244             }
 245         }
 246     }
 247
 248
 249     function _hasIndexes($meta_details, $search = false)
 250     {
 251         $result = false;
 252         if(!empty($meta_details) && is_array($meta_details)){
 253             foreach ($meta_details as $k=>$meta_detail){
 254                 if(empty($search) && strstr($k,'idx')){
 255                     $result = true;
 256                 }elseif (strstr($k,$search)){
 257                     $result = true;
 258                 }
 259             }
 260         }
 261         return $result;
 262     }
 263
 264
 265     function test_should_create_default_values_correctly()
 266     {
 267         $this->installAndIncludeModels(array('Thumbnail'));
 268         $Thumbnail =& new Thumbnail();
 269         $this->assertEqual($Thumbnail->get('owner'), 'Picture');
 270     }
 271
 272     // see AkDbAdapter_schema for the tests; this is only a wrapper
 273     function test_should_rename_columns()
 274     {
 275         $this->Installer->renameColumn('test_defaults','screen_name','real_name');
 276         if ($this->Installer->db->type()=='sqlite') {
 277             $this->assertError();
 278         }
 279         $this->Installer->dropTable('test_defaults');
 280     }
 281
 282 }
 283
 284 ak_test('Test_of_AkInstaller', true);
 285
 286 ?>