Automate show archive process about opencue HOT 3 OPEN

FYI @n-jay this is a good first issue to get involved on pycue and cuebot while also touching the database

from opencue.

Ack @DiegoTavares, thanks! Will check this out. Also, could I be assigned to this?
I'll start working on it on the side and get in fully once the addon CI work is at a satisfactory level.

Will send any questions/doubts in a new mail thread.

from opencue.

@DiegoTavares, I'm gradually shifting to work on this.
To make sure if I've properly understood this;

The implementation involves adding a new api call to the proto layer, implementing the client call on pycue and the server logic on cuebot.

show_alias and show tables currently exist. Correct me if I'm wrong but I believe they are in V1_initial_schema.sql, yes?
The new API should add a new entry to show_alias and concatenate the _archived suffix to the existing entry in the show table.

the flow is as follows:
pycue (API) ▶️ proto layer (new CreateShowAlias rpc) ▶️ cuebot logic (writing data to the show_alias table and updating show table).

from opencue.