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 is_database_exist(dbname, databases_path = DATABASE_FILE_PATH):
if object_in_file_list(obj = dbname, file_path = databases_path):
return True
return False
def is_table_exist(dbname,table_name):
table_infomath_file_path = get_all_table_name_info_txt_path(dbname)
if object_in_file_list(obj = table_name, file_path = table_infomath_file_path):
return True
return False
