#NEWLINE# def test_no_new_soft_deletes( self ) : #NEWLINE# #INDENT# whitelist = [ 'agent_builds' , 'aggregate_hosts' , 'aggregate_metadata' , 'aggregates' , 'block_device_mapping' , 'bw_usage_cache' , 'cells' , 'certificates' , 'compute_nodes' , 'console_pools' , 'consoles' , 'dns_domains' , 'fixed_ips' , 'floating_ips' , 'instance_actions' , 'instance_actions_events' , 'instance_extra' , 'instance_faults' , 'instance_group_member' , 'instance_group_policy' , 'instance_groups' , 'instance_id_mappings' , 'instance_info_caches' , 'instance_metadata' , 'instance_system_metadata' , 'instance_type_extra_specs' , 'instance_type_projects' , 'instance_types' , 'instances' , 'key_pairs' , 'migrations' , 'networks' , 'pci_devices' , 'project_user_quotas' , 'provider_fw_rules' , 'quota_classes' , 'quota_usages' , 'quotas' , 'reservations' , 's3_images' , 'security_group_default_rules' , 'security_group_instance_association' , 'security_group_rules' , 'security_groups' , 'services' , 'snapshot_id_mappings' , 'snapshots' , 'task_log' , 'virtual_interfaces' , 'volume_id_mappings' , 'volume_usage_cache' ] #NEWLINE# tables = [ ] #NEWLINE# for base in [ models . BASE , api_models . API_BASE ] : #NEWLINE# #INDENT# for ( table_name , table ) in base . metadata . tables . items ( ) : #NEWLINE# #INDENT# columns = [ column . name for column in table . columns ] #NEWLINE# if ( ( 'deleted' in columns ) or ( 'deleted_at' in columns ) ) : #NEWLINE# #INDENT# tables . append ( table_name ) #NEWLINE# #UNINDENT# #UNINDENT# #UNINDENT# self . assertEqual ( whitelist , sorted ( tables ) )