diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2014-02-10 14:23:09 +0100 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2014-02-10 14:23:09 +0100 |
| commit | b088bf864bf5827c1801c53c0af1b5a2f89f5b16 (patch) | |
| tree | 5ab11074bae8b5958c6b9195ed570f9d8448d295 /tests | |
| parent | 840ab75520726e4db689ab1a92de6c17d86b107b (diff) | |
| parent | 9b1b6bd47747bf077f6bd5dce69f366391f380c6 (diff) | |
| download | forums-b088bf864bf5827c1801c53c0af1b5a2f89f5b16.tar forums-b088bf864bf5827c1801c53c0af1b5a2f89f5b16.tar.gz forums-b088bf864bf5827c1801c53c0af1b5a2f89f5b16.tar.bz2 forums-b088bf864bf5827c1801c53c0af1b5a2f89f5b16.tar.xz forums-b088bf864bf5827c1801c53c0af1b5a2f89f5b16.zip | |
Merge remote-tracking branch 'Marc/ticket/12170' into develop
* Marc/ticket/12170:
[ticket/12170] Test for 12170
[ticket/12170] Assign schema keys in migration helper with data_depth 1
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/dbal/migration/schema.php | 11 | ||||
| -rw-r--r-- | tests/dbal/migrator_test.php | 2 | ||||
| -rw-r--r-- | tests/migrator/get_schema_steps_test.php | 38 |
3 files changed, 47 insertions, 4 deletions
diff --git a/tests/dbal/migration/schema.php b/tests/dbal/migration/schema.php index 46cf66eaec..98407eb1bd 100644 --- a/tests/dbal/migration/schema.php +++ b/tests/dbal/migration/schema.php @@ -17,6 +17,14 @@ class phpbb_dbal_migration_schema extends \phpbb\db\migration\migration 'test_column1' => array('BOOL', 1), ), ), + 'add_tables' => array( + $this->table_prefix . 'foobar' => array( + 'COLUMNS' => array( + 'module_id' => array('UINT:3', NULL, 'auto_increment'), + ), + 'PRIMARY_KEY' => 'module_id', + ), + ), ); } @@ -28,6 +36,9 @@ class phpbb_dbal_migration_schema extends \phpbb\db\migration\migration 'test_column1', ), ), + 'drop_tables' => array( + $this->table_prefix . 'foobar', + ), ); } } diff --git a/tests/dbal/migrator_test.php b/tests/dbal/migrator_test.php index c075f19825..f22f5f5b30 100644 --- a/tests/dbal/migrator_test.php +++ b/tests/dbal/migrator_test.php @@ -280,6 +280,7 @@ class phpbb_dbal_migrator_test extends phpbb_database_test_case } $this->assertTrue($this->db_tools->sql_column_exists('phpbb_config', 'test_column1')); + $this->assertTrue($this->db_tools->sql_table_exists('phpbb_foobar')); while ($this->migrator->migration_state('phpbb_dbal_migration_schema')) { @@ -287,5 +288,6 @@ class phpbb_dbal_migrator_test extends phpbb_database_test_case } $this->assertFalse($this->db_tools->sql_column_exists('phpbb_config', 'test_column1')); + $this->assertFalse($this->db_tools->sql_table_exists('phpbb_foobar')); } } diff --git a/tests/migrator/get_schema_steps_test.php b/tests/migrator/get_schema_steps_test.php index f354d3617f..226535754e 100644 --- a/tests/migrator/get_schema_steps_test.php +++ b/tests/migrator/get_schema_steps_test.php @@ -21,7 +21,22 @@ class get_schema_steps_test extends phpbb_test_case return array( array( array( - 'add_tables' => array('table1', 'table2', 'table3'), + 'add_tables' => array( + 'foo' => array( + 'COLUMNS' => array( + 'foobar' => array('BOOL', 0), + 'foobar2' => array('BOOL', 0), + ), + 'PRIMARY_KEY' => array('foobar'), + ), + 'bar' => array( + 'COLUMNS' => array( + 'barfoo' => array('BOOL', 0), + 'barfoor2' => array('BOOL', 0), + ), + 'PRIMARY_KEY' => array('barfoo'), + ), + ), 'drop_tables' => array('table1', 'table2', 'table3'), 'add_index' => array( 'table1' => array( @@ -73,9 +88,24 @@ class get_schema_steps_test extends phpbb_test_case array('dbtools.perform_schema_changes', array(array('drop_tables' => array('table1')))), array('dbtools.perform_schema_changes', array(array('drop_tables' => array('table2')))), array('dbtools.perform_schema_changes', array(array('drop_tables' => array('table3')))), - array('dbtools.perform_schema_changes', array(array('add_tables' => array('table1')))), - array('dbtools.perform_schema_changes', array(array('add_tables' => array('table2')))), - array('dbtools.perform_schema_changes', array(array('add_tables' => array('table3')))), + array('dbtools.perform_schema_changes', array(array('add_tables' => array( + 'foo' => array( + 'COLUMNS' => array( + 'foobar' => array('BOOL', 0), + 'foobar2' => array('BOOL', 0), + ), + 'PRIMARY_KEY' => array('foobar'), + ), + )))), + array('dbtools.perform_schema_changes', array(array('add_tables' => array( + 'bar' => array( + 'COLUMNS' => array( + 'barfoo' => array('BOOL', 0), + 'barfoor2' => array('BOOL', 0), + ), + 'PRIMARY_KEY' => array('barfoo'), + ), + )))), array('dbtools.perform_schema_changes', array(array('change_columns' => array( 'table1' => array( 'column1' => array('foo'), |