f2 = Footballer() m1 = Match() m2 = Match() f1.id = 1 f1.name = "nfname1" f1.match_fk = [m1, m2] f2.id = 2 f2.name = "fname2" f2.match_fk = [m1, m2] m1.id = 1 m1.player_fk = [f1, f2] m2.id = 2 m2.player_fk = [f1, f2] m.multi_insert([f1, f2, m1, m2]) find = m.find_by_id(Match(), 1) print("\nI found a match:", find.id, find.player_fk[0].id, find.player_fk[0].name, "\n") m.delete(f1) m.delete(f2) m.delete(m1) m.delete(m2) m.close()
a1.person_fk = p m.insert(p) m.insert(a1) m.insert(c) # m.insert(c2) m.delete(c) # m.delete(c2) m.delete(a1) m.delete(p) # EXAMPLE 3 ########################## simple multi insert ##################################################### # multi insert is used for inserting objects with many to many relation m.multi_insert([p, a1, c]) m.delete(c) m.delete(a1) m.delete(p) # EXAMPLE 4 ########################## simple multi insert for ManyToMany relation ########################### m.multi_insert([actor1, actor2, film1, film2]) film2.id = 222 m.update(film2) m.delete(actor1) m.delete(actor2) m.delete(film1) m.delete(film2)