Example #1
0
 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'
Example #2
0
    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."
Example #3
0
    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
Example #4
0
    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
Example #5
0
 def get_dish_by_id(id):
     dish = db_session.query(Dish).get(id)
     return dish
Example #6
0
 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
Example #7
0
 def get_tag_by_id(id):
     return db_session.query(Tag).get(id)
Example #8
0
 def get_tag_by_name(name):
     return db_session.query(Tag).filter_by(name=name).first()
Example #9
0
 def find_matches(word):
     return db_session.query(Dict_Entry).filter_by(simplified=word).all()
Example #10
0
 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
Example #11
0
 def get_all_words():
     words = []
     food_words = db_session.query(Food_Word).all()
     for word in food_words:
         words.append(word.simplified)
     return words
Example #12
0
 def find_match(word):
     return db_session.query(Food_Word).filter_by(simplified=word).first()
Example #13
0
 def find_match(word):
     return db_session.query(Dish).filter_by(chin_name=word).first()
Example #14
0
 def get_dish_by_id(id):
     dish = db_session.query(Dish).get(id)
     return dish
Example #15
0
 def find_match(word):
     return db_session.query(Dish).filter_by(chin_name=word).first()
Example #16
0
 def get_user_by_id(user_id):
     return db_session.query(User).get(user_id)
Example #17
0
 def find_matches(word):
     return db_session.query(Dict_Entry).filter_by(simplified=word).all()