Getting error after creating and entry. :(

Question

After inputing a blob of text and pressing ctrl+d, the program asks me if I wanna save it. After entering 'y', I get this error:

Do you wanna save it? [Yn]y                                                                                                                       
Traceback (most recent call last):                                                                                                                
  File "/usr/local/pyenv/versions/3.6.4/lib/python3.6/site-packages/peewee.py", line 2780, in execute_sql                                         
    cursor.execute(sql, params or ())                                                                                                             
sqlite3.OperationalError: table entry has no column named content                                                                                 

During handling of the above exception, another exception occurred:                                                                               

Traceback (most recent call last):                                                                                                                
  File "./diary.py", line 89, in <module>                                                                                                         
    menu_loop()                                                                                                                                   
  File "./diary.py", line 42, in menu_loop                                                                                                        
    menu[choice]()                                                                                                                                
  File "./diary.py", line 56, in add_entry                                                                                                        
    Entry.create(content=data)                                                                                                                    
  File "/usr/local/pyenv/versions/3.6.4/lib/python3.6/site-packages/peewee.py", line 3587, in create                                              
    inst.save(force_insert=True)                                                                                                                  
  File "/usr/local/pyenv/versions/3.6.4/lib/python3.6/site-packages/peewee.py", line 3719, in save                                                
    pk_from_cursor = self.insert(**field_dict).execute()                                                                                          
  File "/usr/local/pyenv/versions/3.6.4/lib/python3.6/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.6.4/lib/python3.6/site-packages/peewee.py", line 2172, in _execute                                            
    return self.database.execute_sql(sql, params, self.require_commit)                                                                            
  File "/usr/local/pyenv/versions/3.6.4/lib/python3.6/site-packages/peewee.py", line 2788, in execute_sql                                         
    self.commit()                                                                                                                                 
  File "/usr/local/pyenv/versions/3.6.4/lib/python3.6/site-packages/peewee.py", line 2657, in __exit__                                            
    reraise(new_type, new_type(*exc_value.args), traceback)                                                                                       
  File "/usr/local/pyenv/versions/3.6.4/lib/python3.6/site-packages/peewee.py", line 115, in reraise                                              
    raise value.with_traceback(tb)                                                                                                                
  File "/usr/local/pyenv/versions/3.6.4/lib/python3.6/site-packages/peewee.py", line 2780, in execute_sql                                         
    cursor.execute(sql, params or ())                                                                                                             
peewee.OperationalError: table entry has no column named content

I went back and look at my code because it says that there is no column named content. It doesn't make sense to me because there is the content atribute in the Entry(Model) class.

Here's the code:

from collections import OrderedDict
import datetime
import sys

from peewee import *

db = SqliteDatabase('diary.db')

class Entry(Model):
    content = TextField()
    timestamp = DateTimeField(datetime.datetime.now)

    class Meta:
        database = db


def initialize():
    """Create the database and the table if they don't exist"""
    db.connect()
    db.create_tables([Entry], safe=True)

def menu_loop():
    """Show 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. Press ctrl+d when finished.')
    data = sys.stdin.read().strip()

    if data:
        if input('Do you wanna save it? [Yn]').lower() != 'n':
            Entry.create(content=data)
            print('Your content was saved successfully!')


def view_entries():
    """View previous entries"""
    entries = Entry.select().order_by(Entry.timestamp.desc())

    for entry in entries:
        timestamp = entry.timestamp.strftime('%A %B %d, %Y %I:%M%p')
        print(timestamp)
        print('=' * len(timestamp))
        print(entry.content)
        print('n) for next entry')
        print('q) return to main menu')

        next_action = input('Action: [Nq]  ').lower().strip()
        if next_action == 'q':
            break

def delete_entry(entry):
    """Delete an entry"""

menu = OrderedDict([
    ('a', add_entry),
    ('v', view_entries)
])

if __name__ == "__main__":
    initialize()
    menu_loop()

Answer 1 · 2019-04-03T00:48:52Z

April 3, 2019 12:48am

Don't know if this will make a difference but the code in the workspace is:

timestamp = DateTimeField(default=datetime.datetime.now)

Update: I did a test where I removed default= and got the same error as you

Answer 2 · 2019-04-02T23:07:05Z

April 2, 2019 11:07pm

I used your code with a workspace launched from the video and it seems ok. I was able to add and view entries. Try deleting diary.db then re-run your program.

Answer 3 · 2019-05-19T21:46:44Z

May 19, 2019 9:46pm

I get this same error and I have no idea what the issue is

Answer 4 · 2020-06-19T16:47:16Z

June 19, 2020 4:47pm

Is there any follow up to this? I am getting the same issue with my code: https://w.trhou.se/2xwsziuuqw ignore the comments I've checked and checked and can't find any typos or anything like that

Welcome to the Treehouse Community

Looking to learn something new?

Ewerton Luna

Ewerton Luna

Getting error after creating and entry. :(

4 Answers

KRIS NIKOLAISEN

KRIS NIKOLAISEN

Ewerton Luna

Ewerton Luna

KRIS NIKOLAISEN

KRIS NIKOLAISEN

Ewerton Luna

Ewerton Luna

Abraham Yeransian

Abraham Yeransian

Pete Webb

Pete Webb