def get_from(self, storage, obj_id): conn=storage.conn cur=conn.cursor() cur.execute(""" SELECT * FROM Students WHERE rowid=?""", (obj_id,)) data=cur.fetchone() name, doc, _=data s=Student(name=name, doc=int(doc)) s.sql_id=obj_id
def get_from(self, storage, obj_id): conn=storage.conn cur=conn.cursor() cur.execute("""SELECT * FROM Groups WHERE rowid=?""", (obj_id,)) rc=cur.fetchone() if rc: self.group.name=rc[0] cur.execute("""SELECT rowid,* FROM Students WHERE group_id=? """, (obj_id,)) rows=cur.fetchall() for srowid, name, doc, _ in rows: s=Student(name=name, doc=int(doc), group=self.group) s.sql_id=srowid self.group.sql_id=obj_id