public void Test_Integridade_GetConditionSpecie()
{
string esperado = "Id IN(Select distinct peopleId From people_species_species pss inner join species s on " +
$"s.Id = pss.speciesId where s.name = 'Human' ) and ";
string Atual = FunctionsPeopleService.GetConditionSpecie("Human");
Assert.Equal(esperado, Atual);
}
public void Test_Integridade_GetConditionPlanet_sem_Planet_com_Population()
{
string esperado = $"Id IN(Select distinct peopleId From people_planets_planets ppp inner join planets pl on " +
$"pl.Id = ppp.planetsId where ( Population> 1000)) and ";
string Atual = FunctionsPeopleService.GetConditionPlanet("", "1000");
Assert.Equal(esperado, Atual);
}
public void Test_Integridade_GetConditionStarship()
{
string esperado = $"Id IN(Select distinct peopleId From people_starships_starships pss inner join starships s on " +
$"s.Id = pss.starshipsId where s.name = 'Nave 1' ) and ";
string Atual = FunctionsPeopleService.GetConditionStarship("Nave 1");
Assert.Equal(esperado, Atual);
}
public void Test_Integridade_GetConditionFilm()
{
string esperado = $"Id IN(Select distinct peopleId From people_films_films pff inner join films f on " +
$"f.Id = pff.filmsId where f.title = 'A New Hope' ) and ";
string Atual = FunctionsPeopleService.GetConditionFilm("A New Hope");
Assert.Equal(esperado, Atual);
}
public void Test_Integridade_GetConditionVehicle()
{
string esperado = $"( Id IN(Select distinct peopleId From people_vehicles_vehicles ppp inner join vehicles v on " +
$"v.Id = ppp.vehiclesId where v.name = 'HB20') ) and ";
string Atual = FunctionsPeopleService.GetConditionVehicle("HB20");
Assert.Equal(esperado, Atual);
}
public static string GetConditionPlanet(this RepositoryPeople input, string name, string population)
{
return(FunctionsPeopleService.GetConditionPlanet(name, population));
}
public static string GetConditionSpecie(this RepositoryPeople input, string name)
{
return(FunctionsPeopleService.GetConditionSpecie(name));
}
public static string GetConditionStarship(this PeopleService input, string name)
{
return(FunctionsPeopleService.GetConditionSpecie(name));
}
public static string GetConditionFilm(this PeopleService input, string title)
{
return(FunctionsPeopleService.GetConditionSpecie(title));
}
