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_dishes():
dish_names = []
dishes = db_session.query(Dish).all()
for dish in dishes:
dish_names.append(dish.chin_name)
return dish_names
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_dish_by_id(id):
dish = db_session.query(Dish).get(id)
return dish
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)
def find_matches(word):
return db_session.query(Dict_Entry).filter_by(simplified=word).all()
