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 Create Table

Farbod Jahan
Farbod Jahan
1,993 Points
Posted by Farbod Jahan
Farbod Jahan
1,993 Points

Getting sqlite to work with Pycharm

So I have peewee installed (pip peewee) and I also have sqllite installed (put it in a directory was able to call on it with cmd prompt) when I run the script though that kenneth wrote I get errors meaning its not connecting to the database. What else do I have to do to get it to work?

tables.py 
from peewee import *
db = SqliteDatabase('challenges.db')

class Challenge(Model):
    name = Charfield(max_length=100, unique=True

1 Answer

Benjamin Lange
Benjamin Lange
16,178 Points
Benjamin Lange
Benjamin Lange
16,178 Points

When setting up your models with Peewee, you need to add a class Meta to each model. Add this to your class Challenge. Then, in the class Meta set database = db. This tells Peewee to use the Sqlite database you defined at the top for that class.

from peewee import *
db = SqliteDatabase('challenges.db')

class Challenge(Model):
    name = Charfield(max_length=100, unique=True

    class Meta:
        database = db