internal static void InjectData <T>(DbContextOptions <CompetentieAppFrontendContext> options, params T[] entities)
where T : class
{
using var context = new CompetentieAppFrontendContext(options);
context.Set <T>().AddRange(entities);
context.SaveChanges();
}
public void TestInitialize()
{
_connection = new SqliteConnection(DATA_SOURCE);
_connection.Open();
_options = new DbContextOptionsBuilder <CompetentieAppFrontendContext>()
.UseSqlite(_connection).Options;
using var context = new CompetentieAppFrontendContext(_options);
context.Database.EnsureCreated();
context.EnsureDataSeeded();
}
public void GetAllAuditLogEntries_Should_Return_Data_From_Database()
{
// Arrange
using var context = new CompetentieAppFrontendContext(_options);
var repository = new AuditLogEntryRepository(context);
// Act
var result = repository.GetAllAuditLogEntries();
// Assert
Assert.IsTrue(result.Any(entry => entry.Omschrijving == "Henk creeerde dit"));
}
public void GetAllAuditLogEntries_Should_Return_Instance_Of_Type_IList_With_AuditLogEntry()
{
// Arrange
using var context = new CompetentieAppFrontendContext(_options);
var repository = new AuditLogEntryRepository(context);
// Act
var result = repository.GetAllAuditLogEntries();
// Assert
Assert.IsInstanceOfType(result, typeof(IList <AuditLogEntry>));
}
public void GetAllModules_Should_Include_Competenties()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ModuleRepository(context);
// Act
var result = repository.GetAllModules().First();
// Assert
Assert.IsNotNull(result.Competenties);
}
public void EnsureArchitectuurLaagExist_Should_Save_New_Cohorts()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ArchitectuurLaagRepository(context);
// Act
var result = repository.EnsureArchitectuurLaagExist("verkopen");
// Assert
Assert.AreEqual(6, result);
}
public void EnsureArchitectuurLaagExist_Should_Not_Duplicate_Entry()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ArchitectuurLaagRepository(context);
// Act
var result = repository.EnsureArchitectuurLaagExist("gebruikersinteractie");
// Assert
Assert.AreEqual(1, result);
}
public void EnsureArchitectuurLaagExist_Should_Return_Instance_Of_Type_Long()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ArchitectuurLaagRepository(context);
// Act
var result = repository.EnsureArchitectuurLaagExist("gebruikersinteractie");
// Assert
Assert.IsInstanceOfType(result, typeof(long));
}
public void GetActiviteitNamen_Should_Return_Typeof_IList_Of_Strings()
{
// Arrange
using var context = new CompetentieAppFrontendContext(_options);
var repository = new ActiviteitRepository(context);
// Act
var result = repository.GetAllActiviteitNamen();
// Assert
Assert.IsInstanceOfType(result, typeof(IList <string>));
}
public void GetActiviteitNamen_Should_Return_Names_Retrieved_From_Database(string activiteitNaam)
{
// Arrange
using var context = new CompetentieAppFrontendContext(_options);
var repository = new ActiviteitRepository(context);
// Act
var result = repository.GetAllActiviteitNamen();
// Assert
Assert.IsTrue(result.Contains(activiteitNaam));
}
public void EnsureActiviteitExist_Should_Return_Instance_Of_Type_Long()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ActiviteitRepository(context);
// Act
var result = repository.EnsureActiviteitExist("analyseren");
// Assert
Assert.IsInstanceOfType(result, typeof(long));
}
public void EnsureActiviteitExist_Should_Not_Duplicate_Entry()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ActiviteitRepository(context);
// Act
var result = repository.EnsureActiviteitExist("analyseren");
// Assert
Assert.AreEqual(1, result);
}
public void EnsureCohortExist_Should_Not_Duplicate_Entry()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new CohortRepository(context);
// Act
var result = repository.EnsureCohortExist("2018-2019");
// Assert
Assert.AreEqual(1, result);
}
public void GetAllModules_Should_Be_Retrieved_From_Database(string moduleCode)
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ModuleRepository(context);
// Act
var result = repository.GetAllModules();
// Assert
Assert.IsTrue(result.Any(module => module.ModuleCode.Equals(moduleCode)));
}
public void GetAllModules_Should_Return_Typeof_IList_Of_Modules()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ModuleRepository(context);
// Act
var result = repository.GetAllModules();
// Assert
Assert.IsInstanceOfType(result, typeof(IList <Module>));
}
public void EnsureActiviteitExist_Should_Save_New_Cohorts()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ActiviteitRepository(context);
// Act
var result = repository.EnsureActiviteitExist("testen");
// Assert
Assert.AreEqual(6, result);
}
public void GetAllModules_Should_Include_AuditLogEntries()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ModuleRepository(context);
// Act
var result = repository.GetAllModules().First();
// Assert
Assert.IsTrue(result.AuditLogEntries.Any(entry => entry.Omschrijving == "Henk creeerde dit"));
}
public void GetAllModules_Should_Include_Cohort()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ModuleRepository(context);
// Act
var result = repository.GetAllModules().First();
// Assert
Assert.AreEqual("2018-2019", result.Cohort.CohortNaam);
}
public void GetAllModules_Should_Include_Eindeisen()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ModuleRepository(context);
// Act
var result = repository.GetAllModules().First();
// Assert
Assert.IsTrue(result.Eindeisen.Any(eindeis => eindeis.EindeisBeschrijving.Equals("Deze module is erg moeilijk.")));
}
public void GetAllModules_ShouldInclude_BeheersingsNiveaus()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ModuleRepository(context);
// Act
var result = repository.GetAllModules().First();
// Assert
Assert.IsTrue(result.Competenties.Any(competentie => competentie.BeheersingsNiveau.Niveau.Equals(1)));
}
public void GetAllModules_Should_Include_Specialisaties()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ModuleRepository(context);
// Act
var result = repository.GetAllModules().First();
// Assert
Assert.IsTrue(result.Studiefasen.Any(studiefase =>
studiefase.Specialisatie.Naam.Equals("Propedeuse")));
}
public void GetAllModules_Should_Include_Perioden()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ModuleRepository(context);
// Act
var result = repository.GetAllModules().First();
// Assert
Assert.IsTrue(result.Studiefasen.Any(studiefase =>
studiefase.Periode.PeriodeNummer == 1));
}
public void GetAllModules_Should_Include_ArchitectuurLagen()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new ModuleRepository(context);
// Act
var result = repository.GetAllModules().First();
// Assert
Assert.IsTrue(result.Competenties.Any(competentie =>
competentie.BeheersingsNiveau.ArchitectuurLaag.ArchitectuurLaagNaam.Equals("gebruikersinteractie")));
}
public void GetCompetentiesByCriteria_Should_Include_Competenties_From_Previous_Perioden()
{
// Arrange
using var context = new CompetentieAppFrontendContext(_options);
var repository = new CompetentieRepository(context);
// Act
var result = repository.GetAllCompetentiesByCriteria(new ICompetentieRepository.Criteria
{
PeriodeNummer = 5,
SpecialisatieNaam = "Propedeuse",
CohortNaam = "2018-2019"
});
// Assert
Assert.IsTrue(result.Any());
}
public void GetCompetentiesByCriteria_Should_Return_Retrieve_Data_From_Database(int moduleId)
{
// Arrange
using var context = new CompetentieAppFrontendContext(_options);
var repository = new CompetentieRepository(context);
// Act
var result = repository.GetAllCompetentiesByCriteria(new ICompetentieRepository.Criteria
{
PeriodeNummer = 1,
SpecialisatieNaam = "Propedeuse",
CohortNaam = "2018-2019"
});
// Assert
Assert.IsTrue(result.Any(competentie => competentie.ModuleId == moduleId));
}
public void GetAllCompetentiesByCriteria_Should_Include_Cohort()
{
// Arrange
var context = new CompetentieAppFrontendContext(_options);
var repository = new CompetentieRepository(context);
// Act
var result = repository.GetAllCompetentiesByCriteria(new ICompetentieRepository.Criteria
{
PeriodeNummer = 1,
SpecialisatieNaam = "Propedeuse",
CohortNaam = "2018-2019"
}).First();
// Assert
Assert.AreEqual("2018-2019", result.Module.Cohort.CohortNaam);
}
public void GetCompetentieByCriteria_Should_Return_Typeof_IList_Of_Competenties()
{
// Arrange
using var context = new CompetentieAppFrontendContext(_options);
var repository = new CompetentieRepository(context);
// Act
var result = repository.GetAllCompetentiesByCriteria(new ICompetentieRepository.Criteria
{
PeriodeNummer = 1,
SpecialisatieNaam = "Propedeuse",
CohortNaam = "2018-2019"
});
// Assert
Assert.IsInstanceOfType(result, typeof(IList<Competentie>));
}
public void GetCompetentiesByCriteria_Should_Be_Filtered_By_Criteria()
{
// Arrange
using var context = new CompetentieAppFrontendContext(_options);
var repository = new CompetentieRepository(context);
// Act
var result = repository.GetAllCompetentiesByCriteria(new ICompetentieRepository.Criteria
{
PeriodeNummer = 5,
SpecialisatieNaam = "Forensische ICT",
CohortNaam = "2018-2019"
});
// Assert
Assert.IsFalse(result.Any());
}
public void Create_Should_Save_New_Entry_To_Database()
{
// Arrange
using var context = new CompetentieAppFrontendContext(_options);
var repository = new AuditLogEntryRepository(context);
// Act
repository.Create(new AuditLogEntry
{
ModuleId = 1,
Omschrijving = "Dit is een nieuwe log entry",
Timestamp = new DateTime(2020, 6, 19)
});
// Assert
Assert.IsTrue(context.AuditLogEntries.Any(entry => entry.Omschrijving == "Dit is een nieuwe log entry"));
}
public void GetCompetentiesByCriteria_Should_Include_Module(string moduleCode)
{
// Arrange
using var context = new CompetentieAppFrontendContext(_options);
var repository = new CompetentieRepository(context);
// Act
var result = repository.GetAllCompetentiesByCriteria(new ICompetentieRepository.Criteria
{
PeriodeNummer = 1,
SpecialisatieNaam = "Propedeuse",
CohortNaam = "2018-2019"
});
// Assert
Assert.IsTrue(result.Any(competentie => competentie.Module.ModuleCode == moduleCode));
}
