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 trialJonathan Fernandes
Courses Plus Student 22,784 PointsError raised when trying to save the entry
So I am working on workspaces and following along. After I watched this video, I tried to run it.
Everything works including pressing 'n' to cancel, but when I try to hit a key to continue, I get this error:
Traceback (most recent call last):
File "7_add-entry.py", line 67, in <module>
menu_loop()
File "7_add-entry.py", line 36, in menu_loop
menu[choice]()
File "7_add-entry.py", line 47, in add_entry
Entry.create(contents=data)
File "/usr/local/pyenv/versions/3.4.1/lib/python3.4/site-packages/peewee.py", line 3587, in create
inst.save(force_insert=True)
File "/usr/local/pyenv/versions/3.4.1/lib/python3.4/site-packages/peewee.py", line 3719, in save
pk_from_cursor = self.insert(**field_dict).execute()
File "/usr/local/pyenv/versions/3.4.1/lib/python3.4/site-packages/peewee.py", line 2610, in execute
return self.database.last_insert_id(self._execute(), self.model_class)
File "/usr/local/pyenv/versions/3.4.1/lib/python3.4/site-packages/peewee.py", line 2172, in _execute
return self.database.execute_sql(sql, params, self.require_commit)
File "/usr/local/pyenv/versions/3.4.1/lib/python3.4/site-packages/peewee.py", line 2788, in execute_sql
self.commit()
File "/usr/local/pyenv/versions/3.4.1/lib/python3.4/site-packages/peewee.py", line 2657, in __exit__
reraise(new_type, new_type(*exc_value.args), traceback)
File "/usr/local/pyenv/versions/3.4.1/lib/python3.4/site-packages/peewee.py", line 115, in reraise
raise value.with_traceback(tb)
File "/usr/local/pyenv/versions/3.4.1/lib/python3.4/site-packages/peewee.py", line 2780, in execute_sql
cursor.execute(sql, params or ())
peewee.IntegrityError: entry.content may not be NULL
Don't understand what is going on... please help.
[edit: formatting. --cf]
2 Answers
Chris Freeman
Treehouse Moderator 68,427 PointsThe traceback can be overwhelming, the key lines are:
File "7_add-entry.py", line 47, in add_entry
Entry.create(contents=data)
and
peewee.IntegrityError: entry.content may not be NULL
This is saying peewee
is trying to create a new database entry for "Entry", but the data
value provide in contents=data
is NULL
which violates a data integrity check performed by peewee
("may not be NULL") prior to writing the database.
The issue is why does data
have a NULL
value? Without seeing your code it's hard to guess. I suggest looking for code paths that do not initiate or use an uninitiated value for data
.
EDIT: Looking again at your code, I see the error more clearly.
In your code you are creating the new entry with:
Entry.create(contents=data)
However, the field name defined in the class Entry is "content" not "content*s*". It is complaining because you are setting contents
, but no value is being assigned to content
and is therefore NULL
which raises the error.
Jonathan Fernandes
Courses Plus Student 22,784 PointsHmm... not sure either...
One moment, I'll post my code:
#!/usr/bin/env python3
from collections import OrderedDict
import datetime
import sys
from peewee import * #notice third library imports are here and python's libraries are grouped together (good convention)
db = SqliteDatabase('journal.db')
class Entry(Model):
content = TextField()
timestamp = DateTimeField(default=datetime.datetime.now)
class Meta:
database = db
def initialize():
"""Create the database and the table if they don't exist already."""
db.connect()
db.create_tables([Entry], safe=True)
def menu_loop():
"""show me the menu"""
choice = None
while choice != 'q':
print('Enter "q" to quit')
for key, value in menu.items():
print('{}) {}'.format(key, value.__doc__))
choice = input('Action: ').lower().strip()
if choice in menu:
menu[choice]()
def add_entry():
"""Add an entry."""
print("Enter your entry and then press ctrl+D (ctrl+Z for windows users) when you are finished.")
data = sys.stdin.read().strip() #this reads what is on the screen and we strip it of surrounding white space
#now we check to make sure they actually entered something
if data:
if input("Save entry? [Press 'N' to cancel, press 'Enter' to continue] ").lower() != 'n':
Entry.create(contents=data)
print("Your entry has been saved!")
def view_entries():
"""View previous entries."""
def delete_entry(entry):
"""Delete an entry."""
menu = OrderedDict([
('a', add_entry),
('v', view_entries),
])
if __name__ == '__main__':
initialize()
menu_loop()
Jonathan Fernandes
Courses Plus Student 22,784 PointsI left my random notes on there so I hope that isn't a problem
Chris Freeman
Treehouse Moderator 68,427 PointsI see the error now. See my updated answer above.
Jonathan Fernandes
Courses Plus Student 22,784 PointsIt's always the little things... This is why people always work in teams is my assumption! Hahaha, thanks again!
Jonathan Fernandes
Courses Plus Student 22,784 PointsJonathan Fernandes
Courses Plus Student 22,784 PointsJust exported my file to the command shell for my windows machine, and it raises the same error...
Is this because I am using a conflicting version of Python?