assert sql == orm
session = Session()
def tester():
#List, for every boat, the number of times it has been reserved,
#excluding those boats that have never been reserved (list the id and the name).
orm_2 = session.query(
Boats.bid, Boats.bname,
func.count('reserves.sid')).filter(Boats.bid == Reserves.bid)
sql_2 = "SELECT b.bid, b.bname, count(r.sid) as TRserved FROM boats b JOIN reserves r ON b.bid = r.bid ;"
checker(sql_2, orm_2)
#Find the average age of sailors with a rating of 10.
orm_7 = session.query(func.avg(
Sailors.age)).filter(Sailors.rating == 10).all()
sql_7 = "SELECT avg(s.age) from sailors s where s.rating = 10;"
checker(sql_7, orm_7)
if __name__ == "__main__":
tester()
session.commit()
session.close()
