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)
