Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Python Using Databases in Python Meet Peewee Modeling

Syntax error thrown when entering sqlite3 students.db

I've been trying to use Spyder for this exercise and I successfully installed peewee into my environment. When I enter 'ls' in the console it returns the name of my database successfully (DatabasePractice.py* students.db). However, for some reason entering 'sqlite3 students.db' in my console throws a syntax error. Can anyone offer suggestions please :)? I've checked for typos and can't find anything. I've attached my code below:

from peewee import *

db = SqliteDatabase('students.db')


class Student(Model):
    username = CharField(max_length=255, unique=True)
    points = IntegerField(default=0)

    class Meta:
        database = db

if __name__ == '__main__':
    db.connect()
    db.create_tables([Student], safe=True)

1 Answer

Jeff Muday
MOD
Jeff Muday
Treehouse Moderator 27,586 Points

The code you supplied is syntactically correct. Good job.

The command 'sqlite3 students.db' is invoking the sqlite program on the database. If you don't have sqlite installed or if it is not in your current path, you will get an error.

check this link out. https://teamtreehouse.com/library/creating-a-database

That video helped me figure it out. Thank you!