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

Re #8476 - Implemented and tested `get_cert_root(id)`.

Re #8476 - Implemented and tested `get_cert_details(id)`.

Re #8476 - Added `to_dict` method to Subject, minor bugfix

Re #8476 - Certificate usages bugfix (?)

Re #8476 - Added and tested `get_certificate(id)`.

Re #8476 - Fixed and tested filtering for GET /api/certificates

Re #8476 - Refactored the application; swagger is not used for code generation anymore, REST API is being implemented from scratch. Migration only, fixing tests.

Re #8476 - Implemented `list_certificates` with unit tests.

Re #8476 - Upgraded connexion -> updated requirements.txt

Re #8476 - Created basic unit tests for `create_certificate`.

Re #8476 - Finalized `create_certificate`. Update of swagger main.py

Re #8476 - Database FileAnchor utilization.

Re #8476 - Auxiliary script for database initialization, FileAnchor

Re #8476 - Repository bugfix.

Re #8476 - Controller create certificate bugfix.

Re #8476 - Clarity update.

Re #8476 - Added as a part of the swagger-generated server stub. Imported required objects, SQLite3 thread issue hack (performance impact negligible, violates encapsulation), implemented `create_certificate`.

Re #8476 - Changed the name of `CertificatesUsages` to `CertificateUsages`.

Re #8476 - Added necessary requirements.

Re #8476 - Added as a part of the swagger-generated server stub, fixed attribute error (https://github.com/zalando/connexion/issues/739)

Re #8476 - Added swagger.yaml (created by Jan Pašek).

Re #8476 - Added as a part of the swagger-generated server stub, set base path to root.

Re #8476 - Added swagger-generated server stub.

Re #8472 implement key service certificate service
Merge branch '8472_Implement_KeyService_CertificateService' into 'master'
See merge request aswi/aswi-2021/aswi2021jmsd!7

Re #8473 - Added get_subject_from_certificate to certificate_service.py

Re #8473 - Fixed minor typo in certificate_service.py

Re #8472 - Added a parameter to the craete_sscrt method in CryptographyService in order to be able to specify tha number of days for which the generated certificate will be valid.

Re #8472 - Added missing docstrings to KeyService and CertificateService classes

Re #8472 - Added further tests of the KeyService class

Re #8472 - Added KeyService.delete test and renamed a test suite

Applied a small change to the KeyService.get_keys method

Re #8472 - Changed delete methods in repositories in such way that delete methods now return True only when at least one row was deleted

Re #8472 - Implemented delete_certificate method in CertificateService and added a test validating it

Re #8472 - Changed CertificateRepository.read_all method in such way that empty list is now returned instead of None when no certificates are found

Re #8472 - Added get_chain_of_trust method documentation and comments

Re #8472 - Implemented get_chain_of_trust method and added an integration test validating it

Added return type specification to read_all method in CertificateRepository

Re #8472 - Implemented get_certificates method and added an integration test validating it

Added fixtures providing a unique DB connection for each test

Re #8472 - Fixed an issue in the certificate repository that resulted in inability to filter certificates by their type

Re #8472 - Implemented create_end_cert method and added an integration test validating it

Re #8472 - Added the ability to pass usage dictionary to create_ca and create_root_ca methods via optional parameter

Re #8472 - Fixed an issue in CertificateRepository.create() method where update result (boolean) was returned instead of the created ID

Re #8472 - Implemented create_ca method in CertificateService and added test verifying this method's validity

Re #8472 - Fixed CertificateRepository bug that resulted in inability to create certificates

Re #8472 - Implemented get_certificate method in CertificateService and added a test testing this method

Re #8472 - Fixed a bug in CertificateRepository that resulted in inability to get a single certificate by ID

Re #8472 - Extended integration test asserting correct reading from the database

Re #8472 - Fixed a bug in PrivateKeyRepository that resulted in inability to get a single private key from the repository

Re #8472 - Improved SQL connection/cursor fixtures in such way that connection to DB happens only once per test module

Re #8472 - Added simple integration tests

Re #8472 - Finished implementation of create_root_ca method in CertificateService

Re #8472 - Made small fixes to the CertificateRepository

Re #8472 - Improved parse_cert_pem method in such way that it also parses notBefore and notAfter fields now

Re #8472 - Finished implementation of parse_cert_pem method that parses a subject out of a PEM formatted certificate

Added few unit tests testing this method.

Re #8472 - WIP commit of adding a method capable of parsing a Subject from a cert PEM

Re #8472 - Implemented KeyService

Re #8472 - Fixed PrivateKey field assignment typo

Re #8471 - Merge implement DAO - source code

Re #8471 - Implemented selection of all private keys

Re #8471 - Implemented filter of certificates
- Implemented filter by certificate type using index (id) from CertificateTypes table
- No multiple types supported

Merge branch '8512_update_architecture'

Re: #8471 - Modified database
- password can be null
- FKs in CertificateUsages can not be null

Re #8512 - Rewritten ERA model

Re #8471 - Error correction after review

Re #8471 - Added initialize test

Re #8471 - Simplification of CRUD functions
- conversion source of private key repository to one file
- added comments

Re #8471 - Simplification of CRUD functions
- conversion source of certificate repository to one file
- added comments

Re #8471 - Added name of tables to constants
- TAB_CERTIFICATE_TYPES for CertificateTypes table
- TAB_USAGE_TYPES for UsageTypes table

Re #8471 - Modified scripts and database
- relation between Certificates and CertificateUsages tables on delete 'no action' >> 'cascade'

Re #8471 - Modified relation between tables
- relation between Certificates and CertificateUsages tables 'no action' >> 'cascade'

Re #8471 - Modified source
- deleted redundat files
- deleted '_impl' from repositories filename

Re #8471 - Added comments for CRUD functions

Re #8471 - Tested direct DB communication
- implemented tests for Certificates and PrivateKeys tables via DBManager

Re #8471 - Created database file

Re #8471 - Added FK of parent certificate

Re #8472 cryptography service implementation
Merge branch '#8472_CryptographyService_Implementation' into 'master'
See merge request aswi/aswi-2021/aswi2021jmsd!6

Re #8471 - Edited files for DB communication

Re #8471 - Edited Certificate object
- due to database modification

Re #8471 - Edited constants

Re #8472 - Changed order of create_sscrt method parameters

Re #8472 - Changed some parameter names in create_csr method and renamed make_csr_test.py to create_csr_test.py

Re #8472 - Changed access modifier of run_for_output method to private (was protected previously)

Re #8472 - Changed access modifier of subject_to_param method to private (was protected previously) and added docstring to it

Re #8472 - Changed access modifier of sign_csr method to private (was protected previously)

Re #8472 - Changed access modifier of create_csr method to private (was protected previously)

Re #8471 - Repaired datamodel (SQLite)
- inserted new table for NxN relation (Certificates - UsageTypes)

Re #8471 - Repaired datamodel (SQLite)
- inserted new table for NxN relation (Certificates - UsageTypes)
- edited .sql scripts

Re #8512 - Minor updates of parameters and method names.

Re #8472 - Removed useless private key generation in verify_ca_test.py

Re #8472 - Changed access modifiers of some methods and fixed verify_ca_test.py

Re #8472 - Added new line to `_run_for_output` method's docstring

Re #8472 - Removed unused method parameters

Re #8472 - Renamed `verify_ca` method to `verify_cert` and improved its documentation

Re #8472 - Improved `create_crt` documentation

Re #8472 - Renamed `make_csr` method to `create_csr`

Re #8471 - Corrected stylistics and warnings

Re #8472 - Added few unit tests that perform further testing of _run_for_output method

Re #8472 - Added verify_ca method that verifies whether a certificate has expired

Added 3 unit tests that verify the added method.
Added "days" parameter to some methods in order to be able to specify the number of days after which the generated certificate will expire.

Re #8472 - Small changes in the documentation

Re #8472 - Added create_crt method that creates a certificate

Added 3 unit tests testing the added method.

Re #8472 - Added sign_csr method that signs a CSR

Added 3 unit tests testing the added method.

Re #8472 - Added make_csr method that makes a CSR

Added 2 unit tests testing the added method.
Moved CryptographyService tests into a separate files