def clean_db(args): sa_util.clear_temp_objects(verbose=args.verbose) tables = sorted(list( set(sa_util.table_view_list()) - set(definitions.defined_tables()) - set(sa_util.dependent_objects()) )) print 'Unknown tables' for table in tables: print '\t%s' % table for table in tables: response = raw_input('Delete table `%s` [No/yes/quit]:' % table) if response and response.upper()[0] == 'Y': sa_util.drop_table_or_view(table, verbose=args.verbose) if response and response.upper()[0] == 'Q': return
def clear_views(args): for view in sa_util.view_list(): sa_util.drop_table_or_view(view, force=True)