public void OnlyConsidersPackagesWithAvailableStatus()
{
// Arrange
var cursor = Db2CatalogCursor.ByCreated(DateTime.UtcNow, 20);
// Act
var queryString = GalleryDatabaseQueryService.BuildDb2CatalogSqlQuery(cursor);
// Assert
Assert.Contains($"WHERE P.[PackageStatusKey] = {(int)PackageStatus.Available}", queryString);
}
public void SelectsFromPackagesTable()
{
// Arrange
var cursor = Db2CatalogCursor.ByCreated(DateTime.UtcNow, 20);
// Act
var queryString = GalleryDatabaseQueryService.BuildDb2CatalogSqlQuery(cursor);
// Assert
Assert.Contains("FROM [dbo].[Packages] AS P", queryString);
}
public void JoinsWithPackageRegistrationsTable()
{
// Arrange
var cursor = Db2CatalogCursor.ByCreated(DateTime.UtcNow, 20);
// Act
var queryString = GalleryDatabaseQueryService.BuildDb2CatalogSqlQuery(cursor);
// Assert
Assert.Contains("INNER JOIN [dbo].[PackageRegistrations] AS PR ON P.[PackageRegistrationKey] = PR.[Key]", queryString);
}
public void OrdersByCursorColumnName_LastEdited()
{
// Arrange
var cursor = Db2CatalogCursor.ByLastEdited(DateTime.UtcNow, 20);
// Act
var queryString = GalleryDatabaseQueryService.BuildDb2CatalogSqlQuery(cursor);
// Assert
Assert.EndsWith($"ORDER BY P.[{cursor.ColumnName}]", queryString);
}
public void SelectsTopWithTies()
{
// Arrange
var cursor = Db2CatalogCursor.ByCreated(DateTime.UtcNow, 10);
// Act
var queryString = GalleryDatabaseQueryService.BuildDb2CatalogSqlQuery(cursor);
// Assert
Assert.StartsWith($"SELECT TOP {cursor.Top} WITH TIES", queryString);
}
public IDisposable TrackGetPackageDetailsQueryDuration(Db2CatalogCursor cursor)
{
var properties = new Dictionary <string, string>()
{
{ TelemetryConstants.Method, cursor.ColumnName },
{ TelemetryConstants.BatchItemCount, cursor.Top.ToString() },
{ TelemetryConstants.CursorValue, cursor.CursorValue.ToString("O") }
};
return(_telemetryClient.TrackDuration(TelemetryConstants.GetPackageDetailsSeconds, properties));
}
public void OrdersByCursorColumnName_Created()
{
// Arrange
var cursor = Db2CatalogCursor.ByCreated(DateTime.UtcNow, 20);
// Act
var queryString = GalleryDatabaseQueryService.BuildDb2CatalogSqlQuery(cursor);
// Assert
Assert.EndsWith($"ORDER BY P_EXT.[{cursor.ColumnName}], P_EXT.[{Db2CatalogProjectionColumnNames.Key}]", queryString);
}
public void JoinsWithPackageVulnerabilitiesTables()
{
// Arrange
var cursor = Db2CatalogCursor.ByCreated(DateTime.UtcNow, 20);
// Act
var queryString = GalleryDatabaseQueryService.BuildDb2CatalogSqlQuery(cursor);
// Assert
Assert.Contains("LEFT JOIN [dbo].[VulnerablePackageVersionRangePackages] AS VPVRP ON VPVRP.[Package_Key] = P_EXT.[Key]", queryString);
Assert.Contains("LEFT JOIN [dbo].[VulnerablePackageVersionRanges] AS VPVR ON VPVR.[Key] = VPVRP.[VulnerablePackageVersionRange_Key]", queryString);
Assert.Contains("LEFT JOIN [dbo].[PackageVulnerabilities] AS PV ON PV.[Key] = VPVR.[VulnerabilityKey]", queryString);
}