TEAMMATES / teammates

This is the project website for the TEAMMATES feedback management tool for education
https://teammatesv4.appspot.com/
GNU General Public License v2.0
1.64k stars 3.26k forks source link

[#12048] Add patch script for account request and notifications to amend createdAt field #13077

Closed NicolasCwy closed 2 months ago

NicolasCwy commented 2 months ago

Part of #12048

Context Previously during the non-course migration, createdAt was not migrated due to having the @createdTimestamp annotation. This was removed in the v9-course-migration branch and can be used for this as well.

Outline of Solution Add 2 scripts based of PatchDataMigrationForUsageStatisticsSql to fetch existing account requests and notifications using fields which are identifiers for the entity and amend their createdAt timestamp. Most of the changes are in MigrateEntity method. Verification Scripts can handle the case where an entity exist in postgres but not in datastore (since we have started created new account requests and notification in postgres)

Fields which are identifiers