1. Add entity 'Notification': pairs of mail-openaireId, with the preferences for notifications of this user for this id. 2. Add FetchNotificationHandler and NotificationHandler for 'Notification' entity. 3. springContext-claimsDemo.xml: Add beans for FetchNotificationHandler, NotificationHandler, defaultFrequencyInHours. 4. QueryGenerator.java: Add methods: generateFetchNumberOfClaimsByDateAndOpenaireId, generateSelectCountClaimQueryAsUnionOfAllRelations, generateSelectFirstContextByCommunityIdQuery, generateSelectProjectIdsAndNamesByProjectManagerMail, generateInsertNotificationQuery, generateUpdateNotificationPreferences, generateUpdateNotificationLastInteractionDate, generateSelectNotificationQuery, generateSelectTrueNotificationsQuery Change method: generateSelectContactEmailsByProjectIdQuery (unnest the sql array).
1. Add entity 'Notification': pairs of mail-openaireId, with the preferences for notifications of this user for this id.
2. Add FetchNotificationHandler and NotificationHandler for 'Notification' entity.
3. springContext-claimsDemo.xml: Add beans for FetchNotificationHandler, NotificationHandler, defaultFrequencyInHours.
4. QueryGenerator.java: Add methods:
generateFetchNumberOfClaimsByDateAndOpenaireId, generateSelectCountClaimQueryAsUnionOfAllRelations,
generateSelectFirstContextByCommunityIdQuery, generateSelectProjectIdsAndNamesByProjectManagerMail,
generateInsertNotificationQuery, generateUpdateNotificationPreferences, generateUpdateNotificationLastInteractionDate,
generateSelectNotificationQuery, generateSelectTrueNotificationsQuery
Change method: generateSelectContactEmailsByProjectIdQuery (unnest the sql array).