public async Task delete_a_training_to_a_PostresSql_database()
        {
            var connectionProvider           = new ConnectionProvider("Host=localhost;Port=5432;Username=admin;Password=admin;Database=python_db");
            var trainingRepositoryPostgreSql = new TrainingRepositoryPostgresSqlAdapter(connectionProvider);
            await trainingRepositoryPostgreSql.DeleteTraining(1);

            var training = await trainingRepositoryPostgreSql.GetTrainingById(1);

            training.Should().BeEmpty();
        }
        public async Task get_a_training_by_id_to_a_PostresSql_database()
        {
            var connectionProvider           = new ConnectionProvider("Host=localhost;Port=5432;Username=admin;Password=admin;Database=python_db");
            var trainingRepositoryPostgreSql = new TrainingRepositoryPostgresSqlAdapter(connectionProvider);
            var AName        = "training 1";
            var ADescription = "ADescription";
            var ADateTime    = new DateTime(2017, 4, 30);
            var createdBy    = "123";
            var ATraining    = new Training(1, AName, ADescription, ADateTime, createdBy);
            var trainings    = await trainingRepositoryPostgreSql.GetTrainingById(1);

            trainings.Should().BeEquivalentTo(new List <Training> {
                ATraining
            });
        }