AcademySoftwareFoundation / AcademySoftwareFoundation/OpenCue
[Cuebot] Shows with the same name break querying
- Dominant language
- Python
- Stars
- 957
- Forks
- 259
- Avg merge
- 3d 6h
- Merged PRs (30d)
- 16
Description
**Describe the bug**
There is a chance that 2 shows with the same name but different IDs can be in database. This will cause an error when querying for the show by name or using methods like `AdminManager::findShowEntity` as it will raise an exception `expected 2 but got 1`.
**To Reproduce**
Steps to reproduce the behavior:
1. Create 2 shows with the same name
2. Call `findShowEntity` from `AdminManager` using the same name and this will raise an exception `expected 2 but got 1`.
4. See error
**Expected behavior**
We should have a process to make sure no 2 shows with the same name be in the database at the same time.
Contributor guide
Research direction
Start at AdminManager::findShowEntity and reproduce the failure by creating two shows with the same name but different IDs. Trace the database lookup and related show-creation path to determine where duplicate names are permitted. Done means duplicate show names cannot coexist and querying by name no longer raises the reported exception.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100