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 trialDiego Salas Polar
21,431 PointsI 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?
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)"""
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()
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()])
<!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>
{% 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
35,864 PointsHi 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!