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 Using Databases in Python Meet Peewee Modeling

Posted by jahabeebs
jahabeebs
3,804 Points

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 28,716 Points
Jeff Muday
Jeff Muday
Treehouse Moderator 28,716 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

jahabeebs
jahabeebs
3,804 Points

That video helped me figure it out. Thank you!