Method Commit

internal/database/db.go:403–414

Commit commits the transaction and releases the writer mutex if this is a write transaction. Also promotes any transaction-prepared statements to the DB cache for future use. On failure, the transaction remains active - caller must call Rollback() to release the mutex.

()

// Also promotes any transaction-prepared statements to the DB cache for future use.
// On failure, the transaction remains active - caller must call Rollback() to release the mutex.
func (t *Tx) Commit() error {
	err := t.tx.Commit()
	if err == nil {
		// Commit succeeded - promote statements to cache
		t.promoteStatementsToCache()
		// Release mutex only on successful commit (for write transactions)
		if t.unlockFn != nil {
			t.unlockOnce.Do(t.unlockFn)
		}
	}
	return err
}

// Rollback rolls back the transaction and releases the writer mutex if this is a write transaction.
// Always releases the mutex since the transaction is done (either rolled back successfully,