def get(self, address_id): # 查询数据 if address_id is not None: return db_session.query( self.object).filter(self.object.id == address_id), 'sqlalchemy' else: return db_session.query(self.object).all(), 'sqlalchemy'
def create_user(username, password, password_verify): if password != password_verify: return "Error: Passwords do not match." user = db_session.query(User).filter_by(username=username) if user: return "Error: User already exists." user = User(username=username) user.set_password(password) db_session.add(user) db_session.commit() return "User created."
def find_similar(word): results = [] word_list = [] for char in word: word_list.append(char) for i in range(len(word)): temp = word_list[i] word_list[i] = '%' new_word = ''.join(word_list) similar = db_session.query(Dish).filter(Dish.chin_name.like(new_word)).all() results.extend(similar) word_list[i] = temp return results
def find_similar(word): results = [] word_list = [] for char in word: word_list.append(char) for i in range(len(word)): temp = word_list[i] word_list[i] = '%' new_word = ''.join(word_list) similar = db_session.query(Dish).filter( Dish.chin_name.like(new_word)).all() results.extend(similar) word_list[i] = temp return results
def get_dish_by_id(id): dish = db_session.query(Dish).get(id) return dish
def get_all_dishes(): dish_names = [] dishes = db_session.query(Dish).all() for dish in dishes: dish_names.append(dish.chin_name) return dish_names
def get_tag_by_id(id): return db_session.query(Tag).get(id)
def get_tag_by_name(name): return db_session.query(Tag).filter_by(name=name).first()
def find_matches(word): return db_session.query(Dict_Entry).filter_by(simplified=word).all()
def get_all_words(): words = [] food_words = db_session.query(Food_Word).all() for word in food_words: words.append(word.simplified) return words
def find_match(word): return db_session.query(Food_Word).filter_by(simplified=word).first()
def find_match(word): return db_session.query(Dish).filter_by(chin_name=word).first()
def get_user_by_id(user_id): return db_session.query(User).get(user_id)