实现与数据库的连接,以及一些数据的获取
#每次打开页面都需要更新视图
cur.execute("DROP VIEW USER_VIEW")
cur.execute(
"CREATE VIEW USER_VIEW AS SELECT username, food_name, food_infor, url FROM USER_TABLE,FOOD_TABLE,RELATION_TABLE WHERE USER_TABLE.id=RELATION_TABLE.id AND FOOD_TABLE.food_id=RELATION_TABLE.food_id")
sql = "select username, food_name, food_infor, url from USER_VIEW"
下面是获取到的一些信息
[('user21', '油炒花生米', '花生米,油,黑芝麻', './static/uploads/338.jpg'), ('user5', '年年有鱼山楂糕', '山楂,冰糖', './static/uploads/1580.jpg'), ('user5', '土豆饼', '土豆饼,粘米粉,葱花', './static/uploads/2835.jpg'), ('user6', '南瓜麻球', '南瓜,糯米粉,白芝麻,糖', './static/uploads/2871.jpg'), ('user44', '冬菇蒸鸡', '香菇,鸡腿,姜,剁椒,盐,生抽,鸡粉,生粉,胡椒粉', './static/uploads/3125.jpg'), ('user14', '酸辣白菜', '大白菜,姜,蒜头,泡椒,指天椒,盐,鸡粉,香醋', './static/uploads/3213.jpg'), ('user15', '蒜香蒸排骨', '肋排,蒜头,盐,鸡粉,生抽,老抽,生粉,花生油,红尖椒', './static/uploads/3292.jpg'), ('user12', '萝卜干蛋炒饭', '隔夜米饭,鸡蛋,萝卜干,红尖椒,蒜苗,蒜,生抽,鸡精', './static/uploads/3306.jpg'), ('user7', '小炒鸡爪', '鸡爪,青椒,红椒,姜,蒜,豆豉,料酒,盐,鸡精,生抽,老抽', './static/uploads/3343.jpg'), ……