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

Gilang Ilhami
Gilang Ilhami
12,045 Points

Python for database, tables we're not created

When i try i typed is 'ls', students.db was not created

treehouse:~/workspace$ python students.py                                                        
treehouse:~/workspace$ python students.py                                                        
treehouse:~/workspace$ ls                                                                        
students.py                                                                                      
treehouse:~/workspace$

I wonder if it's the codes or that i haven't connect something

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.connnect()
    db.create_tables([Student], safe=True)

2 Answers

Hi Gilang

The only bit of your code that stands out is the bit where you check to see if the current file is being run.

# its not __main--   its __main__

if __name__=='__main__':# change --  to __
    db.connnect()
    db.create_tables([Student], safe=True)

try this and see if it works

Gilang Ilhami
Gilang Ilhami
12,045 Points

Hey Andreas, thank you very much for the help

I had an error though

treehouse:~/workspace$ python students.py                                                        
Traceback (most recent call last):                                                               
  File "students.py", line 13, in <module>                                                       
    db.connnect()                                                                                
AttributeError: 'SqliteDatabase' object has no attribute 'connnect'                              
treehouse:~/workspace$                                                                           

Hi Gilang

I did not spot it, but you have a typo. should be connect and connnect.

if __name__=='__main__':# change --  to __
    db.connect() # change connnect to connect
    db.create_tables([Student], safe=True)