Attach notes to timeslots upon creation

As discussed with @kmohrf , upon creation of a Timeslot a Note should be created and attached to it.

added Doing label

added 1 deleted label

changed milestone to %1.0-alpha4 — Raving Raccoon

assigned to @eigenwijsje

changed title from Attach to notes to timeslots upon creation to Attach notes to timeslots upon creation

changed the description

added ready-for-testing label and removed Doing label

The database in the dashboard currently has the same:

psql (14.11 (Debian 14.11-1.pgdg120+2))
Type "help" for help.

steering=# select count(*) from program_timeslot;
 count 
-------
 15305
(1 row)

steering=# select count(*) from program_note;
 count 
-------
 15305
(1 row)

steering=# select from program_note where timeslot_id not in (select id from program_timeslot);
--
(0 rows)

Additionally, the notes will have the hosts, language and topic from the shows as contributors, language and topic.

closed

removed ready-for-testing label

I tested it using a user with programme manager group privileges and when I create a new timeslot for a show and then try editing the note of that timeslot, dashboard still shows a "no note" error. When I use a superuser, I can edit without errors.

Another comment: notes are only auto-generated for new timeslots, not for all existing timeslots, no? So when testing and using an existing show, I can still expect to find timeslots without notes, and consequently get a "no note" error. Is there a way to auto-generate notes for all timeslots in the program that have no note so far?

reopened

added Doing label

I cannot reproduce this.

Since last week, every time a new timeslot is created, a note is attached with the contributors (hosts), language and topics from the parent show.

And, every existing timeslot that doesn’t have a note attached, gets one.

closed

removed Doing label

added 25m of time spent