REST-based microservice - Newsservice using Spring Boot, Spring Data JPA, Spring Security, Java8, Maven, MapStruct, Lombok, Bean Validation API, JUnit 5, Mockito and H2 in-memory DB.

• Returns all news for single role/account ID back, which are new and have not been read yet. New news are defined as 1 day old news relative to the current time.
• Input
• accountId
• rolles
• Output
• news (0 bis x)

• Set the read status for a single news
• Input
• accountId
• newsId
• Output
• Ok or error

• Returns a picture for a single news
• Input
• News id
• Picture id
• rolles
• Output
• Picture as file
• Meta data

• Uploads a picture - possible only for users with role PUBLISHER
• Input
• Image as MultipartFile request parameter
• Output
• Ok or error

• Admin: He has the right to see all contents and edit and delete all contents


• Reader: He has the right to read all titles and see all photos in the public area


• Publisher: he can create news and edit or delete of the contents he had created

• Enter the following sql query to get all usernames with their assigned roles:

SELECT u.username, r.role_name FROM "user" u
    inner join user_role ur
        on u.id = ur.user_id
    inner join role r
        on ur.role_id = r.id;

• SQL query to retrieve all news articles along with their associated photos, read status information and corresponding usernames:

SELECT n.title, p.photo_name, r.account_id, u.username
    FROM NEWS n
         LEFT JOIN PHOTO p ON n.photo_id = p.id
         LEFT JOIN READ_STATUS r ON n.read_status_id = r.id
         LEFT JOIN "user" u ON r.account_id =u.id;