def pending(): drifts = Drift.user_drifts() drifts_view = DriftCollection() drifts_view.fill(drifts) return render_template('pending.html', total=drifts_view.total, drifts=drifts_view.drifts)
def pending(): drifts = Drift.query.filter( or_(Drift.requester_id == current_user.id, Drift.gifter_id == current_user.id)).order_by( desc(Drift.create_time)).all() views = DriftCollection(drifts, current_user.id) return render_template('pending.html', drifts=views.data)
def pending(): # 点击鱼漂时跳转 # 交易记录--查询drift表---1.我作为索要者的交易 或者 2.我作为赠送者的交易 drifts = Drift.query.filter( or_(Drift.requester_id == current_user.id, Drift.gifter_id == current_user.id)).order_by(desc(Drift.create_time)).all() # 没有在DriftCollection这个模型中直接写入cuurent_user,保证了模型的完整性,不会被current_user所束缚 views = DriftCollection(drifts, current_user.id) return render_template('pending.html', drifts=views.data)
def pending(): '''处理时光漂流页面。''' # 查询自己身为请求者或赠送者的交易信息 drifts = Drift.query.filter( or_(Drift.requester_id == current_user.id, Drift.gifter_id == current_user.id)).order_by( desc(Drift.create_time)).all() view_model = DriftCollection(drifts, current_user.id) return render_template('web/pending.html', drifts=view_model.data)
def pending(): # 我赠送的或者我索要的书籍列表 drifts = Drift.query.filter( or_(Drift.requester_id == current_user.id, Drift.gifter_id == current_user.id)).order_by( desc(Drift.create_time)).all() # 将数据封装到数据模型中后, 传递给前端 views = DriftCollection(drifts, current_user.id) return render_template('pending.html', drifts=views.data)
def pending(): # or_表示或的关系 # 作为一个用户,你既可以送书也可以要书,那么在交易记录中,既可能是requester也可能是gifter # 所以这里用或的关系查找 drifts = Drift.query.filter( or_(Drift.requester_id == current_user.id, Drift.gifter_id == current_user.id)).order_by( desc(Drift.create_time)).all() view = DriftCollection(drifts) return render_template('pending.html', drifts=view.data)
def pending(): """ 显示交易记录 我作为赠送者 or 我作为请求者 使用or_() 进行or关系的转化 :return: """ drifts = Drift.query.filter( or_(Drift.requester_id == current_user.id, Drift.gifter_id == current_user.id)).order_by( desc(Drift.create_time)).all() views = DriftCollection(drifts, current_user.id) return render_template('pending.html', drifts=views.data)
def pending(): """ requester_id和gifter_id之间是或关系, 筛选出来的记录才是作为赠送者或者是请求人. 方法:使用filter结合or_,or括号里面的条件就是或关系 :return: """ drifts = Drift.query.filter( or_(Drift.requester_id == current_user.id, Drift.gifter_id == current_user.id)).order_by( desc(Drift.create_time)).all() views = DriftCollection(drifts, current_user.id) return render_template('pending.html', drifts=views.data)