数据库——收藏模块

建立relation——table用户食谱关系表并导入数据

数据库接口：

 后端通过输入用户id，使用内连接，获取此用户全部收藏的食谱信息，食谱id，食谱名，图片地址

在用户食谱关系表中补充新的食谱关系

 获取图片路径：

建立单个用户关系食谱表，得到所有关系信息，删除三个函数

 

#建立对应用户的发布食谱表

    def createtable(self, user_id, type):

        # conn = psycopg2.connect(

        #     database="USER_TABLE", user='postgres', password='mn58246110',

        #     host='49.234.14.142', port='5432')

        cursor = self.connection.cursor()

        self.connection.conn.autocommit = True

        cursor.execute(

            "CREATE TABLE FOOD_" + user_id + " AS SELECT relation_table.food_id,food_name,url,food_infor,time  FROM  FOOD_TABLE,RELATION_TABLE WHERE relation_table.id='" + user_id + "' AND FOOD_TABLE.food_id=RELATION_TABLE.food_id and relationship='{0}'".format(type))

表如下：

#建立对应用户的收藏食谱表

    def createtable(self, user_id, type):

        # conn = psycopg2.connect(

        #     database="USER_TABLE", user='postgres', password='mn58246110',

        #     host='49.234.14.142', port='5432')

        cursor = self.connection.cursor()

        self.connection.conn.autocommit = True

        cursor.execute(

            "CREATE TABLE FOOD_" + user_id + " AS SELECT relation_table.food_id,food_name,url,food_infor,time  FROM  FOOD_TABLE,RELATION_TABLE WHERE relation_table.id='" + user_id + "' AND FOOD_TABLE.food_id=RELATION_TABLE.food_id and relationship='{1}'".format(type))

#删除对应用户的收藏食谱表

    def deletetable(self, user_id):

        cursor = self.connection.cursor()

        self.connection.conn.autocommit = True

        cursor.execute("DROP TABLE IF EXISTS FOOD_" + user_id)

#得到对应用户收藏食谱表的内容

    def get(self, user_id):

        cursor = self.connection.cursor()

        self.connection.conn.autocommit = True

        cursor.execute("SELECT * FROM FOOD_" + user_id)

        n = cursor.fetchall()

        self.connection.close_conn()

        return n