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 Build a Social Network with Flask Tacocat Challenge Tacocat!

Diego Salas Polar
Diego Salas Polar
21,431 Points

I am having peewee.OperationalError: table taco has no column named protein, and I need help fixing this Error.

The error occurred when you are logged in and created a taco and click "Create". Can somebody help me?

tacocat.py
from flask import Flask, g, render_template, flash, redirect, url_for
from flask.ext.login import (LoginManager, current_user, login_user, 
                             login_required, logout_user)
from flask.ext.bcrypt import check_password_hash

import models
import forms

DEBUG = True
HOST = '0.0.0.0'
PORT = 8000

app = Flask(__name__)
app.secret_key = 'adjfdjfelnldjd23433.DJFLKDJhdjflkd(&*4545dfkjfwer'

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.get(models.User.id == int(userid))
  except models.DoesNotExist:
    return None


@app.before_request
def before_request():
  """Connect to the database before each request."""
  g.db = models.DATABASE
  g.db.connect()
  g.user = current_user


@app.after_request
def after_request(response):
  """Close the database connection after each request"""
  g.db.close()
  return response


@app.route('/register', methods=('GET', 'POST'))
def register():
  form = forms.RegisterForm()
  if form.validate_on_submit():
    flash("Thank you for registering!", "success")
    models.User.create_user(
      username=form.username.data,
      email=form.email.data,
      password=form.password.data
    )
    return redirect(url_for('index'))
  return render_template('register.html', form=form)


@app.route('/login', methods=('GET', 'POST'))
def login():
  form = forms.LoginForm()
  if form.validate_on_submit():
    try:
      user = models.User.get(models.User.email == form.email.data)
    except models.DoesNotExist:
      flash("Your email or password doesn't match!", "error")
    else:
      if check_password_hash(user.password, form.password.data):
        login_user(user)
        flash("You've been logged in!", "success")
        return redirect(url_for('index'))
      else:
        flash("Your email or password doesn't match!", "error")
  return render_template('login.html', form=form)


@app.route('/logout')
@login_required
def logout():
  logout_user()
  flash("You've been logged out! Come back soon!", "success")
  return redirect(url_for('index'))


@app.route('/taco', methods=('GET', 'POST'))
@login_required
def taco():
  form = forms.TacoForm()
  if form.validate_on_submit():
    models.Taco.create(user=g.user.id, #_get_current_object()
                       protein=form.protein.data.strip(),
                       shell=form.shell.data.strip(),
                       chesse=form.chesse.data,
                       extras=form.extras.data.strip()
                      )
    flash("Your taco has been posted. Thanks!", "success")
    return redirect(url_for('index'))
  return render_template('taco.html', form=form)


@app.route('/')
def index():
  form = models.Taco.select(100)
  return render_template('index.html', tacos=form)
  #return 'Hey!'

"""if __name__ == '__main__':
  models.initialize()
  try:
    models.User.create_user(
      username ='diegoSalas',
      email ='diegosalas00@hotmail.com',
      password ='password',
      admin = True
    )
  except ValueError:
    pass
  app.run(debug=DEBUG, host=HOST, port=PORT)"""
models.py
import datetime

from flask.ext.bcrypt import generate_password_hash
from flask.ext.login import UserMixin
from peewee import *

DATABASE = SqliteDatabase('python.db')

class User(UserMixin, Model):
  username = CharField(unique=True)
  email = CharField(unique=True)
  password = CharField(max_length=100)
  joined_at = DateTimeField(default=datetime.datetime.now)
  is_admin = BooleanField(default=False)

  class Meta:
    database = DATABASE
    order_by = ('-joined_at',)

  def get_taco(self):
    return Taco.select().where(Taco.user == self)

  def get_stream(self):
    return Taco.select().where(
      (Taco.user << self.following()) |
      (Taco.user == self)
    )

  def following(self):
    """The user we are following."""
    return(
      User.select().join(
        Relationship, on=Relationship.to_user
      ).where(
        Relationship.from_user==self
    ))

  @classmethod
  def create_user(cls, username, email, password, admin=False):
    try:
      with DATABASE.transaction():
        cls.create(
          username=username,
          email=email,
          password=generate_password_hash(password),
          is_admin=admin
        )
    except IntegrityError:
      raise ValueError("User already exist")


class Taco(Model):
  timestamp = DateTimeField(default=datetime.datetime.now)
  user = ForeignKeyField(
    rel_model=User,
    related_name='tacos'
  )
  protein = CharField(max_length=100)
  chesse = BooleanField()
  shell = CharField(max_length=100)
  extras = TextField()

  class Meta:
    database = DATABASE
    ordered_by = ('-timestamp',)


'''class Relationship(Model):
  from_user = ForeignKeyField(User, related_name='relationships')
  to_user = ForeignKeyField(User, related_name='related_to')

  class Meta:
    database = DATABASE
    indexs = (
      (('from_user', 'to_user'), True)
    )'''


def initialize():
  DATABASE.connect()
  DATABASE.create_tables([User, Taco], safe=True)
  DATABASE.close()
forms.py
from flask_wtf import Form
from wtforms import StringField, PasswordField, TextAreaField, BooleanField
from wtforms.validators import (DataRequired, Regexp, Email, ValidationError,
                                Length, EqualTo)

from models import User


def name_exists(form, field):
  if User.select().where(User.username == field.data).exists():
    raise ValidationError('User with that name already exists.')


def email_exists(form, field):
  if User.select().where(User.username == field.data).exists():
    raise ValidationError('User with that name already exists.')


class RegisterForm(Form):
  username = StringField(
    'Username',
    validators=[
      DataRequired(),
      Regexp(
        r'^[a-zA-Z0-9_]+$',
        message=("Username should be one word, letters, "
                 "numbers, and underscores only.")
      ),
      name_exists
    ])
  email = StringField(
    'Email',
    validators=[
      DataRequired(),
      Email(),
      email_exists
    ])
  password = PasswordField(
    'Password',
    validators=[
      DataRequired(),
      Length(min=4),
      EqualTo('password2', message='Password must match')
    ])
  password2 = PasswordField(
    'Confirm Password',
    validators=[DataRequired()]
  )

class LoginForm(Form):
  email = StringField('Email', validators=[DataRequired(), Email()])
  password = PasswordField('Password', validators=[DataRequired()])


class TacoForm(Form):
  """Create a Form to order a taco"""
  protein = StringField("Meat?, Chicken?, Pork?, Veggie?", validators=[DataRequired()])
  shell = StringField("Corn?, Wheat?, Crispy?, Soft?", validators=[DataRequired()])
  chesse = BooleanField("Cheese?", default=True)
  extras = StringField("Anything Else?", validators=[DataRequired()])
templates/layout.html
<!doctype html>
<html>
  <head>
    <title>Tacocat</title>
    <link rel="stylesheet" href="/static/css/normalize.css">
    <link rel="stylesheet" href="/static/css/skeleton.css">
    <link rel="stylesheet" href="/static/css/tacocat.css">
  </head>
  <body>
    {% with messages=get_flashed_messages() %}
    {% if messages %}
        <div class="messages">
          {% for message in messages %}
          <div class="message">
            {{ message }}
          </div>
          {% endfor %}
        </div>
    {% endif %}
    {% endwith %}

    <div class="container">
      <div class="row">
        <div class="u-full-width">
          <nav class="menu">
          <!-- menu goes here -->
            <!--<a href="{{ url_for('register') }}">Sign Up</a>
            <a href="{{ url_for('login') }}">Sign In</a>
            {% if current_user.is_authenticated() %}
            <a href="{{ url_for('taco') }}">Create a Taco</a>
            <a href="{{ url_for('logout') }}">Sign Out</a>
            {% endif %}-->
            {% if current_user.is_authenticated() %}
            <a href="{{ url_for('taco') }}">Add a New Taco</a>
            <a href="{{ url_for('logout') }}">Log Out</a>
            {% else %}
            <a href="{{ url_for('login') }}">Log In</a>
            <a href="{{ url_for('register') }}">Sign Up</a>
            {% endif %}
          </nav>
          {% block content %}{% endblock %}
        </div>
      </div>
      <footer>
        <p>An MVP web app made with Flask on <a href="http://teamtreehouse.com">Treehouse</a>.</p>
      </footer>
    </div>
  </body>
</html>
templates/index.html
{% extends 'layout.html' %}

{% block content %}
<h2>Tacos</h2>
    {% if tacos.count() %}
        <table class="u-full-width">
          <thead>
            <tr>
              <th>Protein</th>
              <th>Cheese?</th>
              <th>Shell</th>
              <th>Extras</th>
            </tr>
          </thead>
          <tbody>
        {% for taco in tacos %}
            <tr>
              <!-- taco attributes here -->
              <td>{{ taco.protein }}</td>
              <td>{{ taco.meat }}</td>
              <td>{{ taco.shell }}</td>
              <td>{{ taco.extras }}</td>
            </tr>
        {% endfor %}
          </tbody>
        </table>
    {% else %}
        <!-- message for missing tacos -->
        <p>No tacos yet.</p>
    {% endif %}
{% endblock %}

1 Answer

David Lin
David Lin
35,864 Points

Hi Diego Salas -

Try deleting your python.db file.

If the datatbase file was created and afterwards you modified or added any model fields, then the new fields won't be recognized in the database. Deleting the .db file will recreate a new one on start-up and hopefully fix the issue.

Hope that helps!