Check student points before update

Question

Hi all!

As mentioned in this video lesson, when creating the try & except and getting the student record, I am trying to add an if statement to check if the points have changed. If they remained unchanged then nothing should happen.

I've been trying to give it a go with an if statement as per below, but I am getting an invalid syntax error at the line: if student_record.points == student['points'].

I'm sure the answer is pretty straightforward but I am not seeing the light at this point. :D

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'])
            if student_record.points == student['points']
                pass
            else:
                student_record.points = student['points']
                student_record.save()

I've also tried it the other way around:

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'])
            if student_record.points not == student['points']
                student_record.points = student['points']
                student_record.save()
            else:
                pass

Answer 1 · 2016-06-07T20:09:27Z

June 7, 2016 8:09pm

Hi Nathan,

Many thanks for your swift reply. You're suggestion of using != actually seemed to have worked. I wonder however why the == was giving a syntax error.

I'm only trying to implement what Kenneth implied would be a good thing to try to do, instead of just overwriting the same value. My code should be identical as in the video except where I try to inplement an IF statement to check if the value is identical or not. For reference, I included the code in full here:

from peewee import *


import sqlite3


db = SqliteDatabase('students.db')

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

    class Meta:
        database = db


students = [
    {'username': 'kevinjacobs',
    'points': 4488},
    {'username': 'chalkers',
    'points': 11561},
    {'username': 'joykesten2',
    'points': 7363},
    {'username': 'craigsdennis',
    'points': 4079},
    {'username': 'davemcfarland',
    'points': 45468},
]


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'])
            if student_record.points != student['points']:
                student_record.points = student['points']
                student_record.save()

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

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

Welcome to the Treehouse Community

Looking to learn something new?

Unsubscribed User

Unsubscribed User

Check student points before update

Nathan Tallack

Nathan Tallack

1 Answer

Unsubscribed User

Unsubscribed User

Nathan Tallack

Nathan Tallack