mirror of
https://github.com/Oreolek/kohana-migrations.git
synced 2024-05-19 09:28:17 +03:00
660 lines
15 KiB
PHP
660 lines
15 KiB
PHP
<?php
|
|
|
|
/**
|
|
* Test for the migration model
|
|
*
|
|
* @group minion
|
|
* @group minion.tasks
|
|
* @group minion.tasks.migrations
|
|
*/
|
|
class Minion_Migration_ModelTest extends Kohana_Unittest_Database_TestCase
|
|
{
|
|
/**
|
|
* Runs before the test class as a whole is ran
|
|
* Creates the test table
|
|
*/
|
|
public static function setUpBeforeClass()
|
|
{
|
|
$sql = file_get_contents(Kohana::find_file('', 'minion_schema', 'sql'));
|
|
|
|
$sql = str_replace('`minion_migrations`', '`test_minion_migrations`', $sql);
|
|
|
|
Database::instance()->query(NULL, 'DROP TABLE IF EXISTS `test_minion_migrations`');
|
|
Database::instance()->query(NULL, $sql);
|
|
}
|
|
|
|
/**
|
|
* Removes the test tables after the tests have finished
|
|
*/
|
|
public static function tearDownAfterClass()
|
|
{
|
|
Database::instance()->query(NULL, 'DROP TABLE `test_minion_migrations`');
|
|
}
|
|
|
|
/**
|
|
* Gets the dataset that should be used to populate db
|
|
*
|
|
* @return PHPUnit_Extensions_Database_DataSet_IDataSet
|
|
*/
|
|
public function getDataSet()
|
|
{
|
|
return $this->createFlatXMLDataSet(
|
|
Kohana::find_file('tests/datasets', 'minion/migration/model', 'xml')
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Get an instance of the migration model, pre-loaded with a connection to
|
|
* the test database
|
|
*
|
|
* @return Model_Minion_Migration
|
|
*/
|
|
public function getModel()
|
|
{
|
|
$model = new Model_Minion_Migration($this->getKohanaConnection());
|
|
|
|
return $model->table('test_minion_migrations');
|
|
}
|
|
|
|
/**
|
|
* Tests that the model can fetch all rows from the database
|
|
*
|
|
* @test
|
|
* @covers Model_Minion_Migration::fetch_all
|
|
*/
|
|
public function test_fetch_all()
|
|
{
|
|
$migrations = $this->getModel()->fetch_all();
|
|
|
|
$this->assertSame(10, count($migrations));
|
|
}
|
|
|
|
/**
|
|
* Test that the model accurately fetches the latest versions from the database
|
|
*
|
|
* @test
|
|
* @covers Model_Minion_Migration::fetch_current_versions
|
|
*/
|
|
public function test_fetch_current_versions()
|
|
{
|
|
$versions = $this->getModel()
|
|
->fetch_current_versions('group', 'timestamp');
|
|
|
|
$this->assertSame(
|
|
array (
|
|
'app' => '20101216080000',
|
|
'dblogger' => '20101225000000',
|
|
'done' => '20101546112100',
|
|
),
|
|
$versions
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Provides test data for test_fetch_required_migrations
|
|
*
|
|
* @return array
|
|
*/
|
|
public function provider_fetch_required_migrations()
|
|
{
|
|
return array(
|
|
// Test going up in a specific group
|
|
array(
|
|
array(
|
|
array(
|
|
array(
|
|
'timestamp' => '20101215165000',
|
|
'description' => 'add-name-column-to-members',
|
|
'group' => 'app',
|
|
'applied' => '0',
|
|
'id' => 'app:20101215165000',
|
|
),
|
|
array(
|
|
'timestamp' => '20101216000000',
|
|
'description' => 'add-index-on-name',
|
|
'group' => 'app',
|
|
'applied' => '0',
|
|
'id' => 'app:20101216000000',
|
|
),
|
|
),
|
|
TRUE
|
|
),
|
|
'app',
|
|
TRUE,
|
|
),
|
|
// Testing going down with a specific group
|
|
array(
|
|
array(
|
|
array(
|
|
array(
|
|
'timestamp' => '20101216080000',
|
|
'description' => 'remove-password-salt-column',
|
|
'group' => 'app',
|
|
'applied' => '1',
|
|
'id' => 'app:20101216080000',
|
|
),
|
|
array(
|
|
'timestamp' => '20101215164400',
|
|
'description' => 'create-tables',
|
|
'group' => 'app',
|
|
'applied' => '1',
|
|
'id' => 'app:20101215164400',
|
|
),
|
|
),
|
|
FALSE
|
|
),
|
|
'app',
|
|
FALSE
|
|
),
|
|
// Testing going up across all groups
|
|
array(
|
|
array(
|
|
array(
|
|
array(
|
|
'timestamp' => '20101215165000',
|
|
'description' => 'add-name-column-to-members',
|
|
'group' => 'app',
|
|
'applied' => '0',
|
|
'id' => 'app:20101215165000',
|
|
),
|
|
array(
|
|
'timestamp' => '20101216000000',
|
|
'description' => 'add-index-on-name',
|
|
'group' => 'app',
|
|
'applied' => '0',
|
|
'id' => 'app:20101216000000',
|
|
),
|
|
array(
|
|
'timestamp' => '20101226112100',
|
|
'description' => 'add-pk',
|
|
'group' => 'dblogger',
|
|
'applied' => '0',
|
|
'id' => 'dblogger:20101226112100',
|
|
),
|
|
array(
|
|
'timestamp' => '20101526112100',
|
|
'description' => 'add-col',
|
|
'group' => 'minion',
|
|
'applied' => '0',
|
|
'id' => 'minion:20101526112100',
|
|
),
|
|
),
|
|
TRUE
|
|
),
|
|
NULL,
|
|
TRUE
|
|
),
|
|
// Testing going down across all groups
|
|
array(
|
|
array(
|
|
array(
|
|
array(
|
|
'timestamp' => '20101546112100',
|
|
'description' => 'add-bbb',
|
|
'group' => 'done',
|
|
'applied' => '1',
|
|
'id' => 'done:20101546112100'
|
|
),
|
|
array(
|
|
'timestamp' => '20101536112100',
|
|
'description' => 'add-aaa',
|
|
'group' => 'done',
|
|
'applied' => '1',
|
|
'id'=> 'done:20101536112100'
|
|
),
|
|
array(
|
|
'timestamp' => '20101225000000',
|
|
'description' => 'remove-unique-index',
|
|
'group' => 'dblogger',
|
|
'applied' => '1',
|
|
'id' => 'dblogger:20101225000000',
|
|
),
|
|
array(
|
|
'timestamp' => '20101216080000',
|
|
'description' => 'remove-password-salt-column',
|
|
'group' => 'app',
|
|
'applied' => '1',
|
|
'id' => 'app:20101216080000',
|
|
),
|
|
array(
|
|
'timestamp' => '20101215164500',
|
|
'description' => 'create-table',
|
|
'group' => 'dblogger',
|
|
'applied' => '1',
|
|
'id' => 'dblogger:20101215164500',
|
|
),
|
|
array(
|
|
'timestamp' => '20101215164400',
|
|
'description' => 'create-tables',
|
|
'group' => 'app',
|
|
'applied' => '1',
|
|
'id' => 'app:20101215164400',
|
|
),
|
|
),
|
|
FALSE,
|
|
),
|
|
NULL,
|
|
FALSE
|
|
),
|
|
// Test migrating down to a specific version
|
|
array(
|
|
array(
|
|
array(
|
|
array(
|
|
'timestamp' => '20101216080000',
|
|
'description' => 'remove-password-salt-column',
|
|
'group' => 'app',
|
|
'applied' => '1',
|
|
'id' => 'app:20101216080000',
|
|
),
|
|
),
|
|
FALSE
|
|
),
|
|
'app',
|
|
20101215164400
|
|
),
|
|
// Test migrating up from nothing to everything
|
|
array(
|
|
array(
|
|
array(
|
|
array(
|
|
'timestamp' => '20101526112100',
|
|
'description' => 'add-col',
|
|
'group' => 'minion',
|
|
'applied' => '0',
|
|
'id' => 'minion:20101526112100',
|
|
),
|
|
),
|
|
TRUE
|
|
),
|
|
'minion',
|
|
'+100'
|
|
),
|
|
array(
|
|
array(
|
|
array(
|
|
array(
|
|
'timestamp' => '20101546112100',
|
|
'description' => 'add-bbb',
|
|
'group' => 'done',
|
|
'applied' => '1',
|
|
'id' => 'done:20101546112100'
|
|
),
|
|
),
|
|
FALSE
|
|
),
|
|
'done',
|
|
'-1'
|
|
)
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Test that migrations are fetched in the right order depending on what the target is
|
|
*
|
|
* @test
|
|
* @dataProvider provider_fetch_required_migrations
|
|
* @covers Model_Minion_Migration::fetch_required_migrations
|
|
* @param array An expected resultset
|
|
* @param string|array A group, or groups to get migrations for
|
|
* @param bool|string Target to migrate to
|
|
*/
|
|
public function test_fetch_required_migrations($expected, $group, $target)
|
|
{
|
|
$this->assertSame(
|
|
$expected,
|
|
$this->getModel()->fetch_required_migrations( (array) $group, $target)
|
|
);
|
|
}
|
|
|
|
|
|
/**
|
|
* Provides test data for test_get_migration
|
|
*
|
|
* @return array
|
|
*/
|
|
public function provider_get_migration()
|
|
{
|
|
return array(
|
|
array(
|
|
array(
|
|
'timestamp' => '20101215164400',
|
|
'description' => 'create-tables',
|
|
'group' => 'app',
|
|
'applied' => '1',
|
|
'id' => 'app:20101215164400'
|
|
),
|
|
'app',
|
|
'20101215164400',
|
|
)
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Tests that Model_Minion_Migration::get_migration can get a migration from
|
|
* the database
|
|
*
|
|
* @test
|
|
* @covers Model_Minion_Migration::get_migration
|
|
* @dataProvider provider_get_migration
|
|
* @param array Expected migration
|
|
* @param string The migration's group
|
|
* @param string The migration's timestamp
|
|
*/
|
|
public function test_get_migration($expected, $group, $timestamp)
|
|
{
|
|
$this->assertSame(
|
|
$expected,
|
|
$this->getModel()->get_migration($group, $timestamp)
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Provides test data for test_get_migration_throws_exception_on_invalid_input
|
|
*
|
|
* @return array
|
|
*/
|
|
public function provider_get_migration_throws_exception_on_invalid_input()
|
|
{
|
|
return array(
|
|
array(NULL, NULL),
|
|
array('app', NULL),
|
|
);
|
|
}
|
|
|
|
/**
|
|
* If invalid input is passed to get_migration then it should throw an
|
|
* exception
|
|
*
|
|
* @test
|
|
* @covers Model_Minion_Migration::get_migration
|
|
* @dataProvider provider_get_migration_throws_exception_on_invalid_input
|
|
* @expectedException Kohana_Exception
|
|
*/
|
|
public function test_get_migration_throws_exception_on_invalid_input($group, $timestamp)
|
|
{
|
|
$this->getModel()->get_migration($group, $timestamp);
|
|
}
|
|
|
|
/**
|
|
* Provides test data for test_mark_migration
|
|
*
|
|
* @return array
|
|
*/
|
|
public function provider_mark_migration()
|
|
{
|
|
return array(
|
|
array(
|
|
array(
|
|
'timestamp' => '20101215165000',
|
|
'description' => 'add-name-column-to-members',
|
|
'group' => 'app',
|
|
'applied' => '1',
|
|
'id' => 'app:20101215165000',
|
|
),
|
|
array(
|
|
'timestamp' => '20101215165000',
|
|
'group' => 'app',
|
|
'description' => 'add-name-column-to-members',
|
|
),
|
|
TRUE
|
|
),
|
|
array(
|
|
array(
|
|
'timestamp' => '20101215165000',
|
|
'description' => 'add-name-column-to-members',
|
|
'group' => 'app',
|
|
'applied' => '0',
|
|
'id' => 'app:20101215165000',
|
|
),
|
|
array(
|
|
'timestamp' => '20101215165000',
|
|
'group' => 'app',
|
|
'description' => 'add-name-column-to-members',
|
|
),
|
|
FALSE
|
|
),
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Tests that Model_Minion_Migration::mark_migration() changes the applied
|
|
* status of a migration
|
|
*
|
|
* @test
|
|
* @covers Model_Minion_Migration::mark_migration
|
|
* @dataProvider provider_mark_migration
|
|
* @param array What the DB record should look like after migration is marked
|
|
* @param array The migration to update
|
|
* @param bool Whether the migration should be applied
|
|
*/
|
|
public function test_mark_migration($expected, $migration, $applied)
|
|
{
|
|
$model = $this->getModel();
|
|
|
|
$model->mark_migration($migration, $applied);
|
|
|
|
$this->assertSame(
|
|
$expected,
|
|
$model->get_migration($migration['group'], $migration['timestamp'])
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Provides test data for test_resolve_target()
|
|
*
|
|
* @return array
|
|
*/
|
|
public function provider_resolve_target()
|
|
{
|
|
return array(
|
|
array(
|
|
array('20101216080000', FALSE),
|
|
'app',
|
|
'-1'
|
|
),
|
|
array(
|
|
array(NULL, FALSE),
|
|
'dblogger',
|
|
'-10'
|
|
),
|
|
array(
|
|
array('20101226112100', TRUE),
|
|
'dblogger',
|
|
'+1',
|
|
),
|
|
array(
|
|
array(NULL, TRUE),
|
|
'app',
|
|
'+10'
|
|
),
|
|
array(
|
|
array(NULL, TRUE),
|
|
'dblogger',
|
|
'+100'
|
|
),
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Test that we can resolve a target version for a group.
|
|
*
|
|
* Target version can be relative (+migrations_up / -migrations_down) or absolute (i.e. timestamp)
|
|
*
|
|
* @test
|
|
* @dataProvider provider_resolve_target
|
|
* @covers Model_Minion_Migration::resolve_target
|
|
* @param array Expected output
|
|
* @param string Group name
|
|
* @param string Target version
|
|
*/
|
|
public function test_resolve_target($expected, $group, $target)
|
|
{
|
|
$this->assertSame(
|
|
$expected,
|
|
$this->getModel()->resolve_target( (array) $group, $target)
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Provides test data for test_compile_migrations_from_files()
|
|
*
|
|
* @return array
|
|
*/
|
|
public function provider_compile_migrations_from_files()
|
|
{
|
|
return array(
|
|
array(
|
|
array(
|
|
'myapp:015151051' => array('group' => 'myapp', 'description' => 'setup', 'timestamp' => '015151051', 'id' => 'myapp:015151051'),
|
|
'myapp:015161051' => array('group' => 'myapp', 'description' => 'add-comments', 'timestamp' => '015161051', 'id' => 'myapp:015161051'),
|
|
),
|
|
array(
|
|
'migrations/myapp' => array(
|
|
// This file should be ignored
|
|
'migrations/myapp/015151051_setup.sql'
|
|
=> '/var/www/app/groups/myapp/migrations/myapp/015151051_setup.sql',
|
|
'migrations/myapp/015151051_setup.php'
|
|
=> '/var/www/app/groups/myapp/migrations/myapp/015151051_setup.php',
|
|
'migrations/myapp/015161051_add-comments.php'
|
|
=> '/var/www/app/groups/myapp/migrations/myapp/015161051_add-comments.php',
|
|
),
|
|
)
|
|
),
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Test that Model_Minion_Migration::compile_migrations_from_files accurately
|
|
* compiles a set of files down into a set of migration files
|
|
*
|
|
* @test
|
|
* @covers Model_Minion_Migration::compile_migrations_from_files
|
|
* @dataProvider provider_compile_migrations_from_files
|
|
* @param array Expected output
|
|
* @param array Input Files
|
|
*/
|
|
public function test_compile_migrations_from_files($expected, array $files)
|
|
{
|
|
$this->assertSame(
|
|
$expected,
|
|
$this->getModel()->compile_migrations_from_files($files)
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Provides test data for test_extract_migration_info_from_filename
|
|
*
|
|
* @return array Test Data
|
|
*/
|
|
public function provider_get_migration_from_filename()
|
|
{
|
|
return array(
|
|
array(
|
|
array(
|
|
'group' => 'myapp',
|
|
'description' => 'initial-setup',
|
|
'timestamp' => '1293214439',
|
|
'id' => 'myapp:1293214439',
|
|
),
|
|
'migrations/myapp/1293214439_initial-setup.php',
|
|
),
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Tests that Model_Minion_Migration::get_migration_info_from_filename()
|
|
* correctly extracts information about the migration from its filename
|
|
*
|
|
* @test
|
|
* @covers Model_Minion_Migration::get_migration_from_filename
|
|
* @dataProvider provider_get_migration_from_filename
|
|
* @param array Expected output
|
|
* @param string Input filename
|
|
*/
|
|
public function test_get_migration_from_filename($expected, $file)
|
|
{
|
|
$this->assertSame(
|
|
$expected,
|
|
$this->getModel()->get_migration_from_filename($file)
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Provides test data for test_convert_migration_to_filename
|
|
*
|
|
* @return array Test Data
|
|
*/
|
|
public function provider_get_filename_from_migration()
|
|
{
|
|
return array(
|
|
array(
|
|
'myapp/1293214439_initial-setup.php',
|
|
array(
|
|
'group' => 'myapp',
|
|
'timestamp' => '1293214439',
|
|
'description' => 'initial-setup',
|
|
'id' => 'myapp:1293214439'
|
|
),
|
|
'myapp',
|
|
),
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Tests that Model_Minion_Migration::get_filename_from_migration generates
|
|
* accurate filenames when given a variety of migration information
|
|
*
|
|
* @test
|
|
* @covers Model_Minion_Migration::get_filename_from_migration
|
|
* @dataProvider provider_get_filename_from_migration
|
|
* @param string Expected output
|
|
* @param mixed Migration id
|
|
* @param mixed group
|
|
*/
|
|
public function test_get_filename_from_migration($expected, $migration, $group)
|
|
{
|
|
$this->assertSame(
|
|
$expected,
|
|
$this->getModel()->get_filename_from_migration($migration, $group)
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Provides test data for test_get_class_from_migration
|
|
*
|
|
* @return array Test Data
|
|
*/
|
|
public function provider_get_class_from_migration()
|
|
{
|
|
return array(
|
|
array(
|
|
'Migration_Kohana_201012290258',
|
|
'kohana:201012290258',
|
|
),
|
|
array(
|
|
'Migration_Kohana_201012290258',
|
|
array('group' => 'kohana', 'timestamp' => '201012290258'),
|
|
),
|
|
);
|
|
}
|
|
|
|
/**
|
|
* Tests that Model_Minion_Migration::get_class_from_migration can generate
|
|
* a class name from information about a migration
|
|
*
|
|
* @test
|
|
* @covers Model_Minion_Migration::get_class_from_migration
|
|
* @dataProvider provider_get_class_from_migration
|
|
* @param string Expected output
|
|
* @param string|array Migration info
|
|
*/
|
|
public function test_get_class_from_migration($expected, $migration)
|
|
{
|
|
$this->assertSame(
|
|
$expected,
|
|
$this->getModel()->get_class_from_migration($migration)
|
|
);
|
|
}
|
|
}
|