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);
}
}
}
protected override async Task ExecuteAsync(CancellationToken stoppingToken)
{
while (!stoppingToken.IsCancellationRequested)
{
try
{
var apiClient = new TvYandexApiClient();
var schedule = await apiClient.GetSchedule(DateTime.UtcNow);
var idApiList = new List <int>();
foreach (var item in schedule.schedule.schedules)
{
idApiList.Add(item.channel.id);
}
var dbItem = ChannelDataContext.Instance
.GetList(100,
SqlFilter.In("IdFromApi", idApiList))
.ToDictionary(x => x.IdFromApi, x => x.Id);
foreach (var channel in schedule.schedule.schedules)
{
try
{
if (dbItem.ContainsKey(channel.channel.id))
{
ChannelDataContext.Instance.Update(new Channel(), x =>
{
int val;
dbItem.TryGetValue(channel.channel.id, out val);
x.Id = val;
x.Name = channel.channel.familyTitle;
x.Description = channel.channel.title;
x.UpdatedUtc = DateTime.UtcNow;
x.IdFromApi = channel.channel.id;
});
}
else
{
ChannelDataContext.Instance.Create(new Channel(), x =>
{
x.Name = channel.channel.familyTitle;
x.Description = channel.channel.title;
x.UpdatedUtc = DateTime.UtcNow;
x.IdFromApi = channel.channel.id;
});
}
}
catch (Exception ex)
{
LogHelper.LogError(ex);
}
}
await Task.Delay(TimeSpan.FromMinutes(3), stoppingToken).ConfigureAwait(false);
}
catch (OperationCanceledException ex)
{
LogHelper.LogInfo(ex);
}
catch (Exception ex)
{
LogHelper.LogError(ex);
}
}
}