public void TestMethod_IsNull()
{
var expected = "A Is NULL";
var actual = DbHelper.GetWhereString(SqlFilter.IsNull("A"));
Assert.AreEqual(expected, actual);
}
protected override async Task ExecuteAsync(CancellationToken stoppingToken)
{
while (!stoppingToken.IsCancellationRequested)
{
try
{
var channelsForUpdate = ChannelDataContext.Instance.GetList(1000,
SqlFilter.Lt("LastShow", DateTime.UtcNow.AddMinutes(-1.5))
.Or(SqlFilter.IsNull("LastShow")));
//получила все каналы из бд, для которых по условию нужно обработать их шоу и теперь для каждого: блочу его и получаю по апи все его шоу
var apiClient = new TvYandexApiClient();
foreach (var channel in channelsForUpdate)
{
string lastError = null;
using (var bulk = TvShowsDataContext.Instance.StartBulkProcessing())
{
var lockSessionId =
$"{System.AppDomain.CurrentDomain.FriendlyName}_{Thread.CurrentThread.ManagedThreadId}";
try
{
var node = await apiClient.GetSchedule(DateTime.UtcNow,
channel.IdFromApi);
var isLocked = ChannelDataContext.Instance.TryLock(channel, TimeSpan.FromMinutes(1),
ChannelDataContext.LockType.UpdateShows, lockSessionId);
if (isLocked)
{
// начинаю обработку шоу(получаю их по апи, формирую каждому ключ, мержу
var tvShows = node.events;
foreach (var show in tvShows)
{
try
{
var name = show.programTitle == ""
? (show.episodeTitle)
: (show.programTitle);
var startDateShow = show.start;
var showKey = TvShow.GetHash(name, channel.Id, startDateShow);
bulk.Merge(new TvShow(), x =>
{
x.Id = showKey;
x.Name = name;
x.Description = show.episodeTitle;
x.ImageUrl = show.url;
x.StartDateUtc = show.start;
x.ChannelId = channel.Id;
x.UpdatedUtc = DateTime.UtcNow;
});
}
catch (WarningException wEx)
{
LogHelper.LogWarning(wEx);
}
}
}
}
catch (Exception ex)
{
LogHelper.LogError(ex);
lastError = ex.ToString();
}
finally
{
ChannelDataContext.Instance.Update(channel, ch =>
{
ch.LastError = lastError;
ch.LastShow = DateTime.UtcNow;
}, ChannelDataContext.LockType.UpdateShows, lockSessionId);
}
}
}
await Task.Delay(TimeSpan.FromMinutes(2), stoppingToken);
}
catch (OperationCanceledException ex)
{
LogHelper.LogInfo(ex);
}
catch (Exception e)
{
LogHelper.LogError(e);
await Task.Delay(TimeSpan.FromMinutes(1), stoppingToken);
}
}
}
public void ChannelDataContextTests_GetList()
{
var items = ChannelDataContext.Instance.GetList(1, SqlFilter.Eq("Name", "Pervyy"), SqlFilter.IsNull("UpdatedUtc").Or(SqlFilter.Lt("UpdatedUtc", DateTime.UtcNow.AddHours(-4))));
Assert.AreEqual(0, items.Count);
}