【Flask微电影】19.用户收藏电影：收藏列表和删除

## 收藏管理 设置从1开始自动递增 ```sql mysql> alter table moviecollect auto_increment=1; Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> insert into moviecollect(movie_id, user_id, add_time) values (5, 51, '2018-10-21 16:16:16'), (8, 45, '2018-10-21 16:16:16'), (5, 50, '2018-10-21 16:16:16'), (8, 48, '2018-10-21 16:16:16'), (5, 43, '2018-10-21 16:16:16'), (8, 50, '2018-10-21 16:16:16'); Query OK, 6 rows affected (0.04 sec) Records: 6 Duplicates: 0 Warnings: 0 ``` ### 收藏列表 #### 编辑collect_list收藏列表视图 ```python @admin.route("/collect/list/<int:page>/") @admin_login_require def collect_list(page=None): if page is None: page = 1 page_moviecollects = MovieCollect.query.join( Movie ).join( User ).filter( Movie.id == Comment.movie_id, User.id == Comment.user_id ).order_by( Comment.add_time.desc() ).paginate(page=page, per_page=10) return render_template('admin/collect_list.html', page_moviecollects=page_moviecollects) ``` #### 编辑collect_list.html收藏列表模板 ```html <div class="box-body table-responsive no-padding"> <table class="table table-hover"> {% include 'admin/alert_info.html' %} <tbody> <tr> <th>编号</th> <th>电影</th> <th>用户</th> <th>添加时间</th> <th>操作事项</th> </tr> {% for moviecollect in page_moviecollects.items %} <tr> <td>{{ moviecollect.id }}</td> <td>{{ moviecollect.movie.title }}</td> <td>{{ moviecollect.user.name }}</td> <td>{{ moviecollect.add_time }}</td> <td> <a class="label label-success">编辑</a> &nbsp; <a class="label label-danger">删除</a> </td> </tr> {% endfor %} </tbody> </table> </div> <div class="box-footer clearfix"> {% import 'admin/pagination.html' as pg %} {{ pg.render_pagination(page_moviecollects, 'admin.collect_list') }} </div> ``` ### 收藏删除 #### 增加collect_delete删除收藏视图 ```python @admin.route("/collect/delete/<int:delete_id>") @admin_login_require def collect_delete(delete_id=None): moviecollect = MovieCollect.query.get_or_404(delete_id) db.session.delete(moviecollect) db.session.commit() flash('删除收藏成功！', category='ok') return redirect(url_for('admin.comment_list', page=1)) ``` #### 修改collect_list.html删除收藏链接 ```html <a class="label label-danger" href="{{ url_for('admin. collect_delete', delete_id=moviecollect.id) }}">删除</a> ``` 

明人不说暗话 领红包就是支持！！！ 来都来了，再到页面底部看下呗~ ↓ ↓ ↓

本文地址： http://blog.starmeow.cn/detail/14bfa6bb14875e45bba028a21ed38046/

很赞哦！ (1)