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