Skip to content

An active record implementation for a gradebook with students, assignments, and grades. Uses Python and SQLite.

License

Notifications You must be signed in to change notification settings

ChrisTM/Active-Record-Example-for-a-Gradebook

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

To play around with the active record interface for this gradebook schema, we
must first create the database. In an interactive python terminal (either
"ipython model.py" or "python -i model.py"), run the following:

>>> db.init_db()

That will initialize the database with the schema in the file 'schema.sql' and
the data in 'testdata.sql'. Now try out some of these:

>>> Students.all()
>>> [s.full_name for s in Student.all()]
>>> Student.get(1).get_grades()
>>> Assignment.get(1)
>>> Assignment.where(points=20)

It is a useful exercise to uncomment line 68 of model.py to enable logging and
see the SQL that the program executes to fulfill these requests.

About

An active record implementation for a gradebook with students, assignments, and grades. Uses Python and SQLite.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published