AcademySoftwareFoundation / AcademySoftwareFoundation/OpenCue

[Cuebot] Shows with the same name break querying

Closed
#1,092 0 comments 0 reactions 0 assignees View on GitHub
bug triaged
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.