public void InsertAndDelete_ShouldNoLongerExistAfterDelete()
{
// Arrange
var expectedValue = 0;
var dbModel = new OssIndexModel()
{
ComponentId = 2,
Version = 6072,
Coordinates = "esse",
Description = "itaque",
TypeFormat = "vero",
Reference = "cumque",
ExpireDate = DateTime.Now,
HttpStatus = 90,
};
// Act
var newId = new OssIndexRepository(AppState.ConnectionString).Insert(dbModel);
new OssIndexRepository(AppState.ConnectionString).Delete(newId);
var actualValue = new OssIndexRepository(AppState.ConnectionString)
.Select(newId)
.Id;
// Assert
Assert.AreEqual(expectedValue, actualValue);
}
public void InsertThenUpdate_ShouldReflectChanges()
{
// Arrange
var dummyString = Guid.NewGuid().ToString().Replace("-", "");
var dbModel = new OssIndexModel()
{
ComponentId = 2,
Version = 85,
Coordinates = dummyString,
Description = "dolor",
TypeFormat = "vero",
Reference = "cumque",
ExpireDate = DateTime.Now,
HttpStatus = 90,
};
// Act
var newId = new OssIndexRepository(AppState.ConnectionString)
.Insert(dbModel);
dummyString = Guid.NewGuid().ToString().Replace("-", "");
var dbModel2 = new OssIndexRepository(AppState.ConnectionString)
.Select(newId);
dbModel2.Coordinates = dummyString;
new OssIndexRepository(AppState.ConnectionString)
.Update(dbModel2);
var actualValue = new OssIndexRepository(AppState.ConnectionString)
.Select(newId)
.Coordinates;
// Assert
Assert.AreEqual(dummyString, actualValue);
}
public void InsertAndSelect_ShouldEqualInserted()
{
// Arrange
var dbModel = new OssIndexModel()
{
ComponentId = 2,
Version = 9125,
Coordinates = "vel",
Description = "ut",
TypeFormat = "vero",
Reference = "praesentium",
ExpireDate = DateTime.Now,
HttpStatus = 6077,
};
var expectedValue = new OssIndexRepository(AppState.ConnectionString)
.Insert(dbModel);
// Act
var actualValue = new OssIndexRepository(AppState.ConnectionString)
.Select(expectedValue)
.Id;
// Assert
Assert.AreEqual(expectedValue, actualValue);
}
public void InsertBulkThenSelectList_ShouldEqualTwo()
{
// Arrange
var expectedValue = 2;
var dummyString = Guid.NewGuid().ToString().Replace("-", "");
var listPoco = new List <OssIndexModel>()
{
new OssIndexModel()
{
ComponentId = 2,
Version = 6072,
Coordinates = dummyString,
Description = "itaque",
TypeFormat = "vero",
Reference = "praesentium",
ExpireDate = DateTime.Now,
HttpStatus = 6077,
},
new OssIndexModel()
{
ComponentId = 2,
Version = 6072,
Coordinates = dummyString,
Description = "itaque",
TypeFormat = "vero",
Reference = "praesentium",
ExpireDate = DateTime.Now,
HttpStatus = 6077,
}
};
// Act
new OssIndexRepository(AppState.ConnectionString).InsertBulk(listPoco);
var actualValue = new OssIndexRepository(AppState.ConnectionString)
.SelectList()
.Where(x => x.Coordinates.Equals(dummyString))
.ToList()
.Count;
// Assert
Assert.AreEqual(expectedValue, actualValue);
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.Configure <CookiePolicyOptions>(options =>
{
// This lambda determines whether user consent for non-essential cookies is needed for a given request.
options.CheckConsentNeeded = context => true;
options.MinimumSameSitePolicy = SameSiteMode.None;
});
services.AddSession(options => {
options.IdleTimeout = TimeSpan.FromMinutes(15);
});
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2);
services.AddDbContext <EntityFrameWorkMagicContext>(options =>
options.UseSqlServer(Configuration.GetConnectionString("EntityFrameWorkMagicContext")));
// DI
var connectionString = Environment.GetEnvironmentVariable("SQL_CONNECTION") ?? Configuration.GetConnectionString("ConnMsSQL");
var projectRepository = new ProjectRepository(connectionString);
var componentRepository = new ComponentRepository(connectionString);
var ossIndexRepository = new OssIndexRepository(connectionString);
var ossIndexVulnerabilitiesRepository = new OssIndexVulnerabilitiesRepository(connectionString);
var reportRepository = new ReportRepository(connectionString);
var reportLinesRepository = new ReportLinesRepository(connectionString);
var packageTypeRepository = new PackageTypeRepository();
var httpWebRequestFactory = new HttpWebRequestFactory();
var coordinatesService = new CoordinatesService();
var jsonConvertService = new JsonConvertService();
var ossReportService = new OssReportService(
reportRepository,
componentRepository,
ossIndexRepository,
reportLinesRepository,
coordinatesService,
httpWebRequestFactory,
jsonConvertService,
ossIndexVulnerabilitiesRepository);
services.AddTransient <IProjectRepository>(s => projectRepository);
services.AddTransient <IComponentRepository>(s => componentRepository);
services.AddTransient <IOssIndexRepository>(s => ossIndexRepository);
services.AddTransient <IOssIndexVulnerabilitiesRepository>(s => ossIndexVulnerabilitiesRepository);
services.AddTransient <IReportRepository>(s => reportRepository);
services.AddTransient <IReportLinesRepository>(s => reportLinesRepository);
services.AddTransient <IPackageTypeRepository>(s => packageTypeRepository);
services.AddSingleton <IJsonConvertService>(jsonConvertService);
services.AddSingleton <ICoordinatesService>(coordinatesService);
services.AddSingleton <ISelectListItemService>(new SelectListItemService(projectRepository, packageTypeRepository));
services.AddSingleton <IScoreService>(new ScoreService(reportRepository, reportLinesRepository, ossIndexRepository, ossIndexVulnerabilitiesRepository));
services.AddSingleton <IScoreClassService>(new ScoreClassService());
services.AddSingleton <IBreadcrumbReportService>(new BreadcrumbReportService());
services.AddSingleton <IOssReportService>(ossReportService);
services.AddSingleton <IOssIndexStatusService>(new OssIndexStatusService(
reportRepository,
reportLinesRepository,
ossIndexRepository));
services.AddSingleton <IApiCallerService>(new ApiCallerService(
ossIndexRepository,
ossReportService));
services.AddSingleton <ICoordinatePartsFactory>(new CoordinatePartsFactory());
services.AddSingleton <IHttpWebRequestFactory>(httpWebRequestFactory);
}
