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

Re #8590 - Migrated subjects fields to the table of certificates

Re #8590 - Implemented new table of subjects
- from table of certificates is a linkage 1:1_N (Subject : Certificates)
- table contains all fields of subject (CN, C, L, ST, O, OU, Mail)

Re #8670 - Updated ERA model
- added column deletion_date in Certificates table

Re #8571 -Updated class diagram of CertificateService and CertificateRepository

Re #8578 - Edited database
- added new columns in Certificates table (revocation_date, revocation_reason)
- both can be null and have string (text) type
- generated new SQL query

Re #8475 fix failing setup of CertificateController

Re #8475 - Add a try/catch block in order to account for invalid JSON data being passed when accessing /api/certificates endpoint

Re #8475 - Fixed minor bug in GET /api/certificates endpoint with filtering

Re #8475 - Added redirect from "/" to "/static/index.html"

Re #8475 - Getting root and trust chain from controller uses correct service

Re #8475 - Connection to the RestAPI

Re #8475 Merge master with RestAPI implemented

Re #8476 merge rest api endpoints
Merge branch '8476_rest_api_endpoints' into 'master'
See merge request aswi/aswi-2021/aswi2021jmsd!8

Re #8476 - Changed structure of tests
- Renamed DAO integration tests so that they are found by pytest
- Moved RestAPI tests from UnitTests to IntegrationTests

Re #8476 - Cleaned-up database.

Re #8476 - Heavy refactoring and added comments.

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

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 #8475 - Changed notBefore & notAfter to validityDays

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 #8475 - Added code comments

Re #8475 - Create certificate, added cancel button, success alert

Re #8475 - Create certificate, binding input fields

Re #8475 - Create certificate, available CA selection

Re #8475 - Create certificate, selected CA binding

Re #8475 - Created constants.js for Rest API endpoint definitions

Re #8475 - Certificate item component added

Re #8475 - Added utilities.js with file download support

Re #8475 - Added Axios library

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