ASWI - Pokročilé softwarové inženýrství » ASWI 2021 » Aplikace pro správu X.509 certifikátů (Yoso Czech s.r.o.) - JMSD

Implement all changes for this iteration into the database:

• Certificate service will call a CertificateRepository set_certificate_revoked(id, timestamp, reason)/clear_certificate_revocation(id).
• Database must be extended with the following data: revocation date (Unix timestamp, generated automatically by the CertificateService), bool flag if is revoked, the reason for revocation(may be implemented as a second table with revocation reason values).
• CertificateRepository shall expose the following method get_all_revoked_by(id) that returns all certificates that were issued by the given CA and are now revoked.
• CertificateRepository must implement get_all_issued_by(id) that returns all certificates that were issued by the given CA
• Cover the new functionality by tests
• Cover KeyRepository by tests
• Database shall throw a custom exception in case of any error - if the record is not found, None is returned.

• Discuss with the team if some other improvements to the repositories are necessary

Reviewer: Stanislav Král