let’s say we want to find students who are enrolled in math class: for student in Student.select().join(StudentCourse).join(Course).where( name='math'): print student.name You could also express this this as: for student in Student.filter(studentcourse_set__course__name='math'): print student.name To query what classes a given student is enrolled in: for course in Course.select().join(StudentCourse)

let’s say we want to find students who are enrolled in math class: for student in Student.select().join(StudentCourse).join(Course).where(name=’math’): print student.name You could also express this as: as: for student in Student.filter(studentcourse_set__course__name=’math’): print student.name To query what classes a given student is enrolled in: for course in Course.select().join(StudentCourse)

say we want to find students who are enrolled in math class: for student in Student.select().join(StudentCourse).join(Course).where(Course.name == ’math’): print student.name To query what classes a functions can be used to calculate counts and sums over rows, perform string manipulations, do complex math, and more. There are a lot of functions. To express functions in peewee, use the fn object. The way

let’s say we want to find students who are enrolled in math class: for student in Student.select().join(StudentCourse).join(Course).where( name='math'): print student.name You could also express this this as: for student in Student.filter(studentcourse_set__course__name='math'): print student.name To query what classes a given student is enrolled in: for course in Course.select().join(StudentCourse)

let’s say we want to find students who are enrolled in math class: for student in Student.select().join(StudentCourse).join(Course).where(name=’math’): print student.name You could also express this as: as: for student in Student.filter(studentcourse_set__course__name=’math’): print student.name To query what classes a given student is enrolled in: for course in Course.select().join(StudentCourse)

find students who are enrolled in math class: query = (Student .select() .join(StudentCourse) .join(Course) .where(Course.name == 'math')) for student in query: print(student can register individual groups. This will just # register the DATE and MATH groups of functions. register_groups(db, 'DATE', 'MATH') # If you only wish to register, say, the aggregate functions for a # the toggle() function. clear_settings() Clears all state associated with the setting() function. MATH randomrange(start[, stop=None[, step=None]]) start (int) – Start of range (inclusive) end (int)

find students who are enrolled in math class: query = (Student .select() .join(StudentCourse) .join(Course) .where(Course.name == 'math')) for student in query: print(student can register individual groups. This will just # register the DATE and MATH groups of functions. register_groups(db, 'DATE', 'MATH') # If you only wish to register, say, the aggregate functions for a # the toggle() function. clear_settings() Clears all state associated with the setting() function. MATH randomrange(start[, stop=None[, step=None]]) start (int) – Start of range (inclusive) end (int)

find students who are enrolled in math class: query = (Student .select() .join(StudentCourse) .join(Course) .where(Course.name == 'math')) for student in query: print(student can register individual groups. This will just # register the DATE and MATH groups of functions. register_groups(db, 'DATE', 'MATH') # If you only wish to register, say, the aggregate functions for a # the toggle() function. clear_settings() Clears all state associated with the setting() function. MATH randomrange(start[, stop=None[, step=None]]) start (int) – Start of range (inclusive) end (int)

find students who are enrolled in math class: query = (Student .select() .join(StudentCourse) .join(Course) .where(Course.name == 'math')) for student in query: print(student can register individual groups. This will just # register the DATE and MATH groups of functions. register_groups(db, 'DATE', 'MATH') # If you only wish to register, say, the aggregate functions for a # the toggle() function. clear_settings() Clears all state associated with the setting() function. MATH randomrange(start[, stop=None[, step=None]]) start (int) – Start of range (inclusive) end (int)

course = ForeignKeyField(Course) To query, let’s say we want to find students who are enrolled in math class: query = (Student .select() .join(StudentCourse) (continues on next page) 78 Chapter 1. Contents: Documentation, Release 3.5.0 (continued from previous page) .join(Course) .where(Course.name == 'math')) for student in query: print(student.name) To query what classes a given student is enrolled can register individual groups. This will just # register the DATE and MATH groups of functions. register_groups(db, 'DATE', 'MATH') # If you only wish to register, say, the aggregate functions for a #