D-Net

add new property and parsing methods for new json API responses

update semantics for rlt-organization link

change CachedRowSetImpl to javax.sql.rowset.CachedRowSet;

add methods for organization claims and filter is mine

pass id suffix for direct indexed results

return the result source to decide in UI if available or pending

export metadata for software and other

replace openaire_id prefix with userclaim___::

Job: update isOld function

missing from previous commit - Add Job class

simplify response to minimum required fields
move the where clause in each query to eliminate their size before union their results

ommited test methods that require db connection

log4j2 integrated + uoa-global-parent

[Trunk | Claims]: springContext-claims.xml: Added default value for sslProtocols to null (if property does not exist).

Clean up code use only the method to get managers without session cookie
add more checks if community is enabled for notifications or not

temporal fix for log4j build fail

get managers list: update the methods - add new properties

[Trunk | Claims]:
1. db_script.sql: Comment existing commands and add commands for creating metrics table and intialize it with empty values.
2. NotificationHandler.java: [Bug fix] In logger set NotificationHandler.class.
3. QueryGenerator.java: Remove unnecessary log.

[Trunk | Claims Service]:
1. Metrics.java: New entity for Metrics.
2. MetricsHandler.java: Handler for metrics to create queries via QueryGenerator for saving and fetching metrics and execute them.
3. QueryGenerator.java: Queries for metrics added (not all of them are used - created for testing)....

[Trunk | Claims Service]:
1. springContext-claims.properties: Updated "services.claims.mail.openaireCommunityClaimsPage" and "services.claims.mail.manageCommunityUserNotificationsPage" to use the new admin portal urls (Admin portal redesign).
2. EmailSender.java: Build urls by replacing "{community}" with openaire_id in "openaireCommunityClaimsPage" and "manageCommunityUserNotificationsPage" properties, (Admin portal redesign - new urls).

Fix context query (to return claims linked to a community or made in community dashboard)

[Trunk | Claims Service]:
1. ManagerUtils.java: Added method "isCommunityManager()" to check if a user_email is among managers of a community.
2. springContext-claims.xml: Added in bean with id=emailSender, property name="managerUtils" and removed property name="communityUtils".

[Trunk | Claims Service]:
1. ManagerUtils.java: [NEW] File for getting community managers from registry service added.
2. springContext-claims.properties: Property "services.claims.registryAPIForManagerEmails" added - URL of registry service for requesting community manager emails....

- fix order by titles
- context query: get results made in the same dashboard
- add claimed_in_dashboard in the result
- commit changes in Test CopyFromBeta

Query Generator:
context query: link with specific community or claimed in community's dashboard

[Trunk | Claims Service]: EmailSender.java: Remove "beta" prefix from link for community dashboard when sending email notification for community claims.

Updates to Migrate community claims from Beta to Production

CommunityUtils:
chnage methods from static, add it with autowired in EmailSender
update properties

Update email Sender and Scheduler:

rename property emailScheduler.sendEmailNotifications to services.claims.mail.sendEmailNotifications

Add properties to enable/disable notifications for specific entities:
services.claims.mail.notifyCommunityManagers
services.claims.mail.notifyProjectManagers

Fix1: set type after parsing response from external sources - this fix puts the record in the proper file path

Fix2: Update orcid parser, use single orcid work response
update ExternalParserTest

ClaimEntity: Add information about the dashboard where the claim was created

Properties:
add properties for the different services
create beans properly
production or beta is decided from the services urls in properties

Migration:
create migration method: CopyFromBetaToProduction for communities

Search utils, Project Handler, IndexResultHandler:
get search service url from properties
remove isProduction parameter
remove dedup result methods used in migration

-> update method calls and signatures accordingly

- rename properties files springContext-claimsDemo.xml --> springContext-claims.xml
- rename properties paths services.claimsDemo.* to services.claims.*

-Remove methods and classes used for the migration from old database schema to new
-Remove communities XMLs
-rearrange packages (remove 'migration' and 'claimsDemo') Properties paths didn't change!

springContext-claimsDemo.properties: Property 'sendEmailNotifications' set to false by default.

Add property 'enabledCommunities' to send email notifications only to specific communities.

[Trunk]

Email sEnder:
comment notification functions
add property for auth
read emailScheduler.sendEmailNotifications from properties

Parsing Orcid records: fix parsing issue, add one more test

1. pom.xml: Add commented plugin for surfire (possibly needed in openjdk: bug in their release) | update version of javax.mail.
2. FetchContextHandler.java: bug fix in parsing resultset.
3. QueryGenerator.java: bug fix in query of method 'generateSelectFirstContextByCommunityIdQuery'....

NotificationHandler.java & EmailSender.java: bug fix in calculating seconds (store 12:00 and add 1 sec to last_interaction_date when sending email).

springContext-claimsDemo.xml: targetHour and targetMinute beans restored (were changed for testing purposes).

1. FetchClaimHandler.java: add method fetchNumberOfClaimsByDateAndOpenaireId.
2. CommunityUtils.java: request datasource API to get community information (including managers).
3. FetchContextHandler.java: Method fetchFirstContextByCommunityId to parse name of community to be used in the above API....

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....

1. Project.java: Remove 'token' field from 'Project' entity.
2. FetchProjectHandler.java, ProjectHandler.java, TestClass.java: Remove methods related to 'token' field.
3. FetchProjectHandler.java: Add 'fetchProjectIdsAndNamesByProjectManagerMail' method | Change 'fetchContactEmailsByProjectId' method (mails are returned as List from DAO).

SqlStore.java:
close ResultSet and Statement in finally clause
return CachedRowSet instead of ResultSet when needed (avoids problems with closed connection, nothing else changes because CachedRowSet extends ResultSet)

Parameterize context utils methods with a boolean parameter for productionIndex, add production url
In delete claims method add check for deleting record

Enable claiming for ORPs
Set direct index url in properties
Migration:
save orphan Ids, claims
uncomment fetch dedup

1. FetchProjectHandler.java: Rename 'fetchProjectIdByToken' to 'fetchProjectIdByTokenAndEmail' and create 'public String fetchProjectIdByToken(String token)' method.
2. QueryGenerator.java: Rename 'generateSelectProjectIdByTokenQuery' to 'generateSelectProjectIdByTokenAndEmailQuery' -...

Change ContextUtils to get concept label from new Context API

add communities xml files| change fetching methods for communities | set properly date in migration | change ORCID API

fixing issues with ordering and types filter

close the db connection per request, in fetch claims by context id use like and wild character in order to get all claims of a community

change migration procedure: search first in beta then in production| add software | change directIndexHandler check for response

Delete file when claim is deleted and result has no other links| change semantics | change the openaireId generation

prepared statements for the sql queries

claims-demo folder renamed to trunk

Copy for Java8