| @@ 244-300 (lines=57) @@ | ||
| 241 | self::assertCount(0, $tableDiff->changedColumns, "Nothing should be changed as all fields old & new have diff names."); |
|
| 242 | } |
|
| 243 | ||
| 244 | public function testCompareRemovedIndex() |
|
| 245 | { |
|
| 246 | $schema1 = new Schema( array( |
|
| 247 | 'bugdb' => new Table('bugdb', |
|
| 248 | array ( |
|
| 249 | 'integerfield1' => new Column('integerfield1', Type::getType('integer')), |
|
| 250 | 'integerfield2' => new Column('integerfield2', Type::getType('integer')), |
|
| 251 | ), |
|
| 252 | array ( |
|
| 253 | 'primary' => new Index('primary', |
|
| 254 | array( |
|
| 255 | 'integerfield1' |
|
| 256 | ), |
|
| 257 | true |
|
| 258 | ) |
|
| 259 | ) |
|
| 260 | ), |
|
| 261 | ) ); |
|
| 262 | $schema2 = new Schema( array( |
|
| 263 | 'bugdb' => new Table('bugdb', |
|
| 264 | array ( |
|
| 265 | 'integerfield1' => new Column('integerfield1', Type::getType('integer')), |
|
| 266 | 'integerfield2' => new Column('integerfield2', Type::getType('integer')), |
|
| 267 | ) |
|
| 268 | ), |
|
| 269 | ) ); |
|
| 270 | ||
| 271 | $expected = new SchemaDiff ( array(), |
|
| 272 | array ( |
|
| 273 | 'bugdb' => new TableDiff( 'bugdb', array(), array(), array(), array(), array(), |
|
| 274 | array ( |
|
| 275 | 'primary' => new Index('primary', |
|
| 276 | array( |
|
| 277 | 'integerfield1' |
|
| 278 | ), |
|
| 279 | true |
|
| 280 | ) |
|
| 281 | ) |
|
| 282 | ), |
|
| 283 | ) |
|
| 284 | ); |
|
| 285 | $expected->fromSchema = $schema1; |
|
| 286 | $expected->changedTables['bugdb']->fromTable = $schema1->getTable('bugdb'); |
|
| 287 | ||
| 288 | self::assertEquals($expected, Comparator::compareSchemas( $schema1, $schema2 ) ); |
|
| 289 | } |
|
| 290 | ||
| 291 | public function testCompareNewIndex() |
|
| 292 | { |
|
| 293 | $schema1 = new Schema( array( |
|
| 294 | 'bugdb' => new Table('bugdb', |
|
| 295 | array ( |
|
| 296 | 'integerfield1' => new Column('integerfield1', Type::getType('integer')), |
|
| 297 | 'integerfield2' => new Column('integerfield2', Type::getType('integer')), |
|
| 298 | ) |
|
| 299 | ), |
|
| 300 | ) ); |
|
| 301 | $schema2 = new Schema( array( |
|
| 302 | 'bugdb' => new Table('bugdb', |
|
| 303 | array ( |
|
| @@ 291-345 (lines=55) @@ | ||
| 288 | self::assertEquals($expected, Comparator::compareSchemas( $schema1, $schema2 ) ); |
|
| 289 | } |
|
| 290 | ||
| 291 | public function testCompareNewIndex() |
|
| 292 | { |
|
| 293 | $schema1 = new Schema( array( |
|
| 294 | 'bugdb' => new Table('bugdb', |
|
| 295 | array ( |
|
| 296 | 'integerfield1' => new Column('integerfield1', Type::getType('integer')), |
|
| 297 | 'integerfield2' => new Column('integerfield2', Type::getType('integer')), |
|
| 298 | ) |
|
| 299 | ), |
|
| 300 | ) ); |
|
| 301 | $schema2 = new Schema( array( |
|
| 302 | 'bugdb' => new Table('bugdb', |
|
| 303 | array ( |
|
| 304 | 'integerfield1' => new Column('integerfield1', Type::getType('integer')), |
|
| 305 | 'integerfield2' => new Column('integerfield2', Type::getType('integer')), |
|
| 306 | ), |
|
| 307 | array ( |
|
| 308 | 'primary' => new Index('primary', |
|
| 309 | array( |
|
| 310 | 'integerfield1' |
|
| 311 | ), |
|
| 312 | true |
|
| 313 | ) |
|
| 314 | ) |
|
| 315 | ), |
|
| 316 | ) ); |
|
| 317 | ||
| 318 | $expected = new SchemaDiff ( array(), |
|
| 319 | array ( |
|
| 320 | 'bugdb' => new TableDiff( 'bugdb', array(), array(), array(), |
|
| 321 | array ( |
|
| 322 | 'primary' => new Index('primary', |
|
| 323 | array( |
|
| 324 | 'integerfield1' |
|
| 325 | ), |
|
| 326 | true |
|
| 327 | ) |
|
| 328 | ) |
|
| 329 | ), |
|
| 330 | ) |
|
| 331 | ); |
|
| 332 | $expected->fromSchema = $schema1; |
|
| 333 | $expected->changedTables['bugdb']->fromTable = $schema1->getTable('bugdb'); |
|
| 334 | ||
| 335 | self::assertEquals($expected, Comparator::compareSchemas( $schema1, $schema2 ) ); |
|
| 336 | } |
|
| 337 | ||
| 338 | public function testCompareChangedIndex() |
|
| 339 | { |
|
| 340 | $schema1 = new Schema( array( |
|
| 341 | 'bugdb' => new Table('bugdb', |
|
| 342 | array ( |
|
| 343 | 'integerfield1' => new Column('integerfield1', Type::getType('integer')), |
|
| 344 | 'integerfield2' => new Column('integerfield2', Type::getType('integer')), |
|
| 345 | ), |
|
| 346 | array ( |
|
| 347 | 'primary' => new Index('primary', |
|
| 348 | array( |
|