Iteration #3¶

Target: Deliver a minimalistic application with Web GUI that enables the creation of a certificate and list all certificates. The listing shall enable the user to download the certificate and corresponding chain of trust in a separate file.

• Create DAO objects - Certificate, Private Key
• Create a subset of Rest API endpoints
• Create a simple GUI

DAO:

• get_certificate_by_id - queries a certificate based on given ID
• get_all_certificates - select all certificates
• get_all_certificate_authorities - select all certificate authorities
• get_issuer_of - get issuer of a certificate given by ID
• get_private_key_of - get private key ID of a certificate given by ID
• insert_new_certificate - inserts a new certificate into the DB

• get_private_key_by_id - queries a private key based on given ID
• insert_new_private_key - inserts a new private key into the DB