[Skip to content](#main)

[→](/)

[![Avunu](/brand/avunu-logo.svg)![Avunu](/brand/avunu-logo-light.svg)](/)[Services](/services/)[Consulting](/services/consulting/)[ERP](/services/erp/)[Odoo](/services/erp/odoo/)[ERPNext](/services/erp/erpnext/)[Custom software](/services/custom-software/)[Devices & IoT](/services/devices-iot/)[Websites](/services/websites/)[Infrastructure](/services/infrastructure/)[Partners](/partners/)

[Work](/work/)[Open source](/open-source/)[Knowledge base](/kb/)[About](/about/)

[About Avunu](/about/)[Team](/about/team/)[Insights](/insights/)[Contact](/contact/)

[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

- [Services](/services/)[Consulting](/services/consulting/)
- [ERP](/services/erp/)
- [Odoo](/services/erp/odoo/)
- [ERPNext](/services/erp/erpnext/)
- [Custom software](/services/custom-software/)
- [Devices & IoT](/services/devices-iot/)
- [Websites](/services/websites/)
- [Infrastructure](/services/infrastructure/)
- [Partners](/partners/)

[Work](/work/)[Open source](/open-source/)[Knowledge base](/kb/)[About](/about/)

- [About Avunu](/about/)
- [Team](/about/team/)
- [Insights](/insights/)
- [Contact](/contact/)

[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

[Knowledge base](/kb/)[Frappe](/kb/frappe/)Testing on Live Databases

Search the knowledge basePress/

ESC

Jump to

[Browse the knowledge base](/kb/)[Frappe](/kb/frappe/)[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Databases](/kb/databases/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

↵select↑↓navigateescclose

Search the knowledge base

[Skip to the article](#kb-article)[Frappe](/kb/frappe/)20 articles

- [Overview](/kb/frappe/)
- [Bench Operations](/kb/frappe/bench-operations/)
- [Builder Page Scripts](/kb/frappe/builder-page-scripts/)
- [Client-Side Recipes](/kb/frappe/client-side-recipes/)
- [Common Query Patterns](/kb/frappe/common-query-patterns/)
- [Custom Field Controllers](/kb/frappe/custom-field-controllers/)
- [Custom Pages](/kb/frappe/custom-pages/)
- [Custom Views](/kb/frappe/custom-views/)
- [Customizations API](/kb/frappe/customizations-api/)
- [Customizing Grid Columns for Child Tables](/kb/frappe/customizing-grid-columns-child-tables/)
- [Doctype States & Status Fields](/kb/frappe/doctype-states-status-fields/)
- [Grandchild Table Fields](/kb/frappe/grandchild-table-fields/)
- [Portal Views](/kb/frappe/portal-views/)
- [Project Structure & Hooks](/kb/frappe/project-structure-hooks/)
- [Query Builder & PyPika Extensions](/kb/frappe/query-builder-pypika/)
- [Quick Entry Forms](/kb/frappe/quick-entry-forms/)
- [Script Reports](/kb/frappe/script-reports/)
- [Testing on Live Databases](/kb/frappe/testing-live-databases/)
- [Type Annotations & Controller Overrides](/kb/frappe/type-annotations-controller-overrides/)
- [Vite & TypeScript Compilation](/kb/frappe/vite-typescript-compilation/)
- [Web Forms](/kb/frappe/web-forms/)

Other sections[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Databases](/kb/databases/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

In Frappe: 20 articles

[Overview](/kb/frappe/)[Bench Operations](/kb/frappe/bench-operations/)[Builder Page Scripts](/kb/frappe/builder-page-scripts/)[Client-Side Recipes](/kb/frappe/client-side-recipes/)[Common Query Patterns](/kb/frappe/common-query-patterns/)[Custom Field Controllers](/kb/frappe/custom-field-controllers/)[Custom Pages](/kb/frappe/custom-pages/)[Custom Views](/kb/frappe/custom-views/)[Customizations API](/kb/frappe/customizations-api/)[Customizing Grid Columns for Child Tables](/kb/frappe/customizing-grid-columns-child-tables/)[Doctype States & Status Fields](/kb/frappe/doctype-states-status-fields/)[Grandchild Table Fields](/kb/frappe/grandchild-table-fields/)[Portal Views](/kb/frappe/portal-views/)[Project Structure & Hooks](/kb/frappe/project-structure-hooks/)[Query Builder & PyPika Extensions](/kb/frappe/query-builder-pypika/)[Quick Entry Forms](/kb/frappe/quick-entry-forms/)[Script Reports](/kb/frappe/script-reports/)[Testing on Live Databases](/kb/frappe/testing-live-databases/)[Type Annotations & Controller Overrides](/kb/frappe/type-annotations-controller-overrides/)[Vite & TypeScript Compilation](/kb/frappe/vite-typescript-compilation/)[Web Forms](/kb/frappe/web-forms/)

Other sections[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Databases](/kb/databases/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

FrappeTesting on Live Databases

Run Frappe integration tests against a live database safely by suppressing commits, patching side effects, and rolling back.

UpdatedMar 13, 2026

Tagsfrappetestingpythondatabase

Reading time4 min

On this page[The Core Problem](#the-core-problem)[The Solution: Commit Suppression](#the-solution-commit-suppression)[Patching External Side Effects](#patching-external-side-effects)[Saving and Restoring Critical State](#saving-and-restoring-critical-state)[Test Fixtures and Idempotent Setup](#test-fixtures-and-idempotent-setup)[Testing Guest/Public Access](#testing-guestpublic-access)[Testing Web Form Payment Flow](#testing-web-form-payment-flow)[Manual Cleanup Within Tests](#manual-cleanup-within-tests)[Running Tests](#running-tests)

Frappe integration tests run against the live database. This makes them powerful but dangerous — business logic often calls `frappe.db.commit()`, which permanently cements test data even if `tearDown` attempts a `rollback()`.

## The Core Problem

During normal operation, code paths like workflow actions, messaging group creation, and payment processing call `frappe.db.commit()`. When tests trigger these paths, the commit makes test artifacts permanent.

```text
Test creates Season → triggers validate() → validate() calls commit() → data is permanent
↓
tearDownClass calls rollback() → but commit already persisted the data!
```

## The Solution: Commit Suppression

Patch `frappe.db.commit` to a no-op for the duration of the test class:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">from</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> typing </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> Any</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">from</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> unittest.mock </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> MagicMock, patch</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">from</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.tests.classes </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> IntegrationTestCase</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">class</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">MyTestCase</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">IntegrationTestCase</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    _commit_patcher: Any </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">@</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">classmethod</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setUpClass</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(cls) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">super</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">().setUpClass()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Suppress all commits — rollback will actually undo everything</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> patch.object(frappe.db, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"commit"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, MagicMock())</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher.start()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.addClassCleanup(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher.stop)</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">@</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">classmethod</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">tearDownClass</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(cls) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        frappe.db.rollback()  </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Undo all test changes</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher.stop()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">super</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">().tearDownClass()</span>
```

With `commit` patched to a no-op, `rollback()` in `tearDownClass` actually undoes all changes made during tests.

## Patching External Side Effects

Tests shouldn't send real emails, create messaging groups, or trigger workflows. Patch these alongside the commit:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">from</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.email.doctype.notification.notification </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> Notification</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">from</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.workflow.doctype.workflow_action </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> workflow_action</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">from</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> messaging.messaging.custom.contact </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> Contact</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">class</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">AppTestCase</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">IntegrationTestCase</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    _commit_patcher: Any </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    _add_to_group_patcher: Any </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    _notification_send_patcher: Any </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    _workflow_email_patcher: Any </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">@</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">classmethod</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setUpClass</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(cls) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">super</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">().setUpClass()</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Patch commit</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> patch.object(frappe.db, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"commit"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, MagicMock())</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher.start()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.addClassCleanup(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher.stop)</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Patch messaging side effects</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._add_to_group_patcher </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> patch.object(</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            Contact, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"add_to_group"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, MagicMock()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        )</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._add_to_group_patcher.start()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.addClassCleanup(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._add_to_group_patcher.stop)</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Patch notification sending</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._notification_send_patcher </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> patch.object(</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            Notification, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"send"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, MagicMock()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        )</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._notification_send_patcher.start()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.addClassCleanup(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._notification_send_patcher.stop)</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Patch workflow email sending</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._workflow_email_patcher </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> patch.object(</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            workflow_action, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"send_workflow_action_email"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, MagicMock()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        )</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._workflow_email_patcher.start()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.addClassCleanup(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._workflow_email_patcher.stop)</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">@</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">classmethod</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">tearDownClass</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(cls) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        frappe.db.rollback()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher.stop()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">super</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">().tearDownClass()</span>
```

## Saving and Restoring Critical State

If business logic modifies shared state via direct SQL (outside the ORM), save and restore it:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">save_current_season</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">() -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">str</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">|</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    val </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.db.get_value(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Season"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"current"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">str</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(val) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> val </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">else</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">restore_current_season</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(original_name: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">str</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">|</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">not</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> original_name:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    current </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.db.get_value(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Season"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"current"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> current </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">==</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> original_name:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    frappe.db.sql(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"UPDATE `tabSeason` SET `current` = 0 WHERE `current` = 1"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    frappe.db.set_value(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Season"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, original_name, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"current"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">update_modified</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">False</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    frappe.db.commit()  </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Real commit — patch is stopped by now</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">class</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">AppTestCase</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">IntegrationTestCase</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    _original_current_season: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">str</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">|</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">@</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">classmethod</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setUpClass</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(cls) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">super</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">().setUpClass()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._original_current_season </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> save_current_season()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># ... start patches</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">@</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">classmethod</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">tearDownClass</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(cls) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        frappe.db.rollback()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._commit_patcher.stop()  </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Stop commit patch BEFORE restoring</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        restore_current_season(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">cls</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._original_current_season)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">super</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">().tearDownClass()</span>
```

**Order matters:** Stop the commit patcher *before* restoring state, so the restore's `commit()` actually executes.

## Test Fixtures and Idempotent Setup

Create test data idempotently — check existence before inserting:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">class</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">TestPlayerApplication</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">AppTestCase</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setUp</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(self) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">self</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">._ensure_test_fixtures()</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">_ensure_test_fixtures</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(self) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">not</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.db.exists(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Season"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"season_name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Test Season"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            season </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.new_doc(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Season"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            season.season_name </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Test Season"</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            season.current </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            season.insert()</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">not</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.db.exists(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Division"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"division_name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Test Division"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            division </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.new_doc(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Division"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            division.division_name </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Test Division"</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            division.insert()</span>
```

## Testing Guest/Public Access

Simulate guest users for web form and public API testing:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">test_guest_can_submit</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(self) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    frappe.set_user(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Guest"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">try</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        app </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.get_doc({</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"doctype"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Player Application"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"name_player_first"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Test"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">...</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        })</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        app.insert()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">self</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.assertTrue(frappe.db.exists(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Player Application"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, app.name))</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">finally</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        frappe.set_user(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Administrator"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
```

## Testing Web Form Payment Flow

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">test_webform_accept_for_payment</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(self) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">from</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> payments.overrides.payment_webform </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> accept</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    web_form </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.get_doc(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Web Form"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"player-enrollment"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    data </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">self</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.get_test_enrollment_data()</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Simulate form submission</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    result </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> accept(web_form, data)</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Result should contain a payment redirect</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">self</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.assertIn(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"stripe.com"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, result)</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Parse and validate the payment URL</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    parsed </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> urlparse(result)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    params </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> parse_qs(parsed.query)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">self</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.assertEqual(params[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"amount"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">][</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">], </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"150.0"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">self</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.assertEqual(params[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"currency"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">][</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">], </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"USD"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
```

## Manual Cleanup Within Tests

Even with rollback, explicit cleanup helps when tests in the same class depend on clean state:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">_cleanup_linked_documents</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(self, docs: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">dict</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"""Reverse-order cleanup respecting foreign key constraints."""</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    frappe.set_user(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Administrator"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> docs.get(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"application"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.db.exists(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Player Application"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, docs[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"application"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">]):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            app </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.get_doc(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Player Application"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, docs[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"application"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">])</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> app.docstatus </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">==</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                app.cancel()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            app.delete()</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> docs.get(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"player"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.db.exists(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Player"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, docs[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"player"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">]):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            frappe.delete_doc(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Player"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, docs[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"player"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">])</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> docs.get(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"family"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.db.exists(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Family"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, docs[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"family"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">]):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            frappe.delete_doc(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Family"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, docs[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"family"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">])</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Continue in reverse creation order...</span>
```

## Running Tests

```
<span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Run all tests for an app</span>
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">bench</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--site</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">mysite</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">run-tests</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--app</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">myapp</span>

<span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Run tests for a specific doctype</span>
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">bench</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--site</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">mysite</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">run-tests</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--doctype</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Player Application"</span>

<span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Run a specific test file</span>
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">bench</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--site</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">mysite</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">run-tests</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--module</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">my_app.my_module.doctype.player_application.test_player_application</span>
```

Need help with Frappe?

Our notes can take you a long way, but sometimes you'd rather have someone who's done it before.

[ERPNext implementation](/services/erp/erpnext/)

[← PreviousScript Reports](/kb/frappe/script-reports/)[Next →Type Annotations & Controller Overrides](/kb/frappe/type-annotations-controller-overrides/)

CC0This article is in the public domain ([CC0 1.0](https://creativecommons.org/publicdomain/zero/1.0/)), code samples included. Use it however helps you.

On this page

- [The Core Problem](#the-core-problem)
- [The Solution: Commit Suppression](#the-solution-commit-suppression)
- [Patching External Side Effects](#patching-external-side-effects)
- [Saving and Restoring Critical State](#saving-and-restoring-critical-state)
- [Test Fixtures and Idempotent Setup](#test-fixtures-and-idempotent-setup)
- [Testing Guest/Public Access](#testing-guestpublic-access)
- [Testing Web Form Payment Flow](#testing-web-form-payment-flow)
- [Manual Cleanup Within Tests](#manual-cleanup-within-tests)
- [Running Tests](#running-tests)

[Back to top↑](#top)

Services

- [ERP implementation](/services/erp/)
- [Odoo](/services/erp/odoo/)
- [ERPNext](/services/erp/erpnext/)
- [Custom software](/services/custom-software/)
- [Devices & IoT](/services/devices-iot/)
- [Websites](/services/websites/)
- [Infrastructure](/services/infrastructure/)

Resources

- [Our work](/work/)
- [Open source](/open-source/)
- [Knowledge base](/kb/)
- [Insights](/insights/)

Company

- [About](/about/)
- [Team](/about/team/)
- [Partners](/partners/)
- [Contact](/contact/)

Clients

- [Project portal](https://erp.avunu.net/projects)
- [Invoices](https://erp.avunu.net/)
- [Support](https://erp.avunu.net/)

[![Avunu](/brand/avunu-logo-light.svg)](/)[\<av-icon data-jx-static>\<svg viewBox="0 0 24 24" width="20" height="20" fill="currentColor" stroke="none" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true" focusable="false">\<path d="M20.400 20.500h-3.600v-5.600c0-1.300 0-3-1.800-3s-2.100 1.400-2.100 2.900v5.700H9.400V9h3.400v1.600c.5-.9 1.600-1.900 3.400-1.900 3.600 0 4.300 2.400 4.300 5.500v6.300zM5.300 7.400a2.100 2.100 0 1 1 0-4.100 2.100 2.100 0 0 1 0 4.100zm1.800 13.100H3.600V9h3.500v11.500zM22.200 0H1.800C.8 0 0 .8 0 1.700v20.600c0 .9.800 1.700 1.800 1.700h20.400c1 0 1.800-.8 1.800-1.700V1.700C24 .8 23.200 0 22.200 0z">\</path>\</svg>\</av-icon>](https://www.linkedin.com/company/avunu)[\<av-icon data-jx-static>\<svg viewBox="0 0 24 24" width="20" height="20" fill="currentColor" stroke="none" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true" focusable="false">\<path d="M12 .3a12 12 0 0 0-3.8 23.4c.6.1.8-.3.8-.6v-2c-3.3.7-4-1.6-4-1.6-.6-1.4-1.4-1.8-1.4-1.8-1-.7.1-.7.1-.7 1.2.1 1.8 1.2 1.8 1.2 1 1.8 2.8 1.3 3.5 1 .1-.8.4-1.3.7-1.6-2.7-.3-5.5-1.3-5.5-5.9 0-1.3.5-2.4 1.2-3.2-.1-.3-.5-1.5.1-3.2 0 0 1-.3 3.3 1.2a11.500 11.500 0 0 1 6 0c2.300-1.500 3.300-1.200 3.300-1.200.6 1.700.2 2.900.1 3.200.8.8 1.200 1.900 1.200 3.200 0 4.600-2.800 5.600-5.500 5.900.4.400.8 1.100.8 2.200v3.300c0 .3.2.7.8.6A12 12 0 0 0 12 .3">\</path>\</svg>\</av-icon>](https://github.com/Avunu)[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

Avunu LLC · 948 East Philadelphia Street, York, PA 17403 · (717) 814-8540Knowledge base articles are in the public domain[Privacy](/privacy/)[Terms](/terms/)
