python databases, cant create tables in postgres

Question

Heyo peoeple! :) so i'm at the python track and just started "Using databases in python"

i've followed the documentation prowided to setup postgres instead of Sqlite

but the code below only create a file called peewee.db and nothing in the database "python-development"

my platform is mac i have the newest version of postgres install thrue homebrew when loggin into the postgres console i can see my database python development with

\d

hovever when i mark the database and use :

\dt

to list the table it return "No relations found." also i can see that the data i just wrote end up in peewee.db

from peewee import *



db = PostgresqlDatabase(
    'python-development',  # Required by Peewee.
    user='teamtreehouse',  # Will be passed directly to psycopg2.
    password='12345',  # Ditto.
    host='localhost',  # Ditto.
)


class Student(Model):
    username = CharField(max_length=225, unique=True)
    points = IntegerField(default=0)

    class Meta:
        Database = db


if __name__ == '__main__':
    db.connect()
    Student.create_table()
    db.create_tables([Student], safe=True)
    Student.create(username='Adlex', points=4)
    db.close()

Answer 1 · 2017-03-20T15:18:48Z

March 20, 2017 3:18pm

so it turns out that the problem was that i did'nt lowercase the ´´´python datebase = db ´´´ in the meta class caussed the problem

Welcome to the Treehouse Community

Looking to learn something new?

Alexander Lausten

Alexander Lausten

python databases, cant create tables in postgres

1 Answer

Alexander Lausten

Alexander Lausten