class good_rate(db.Model):
__tablename__ = 'good_rate'
res_name = db.Column(db.Text, primary_key=True)
rate = db.Column(db.Float)
def __repr__(self):
return "res_name:`{}`, rate :`{}`".format(self.res_name, self.rate)
class fastfood(db.Model):
__tablename__ = 'fastfood'
res_name = db.Column(db.Text, primary_key=True)
flavor = db.Column(db.Float)
mutton_noodles = db.Column(db.Float)
mutton = db.Column(db.Float)
environment = db.Column(db.Float)
soup = db.Column(db.Float)
rice_noodles = db.Column(db.Float)
good = db.Column(db.Float)
beef_offal = db.Column(db.Float)
chilli_sauce = db.Column(db.Float)
beef_offal_noodles = db.Column(db.Float)
fried_bun = db.Column(db.Float)
duck_noodles = db.Column(db.Float)
bean_noodles = db.Column(db.Float)
cake = db.Column(db.Float)
bread = db.Column(db.Float)
group_purchase = db.Column(db.Float)
convenience = db.Column(db.Float)
soup_liquid = db.Column(db.Float)
haggis = db.Column(db.Float)
def __repr__(self):
return "res_name:`{}`, flavor:`{}`,mutton_noodles:`{}`,mutton:`{}`,environment:`{}`,soup:`{}`,rice_noodles:`{}`,good:`{}`, beef_offal:`{}`,chilli_sauce:`{}`,beef_offal_noodles:`{}`,fried_bun:`{}`,duck_noodles:`{}`,bean_noodles:`{}`,cake:`{}`,bread:`{}`,group_purchase:`{}`,convenience:`{}`,soup_liquid:`{}`,haggis:`{}`".format(
self.res_name, self.flavor, self.mutton_noodles, self.mutton,
self.environment, self.soup, self.rice_noodles, self.good,
self.beef_offal, self.chilli_sauce, self.beef_offal_noodles,
self.fried_bun, self.duck_noodles, self.bean_noodles, self.cake,
self.bread, self.group_purchase, self.convenience,
self.soup_liquid, self.haggis)
class hotpot(db.Model):
__tablename__ = 'hotpot'
res_name = db.Column(db.Text, primary_key=True)
beef = db.Column(db.Float)
fresh = db.Column(db.Float)
good = db.Column(db.Float)
environment = db.Column(db.Float)
flavor = db.Column(db.Float)
convenience = db.Column(db.Float)
service = db.Column(db.Float)
meat = db.Column(db.Float)
fruit = db.Column(db.Float)
buffet = db.Column(db.Float)
seafood = db.Column(db.Float)
shrimp = db.Column(db.Float)
mutton = db.Column(db.Float)
def __repr__(self):
return "res_name:`{}`, beef:`{}`,fresh:`{}`,good:`{}`,environment:`{}`,flavor:`{}`,convenience:`{}`,service:`{}`,meat:`{}`,fruit:`{}`,buffet:`{}`,seafood:`{}`,shrimp:`{}`,mutton:`{}`".format(
self.res_name, self.beef, self.fresh, self.good, self.environment,
self.flavor, self.convenience, self.service, self.meat, self.fruit,
self.buffet, self.seafood, self.shrimp, self.mutton)
class dessert(db.Model):
__tablename__ = 'dessert'
res_name = db.Column(db.Text, primary_key=True)
# res_name = db.Column(db.text)
cake = db.Column(db.Float)
good = db.Column(db.Float)
mango = db.Column(db.Float)
flavor = db.Column(db.Float)
cream = db.Column(db.Float)
stratiform_cake = db.Column(db.Float)
cheese_cake = db.Column(db.Float)
cheese = db.Column(db.Float)
cheap = db.Column(db.Float)
milktea = db.Column(db.Float)
good_drink = db.Column(db.Float)
pearl_milktea = db.Column(db.Float)
group_purchase = db.Column(db.Float)
convenience = db.Column(db.Float)
milk_cover = db.Column(db.Float)
tea = db.Column(db.Float)
matcha = db.Column(db.Float)
durian = db.Column(db.Float)
puff = db.Column(db.Float)
def __repr__(self):
return "res_name:`{}`, cake:`{}`,good:`{}`,mango:`{}`,flavor:`{}`,cream:`{}`,stratiform_cake:`{}`,cheese_cake:`{}`,cheese:`{}`,cheap:`{}`,milktea:`{}`,good_drink:`{}`,pearl_milktea:`{}`,group_purchase:`{}`,convenience:`{}`,milk_cover:`{}`,tea:`{}`,matcha:`{}`,durian:`{}`,puff:`{}`".format(
self.res_name, self.cake, self.good, self.mango, self.flavor,
self.cream, self.stratiform_cake, self.cheese_cake, self.cheese,
self.cheap, self.milktea, self.good_drink, self.pearl_milktea,
self.group_purchase, self.convenience, self.milk_cover, self.tea,
self.matcha, self.durian, self.puff)
class western_food(db.Model):
__tablename__ = 'western_food'
res_name = db.Column(db.Text, primary_key=True)
good = db.Column(db.Float)
environment = db.Column(db.Float)
flavor = db.Column(db.Float)
snack = db.Column(db.Float)
drinks = db.Column(db.Float)
fried_tofu = db.Column(db.Float)
rice = db.Column(db.Float)
steak = db.Column(db.Float)
service = db.Column(db.Float)
chips = db.Column(db.Float)
cake = db.Column(db.Float)
package = db.Column(db.Float)
durian_egg = db.Column(db.Float)
dessert = db.Column(db.Float)
buffet = db.Column(db.Float)
fruit = db.Column(db.Float)
corn_soup = db.Column(db.Float)
def __repr__(self):
return "res_name:`{}`, good:`{}`,environment:`{}`,flavor :`{}`,snack :`{}`,drinks:`{}`,fried_tofu:`{}`,rice :`{}`,steak:`{}`,service:`{}`,chips:`{}`,cake:`{}`,package :`{}`,durian_egg:`{}`,dessert:`{}`,buffet:`{}`,fruit:`{}`,corn_soup:`{}`".format(self.res_name, self.good, self.environment, self.flavor, self.snack, self.drinks, self.fried_tofu, self.rice, self.steak, self.service, self.chips, self.cake, self.package, self.durian_egg, self.dessert, self.buffet, self.fruit, self.corn_soup)
class jk(db.Model):
__tablename__ = 'jk'
res_name = db.Column(db.Text, primary_key=True)
good = db.Column(db.Float)
sushi = db.Column(db.Float)
salmon = db.Column(db.Float)
fresh = db.Column(db.Float)
flavor = db.Column(db.Float)
environment = db.Column(db.Float)
shrimp_crab = db.Column(db.Float)
eel_rice = db.Column(db.Float)
roll = db.Column(db.Float)
rice = db.Column(db.Float)
avocado = db.Column(db.Float)
sukiyaki = db.Column(db.Float)
tuna = db.Column(db.Float)
mixed_rice = db.Column(db.Float)
pork_chop = db.Column(db.Float)
beef = db.Column(db.Float)
fruit = db.Column(db.Float)
hotpot = db.Column(db.Float)
sashimi = db.Column(db.Float)
urchin = db.Column(db.Float)
buffet = db.Column(db.Float)
shrimp = db.Column(db.Float)
service = db.Column(db.Float)
def __repr__(self):
return "res_name:`{}`, good :`{}`,sushi:`{}`,salmon:`{}`,fresh:`{}`,flavor:`{}`, environment:`{}`,shrimp_crab:`{}`, eel_rice:`{}`,roll:`{}`,rice:`{}`, avocado:`{}`,sukiyaki:`{}`,tuna:`{}`,mixed_rice:`{}`, pork_chop:`{}`,beef:`{}`,fruit:`{}`,hotpot:`{}`,sashimi:`{}`,urchin:`{}`,buffet:`{}`,shrimp:`{}`,service:`{}`".format(
self.res_name, self.good, self.sushi, self.salmon, self.fresh,
self.flavor, self.environment, self.shrimp_crab, self.eel_rice,
self.roll, self.rice, self.avocado, self.sukiyaki, self.tuna,
self.mixed_rice, self.pork_chop, self.beef, self.fruit,
self.hotpot, self.sashimi, self.urchin, self.buffet, self.shrimp,
self.service)
class chuanxiang(db.Model):
__tablename__ = 'chuanxiang'
res_name = db.Column(db.Text, primary_key=True)
good = db.Column(db.Float)
flavor = db.Column(db.Float)
chilli_fish_head = db.Column(db.Float)
pettitoes = db.Column(db.Float)
spicy = db.Column(db.Float)
roast_fish = db.Column(db.Float)
service = db.Column(db.Float)
qingjiang_fish = db.Column(db.Float)
pickled_fish = db.Column(db.Float)
environment = db.Column(db.Float)
performance = db.Column(db.Float)
attitude = db.Column(db.Float)
fish = db.Column(db.Float)
line = db.Column(db.Float)
def __repr__(self):
return "res_name:`{}`, good:`{}`,flavor:`{}`,chilli_fish_head:`{}`,pettitoes:`{}`,spicy:`{}`,roast_fish:`{}`,service:`{}`,qingjiang_fish:`{}`,pickled_fish:`{}`,environment:`{}`,performance:`{}`,attitude:`{}`,fish:`{}`,line:`{}`".format(
self.res_name, self.good, self.flavor, self.chilli_fish_head,
self.pettitoes, self.spicy, self.roast_fish, self.service,
self.qingjiang_fish, self.pickled_fish, self.environment,
self.performance, self.attitude, self.fish, self.line)