<s> """<STR_LIT>""" <EOL> import os <EOL> from oslo_db . sqlalchemy import test_base <EOL> from oslo_db . sqlalchemy import utils as db_utils <EOL> from sahara . tests . unit . db . migration import test_migrations_base as base <EOL> class SaharaMigrationsCheckers ( object ) : <EOL> def assertColumnExists ( self , engine , table , column ) : <EOL> t = db_utils . get_table ( engine , table ) <EOL> self . assertIn ( column , t . c ) <EOL> def assertColumnsExist ( self , engine , table , columns ) : <EOL> for column in columns : <EOL> self . assertColumnExists ( engine , table , column ) <EOL> def assertColumnType ( self , engine , table , column , column_type ) : <EOL> t = db_utils . get_table ( engine , table ) <EOL> column_ref_type = str ( t . c [ column ] . type ) <EOL> self . assertEqual ( column_ref_type , column_type ) <EOL> def assertColumnCount ( self , engine , table , columns ) : <EOL> t = db_utils . get_table ( engine , table ) <EOL> self . assertEqual ( len ( columns ) , len ( t . columns ) ) <EOL> def assertColumnNotExists ( self , engine , table , column ) : <EOL> t = db_utils . get_table ( engine , table ) <EOL> self . assertNotIn ( column , t . c ) <EOL> def assertIndexExists ( self , engine , table , index ) : <EOL> t = db_utils . get_table ( engine , table ) <EOL> index_names = [ idx . name for idx in t . indexes ] <EOL> self . assertIn ( index , index_names ) <EOL> def assertIndexMembers ( self , engine , table , index , members ) : <EOL> self . assertIndexExists ( engine , table , index ) <EOL> t = db_utils . get_table ( engine , table ) <EOL> index_columns = None <EOL> for idx in t . indexes : <EOL> if idx . name == index : <EOL> index_columns = idx . columns . keys ( ) <EOL> break <EOL> self . assertEqual ( sorted ( members ) , sorted ( index_columns ) ) <EOL> def test_walk_versions ( self ) : <EOL> self . walk_versions ( self . engine ) <EOL> def _pre_upgrade_001 ( self , engine ) : <EOL> pass <EOL> def _check_001 ( self , engine , data ) : <EOL> job_binary_internal_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT:data>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( <EOL> engine , '<STR_LIT>' , job_binary_internal_columns ) <EOL> self . assertColumnCount ( <EOL> engine , '<STR_LIT>' , job_binary_internal_columns ) <EOL> node_group_templates_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT:description>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( <EOL> engine , '<STR_LIT>' , node_group_templates_columns ) <EOL> self . assertColumnCount ( <EOL> engine , '<STR_LIT>' , node_group_templates_columns ) <EOL> data_sources_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT:description>' , <EOL> '<STR_LIT:type>' , <EOL> '<STR_LIT:url>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( <EOL> engine , '<STR_LIT>' , data_sources_columns ) <EOL> self . assertColumnCount ( <EOL> engine , '<STR_LIT>' , data_sources_columns ) <EOL> cluster_templates_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT:description>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( <EOL> engine , '<STR_LIT>' , cluster_templates_columns ) <EOL> self . assertColumnCount ( <EOL> engine , '<STR_LIT>' , cluster_templates_columns ) <EOL> job_binaries_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT:description>' , <EOL> '<STR_LIT:url>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( <EOL> engine , '<STR_LIT>' , job_binaries_columns ) <EOL> self . assertColumnCount ( <EOL> engine , '<STR_LIT>' , job_binaries_columns ) <EOL> jobs_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT:description>' , <EOL> '<STR_LIT:type>' <EOL> ] <EOL> self . assertColumnsExist ( engine , '<STR_LIT>' , jobs_columns ) <EOL> self . assertColumnCount ( engine , '<STR_LIT>' , jobs_columns ) <EOL> templates_relations_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:count>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( <EOL> engine , '<STR_LIT>' , templates_relations_columns ) <EOL> self . assertColumnCount ( <EOL> engine , '<STR_LIT>' , templates_relations_columns ) <EOL> mains_association_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( <EOL> engine , '<STR_LIT>' , mains_association_columns ) <EOL> self . assertColumnCount ( <EOL> engine , '<STR_LIT>' , mains_association_columns ) <EOL> libs_association_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( <EOL> engine , '<STR_LIT>' , libs_association_columns ) <EOL> self . assertColumnCount ( <EOL> engine , '<STR_LIT>' , libs_association_columns ) <EOL> clusters_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT:description>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:status>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:info>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( engine , '<STR_LIT>' , clusters_columns ) <EOL> self . assertColumnCount ( engine , '<STR_LIT>' , clusters_columns ) <EOL> node_groups_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:count>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( engine , '<STR_LIT>' , node_groups_columns ) <EOL> self . assertColumnCount ( engine , '<STR_LIT>' , node_groups_columns ) <EOL> job_executions_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:info>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( <EOL> engine , '<STR_LIT>' , job_executions_columns ) <EOL> self . assertColumnCount ( <EOL> engine , '<STR_LIT>' , job_executions_columns ) <EOL> instances_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnsExist ( engine , '<STR_LIT>' , instances_columns ) <EOL> self . assertColumnCount ( engine , '<STR_LIT>' , instances_columns ) <EOL> self . _data_001 ( engine , data ) <EOL> def _data_001 ( self , engine , data ) : <EOL> datasize = <NUM_LIT> * <NUM_LIT> <EOL> data = os . urandom ( datasize ) <EOL> t = db_utils . get_table ( engine , '<STR_LIT>' ) <EOL> engine . execute ( t . insert ( ) , data = data , id = '<STR_LIT>' , name = '<STR_LIT:name>' ) <EOL> new_data = engine . execute ( t . select ( ) ) . fetchone ( ) . data <EOL> self . assertEqual ( data , new_data ) <EOL> engine . execute ( t . delete ( ) ) <EOL> def _check_002 ( self , engine , data ) : <EOL> pass <EOL> def _check_003 ( self , engine , data ) : <EOL> pass <EOL> def _check_004 ( self , engine , data ) : <EOL> pass <EOL> def _check_005 ( self , engine , data ) : <EOL> pass <EOL> def _check_006 ( self , engine , data ) : <EOL> pass <EOL> def _pre_upgrade_007 ( self , engine ) : <EOL> desc = '<STR_LIT>' <EOL> t = db_utils . get_table ( engine , '<STR_LIT>' ) <EOL> engine . execute ( t . insert ( ) , id = '<STR_LIT>' , name = '<STR_LIT:name>' , plugin_name = '<STR_LIT>' , <EOL> hadoop_version = '<STR_LIT:1>' , management_private_key = '<STR_LIT:2>' , <EOL> management_public_key = '<STR_LIT:3>' , status_description = desc ) <EOL> def _check_007 ( self , engine , data ) : <EOL> t = db_utils . get_table ( engine , '<STR_LIT>' ) <EOL> res = engine . execute ( t . select ( ) . where ( t . c . id == '<STR_LIT>' ) ) . first ( ) <EOL> self . assertEqual ( '<STR_LIT>' , res [ '<STR_LIT>' ] ) <EOL> engine . execute ( t . delete ( ) ) <EOL> desc = '<STR_LIT:a>' * <NUM_LIT> * <NUM_LIT> <EOL> t = db_utils . get_table ( engine , '<STR_LIT>' ) <EOL> engine . execute ( t . insert ( ) , id = '<STR_LIT>' , name = '<STR_LIT:name>' , plugin_name = '<STR_LIT>' , <EOL> hadoop_version = '<STR_LIT>' , management_private_key = '<STR_LIT:1>' , <EOL> management_public_key = '<STR_LIT:2>' , status_description = desc ) <EOL> new_desc = engine . execute ( t . select ( ) ) . fetchone ( ) . status_description <EOL> self . assertEqual ( desc , new_desc ) <EOL> engine . execute ( t . delete ( ) ) <EOL> def _check_008 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> def _check_009 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> def _check_010 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> def _check_011 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> def _check_012 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> def _check_014 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> def _check_015 ( self , engine , data ) : <EOL> provision_steps_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> ] <EOL> events_columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> ] <EOL> self . assertColumnCount ( engine , '<STR_LIT>' , <EOL> provision_steps_columns ) <EOL> self . assertColumnsExist ( engine , '<STR_LIT>' , <EOL> provision_steps_columns ) <EOL> self . assertColumnCount ( engine , '<STR_LIT>' , events_columns ) <EOL> self . assertColumnsExist ( engine , '<STR_LIT>' , events_columns ) <EOL> def _check_016 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> def _check_017 ( self , engine , data ) : <EOL> self . assertColumnNotExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> def _check_018 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> def _check_019 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> def _check_020 ( self , engine , data ) : <EOL> self . assertColumnNotExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnNotExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnNotExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> def _check_021 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> def _check_022 ( self , engine , data ) : <EOL> columns = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT:description>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:location>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT:default>' <EOL> ] <EOL> self . assertColumnCount ( engine , '<STR_LIT>' , columns ) <EOL> self . assertColumnsExist ( engine , '<STR_LIT>' , columns ) <EOL> def _check_023 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> def _check_024 ( self , engine , data ) : <EOL> tables = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> for table in tables : <EOL> self . assertColumnExists ( engine , table , '<STR_LIT>' ) <EOL> def _check_025 ( self , engine , data ) : <EOL> self . assertColumnType ( engine , '<STR_LIT>' , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnType ( engine , '<STR_LIT>' , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> def _check_026 ( self , engine , data ) : <EOL> tables = [ <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> ] <EOL> for table in tables : <EOL> self . assertColumnExists ( engine , table , '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , table , '<STR_LIT>' ) <EOL> def _check_027 ( self , engine , data ) : <EOL> self . assertColumnNotExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , <EOL> '<STR_LIT>' ) <EOL> def _check_028 ( self , engine , data ) : <EOL> self . assertColumnExists ( engine , '<STR_LIT>' , '<STR_LIT>' ) <EOL> def _pre_upgrade_029 ( self , engine ) : <EOL> t = db_utils . get_table ( engine , '<STR_LIT>' ) <EOL> engine . execute ( t . insert ( ) , id = '<STR_LIT>' , name = '<STR_LIT>' , plugin_name = '<STR_LIT>' , <EOL> hadoop_version = '<STR_LIT:1>' , flavor_id = '<STR_LIT:1>' , volumes_per_node = <NUM_LIT:0> , <EOL> is_default = True , is_protected = False ) <EOL> engine . execute ( t . insert ( ) , id = '<STR_LIT>' , name = '<STR_LIT>' , plugin_name = '<STR_LIT>' , <EOL> hadoop_version = '<STR_LIT:1>' , flavor_id = '<STR_LIT:1>' , volumes_per_node = <NUM_LIT:0> , <EOL> is_default = False , is_protected = False ) <EOL> t = db_utils . get_table ( engine , '<STR_LIT>' ) <EOL> engine . execute ( t . insert ( ) , id = '<STR_LIT>' , name = '<STR_LIT:name>' , plugin_name = '<STR_LIT>' , <EOL> hadoop_version = '<STR_LIT:1>' , is_default = True , is_protected = False ) <EOL> engine . execute ( t . insert ( ) , id = '<STR_LIT>' , name = '<STR_LIT:name>' , plugin_name = '<STR_LIT>' , <EOL> hadoop_version = '<STR_LIT:1>' , is_default = False , <EOL> is_protected = False ) <EOL> def _check_029 ( self , engine , data ) : <EOL> t = db_utils . get_table ( engine , '<STR_LIT>' ) <EOL> res = engine . execute ( t . select ( ) . where ( t . c . id == '<STR_LIT>' ) ) . first ( ) <EOL> self . assertTrue ( res [ '<STR_LIT>' ] ) <EOL> res = engine . execute ( t . select ( ) . where ( t . c . id == '<STR_LIT>' ) ) . first ( ) <EOL> self . assertFalse ( res [ '<STR_LIT>' ] ) <EOL> engine . execute ( t . delete ( ) ) <EOL> t = db_utils . get_table ( engine , '<STR_LIT>' ) <EOL> res = engine . execute ( t . select ( ) . where ( t . c . id == '<STR_LIT>' ) ) . first ( ) <EOL> self . assertTrue ( res [ '<STR_LIT>' ] ) <EOL> res = engine . execute ( t . select ( ) . where ( t . c . id == '<STR_LIT>' ) ) . first ( ) <EOL> self . assertFalse ( res [ '<STR_LIT>' ] ) <EOL> engine . execute ( t . delete ( ) ) <EOL> def _check_030 ( self , engine , data ) : <EOL> health_check_columns = [ <EOL> '<STR_LIT:status>' , <EOL> '<STR_LIT:name>' , <EOL> '<STR_LIT:description>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> verification_columns = [ <EOL> '<STR_LIT:status>' , <EOL> '<STR_LIT:id>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' , <EOL> '<STR_LIT>' <EOL> ] <EOL> self . assertColumnCount ( engine , '<STR_LIT>' , <EOL> verification_columns ) <EOL> self . assertColumnsExist ( engine , '<STR_LIT>' , <EOL> verification_columns ) <EOL> self . assertColumnCount ( engine , '<STR_LIT>' , <EOL> health_check_columns ) <EOL> self . assertColumnsExist ( engine , '<STR_LIT>' , <EOL> health_check_columns ) <EOL> class TestMigrationsMySQL ( SaharaMigrationsCheckers , <EOL> base . BaseWalkMigrationTestCase , <EOL> base . TestModelsMigrationsSync , <EOL> test_base . MySQLOpportunisticTestCase ) : <EOL> pass <EOL> class TestMigrationsPostgresql ( SaharaMigrationsCheckers , <EOL> base . BaseWalkMigrationTestCase , <EOL> base . TestModelsMigrationsSync , <EOL> test_base . PostgreSQLOpportunisticTestCase ) : <EOL> pass </s>
