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)
Jeff MudayTreehouse 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