Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

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)