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
