search

UniversityOfHelsinkiCS / palaute

Norppa-palautejärjestelmä
https://norppa.helsinki.fi
MIT License
12 stars 8 forks source link

TAU Changes #1362

Closed HRemonen closed 1 month ago

HRemonen commented 1 month ago

CURRENTLY for https://norppa.helsinki.fi/course-summary/TKT20005?startDate=2022-08-01&endDate=2023-07-31 the course summary page is the following:

Image

AFTER THESE CHANGES the same page looks like this: Image

Where did the CUR rows disappear?

Also displaying all of the CUR's for a CU does not work anymore. BEFORE THE CHANGES: Image

AFTER THE CHANGES: Image

HRemonen commented 1 month ago

AFTER THE CHANGES every feedbacktarget in the My Teaching page seems to have lost their feedback count and student counts:

image

HOWEVER when visiting the feedbacktarget page, the counts are normally there.

HRemonen commented 1 month ago

[!NOTE] Okay so further investigation with Asta revealed that the summaries table has to be completely flushed and rebuild in order to get the "new" data in and old data out.

Now this is not working because we still have the old summaries data in the DB.

[!CAUTION] This is pretty dangerous shit

  1. Flush the current summaries table with 
    truncate summaries;
delete from summaries;
  2. Rebuild the summaries table either programmatically or through the summaries "Aja datanpäivitys"
  3. Profit

The full rebuild takes little over one minute or so. I was thinking that if the steps should be done inside migrations rather than manually, either way this is not super ideal for production build, as it might cause issues.