Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialDmitry Karamin
10,099 PointsTemplate doesn't work
i've added lines following the task...but it doesn't work. i'can see queryset to follow.
import datetime
from flask import Flask, g, render_template, flash, redirect, url_for
from flask.ext.bcrypt import check_password_hash
from flask.ext.login import LoginManager, login_user, current_user, login_required, logout_user
import forms
import models
app = Flask(__name__)
app.secret_key = 'this is our super secret key. do not share it with anyone!'
login_manager = LoginManager()
login_manager.init_app(app)
login_manager.login_view = 'login'
@login_manager.user_loader
def load_user(userid):
try:
return models.User.select().where(
models.User.id == int(userid)
).get()
except models.DoesNotExist:
return None
@app.before_request
def before_request():
g.db = models.DATABASE
g.db.connect()
g.user = current_user
@app.after_request
def after_request(response):
g.db.close()
return response
@app.route('/register', methods=('GET', 'POST'))
def register():
form = forms.SignUpInForm()
if form.validate_on_submit():
models.User.new(
email=form.email.data,
password=form.password.data
)
flash("Thanks for registering!")
return render_template('register.html', form=form)
@app.route('/login', methods=('GET', 'POST'))
def login():
form = forms.SignUpInForm()
if form.validate_on_submit():
try:
user = models.User.get(
models.User.email == form.email.data
)
if check_password_hash(user.password, form.password.data):
login_user(user)
flash("You're now logged in!")
else:
flash("No user with that email/password combo")
except models.DoesNotExist:
flash("No user with that email/password combo")
return render_template('register.html', form=form)
@app.route('/secret')
@login_required
def secret():
return "I should only be visible to logged-in users"
@app.route('/logout')
def logout():
logout_user()
return redirect(url_for('login'))
@app.route('/')
def index():
return render_template('index.html')
@app.route('/order', methods=('GET', 'POST'))
def order_lunch():
form = forms.LunchOrderForm()
if form.validate_on_submit():
models.LunchOrder.create(
user=g.user._get_current_object(),
date=form.date.data,
order=form.order.data.strip()
)
return render_template('lunch.html', form=form)
@app.route('/today')
@login_required
def today():
order = models.LunchOrder.select().where(
models.LunchOrder.date == datetime.date.today() &
models.LunchOrder.user == g.user._get_current_object()
).get()
return render_template('today.html', order=order)
@app.route('/cancel_order/<int:order_id>')
@login_required
def cancel_order(order_id):
try:
order = models.LunchOrder.select().where(
id=order_id,
user=g.user._get_current_object()
).get()
except models.DoesNotExist:
pass
else:
order.delete_instance()
return redirect(url_for('index'))
@app.route('/follow/<int:user_id>')
@login_required
def follow(user_id):
try:
user = models.User.get(
models.User.id == user_id
)
models.Relationship.create(
from_user=g.user._get_current_object(),
to_user=user
)
except (models.DoesNotExist, models.IntegrityError):
pass
return redirect(url_for('index'))
@app.route('/unfollow/<int:user_id>')
@login_required
def unfollow(user_id):
try:
user = models.User.get(
models.User.id == user_id
)
models.Relationship.get(
models.Relationship.from_user==g.user._get_current_object(),
models.Relationship.to_user==user
).delete_instance()
except (models.DoesNotExist, models.IntegrityError):
pass
return redirect(url_for('index'))
@app.route('/profile/<int:user_id>')
def profile(user_id):
user = models.User.select().where(
models.User.id == user_id
).get()
return render_template('profile.html', user=user)
import datetime
from flask.ext.bcrypt import generate_password_hash
from flask.ext.login import UserMixin
from peewee import *
DATABASE = SqliteDatabase(':memory:')
class User(UserMixin, Model):
email = CharField(unique=True)
password = CharField(max_length=100)
join_date = DateTimeField(default=datetime.datetime.now)
bio = CharField(default='')
class Meta:
database = DATABASE
@property
def following(self):
return (
User
.select()
.join(Relationship, on=Relationship.to_user)
.where(Relationship.from_user == self)
)
@property
def followers(self):
return (
User
.select()
.join(Relationship, on=Relationship.from_user)
.where(Relationship.to_user == self)
)
@classmethod
def new(cls, email, password):
cls.create(
email=email,
password=generate_password_hash(password)
)
class LunchOrder(Model):
order = TextField()
date = DateField()
user = ForeignKeyField(User, related_name="orders")
class Relationship(Model):
from_user = ForeignKeyField(User, related_name="relationships")
to_user = ForeignKeyField(User, related_name="related_to")
created_at = DateTimeField(default=datetime.datetime.now)
class Meta:
database = DATABASE
indexes = (
(('from_user', 'to_user'), True),
)
def initialize():
DATABASE.connect()
DATABASE.create_tables([User, LunchOrder], safe=True)
DATABASE.close()
{% extends "layout.html" %}
{% from "macro.html" import hide_email %}
{% block content %}
<h1>{{ hide_email(user) }}</h1>
<dl>
<dt>Lunches:</dt>
<dd>{{ ordered.count() }}<!-- total # of lunches ordered --></dd>
<dt>Followers:</dt>
<dd>{{ followers.count() }}<!-- # of followers. user.followers is a queryset of followers --></dd>
<dt>Following:</dt>
<dd>{{ followed.count() }}<!-- # of users followed. user.following is a queryset of users followed --></dd>
</dl>
{% endblock %}
4 Answers
T K
21,479 PointsYou need to specify the user to look up the followers/following/orders of.
So you should have {{ user.followers.count() }} etc.
Dmitry Karamin
10,099 PointsNo i can't do like this. I tried this way when i first saw this task. In template it is written that user.following and user.followers are queryset of followed and followers. As far as i can guess user.orders is a queryset of ordered. But still it is not working
So the question is still open
T K
21,479 PointsOrders is the related name for the foreign key, so user.orders.count() should return that what you're after.
However, the wording for your following is off too. You've put "followed" and the name of the queryset is "following".
Dmitry Karamin
10,099 PointsQuote from the task <!-- # of users followed. user.following is a queryset of users followed --> So the name of the queryset is 'followed'
Dmitry Karamin
10,099 PointsI did it man user.orders.count() user.following.count() user.followers.count()
Thanks
T K
21,479 PointsT K
21,479 PointsThere's also a couple of names that are a bit off in your code! I'll give you hints: