Changes between Version 6 and Version 7 of P8

Timestamp:

05/18/26 21:18:36 (8 days ago)

Author:

211171

Comment:

--

P8

@@ -604 +604 @@
 }}}
 
-== Isolation Levels ==
-=== Overview ===
-Isolation defines how concurrent transactions behave.
-
-Problems prevented:
-
-* Dirty reads
-* Non-repeatable reads
-* Phantom reads
-* Lost updates
-
-=== Levels ===
-
-* READ COMMITTED – basic reads
-* REPEATABLE READ – RSVP consistency
-* SERIALIZABLE – full booking + budget validation
-
-=== SQLAlchemy ===
-{{{
-db.session.execute(text('SET TRANSACTION ISOLATION LEVEL SERIALIZABLE'))
-}}}
-
-== Connection Pooling ==
-=== Why needed ===
-Pooling reuses DB connections instead of creating new ones per request.
-
 === Flask Implementation ===
 {{{
@@ -688 +662 @@
 === Explanation ===
 begin_nested() creates a database savepoint. If the band booking fails, only the operations after the savepoint are rolled back while earlier successful inserts remain intact.
+
+== Isolation Levels ==
+=== Overview ===
+Isolation defines how concurrent transactions behave.
+
+Problems prevented:
+
+* Dirty reads
+* Non-repeatable reads
+* Phantom reads
+* Lost updates
+
+=== Levels ===
+
+* READ COMMITTED – basic reads
+* REPEATABLE READ – RSVP consistency
+* SERIALIZABLE – full booking + budget validation
+
+=== SQLAlchemy ===
+{{{
+db.session.execute(text('SET TRANSACTION ISOLATION LEVEL SERIALIZABLE'))
+}}}
+
+== Connection Pooling ==
+=== Why needed ===
+Pooling reuses DB connections instead of creating new ones per request.
 
 === Affected endpoints ===