@@ 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( |