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

Re #8471 - Implemented DB communication
- Implementation of communication with specific tables (Certificate, PrivateKey)

Re #8471 - Edited arguments in headers of functions

Re #8471 - Created constants of DB names
- Constant for each of names in DB (table, column)

Re #8471 - Implemented DB communication
- implemented operations create, read, update, delete
- created file with constants contains name of DB file and default values in DB

Re #8471 - Initialization of DAO implementation
- created data class according to DB tables (Certificate, PrivateKey)
- created abstract class for DB communication

Re #8474 - Added Bootstrap .map files

Re #8474 - Fixed index.html table header alignment

Re #8472 - Added CryptographyService class and implemented a method to generate private keys

Added CryptographyException exception that is thrown when incorrect parameters are passed to openssl or when openssl process exits with non-zero return code.
Added 3 unit tests verifying the validity of the private key generation.

Re #8474 - Separated issuer and subject in create_certificate.html

Re #8474 - Styling of create_certificate.html using Bootstrap

Re #8474 - Styling of index.html using Bootstrap

Re #8474 - Added Bootstrap resources

Re #8474 - Created create_certificate.html for creating certificates

Re #8474 - Created index.html with certificate listing

Fixed a typo

Re #8307 - Fixed a typo

Re #8429 - Updates resulting from the standard review.

Re #8429 - Fixed minor issues discovered during Architecture Documentation updates.

Re #8429 - Completed the contained artefacts according to discussion conclusion.

Re #8429 - Finished discussion-independent updates.

Re #8305 create era model
Merge branch '#8305_Create_ERA_model' into 'master'
See merge request aswi/aswi-2021/aswi2021jmsd!5

Re #8305 - Edited ERA model and script for generate database
- password column migrated from Certificate table to PrivateKey table

Re #8305 - Created ERA model and DB script
- ERA model
- script for generate DB
- script for insert default values into DB

Re #8307 - The children certificate including the whole chain of trust is now also saved to a PFX store

Re #8307 - added a proof of concept that demonstrates the ability to create a chain of trust

- a Python script was added that is able to generate a chain of trust consisting of root and intermediate CAs. In addition to that a child certificate with the specified common name will be generated and signed by the intermediate CA....