public async void InvokeSqlAssessmentServerTest()
{
var liveConnection = LiveConnectionHelper.InitLiveConnectionInfo("master");
var connection = liveConnection.ConnectionInfo.AllConnections.FirstOrDefault();
Debug.Assert(connection != null, "Live connection is always expected providing a connection");
var serverInfo = ReliableConnectionHelper.GetServerVersion(connection);
var response = await CallAssessment <AssessmentResultItem>(
nameof(SqlAssessmentService.InvokeSqlAssessment),
SqlObjectType.Server,
liveConnection);
Assert.All(
response.Items,
i =>
{
Assert.NotNull(i.Message);
Assert.NotEmpty(i.Message);
Assert.Equal(serverInfo.ServerName, i.TargetName);
if (i.Kind == 0)
{
AssertInfoPresent(i);
}
});
}
public async Task FindGameMinecraft()
{
var gamesResult = await sut.SearchGames("Minecraft");
Assert.NotNull(gamesResult);
Assert.NotEmpty(gamesResult);
}
public async Task FindGameWoW()
{
var gamesResult = await sut.SearchGames("World of Warcraft");
Assert.NotNull(gamesResult);
Assert.NotEmpty(gamesResult);
}
public async Task FindStreamEtup()
{
var streamsResult = await sut.SearchStreams(StreamName);
Assert.NotNull(streamsResult);
Assert.NotEmpty(streamsResult);
}
public async Task FindStreamsGivenPartialNames()
{
var streamsResult = await sut.SearchStreams("the");
Assert.NotNull(streamsResult);
Assert.NotEmpty(streamsResult);
}
public void ExtraKeyMustBeAdded()
{
//Arrange
var product = _databaseFixture.GetFirstTestProduct();
var key = KeyGenerator.GenerateExtraProductKey(product.Name, _databaseFixture.ExtraKeyName);
var extraKey = new ExtraProductKey {
Key = key, Name = _databaseFixture.ExtraKeyName
};
product.ExtraKeys = new List <ExtraProductKey> {
extraKey
};
//Act
_databaseFixture.DatabaseAdapter.UpdateProduct(product);
//Assert
var gotProduct = _databaseFixture.DatabaseAdapter.GetProduct(product.Name);
Assert.NotEmpty(gotProduct.ExtraKeys);
var keyFromDB = gotProduct.ExtraKeys.First();
Assert.Equal(extraKey.Name, keyFromDB.Name);
Assert.Equal(extraKey.Key, keyFromDB.Key);
}
public async Task GetFollowsFromUser()
{
var followedStreams = await sut.GetUserFollows(StreamName);
Assert.NotNull(followedStreams);
Assert.NotEmpty(followedStreams.Follows);
}
public void SensorValuesFromTheGivenPeriodMustBeReturned()
{
//Arrange
var product = _databaseFixture.GetFirstTestProduct();
var info = _databaseFixture.CreateSensorInfo();
var data = _databaseFixture.CreateSensorValues();
_databaseFixture.DatabaseAdapter.AddProduct(product);
_databaseFixture.DatabaseAdapter.AddSensor(info);
//Act
data.ForEach(d => _databaseFixture.DatabaseAdapter.PutSensorData(d, product.Name));
DateTime from = DateTime.Now.AddDays(-1 * 15);
DateTime to = DateTime.Now.AddDays(-1 * 4);
var expectedData = data.Where(e => e.TimeCollected <to &&
e.TimeCollected> from).ToList();
var dataFromDB = _databaseFixture.DatabaseAdapter.GetSensorHistory(product.Name, info.Path, from, to);
//Assert
Assert.NotEmpty(dataFromDB);
Assert.Equal(expectedData.Count, dataFromDB.Count);
expectedData.Sort((d1, d2) => d2.TimeCollected.CompareTo(d1.TimeCollected));
dataFromDB.Sort((d1, d2) => d2.Time.CompareTo(d1.Time));
for (int i = 0; i < expectedData.Count; ++i)
{
Assert.Equal(expectedData[i].TypedData, dataFromDB[i].TypedData);
Assert.Equal(expectedData[i].DataType, (byte)dataFromDB[i].SensorType);
}
}
public async Task GetTopGamesList()
{
var topGames = await sut.GetTopGames();
Assert.NotNull(topGames);
Assert.NotEmpty(topGames);
topGames.ForEach(x =>
{
Assert.NotNull(x.Game);
Assert.NotNull(x.Game.Name);
});
}
public async Task GetStreamsDetails()
{
var streamNames = new List <string>(new []
{
"massansc",
"esl_csgo",
"saintvicious"
});
var streamsDetails = await sut.GetStreamsDetails(streamNames);
Assert.NotNull(streamsDetails);
Assert.NotEmpty(streamsDetails);
}
public async Task GetChannelVideos(string channelName, bool broadcastsOnly, bool hlsVodsOnly)
{
var channelVideosQuery = new ChannelVideosQuery()
{
ChannelName = channelName,
BroadcastsOnly = broadcastsOnly,
HLSVodsOnly = hlsVodsOnly,
};
var channelVideos = await sut.GetChannelVideos(channelVideosQuery);
Assert.NotNull(channelVideos);
Assert.NotEmpty(channelVideos);
}
private void AssertInfoPresent(AssessmentItemInfo item)
{
Assert.NotNull(item.CheckId);
Assert.NotEmpty(item.CheckId);
Assert.NotNull(item.DisplayName);
Assert.NotEmpty(item.DisplayName);
Assert.NotNull(item.Description);
Assert.NotEmpty(item.Description);
Assert.NotNull(item.Tags);
Assert.All(item.Tags, t =>
{
Assert.NotNull(t);
Assert.NotEmpty(t);
});
}
public async Task GetTopStreams(string gameName)
{
var topStreamsQuery = new TopStreamQuery()
{
Skip = 0, Take = 100, GameName = gameName
};
var topStreams = await sut.GetTopStreams(topStreamsQuery);
Assert.NotNull(topStreams);
Assert.NotEmpty(topStreams);
if (topStreamsQuery.GameName != null)
{
Assert.All(topStreams, stream => Assert.Contains(topStreamsQuery.GameName, stream.Game, StringComparison.OrdinalIgnoreCase));
}
}
public void AllSensorValuesMustBeAdded()
{
//Arrange
var product = _databaseFixture.GetFirstTestProduct();
var info = _databaseFixture.CreateSensorInfo();
var data = _databaseFixture.CreateSensorValues();
_databaseFixture.DatabaseAdapter.AddProduct(product);
_databaseFixture.DatabaseAdapter.AddSensor(info);
//Act
data.ForEach(d => _databaseFixture.DatabaseAdapter.PutSensorData(d, product.Name));
var dataFromDB = _databaseFixture.DatabaseAdapter.GetAllSensorHistory(product.Name, info.Path);
//Assert
Assert.NotEmpty(dataFromDB);
Assert.Equal(data.Count, dataFromDB.Count);
}
public void ProductRoleMustBeAdded()
{
//Arrange
var user = _databaseFixture.CreateThirdUser();
//Act
_databaseFixture.DatabaseAdapter.AddUser(user);
var existingUser = _databaseFixture.DatabaseAdapter.GetUsers().First(u => u.Id == user.Id);
var key = _databaseFixture.GetFirstTestProduct().Key;
user.ProductsRoles.Add(new KeyValuePair <string, ProductRoleEnum>(key, ProductRoleEnum.ProductManager));
existingUser.Update(user);
Thread.Sleep(1000);
_databaseFixture.DatabaseAdapter.UpdateUser(existingUser);
var newUser = _databaseFixture.DatabaseAdapter.GetUsers().First(u => u.Id == user.Id);
//Assert
Assert.NotEmpty(newUser.ProductsRoles);
Assert.Equal(key, newUser.ProductsRoles.First().Key);
}
public async void InvokeSqlAssessmentIDatabaseTest()
{
const string DatabaseName = "tempdb";
var liveConnection = LiveConnectionHelper.InitLiveConnectionInfo(DatabaseName);
var response = await CallAssessment <AssessmentResultItem>(
nameof(SqlAssessmentService.InvokeSqlAssessment),
SqlObjectType.Database,
liveConnection);
Assert.All(
response.Items,
i =>
{
StringAssert.EndsWith(":" + DatabaseName, i.TargetName);
Assert.NotNull(i.Message);
Assert.NotEmpty(i.Message);
if (i.Kind == 0)
{
AssertInfoPresent(i);
}
});
}
