From 6b5c87d5c35ebbac6f7fbcac1a722bd0b3148e04 Mon Sep 17 00:00:00 2001 From: Michaël Ball Date: Sun, 9 Aug 2015 14:44:55 +0100 Subject: Improve performance - introduce transactions --- models/album.py | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'models/album.py') diff --git a/models/album.py b/models/album.py index b2625db..216b615 100644 --- a/models/album.py +++ b/models/album.py @@ -24,6 +24,8 @@ class Album(): for track in self.tracks: track.delete() + cursor.execute("BEGIN TRANSACTION") + delete_sql = "DELETE FROM album WHERE id = ?" cursor.execute(delete_sql, (self.id,)) @@ -33,6 +35,8 @@ class Album(): delete_artist_rel_sql = "DELETE FROM album_artist WHERE album_id = ?" cursor.execute(delete_artist_rel_sql, (self.id,)) + cursor.execute("COMMIT TRANSACTION") + return True @property -- cgit v1.2.3