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)
