Python Using Databases in Python Meet Peewee Modeling

jahabeebs
jahabeebs
3,749 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 24,891 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,749 Points

That video helped me figure it out. Thank you!