Repeating this course outside of workspaces using Visual Studio

Ok I tried a couple things and got it to function correctly. I moved everything out of the separate students.py file I created to store students class. I moved all code back to the file I initially created in Visual Studio called PythonDatabaseCourse.py. In that py file I now have the Student Class. Everything works like normal. I added all the rest of the code from the end of this part of the course and everything works find.

from peewee import *

#from peewee import SqliteDatabase, Model
#from peewee import CharField, DateTimeField, BooleanField, TextField, ForeignKeyField, IntegerField
#from peewee import IntegrityError

db = SqliteDatabase('Students.db')
class Student(Model):
    username = CharField(max_length=255, unique=True)
    points = IntegerField(default=0)

    class Meta:
        database = db

students = [
    {'username': 'kennethlove',
     'points': 154888},
    {'username': 'chalkers',
     'points': 11912},
    {'username': 'joykesten2',
     'points': 7363},
    {'username': 'craigdennis',
     'points': 4079},
    {'username': 'davemcfarland',
     'points': 14747}
]

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()

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 right now is : {0.username}.".format(top_student()))

My big hang up here the whole time is my lack of understanding about how to break out classes into different .py files in Visual Studio and then call them from the main py file. I'll have to do more research on that topic but hopefully this helps future students interested in giving Visual Studio a try. Thanks for playing along, Jo S!

I think you placed the import statements in the wrong spot. import statements should be placed at the very beginning of your file (or module), ie at 'module level'.

Your import statements are inside the class Student block and indented. Take them out and place them on the first line of your file.

That should allow you to use "from peewee import *" as well.

I don't have Visual Studio to test this, but pls let me know if it worked.

What exactly do you mean by it bounces me to the students class? And why are you importing students? Where is the db = SqliteDatabase line located in your code?

It's probably easiest if you post the full code and the full error message to clarify

also why do you have this line?

class students(object):

I am glad this worked. I deliberately didn't give you full explanations about what the specific errors are and what the script should be explicitly so that you can research it by yourself.

I suggest you look up these things:

1) if name == 'main': what does this mean/do?

2) what does indentation mean/do in python?

You can look it up on Google or rewatch the basic python modules from Kenneth, I'm pretty sure he goes through the explanations - but I can't remember exactly in which videos.

mattmilanowski If you don't mind, could you pls select my previous comment as the Best Answer ? Thanks!