Branch: refs/heads/master Home: https://github.com/openSUSE/open-build-service Commit: c730462f265035b54ac07ed8a3c223e2a7c65262 https://github.com/openSUSE/open-build-service/commit/c730462f265035b54ac07e... Author: Eduardo Navarro <enavarro@suse.com> Date: 2020-04-24 (Fri, 24 Apr 2020) Changed paths: A src/api/db/migrate/20200421115317_create_join_table_notified_projects.rb M src/api/db/structure.sql Log Message: ----------- Create notified_projects join table Retrieving the projects of a notification, requires querying for comments, requests and reviews. We want to avoid n+1 queries instead of going through the polymorphic associations notifiable and notifiable.commentable for comments. We need to have an ID in the table since we'll be using a `has_many through:` association Co-authored-by: Dany Marcoux <dmarcoux@suse.com> Co-authored-by: David Kang <dkang@suse.com> Co-authored-by: Saray Cabrera Padrón <scabrerapadron@suse.de> Commit: e85d1203ab053fe605b8f24ed220de344810353c https://github.com/openSUSE/open-build-service/commit/e85d1203ab053fe605b8f2... Author: Dany Marcoux <dmarcoux@posteo.de> Date: 2020-04-24 (Fri, 24 Apr 2020) Changed paths: M src/api/app/models/notification.rb A src/api/app/models/notified_project.rb M src/api/app/models/project.rb Log Message: ----------- Add model and associations for join table notified_projects Commit: cef8f358b6fa12704ef765d71dbc96059a20ad12 https://github.com/openSUSE/open-build-service/commit/cef8f358b6fa12704ef765... Author: Eduardo Navarro <enavarro@suse.com> Date: 2020-04-24 (Fri, 24 Apr 2020) Changed paths: A src/api/app/services/notified_projects.rb Log Message: ----------- Create service to get the projects of a notification This service retrieves the associated projects of a notification. It will be used either by the notification creation from events, or from a data migration that will fill the notifications' projects after the notified_projects table was introduced. Co-authored-by: Saray Cabrera Padrón <scabrerapadron@suse.de> Commit: de3eba3b9d8e765364b50a95eef2396bf5a54107 https://github.com/openSUSE/open-build-service/commit/de3eba3b9d8e765364b50a... Author: Dany Marcoux <dmarcoux@posteo.de> Date: 2020-04-24 (Fri, 24 Apr 2020) Changed paths: A src/api/db/data/20200421121610_backfill_notified_projects.rb A src/api/spec/cassettes/BackfillNotifiedProjects/up/backfills_the_notifications_projects_table_with_all_projects_from_existing_notifications.yml A src/api/spec/db/data/backfill_notified_projects_spec.rb Log Message: ----------- Add migration to backfill notified_projects table Commit: 2392177bccc6908cb002fee54e998a446fce0830 https://github.com/openSUSE/open-build-service/commit/2392177bccc6908cb002fe... Author: Victor Pereira <vpereira@suse.de> Date: 2020-04-24 (Fri, 24 Apr 2020) Changed paths: M src/api/app/models/notification.rb A src/api/app/models/notified_project.rb M src/api/app/models/project.rb A src/api/app/services/notified_projects.rb A src/api/db/data/20200421121610_backfill_notified_projects.rb A src/api/db/migrate/20200421115317_create_join_table_notified_projects.rb M src/api/db/structure.sql A src/api/spec/cassettes/BackfillNotifiedProjects/up/backfills_the_notifications_projects_table_with_all_projects_from_existing_notifications.yml A src/api/spec/db/data/backfill_notified_projects_spec.rb Log Message: ----------- Merge pull request #9433 from dmarcoux/data-migration-notified-projects Create and backfill notified_projects table Compare: https://github.com/openSUSE/open-build-service/compare/f4bc345a71ad...239217...