[Django] #31908: Add parallel testing support to Oracle backend

[Django]

#31908: Add parallel testing support to Oracle backend
-------------------------------------+-------------------------------------
Reporter: Ahmad A. | Owner: Ahmad A. Hussein
Hussein |
Type: New | Status: assigned
feature |
Component: Testing | Version: master
framework | Keywords: oracle, parallel,
Severity: Normal | tests
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
This was part of the original parallel test runner ticket that Aymeric
Augustin worked on. It still remains a nice feature to have.

--
Ticket URL: <https://code.djangoproject.com/ticket/31908>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#31908: Add parallel testing support to Oracle backend
-------------------------------------+-------------------------------------

Reporter: Ahmad A. Hussein | Owner: Ahmad A.
| Hussein
Type: New feature | Status: assigned
Component: Testing framework | Version: master
Severity: Normal | Resolution:
Keywords: oracle, parallel, | Triage Stage: Accepted
tests |
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Carlton Gibson):

* stage: Unreviewed => Accepted

--
Ticket URL: <https://code.djangoproject.com/ticket/31908#comment:1>

[Django]

#31908: Add parallel testing support to Oracle backend
-------------------------------------+-------------------------------------

Reporter: Ahmad A. Hussein | Owner: Ahmad A.
| Hussein
Type: New feature | Status: assigned
Component: Testing framework | Version: master
Severity: Normal | Resolution:
Keywords: oracle, parallel, | Triage Stage: Accepted
tests |

Has patch: 1 | Needs documentation: 1
Needs tests: 1 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by felixxm):

* needs_better_patch: 0 => 1
* has_patch: 0 => 1
* needs_tests: 0 => 1
* needs_docs: 0 => 1

Comment:

[https://github.com/django/django/pull/13326 PR]

--
Ticket URL: <https://code.djangoproject.com/ticket/31908#comment:2>

[Django]

#31908: Add parallel testing support to Oracle backend
-------------------------------------+-------------------------------------

Reporter: Ahmad A. Hussein | Owner: (none)
Type: New feature | Status: new
Component: Testing framework | Version: dev

Severity: Normal | Resolution:
Keywords: oracle, parallel, | Triage Stage: Accepted
tests |
Has patch: 1 | Needs documentation: 1
Needs tests: 1 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Ahmed Ibrahim):

* owner: Ahmad A. Hussein => (none)
* status: assigned => new

Comment:

(Ticket inactive for 4 years, de-assigning)
--
Ticket URL: <https://code.djangoproject.com/ticket/31908#comment:3>

[Django]

#31908: Add parallel testing support to Oracle backend
-------------------------------------+-------------------------------------

Reporter: Ahmad A. Hussein | Owner: (none)
Type: New feature | Status: new
Component: Testing framework | Version: dev
Severity: Normal | Resolution:
Keywords: oracle, parallel, | Triage Stage: Accepted
tests |
Has patch: 1 | Needs documentation: 1
Needs tests: 1 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Siddharth Panditrao):

Hi, I’ve been reading through the history of this ticket and the old PR to
understand why it was closed.

From what I can tell, the main issues earlier were:
* Dependency on ``expdp`` / ``impdp``
* Oracle-specific logic in the base backend
* Added complexity around cloning data

== Question / Idea ==

I was wondering if a simpler approach could work for Oracle:

* For parallel tests, create empty cloned test users (with suffixes like
``_1``, ``_2``)
* Skip exporting/importing data entirely
* Let Django handle schema creation via migrations and test data via its
existing serialization logic

This seems closer to how Django already handles parallel tests and avoids
external tools.

== Questions ==

I’m still learning Django internals, so I wanted to ask:

* Is empty schema cloning considered sufficient for Oracle?
* Would this be an acceptable direction to revisit this ticket, or is
there something I’m missing?

Happy to learn and adjust based on feedback. Thanks!
--
Ticket URL: <https://code.djangoproject.com/ticket/31908#comment:4>

[Django]

#31908: Add parallel testing support to Oracle backend
-------------------------------------+-------------------------------------

Reporter: Ahmad A. Hussein | Owner: Siddharth
| Panditrao

Type: New feature | Status: assigned

Component: Testing framework | Version: dev
Severity: Normal | Resolution:
Keywords: oracle, parallel, | Triage Stage: Accepted
tests |
Has patch: 1 | Needs documentation: 1
Needs tests: 1 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Siddharth Panditrao):

* owner: (none) => Siddharth Panditrao
* status: new => assigned

--
Ticket URL: <https://code.djangoproject.com/ticket/31908#comment:5>

[Django]

#31908: Add parallel testing support to Oracle backend
-------------------------------------+-------------------------------------

Reporter: Ahmad A. Hussein | Owner: Siddharth
| Panditrao
Type: New feature | Status: assigned
Component: Testing framework | Version: dev
Severity: Normal | Resolution:
Keywords: oracle, parallel, | Triage Stage: Accepted
tests |
Has patch: 1 | Needs documentation: 1
Needs tests: 1 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Siddharth Panditrao):

[https://github.com/django/django/pull/20492 PR]
--
Ticket URL: <https://code.djangoproject.com/ticket/31908#comment:6>

[Django]

#31908: Add parallel testing support to Oracle backend
-------------------------------------+-------------------------------------

Reporter: Ahmad A. Hussein | Owner: Siddharth
| Panditrao
Type: New feature | Status: assigned
Component: Testing framework | Version: dev
Severity: Normal | Resolution:
Keywords: oracle, parallel, | Triage Stage: Accepted
tests |

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Jacob Walls):

* needs_better_patch: 1 => 0
* needs_docs: 1 => 0
* needs_tests: 1 => 0

Comment:

Unsetting flags for fresh review.
--
Ticket URL: <https://code.djangoproject.com/ticket/31908#comment:7>

[Django]

#31908: Add parallel testing support to Oracle backend
-------------------------------------+-------------------------------------

Reporter: Ahmad A. Hussein | Owner: Siddharth
| Panditrao
Type: New feature | Status: assigned
Component: Testing framework | Version: dev
Severity: Normal | Resolution:
Keywords: oracle, parallel, | Triage Stage: Accepted
tests |

Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Jacob Walls):

* needs_better_patch: 0 => 1

Comment:

Tests are failing.
--
Ticket URL: <https://code.djangoproject.com/ticket/31908#comment:8>

[Django]

#31908: Add parallel testing support to Oracle backend
-------------------------------------+-------------------------------------

Reporter: Ahmad A. Hussein | Owner: Siddharth
| Panditrao
Type: New feature | Status: assigned
Component: Testing framework | Version: dev
Severity: Normal | Resolution:
Keywords: oracle, parallel, | Triage Stage: Accepted
tests |

Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Siddharth Panditrao):

Replying to [comment:8 Jacob Walls]:
> Tests are failing.
Thanks for the review. I see the Oracle CI failures in the shared test
creation and test runner tests and I’m working on addressing them.
--
Ticket URL: <https://code.djangoproject.com/ticket/31908#comment:9>