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 trial

Python

Posted by qasimalbaqali
qasimalbaqali
17,839 Points

Categories for posts

So let's say I want to create categories for the posts, so that the user can choose the best fitting category for his post to be under. I would have a models.py that has class Post and class Category and they would look like the following:

class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80))
    body = db.Column(db.Text)
    pub_date = db.Column(db.DateTime)

    category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
    category = db.relationship('Category',
        backref=db.backref('posts', lazy='dynamic'))

    def __init__(self, title, body, category, pub_date=None):
        self.title = title
        self.body = body
        if pub_date is None:
            pub_date = datetime.utcnow()
        self.pub_date = pub_date
        self.category = category

    def __repr__(self):
        return '<Post %r>' % self.title

class Category(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))

    def __init__(self, name):
        self.name = name

    def __repr__(self):
        return '<Category %r>' % self.name

From there how do I create category pages. So I know that the end result should look like www.example.com/category/posttitle

My first guess is I would create a category.html, BUT the thing is I have no idea what to write in there. I know how to simply create a form with all the data and let the user post it and render it on a page but no idea how to let the post go under different type of categories. Any one can help me with this? Tried to look tutorials online but most of these just show how to let a user post and render the post but not list it under a category.