database rows not updating

Question

Hi, I have the lesson copied out in sublime text and am able to create tables and rows using this code. However, when I change the dictionary point values, save, and rerun the file through the terminal, the database is not updating with the new points values.

Interestingly...when I go into mysqlworkbench and drop the table, I can get the python to create a new table with the right users and vales. Obviously there's something wrong in the except block. Help?

Here's my code.

from peewee import *
from playhouse.db_url import connect

#db = MySQLDatabase('students.db')
db = connect('mysql://root:Purple12!@localhost:3306/python_work')


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

    class Meta:
        database = db


students = [
    {'username': 'kennethlove',
    'points': 888},
    {'username': 'oscargrouch',
    'points': 8000},
    {'username': 'jokenston2',
    'points': 7346},
    {'username': 'twoheadedcow',
    'points': 1983},
    {'username': 'giantman',
    'points': 250}
]

def add_students():
    try:
        for student in students:
            Student.create(username=student['username'],
                        points=student['points'])
    except IntegrityError:
        student_record = Student.get(username=student['username'])
        student_record.points = student['points']
        student_record.save()

def top_student():
    student = Student.select().order_by(Student.points.desc()).get()
    return student.username



if __name__ == '__main__':
    db.connect()
    db.create_tables([Student], safe = True)
    add_students()
    print("Our top student right now is: {}." .format(top_student()))

Answer 1 · 2016-07-08T13:08:21Z

July 8, 2016 1:08pm

I found it!!

The progression through the dictionary was inside the try block. Updated (working!) code is as follows:

def add_students():
    for student in students:
        try:
            Student.create(username=student['username'],
                            points=student['points'])
        except IntegrityError:
            student_record = Student.get(username=student['username'])
            student_record.points = student['points']
            student_record.save()

Welcome to the Treehouse Community

Looking to learn something new?

Beth Singley

Beth Singley

database rows not updating

1 Answer

Beth Singley

Beth Singley