def select_folder_list(user_id): chosen_db = choose_a_db(user_id) folder_list = Folder.objects.using(chosen_db) \ .filter(user_id=user_id) \ .order_by('order') return folder_list
def delete_myimage_instance_in_db(user_id, key): is_successful = True chosen_db = choose_a_db(user_id) try: myimage_instance = MyImageInstance.objects.using(chosen_db).get(key=key) except MyImageInstance.DoesNotExist: is_successful = False else: myimage_instance.delete() return is_successful
def create_myimage_instance(user_id, key, url, myarticle_instance_id, title='', description=''): chosen_db = choose_a_db(user_id) try: myimage_instance = MyImageInstance.objects.using(chosen_db).get(key=key) except MyImageInstance.DoesNotExist: myimage_instance = MyImageInstance() myimage_instance.user_id=user_id myimage_instance.key=key myimage_instance.url=url myimage_instance.myarticle_instance_id = myarticle_instance_id myimage_instance.title=title myimage_instance.description=description myimage_instance.save() return myimage_instance
def get_folder_by_name(user_id, name): if name: folder_key = generate_folder_key(user_id, name) folder = cache.get(folder_key, None) if folder is None: chosen_db = choose_a_db(user_id) try: folder = folder.objects.using(chosen_db).get(user_id=user_id, name=name) except: pass else: folder.update_cache() else: folder = None return folder