def show_databases():
databases = get_object_from_file_extend_to_list(DATABASE_FILE_PATH)
print 'All databases:'
for db in databases:
print db
print ''
return databases
def show_tables(database_name):
if database_name is None:
print 'Not database used, use a database fisrt!'
return None
if is_database_exist(database_name) == False:
print 'The database named %s was not exists!' % (database_name)
return None
table_infomath_file_path = get_all_table_name_info_txt_path(database_name)
tables = get_object_from_file_extend_to_list(table_infomath_file_path)
print 'All tables:'
for tb in tables:
print tb
print ''
return tables
def drop_database(database_name):
if not object_in_file_list(obj = database_name , file_path = DATABASE_FILE_PATH):
print 'The database had not exists!'
return False
database_path = get_database_path(database_name)
try:
shutil.rmtree(database_path)
except:
#print 'Drop error!'
return False
databases = get_object_from_file_extend_to_list(DATABASE_FILE_PATH)
after_drop_databases = [db for db in databases if db != database_name]
databases = '\n'.join(after_drop_databases)
write_to_file(string = databases,file_path = DATABASE_FILE_PATH)
if default_variable.CURRENT_DB == database_name:
default_variable.CURRENT_DB = None
return True
def drop_table(database_name,table_name):
if is_table_exist(database_name,table_name) == False:
print 'The table has not exists!'
return False
table_info_path = get_table_info_txt_path(database_name,table_name)
table_data_path = get_table_data_file_path(database_name,table_name)
all_tables_info_path = get_all_table_name_info_txt_path(database_name)
try:
os.remove(table_info_path)
os.remove(table_data_path)
except:
#print 'Drop error!'
return False
tables = get_object_from_file_extend_to_list(all_tables_info_path)
after_drop_tables = [tb for tb in tables if tb != table_name]
tables = '\n'.join(after_drop_tables)
write_to_file(string = tables,file_path = all_tables_info_path)
return True
