daos.py 文件源码

def create(self, user_id, ingredient_id, coefficient):
        """Create a new record in the database"""
        query = text("""
        INSERT INTO tblUserPreference
            (user_id, ingredient_id, coefficient)
        VALUES
            (:user_id, :ingredient_id, :coefficient);
        """)
        result = self.execute(query,
                              user_id=user_id,
                              ingredient_id=ingredient_id,
                              coefficient=coefficient)
        db.session.commit()
        return result.lastrowid