void workerMyAnime2_DoWork(object sender, DoWorkEventArgs e)
{
MA2Progress ma2Progress = new MA2Progress();
ma2Progress.CurrentFile = 0;
ma2Progress.ErrorMessage = "";
ma2Progress.MigratedFiles = 0;
ma2Progress.TotalFiles = 0;
try
{
string databasePath = e.Argument as string;
string connString = string.Format(@"data source={0};useutf16encoding=True", databasePath);
SQLiteConnection myConn = new SQLiteConnection(connString);
myConn.Open();
// get a list of unlinked files
VideoLocalRepository repVids = new VideoLocalRepository();
AniDB_EpisodeRepository repAniEps = new AniDB_EpisodeRepository();
AniDB_AnimeRepository repAniAnime = new AniDB_AnimeRepository();
AnimeSeriesRepository repSeries = new AnimeSeriesRepository();
AnimeEpisodeRepository repEps = new AnimeEpisodeRepository();
List<VideoLocal> vids = repVids.GetVideosWithoutEpisode();
ma2Progress.TotalFiles = vids.Count;
foreach (VideoLocal vid in vids)
{
ma2Progress.CurrentFile = ma2Progress.CurrentFile + 1;
workerMyAnime2.ReportProgress(0, ma2Progress);
// search for this file in the XrossRef table in MA2
string sql = string.Format("SELECT AniDB_EpisodeID from CrossRef_Episode_FileHash WHERE Hash = '{0}' AND FileSize = {1}", vid.ED2KHash, vid.FileSize);
SQLiteCommand sqCommand = new SQLiteCommand(sql);
sqCommand.Connection = myConn;
SQLiteDataReader myReader = sqCommand.ExecuteReader();
while (myReader.Read())
{
int episodeID = 0;
if (!int.TryParse(myReader.GetValue(0).ToString(), out episodeID)) continue;
if (episodeID <= 0) continue;
sql = string.Format("SELECT AnimeID from AniDB_Episode WHERE EpisodeID = {0}", episodeID);
sqCommand = new SQLiteCommand(sql);
sqCommand.Connection = myConn;
SQLiteDataReader myReader2 = sqCommand.ExecuteReader();
while (myReader2.Read())
{
int animeID = myReader2.GetInt32(0);
// so now we have all the needed details we can link the file to the episode
// as long as wehave the details in JMM
AniDB_Anime anime = null;
AniDB_Episode ep = repAniEps.GetByEpisodeID(episodeID);
if (ep == null)
{
logger.Debug("Getting Anime record from AniDB....");
anime = JMMService.AnidbProcessor.GetAnimeInfoHTTP(animeID, true, ServerSettings.AutoGroupSeries);
}
else
anime = repAniAnime.GetByAnimeID(animeID);
// create the group/series/episode records if needed
AnimeSeries ser = null;
if (anime == null) continue;
logger.Debug("Creating groups, series and episodes....");
// check if there is an AnimeSeries Record associated with this AnimeID
ser = repSeries.GetByAnimeID(animeID);
if (ser == null)
{
// create a new AnimeSeries record
ser = anime.CreateAnimeSeriesAndGroup();
}
ser.CreateAnimeEpisodes();
// check if we have any group status data for this associated anime
// if not we will download it now
AniDB_GroupStatusRepository repStatus = new AniDB_GroupStatusRepository();
if (repStatus.GetByAnimeID(anime.AnimeID).Count == 0)
{
CommandRequest_GetReleaseGroupStatus cmdStatus = new CommandRequest_GetReleaseGroupStatus(anime.AnimeID, false);
cmdStatus.Save();
}
// update stats
ser.EpisodeAddedDate = DateTime.Now;
repSeries.Save(ser);
AnimeGroupRepository repGroups = new AnimeGroupRepository();
foreach (AnimeGroup grp in ser.AllGroupsAbove)
{
grp.EpisodeAddedDate = DateTime.Now;
repGroups.Save(grp);
}
AnimeEpisode epAnime = repEps.GetByAniDBEpisodeID(episodeID);
if (epAnime == null)
continue;
CrossRef_File_EpisodeRepository repXRefs = new CrossRef_File_EpisodeRepository();
CrossRef_File_Episode xref = new CrossRef_File_Episode();
try
{
xref.PopulateManually(vid, epAnime);
}
catch (Exception ex)
{
string msg = string.Format("Error populating XREF: {0} - {1}", vid.ToStringDetailed(), ex.ToString());
throw;
}
repXRefs.Save(xref);
vid.RenameIfRequired();
vid.MoveFileIfRequired();
// update stats for groups and series
if (ser != null)
{
// update all the groups above this series in the heirarchy
ser.UpdateStats(true, true, true);
StatsCache.Instance.UpdateUsingSeries(ser.AnimeSeriesID);
}
// Add this file to the users list
if (ServerSettings.AniDB_MyList_AddFiles)
{
CommandRequest_AddFileToMyList cmd = new CommandRequest_AddFileToMyList(vid.ED2KHash);
cmd.Save();
}
ma2Progress.MigratedFiles = ma2Progress.MigratedFiles + 1;
workerMyAnime2.ReportProgress(0, ma2Progress);
}
myReader2.Close();
//Console.WriteLine(myReader.GetString(0));
}
myReader.Close();
}
myConn.Close();
ma2Progress.CurrentFile = ma2Progress.CurrentFile + 1;
workerMyAnime2.ReportProgress(0, ma2Progress);
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
ma2Progress.ErrorMessage = ex.Message;
workerMyAnime2.ReportProgress(0, ma2Progress);
}
}
private void ProcessFile_AniDB(VideoLocal vidLocal)
{
logger.Trace("Checking for AniDB_File record for: {0} --- {1}", vidLocal.Hash, vidLocal.FilePath);
// check if we already have this AniDB_File info in the database
AniDB_FileRepository repAniFile = new AniDB_FileRepository();
AniDB_EpisodeRepository repAniEps = new AniDB_EpisodeRepository();
AniDB_AnimeRepository repAniAnime = new AniDB_AnimeRepository();
AnimeSeriesRepository repSeries = new AnimeSeriesRepository();
VideoLocalRepository repVidLocals = new VideoLocalRepository();
AnimeEpisodeRepository repEps = new AnimeEpisodeRepository();
CrossRef_File_EpisodeRepository repXrefFE = new CrossRef_File_EpisodeRepository();
AniDB_File aniFile = null;
if (!ForceAniDB)
{
aniFile = repAniFile.GetByHashAndFileSize(vidLocal.Hash, vlocal.FileSize);
if (aniFile == null)
logger.Trace("AniDB_File record not found");
}
int animeID = 0;
if (aniFile == null)
{
// get info from AniDB
logger.Debug("Getting AniDB_File record from AniDB....");
Raw_AniDB_File fileInfo = JMMService.AnidbProcessor.GetFileInfo(vidLocal);
if (fileInfo != null)
{
// check if we already have a record
aniFile = repAniFile.GetByHashAndFileSize(vidLocal.Hash, vlocal.FileSize);
if (aniFile == null)
aniFile = new AniDB_File();
aniFile.Populate(fileInfo);
//overwrite with local file name
string localFileName = Path.GetFileName(vidLocal.FilePath);
aniFile.FileName = localFileName;
repAniFile.Save(aniFile, false);
aniFile.CreateLanguages();
aniFile.CreateCrossEpisodes(localFileName);
if (!string.IsNullOrEmpty(fileInfo.OtherEpisodesRAW))
{
string[] epIDs = fileInfo.OtherEpisodesRAW.Split(',');
foreach (string epid in epIDs)
{
int id = 0;
if (int.TryParse(epid, out id))
{
CommandRequest_GetEpisode cmdEp = new CommandRequest_GetEpisode(id);
cmdEp.Save();
}
}
}
animeID = aniFile.AnimeID;
}
}
bool missingEpisodes = false;
// if we still haven't got the AniDB_File Info we try the web cache or local records
if (aniFile == null)
{
// check if we have any records from previous imports
List<CrossRef_File_Episode> crossRefs = repXrefFE.GetByHash(vidLocal.Hash);
if (crossRefs == null || crossRefs.Count == 0)
{
// lets see if we can find the episode/anime info from the web cache
if (ServerSettings.WebCache_XRefFileEpisode_Get)
{
crossRefs = XMLService.Get_CrossRef_File_Episode(vidLocal);
if (crossRefs == null || crossRefs.Count == 0)
{
logger.Debug("Cannot find AniDB_File record or get cross ref from web cache record so exiting: {0}", vidLocal.ED2KHash);
return;
}
else
{
foreach (CrossRef_File_Episode xref in crossRefs)
{
// in this case we need to save the cross refs manually as AniDB did not provide them
repXrefFE.Save(xref);
}
}
}
else
{
logger.Debug("Cannot get AniDB_File record so exiting: {0}", vidLocal.ED2KHash);
return;
}
}
// we assume that all episodes belong to the same anime
foreach (CrossRef_File_Episode xref in crossRefs)
{
animeID = xref.AnimeID;
AniDB_Episode ep = repAniEps.GetByEpisodeID(xref.EpisodeID);
if (ep == null) missingEpisodes = true;
}
}
else
{
// check if we have the episode info
// if we don't, we will need to re-download the anime info (which also has episode info)
if (aniFile.EpisodeCrossRefs.Count == 0)
{
animeID = aniFile.AnimeID;
// if we have the anidb file, but no cross refs it means something has been broken
logger.Debug("Could not find any cross ref records for: {0}", vidLocal.ED2KHash);
missingEpisodes = true;
}
else
{
foreach (CrossRef_File_Episode xref in aniFile.EpisodeCrossRefs)
{
AniDB_Episode ep = repAniEps.GetByEpisodeID(xref.EpisodeID);
if (ep == null)
missingEpisodes = true;
animeID = xref.AnimeID;
}
}
}
// get from DB
AniDB_Anime anime = repAniAnime.GetByAnimeID(animeID);
bool animeRecentlyUpdated = false;
if (anime != null)
{
TimeSpan ts = DateTime.Now - anime.DateTimeUpdated;
if (ts.TotalHours < 4) animeRecentlyUpdated = true;
}
// even if we are missing episode info, don't get data more than once every 4 hours
// this is to prevent banning
if (missingEpisodes && !animeRecentlyUpdated)
{
logger.Debug("Getting Anime record from AniDB....");
// try using the cache first
using (var session = JMMService.SessionFactory.OpenSession())
{
anime = JMMService.AnidbProcessor.GetAnimeInfoHTTPFromCache(session, animeID, ServerSettings.AutoGroupSeries);
}
// if not in cache try from AniDB
if (anime == null)
anime = JMMService.AnidbProcessor.GetAnimeInfoHTTP(animeID, true, ServerSettings.AutoGroupSeries);
}
// create the group/series/episode records if needed
AnimeSeries ser = null;
if (anime != null)
{
logger.Debug("Creating groups, series and episodes....");
// check if there is an AnimeSeries Record associated with this AnimeID
ser = repSeries.GetByAnimeID(animeID);
if (ser == null)
{
// create a new AnimeSeries record
ser = anime.CreateAnimeSeriesAndGroup();
}
ser.CreateAnimeEpisodes();
// check if we have any group status data for this associated anime
// if not we will download it now
AniDB_GroupStatusRepository repStatus = new AniDB_GroupStatusRepository();
if (repStatus.GetByAnimeID(anime.AnimeID).Count == 0)
{
CommandRequest_GetReleaseGroupStatus cmdStatus = new CommandRequest_GetReleaseGroupStatus(anime.AnimeID, false);
cmdStatus.Save();
}
// update stats
ser.EpisodeAddedDate = DateTime.Now;
repSeries.Save(ser);
AnimeGroupRepository repGroups = new AnimeGroupRepository();
foreach (AnimeGroup grp in ser.AllGroupsAbove)
{
grp.EpisodeAddedDate = DateTime.Now;
repGroups.Save(grp);
}
}
vidLocal.RenameIfRequired();
vidLocal.MoveFileIfRequired();
// update stats for groups and series
if (ser != null)
{
// update all the groups above this series in the heirarchy
ser.UpdateStats(true, true, true);
StatsCache.Instance.UpdateUsingSeries(ser.AnimeSeriesID);
}
// Add this file to the users list
if (ServerSettings.AniDB_MyList_AddFiles)
{
CommandRequest_AddFileToMyList cmd = new CommandRequest_AddFileToMyList(vidLocal.ED2KHash);
cmd.Save();
}
// lets also try adding to the users trakt collecion by sync'ing the series
if (ser != null)
{
CommandRequest_TraktSyncCollectionSeries cmdTrakt = new CommandRequest_TraktSyncCollectionSeries(ser.AnimeSeriesID, ser.GetAnime().MainTitle);
cmdTrakt.Save();
}
// sync the series on MAL
if (ser != null)
{
CommandRequest_MALUpdatedWatchedStatus cmdMAL = new CommandRequest_MALUpdatedWatchedStatus(ser.AniDB_ID);
cmdMAL.Save();
}
}
public string AssociateSingleFile(int videoLocalID, int animeEpisodeID)
{
try
{
VideoLocalRepository repVids = new VideoLocalRepository();
VideoLocal vid = repVids.GetByID(videoLocalID);
if (vid == null)
return "Could not find video record";
AnimeEpisodeRepository repEps = new AnimeEpisodeRepository();
AnimeEpisode ep = repEps.GetByID(animeEpisodeID);
if (ep == null)
return "Could not find episode record";
CrossRef_File_EpisodeRepository repXRefs = new CrossRef_File_EpisodeRepository();
CrossRef_File_Episode xref = new CrossRef_File_Episode();
try
{
xref.PopulateManually(vid, ep);
}
catch (Exception ex)
{
string msg = string.Format("Error populating XREF: {0}", vid.ToStringDetailed());
throw;
}
repXRefs.Save(xref);
vid.RenameIfRequired();
vid.MoveFileIfRequired();
CommandRequest_WebCacheSendXRefFileEpisode cr = new CommandRequest_WebCacheSendXRefFileEpisode(xref.CrossRef_File_EpisodeID);
cr.Save();
AnimeSeries ser = ep.GetAnimeSeries();
ser.QueueUpdateStats();
// update epidsode added stats
AnimeSeriesRepository repSeries = new AnimeSeriesRepository();
ser.EpisodeAddedDate = DateTime.Now;
repSeries.Save(ser);
AnimeGroupRepository repGroups = new AnimeGroupRepository();
foreach (AnimeGroup grp in ser.AllGroupsAbove)
{
grp.EpisodeAddedDate = DateTime.Now;
repGroups.Save(grp);
}
CommandRequest_AddFileToMyList cmdAddFile = new CommandRequest_AddFileToMyList(vid.Hash);
cmdAddFile.Save();
return "";
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
}
return "";
}
// List of Default priorities for commands
// Pri 1
//------
// Reserved for commands user manually initiates from UI
//------
// Pri 2
//------
// CommandRequest_GetAnimeHTTP
//------
// Pri 3
//------
// CommandRequest_ProcessFile
// CommandRequest_GetFile
//------
// Pri 4
//------
// CommandRequest_GetUpdated
// CommandRequest_ReadMediaInfo
// CommandRequest_GetEpsode
//------
// Pri 5
//------
// CommandRequest_GetReleaseGroupStatus
//------
// Pri 6
//------
// CommandRequest_SyncMyList
// CommandRequest_SyncMyVotes
//------
// Pri 7
//------
// CommandRequest_GetCalendar
//------
// Pri 8
//------
// CommandRequest_UpdateMyListFileStatus
// CommandRequest_GetCharactersCreators
// CommandRequest_TraktSyncCollection
// CommandRequest_TvDBUpdateSeriesAndEpisodes
// CommandRequest_TvDBDownloadImages
// CommandRequest_TvDBSearchAnime
// CommandRequest_MovieDBSearchAnime
// CommandRequest_TraktSearchAnime
// CommandRequest_MALSearchAnime
//------
// Pri 9
//------
// CommandRequest_WebCacheSendFileHash
// CommandRequest_GetReviews
// CommandRequest_GetReleaseGroup
// CommandRequest_WebCacheSendXRefFileEpisode
// CommandRequest_WebCacheDeleteXRefFileEpisode
// CommandRequest_AddFileToMyList
// CommandRequest_DeleteFileFromMyList
// CommandRequest_VoteAnime
// CommandRequest_WebCacheDeleteXRefAniDBTvDB
// CommandRequest_WebCacheDeleteXRefAniDBTvDBAll
// CommandRequest_WebCacheSendXRefAniDBTvDB
// CommandRequest_WebCacheSendXRefAniDBOther
// CommandRequest_WebCacheDeleteXRefAniDBOther
// CommandRequest_WebCacheDeleteXRefAniDBTrakt
// CommandRequest_WebCacheSendXRefAniDBTrakt
// CommandRequest_TraktUpdateInfoAndImages
// CommandRequest_TraktSyncCollectionSeries
// CommandRequest_TraktShowEpisodeUnseen
// CommandRequest_DownloadImage
// CommandRequest_TraktUpdateAllSeries
// CommandRequest_MALUpdatedWatchedStatus
// CommandRequest_MALUploadStatusToMAL
// CommandRequest_MALDownloadStatusFromMAL
// CommandRequest_WebCacheSendAniDB_File
// CommandRequest_Azure_SendAnimeFull
//------
// Pri 10
//------
// CommandRequest_UpdateMylistStats
// CommandRequest_Azure_SendAnimeXML
//------
// Pri 11
//------
// CommandRequest_Azure_SendAnimeTitle
public static ICommandRequest GetCommand(CommandRequest crdb)
{
CommandRequestType crt = (CommandRequestType)crdb.CommandType;
switch (crt)
{
case CommandRequestType.Trakt_SyncCollectionSeries:
CommandRequest_TraktSyncCollectionSeries cr_CommandRequest_TraktSyncCollectionSeries =
new CommandRequest_TraktSyncCollectionSeries();
cr_CommandRequest_TraktSyncCollectionSeries.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_CommandRequest_TraktSyncCollectionSeries);
case CommandRequestType.AniDB_GetEpisodeUDP:
CommandRequest_GetEpisode cr_CommandRequest_GetEpisode = new CommandRequest_GetEpisode();
cr_CommandRequest_GetEpisode.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_CommandRequest_GetEpisode);
case CommandRequestType.Azure_SendAnimeTitle:
CommandRequest_Azure_SendAnimeTitle cr_CommandRequest_Azure_SendAnimeTitle =
new CommandRequest_Azure_SendAnimeTitle();
cr_CommandRequest_Azure_SendAnimeTitle.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_CommandRequest_Azure_SendAnimeTitle);
case CommandRequestType.AniDB_GetTitles:
CommandRequest_GetAniDBTitles cr_CommandRequest_GetAniDBTitles = new CommandRequest_GetAniDBTitles();
cr_CommandRequest_GetAniDBTitles.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_CommandRequest_GetAniDBTitles);
case CommandRequestType.Azure_SendAnimeXML:
CommandRequest_Azure_SendAnimeXML cr_CommandRequest_Azure_SendAnimeXML =
new CommandRequest_Azure_SendAnimeXML();
cr_CommandRequest_Azure_SendAnimeXML.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_CommandRequest_Azure_SendAnimeXML);
case CommandRequestType.Azure_SendAnimeFull:
CommandRequest_Azure_SendAnimeFull cr_CommandRequest_Azure_SendAnimeFull =
new CommandRequest_Azure_SendAnimeFull();
cr_CommandRequest_Azure_SendAnimeFull.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_CommandRequest_Azure_SendAnimeFull);
case CommandRequestType.Azure_SendUserInfo:
CommandRequest_Azure_SendUserInfo cr_CommandRequest_Azure_SendUserInfo =
new CommandRequest_Azure_SendUserInfo();
cr_CommandRequest_Azure_SendUserInfo.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_CommandRequest_Azure_SendUserInfo);
case CommandRequestType.AniDB_UpdateMylistStats:
CommandRequest_UpdateMylistStats cr_AniDB_UpdateMylistStats = new CommandRequest_UpdateMylistStats();
cr_AniDB_UpdateMylistStats.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_AniDB_UpdateMylistStats);
case CommandRequestType.MAL_DownloadWatchedStates:
CommandRequest_MALDownloadStatusFromMAL cr_MAL_DownloadWatchedStates =
new CommandRequest_MALDownloadStatusFromMAL();
cr_MAL_DownloadWatchedStates.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_MAL_DownloadWatchedStates);
case CommandRequestType.MAL_UploadWatchedStates:
CommandRequest_MALUploadStatusToMAL cr_MAL_UploadWatchedStates =
new CommandRequest_MALUploadStatusToMAL();
cr_MAL_UploadWatchedStates.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_MAL_UploadWatchedStates);
case CommandRequestType.MAL_UpdateStatus:
CommandRequest_MALUpdatedWatchedStatus cr_MAL_UpdateStatus =
new CommandRequest_MALUpdatedWatchedStatus();
cr_MAL_UpdateStatus.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_MAL_UpdateStatus);
case CommandRequestType.MAL_SearchAnime:
CommandRequest_MALSearchAnime cr_MAL_SearchAnime = new CommandRequest_MALSearchAnime();
cr_MAL_SearchAnime.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_MAL_SearchAnime);
case CommandRequestType.WebCache_SendXRefAniDBMAL:
CommandRequest_WebCacheSendXRefAniDBMAL cr_WebCacheSendXRefAniDBMAL =
new CommandRequest_WebCacheSendXRefAniDBMAL();
cr_WebCacheSendXRefAniDBMAL.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_WebCacheSendXRefAniDBMAL);
case CommandRequestType.WebCache_DeleteXRefAniDBMAL:
CommandRequest_WebCacheDeleteXRefAniDBMAL cr_WebCacheDeleteXRefAniDBMAL =
new CommandRequest_WebCacheDeleteXRefAniDBMAL();
cr_WebCacheDeleteXRefAniDBMAL.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_WebCacheDeleteXRefAniDBMAL);
case CommandRequestType.AniDB_GetFileUDP:
CommandRequest_GetFile cr_AniDB_GetFileUDP = new CommandRequest_GetFile();
cr_AniDB_GetFileUDP.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_AniDB_GetFileUDP);
case CommandRequestType.ReadMediaInfo:
CommandRequest_ReadMediaInfo cr_ReadMediaInfo = new CommandRequest_ReadMediaInfo();
cr_ReadMediaInfo.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_ReadMediaInfo);
case CommandRequestType.Trakt_UpdateAllSeries:
CommandRequest_TraktUpdateAllSeries cr_Trakt_UpdateAllSeries =
new CommandRequest_TraktUpdateAllSeries();
cr_Trakt_UpdateAllSeries.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_Trakt_UpdateAllSeries);
case CommandRequestType.Trakt_EpisodeCollection:
CommandRequest_TraktCollectionEpisode cr_TraktCollectionEpisode =
new CommandRequest_TraktCollectionEpisode();
cr_TraktCollectionEpisode.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_TraktCollectionEpisode);
case CommandRequestType.Trakt_SyncCollection:
CommandRequest_TraktSyncCollection cr_Trakt_SyncCollection =
new CommandRequest_TraktSyncCollection();
cr_Trakt_SyncCollection.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_Trakt_SyncCollection);
case CommandRequestType.Trakt_EpisodeHistory:
CommandRequest_TraktHistoryEpisode cr_Trakt_EpisodeHistory =
new CommandRequest_TraktHistoryEpisode();
cr_Trakt_EpisodeHistory.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_Trakt_EpisodeHistory);
case CommandRequestType.Trakt_UpdateInfoImages:
CommandRequest_TraktUpdateInfoAndImages cr_Trakt_UpdateInfoImages =
new CommandRequest_TraktUpdateInfoAndImages();
cr_Trakt_UpdateInfoImages.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_Trakt_UpdateInfoImages);
case CommandRequestType.WebCache_SendXRefAniDBTrakt:
CommandRequest_WebCacheSendXRefAniDBTrakt cr_WebCache_SendXRefAniDBTrakt =
new CommandRequest_WebCacheSendXRefAniDBTrakt();
cr_WebCache_SendXRefAniDBTrakt.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_WebCache_SendXRefAniDBTrakt);
case CommandRequestType.WebCache_DeleteXRefAniDBTrakt:
CommandRequest_WebCacheDeleteXRefAniDBTrakt cr_WebCache_DeleteXRefAniDBTrakt =
new CommandRequest_WebCacheDeleteXRefAniDBTrakt();
cr_WebCache_DeleteXRefAniDBTrakt.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_WebCache_DeleteXRefAniDBTrakt);
case CommandRequestType.Trakt_SearchAnime:
CommandRequest_TraktSearchAnime cr_Trakt_SearchAnime = new CommandRequest_TraktSearchAnime();
cr_Trakt_SearchAnime.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_Trakt_SearchAnime);
case CommandRequestType.MovieDB_SearchAnime:
CommandRequest_MovieDBSearchAnime cr_MovieDB_SearchAnime = new CommandRequest_MovieDBSearchAnime();
cr_MovieDB_SearchAnime.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_MovieDB_SearchAnime);
case CommandRequestType.WebCache_DeleteXRefAniDBOther:
CommandRequest_WebCacheDeleteXRefAniDBOther cr_SendXRefAniDBOther =
new CommandRequest_WebCacheDeleteXRefAniDBOther();
cr_SendXRefAniDBOther.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_SendXRefAniDBOther);
case CommandRequestType.WebCache_SendXRefAniDBOther:
CommandRequest_WebCacheSendXRefAniDBOther cr_WebCacheSendXRefAniDBOther =
new CommandRequest_WebCacheSendXRefAniDBOther();
cr_WebCacheSendXRefAniDBOther.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_WebCacheSendXRefAniDBOther);
case CommandRequestType.AniDB_DeleteFileUDP:
CommandRequest_DeleteFileFromMyList cr_AniDB_DeleteFileUDP =
new CommandRequest_DeleteFileFromMyList();
cr_AniDB_DeleteFileUDP.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_AniDB_DeleteFileUDP);
case CommandRequestType.ImageDownload:
CommandRequest_DownloadImage cr_ImageDownload = new CommandRequest_DownloadImage();
cr_ImageDownload.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_ImageDownload);
case CommandRequestType.WebCache_DeleteXRefAniDBTvDB:
CommandRequest_WebCacheDeleteXRefAniDBTvDB cr_DeleteXRefAniDBTvDB =
new CommandRequest_WebCacheDeleteXRefAniDBTvDB();
cr_DeleteXRefAniDBTvDB.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_DeleteXRefAniDBTvDB);
case CommandRequestType.WebCache_SendXRefAniDBTvDB:
CommandRequest_WebCacheSendXRefAniDBTvDB cr_SendXRefAniDBTvDB =
new CommandRequest_WebCacheSendXRefAniDBTvDB();
cr_SendXRefAniDBTvDB.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_SendXRefAniDBTvDB);
case CommandRequestType.TvDB_SearchAnime:
CommandRequest_TvDBSearchAnime cr_TvDB_SearchAnime = new CommandRequest_TvDBSearchAnime();
cr_TvDB_SearchAnime.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_TvDB_SearchAnime);
case CommandRequestType.TvDB_DownloadImages:
CommandRequest_TvDBDownloadImages cr_TvDB_DownloadImages = new CommandRequest_TvDBDownloadImages();
cr_TvDB_DownloadImages.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_TvDB_DownloadImages);
case CommandRequestType.TvDB_SeriesEpisodes:
CommandRequest_TvDBUpdateSeriesAndEpisodes cr_TvDB_Episodes =
new CommandRequest_TvDBUpdateSeriesAndEpisodes();
cr_TvDB_Episodes.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_TvDB_Episodes);
case CommandRequestType.AniDB_SyncVotes:
CommandRequest_SyncMyVotes cr_SyncVotes = new CommandRequest_SyncMyVotes();
cr_SyncVotes.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_SyncVotes);
case CommandRequestType.AniDB_VoteAnime:
CommandRequest_VoteAnime cr_VoteAnime = new CommandRequest_VoteAnime();
cr_VoteAnime.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_VoteAnime);
case CommandRequestType.AniDB_GetCalendar:
CommandRequest_GetCalendar cr_GetCalendar = new CommandRequest_GetCalendar();
cr_GetCalendar.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_GetCalendar);
case CommandRequestType.AniDB_GetReleaseGroup:
CommandRequest_GetReleaseGroup cr_GetReleaseGroup = new CommandRequest_GetReleaseGroup();
cr_GetReleaseGroup.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_GetReleaseGroup);
case CommandRequestType.AniDB_GetAnimeHTTP:
CommandRequest_GetAnimeHTTP cr_geth = new CommandRequest_GetAnimeHTTP();
cr_geth.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_geth);
case CommandRequestType.AniDB_GetReleaseGroupStatus:
CommandRequest_GetReleaseGroupStatus cr_GetReleaseGroupStatus =
new CommandRequest_GetReleaseGroupStatus();
cr_GetReleaseGroupStatus.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_GetReleaseGroupStatus);
case CommandRequestType.HashFile:
CommandRequest_HashFile cr_HashFile = new CommandRequest_HashFile();
cr_HashFile.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_HashFile);
case CommandRequestType.ProcessFile:
CommandRequest_ProcessFile cr_pf = new CommandRequest_ProcessFile();
cr_pf.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_pf);
case CommandRequestType.AniDB_AddFileUDP:
CommandRequest_AddFileToMyList cr_af = new CommandRequest_AddFileToMyList();
cr_af.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_af);
case CommandRequestType.AniDB_UpdateWatchedUDP:
CommandRequest_UpdateMyListFileStatus cr_umlf = new CommandRequest_UpdateMyListFileStatus();
cr_umlf.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_umlf);
case CommandRequestType.WebCache_DeleteXRefFileEpisode:
CommandRequest_WebCacheDeleteXRefFileEpisode cr_DeleteXRefFileEpisode =
new CommandRequest_WebCacheDeleteXRefFileEpisode();
cr_DeleteXRefFileEpisode.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_DeleteXRefFileEpisode);
case CommandRequestType.WebCache_SendXRefFileEpisode:
CommandRequest_WebCacheSendXRefFileEpisode cr_SendXRefFileEpisode =
new CommandRequest_WebCacheSendXRefFileEpisode();
cr_SendXRefFileEpisode.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_SendXRefFileEpisode);
case CommandRequestType.AniDB_GetReviews:
CommandRequest_GetReviews cr_GetReviews = new CommandRequest_GetReviews();
cr_GetReviews.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_GetReviews);
case CommandRequestType.AniDB_GetUpdated:
CommandRequest_GetUpdated cr_GetUpdated = new CommandRequest_GetUpdated();
cr_GetUpdated.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_GetUpdated);
case CommandRequestType.AniDB_SyncMyList:
CommandRequest_SyncMyList cr_SyncMyList = new CommandRequest_SyncMyList();
cr_SyncMyList.LoadFromDBCommand(crdb);
return((ICommandRequest)cr_SyncMyList);
case CommandRequestType.Refresh_AnimeStats:
CommandRequest_RefreshAnime cr_refreshAnime = new CommandRequest_RefreshAnime();
cr_refreshAnime.LoadFromDBCommand(crdb);
return(cr_refreshAnime);
case CommandRequestType.LinkAniDBTvDB:
CommandRequest_LinkAniDBTvDB cr_linkAniDBTvDB = new CommandRequest_LinkAniDBTvDB();
cr_linkAniDBTvDB.LoadFromDBCommand(crdb);
return(cr_linkAniDBTvDB);
}
return(null);
}
private void ProcessFile_AniDB(VideoLocal vidLocal)
{
logger.Trace("Checking for AniDB_File record for: {0} --- {1}", vidLocal.Hash, vidLocal.FilePath);
// check if we already have this AniDB_File info in the database
AniDB_FileRepository repAniFile = new AniDB_FileRepository();
AniDB_EpisodeRepository repAniEps = new AniDB_EpisodeRepository();
AniDB_AnimeRepository repAniAnime = new AniDB_AnimeRepository();
AnimeSeriesRepository repSeries = new AnimeSeriesRepository();
VideoLocalRepository repVidLocals = new VideoLocalRepository();
AnimeEpisodeRepository repEps = new AnimeEpisodeRepository();
CrossRef_File_EpisodeRepository repXrefFE = new CrossRef_File_EpisodeRepository();
AniDB_File aniFile = null;
if (!ForceAniDB)
{
aniFile = repAniFile.GetByHashAndFileSize(vidLocal.Hash, vlocal.FileSize);
if (aniFile == null)
{
logger.Trace("AniDB_File record not found");
}
}
int animeID = 0;
if (aniFile == null)
{
// get info from AniDB
logger.Debug("Getting AniDB_File record from AniDB....");
Raw_AniDB_File fileInfo = JMMService.AnidbProcessor.GetFileInfo(vidLocal);
if (fileInfo != null)
{
// check if we already have a record
aniFile = repAniFile.GetByHashAndFileSize(vidLocal.Hash, vlocal.FileSize);
if (aniFile == null)
{
aniFile = new AniDB_File();
}
aniFile.Populate(fileInfo);
//overwrite with local file name
string localFileName = Path.GetFileName(vidLocal.FilePath);
aniFile.FileName = localFileName;
repAniFile.Save(aniFile, false);
aniFile.CreateLanguages();
aniFile.CreateCrossEpisodes(localFileName);
if (!string.IsNullOrEmpty(fileInfo.OtherEpisodesRAW))
{
string[] epIDs = fileInfo.OtherEpisodesRAW.Split(',');
foreach (string epid in epIDs)
{
int id = 0;
if (int.TryParse(epid, out id))
{
CommandRequest_GetEpisode cmdEp = new CommandRequest_GetEpisode(id);
cmdEp.Save();
}
}
}
animeID = aniFile.AnimeID;
}
}
bool missingEpisodes = false;
// if we still haven't got the AniDB_File Info we try the web cache or local records
if (aniFile == null)
{
// check if we have any records from previous imports
List <CrossRef_File_Episode> crossRefs = repXrefFE.GetByHash(vidLocal.Hash);
if (crossRefs == null || crossRefs.Count == 0)
{
// lets see if we can find the episode/anime info from the web cache
if (ServerSettings.WebCache_XRefFileEpisode_Get)
{
List <JMMServer.Providers.Azure.CrossRef_File_Episode> xrefs = JMMServer.Providers.Azure.AzureWebAPI.Get_CrossRefFileEpisode(vidLocal);
crossRefs = new List <CrossRef_File_Episode>();
if (xrefs == null || xrefs.Count == 0)
{
logger.Debug("Cannot find AniDB_File record or get cross ref from web cache record so exiting: {0}", vidLocal.ED2KHash);
return;
}
else
{
foreach (JMMServer.Providers.Azure.CrossRef_File_Episode xref in xrefs)
{
CrossRef_File_Episode xrefEnt = new CrossRef_File_Episode();
xrefEnt.Hash = vidLocal.ED2KHash;
xrefEnt.FileName = Path.GetFileName(vidLocal.FullServerPath);
xrefEnt.FileSize = vidLocal.FileSize;
xrefEnt.CrossRefSource = (int)JMMServer.CrossRefSource.WebCache;
xrefEnt.AnimeID = animeID;
xrefEnt.EpisodeID = xref.EpisodeID;
xrefEnt.Percentage = xref.Percentage;
xrefEnt.EpisodeOrder = xref.EpisodeOrder;
crossRefs.Add(xrefEnt);
// in this case we need to save the cross refs manually as AniDB did not provide them
repXrefFE.Save(xrefEnt);
}
}
}
else
{
logger.Debug("Cannot get AniDB_File record so exiting: {0}", vidLocal.ED2KHash);
return;
}
}
// we assume that all episodes belong to the same anime
foreach (CrossRef_File_Episode xref in crossRefs)
{
animeID = xref.AnimeID;
AniDB_Episode ep = repAniEps.GetByEpisodeID(xref.EpisodeID);
if (ep == null)
{
missingEpisodes = true;
}
}
}
else
{
// check if we have the episode info
// if we don't, we will need to re-download the anime info (which also has episode info)
if (aniFile.EpisodeCrossRefs.Count == 0)
{
animeID = aniFile.AnimeID;
// if we have the anidb file, but no cross refs it means something has been broken
logger.Debug("Could not find any cross ref records for: {0}", vidLocal.ED2KHash);
missingEpisodes = true;
}
else
{
foreach (CrossRef_File_Episode xref in aniFile.EpisodeCrossRefs)
{
AniDB_Episode ep = repAniEps.GetByEpisodeID(xref.EpisodeID);
if (ep == null)
{
missingEpisodes = true;
}
animeID = xref.AnimeID;
}
}
}
// get from DB
AniDB_Anime anime = repAniAnime.GetByAnimeID(animeID);
bool animeRecentlyUpdated = false;
if (anime != null)
{
TimeSpan ts = DateTime.Now - anime.DateTimeUpdated;
if (ts.TotalHours < 4)
{
animeRecentlyUpdated = true;
}
}
// even if we are missing episode info, don't get data more than once every 4 hours
// this is to prevent banning
if (missingEpisodes && !animeRecentlyUpdated)
{
logger.Debug("Getting Anime record from AniDB....");
anime = JMMService.AnidbProcessor.GetAnimeInfoHTTP(animeID, true, ServerSettings.AutoGroupSeries);
}
// create the group/series/episode records if needed
AnimeSeries ser = null;
if (anime != null)
{
logger.Debug("Creating groups, series and episodes....");
// check if there is an AnimeSeries Record associated with this AnimeID
ser = repSeries.GetByAnimeID(animeID);
if (ser == null)
{
// create a new AnimeSeries record
ser = anime.CreateAnimeSeriesAndGroup();
}
ser.CreateAnimeEpisodes();
// check if we have any group status data for this associated anime
// if not we will download it now
AniDB_GroupStatusRepository repStatus = new AniDB_GroupStatusRepository();
if (repStatus.GetByAnimeID(anime.AnimeID).Count == 0)
{
CommandRequest_GetReleaseGroupStatus cmdStatus = new CommandRequest_GetReleaseGroupStatus(anime.AnimeID, false);
cmdStatus.Save();
}
// update stats
ser.EpisodeAddedDate = DateTime.Now;
repSeries.Save(ser);
AnimeGroupRepository repGroups = new AnimeGroupRepository();
foreach (AnimeGroup grp in ser.AllGroupsAbove)
{
grp.EpisodeAddedDate = DateTime.Now;
repGroups.Save(grp);
}
}
vidLocal.RenameIfRequired();
vidLocal.MoveFileIfRequired();
// update stats for groups and series
if (ser != null)
{
// update all the groups above this series in the heirarchy
ser.UpdateStats(true, true, true);
StatsCache.Instance.UpdateUsingSeries(ser.AnimeSeriesID);
}
// Add this file to the users list
if (ServerSettings.AniDB_MyList_AddFiles)
{
CommandRequest_AddFileToMyList cmd = new CommandRequest_AddFileToMyList(vidLocal.ED2KHash);
cmd.Save();
}
// lets also try adding to the users trakt collecion by sync'ing the series
if (ser != null)
{
if (ServerSettings.WebCache_Trakt_Send && !string.IsNullOrEmpty(ServerSettings.Trakt_Username))
{
CommandRequest_TraktSyncCollectionSeries cmdTrakt = new CommandRequest_TraktSyncCollectionSeries(ser.AnimeSeriesID, ser.GetAnime().MainTitle);
cmdTrakt.Save();
}
}
// sync the series on MAL
if (ser != null)
{
CommandRequest_MALUpdatedWatchedStatus cmdMAL = new CommandRequest_MALUpdatedWatchedStatus(ser.AniDB_ID);
cmdMAL.Save();
}
}
public void ForceAddFileToMyList(string hash)
{
try
{
CommandRequest_AddFileToMyList cmdAddFile = new CommandRequest_AddFileToMyList(hash);
cmdAddFile.Save();
}
catch (Exception ex)
{
logger.ErrorException(ex.ToString(), ex);
}
}
public override void ProcessCommand()
{
logger.Info("Processing CommandRequest_SyncMyList");
try
{
// we will always assume that an anime was downloaded via http first
ScheduledUpdateRepository repSched = new ScheduledUpdateRepository();
AniDB_FileRepository repAniFile = new AniDB_FileRepository();
VideoLocalRepository repVidLocals = new VideoLocalRepository();
ScheduledUpdate sched = repSched.GetByUpdateType((int)ScheduledUpdateType.AniDBMyListSync);
if (sched == null)
{
sched = new ScheduledUpdate();
sched.UpdateType = (int)ScheduledUpdateType.AniDBMyListSync;
sched.UpdateDetails = "";
}
else
{
int freqHours = Utils.GetScheduledHours(ServerSettings.AniDB_MyList_UpdateFrequency);
// if we have run this in the last 24 hours and are not forcing it, then exit
TimeSpan tsLastRun = DateTime.Now - sched.LastUpdate;
if (tsLastRun.TotalHours < freqHours)
{
if (!ForceRefresh)
{
return;
}
}
}
AniDBHTTPCommand_GetMyList cmd = new AniDBHTTPCommand_GetMyList();
cmd.Init(ServerSettings.AniDB_Username, ServerSettings.AniDB_Password);
enHelperActivityType ev = cmd.Process();
if (ev == enHelperActivityType.GotMyListHTTP && cmd.MyListItems.Count > 1)
{
int totalItems = 0;
int watchedItems = 0;
int modifiedItems = 0;
double pct = 0;
// 2. find files locally for the user, which are not recorded on anidb
// and then add them to anidb
Dictionary <int, Raw_AniDB_MyListFile> onlineFiles = new Dictionary <int, Raw_AniDB_MyListFile>();
foreach (Raw_AniDB_MyListFile myitem in cmd.MyListItems)
{
onlineFiles[myitem.FileID] = myitem;
}
Dictionary <string, AniDB_File> dictAniFiles = new Dictionary <string, AniDB_File>();
List <AniDB_File> allAniFiles = repAniFile.GetAll();
foreach (AniDB_File anifile in allAniFiles)
{
dictAniFiles[anifile.Hash] = anifile;
}
int missingFiles = 0;
foreach (VideoLocal vid in repVidLocals.GetAll())
{
if (!dictAniFiles.ContainsKey(vid.Hash))
{
continue;
}
int fileID = dictAniFiles[vid.Hash].FileID;
if (!onlineFiles.ContainsKey(fileID))
{
// means we have found a file in our local collection, which is not recorded online
CommandRequest_AddFileToMyList cmdAddFile = new CommandRequest_AddFileToMyList(vid.Hash);
cmdAddFile.Save();
missingFiles++;
}
}
logger.Info(string.Format("MYLIST Missing Files: {0} Added to queue for inclusion", missingFiles));
JMMUserRepository repUsers = new JMMUserRepository();
List <JMMUser> aniDBUsers = repUsers.GetAniDBUsers();
VideoLocal_UserRepository repVidUsers = new VideoLocal_UserRepository();
CrossRef_File_EpisodeRepository repFileEp = new CrossRef_File_EpisodeRepository();
// 1 . sync mylist items
foreach (Raw_AniDB_MyListFile myitem in cmd.MyListItems)
{
// ignore files mark as deleted by the user
if (myitem.State == (int)AniDBFileStatus.Deleted)
{
continue;
}
totalItems++;
if (myitem.IsWatched)
{
watchedItems++;
}
//calculate percentage
pct = (double)totalItems / (double)cmd.MyListItems.Count * (double)100;
string spct = pct.ToString("#0.0");
string hash = string.Empty;
AniDB_File anifile = repAniFile.GetByFileID(myitem.FileID);
if (anifile != null)
{
hash = anifile.Hash;
}
else
{
// look for manually linked files
List <CrossRef_File_Episode> xrefs = repFileEp.GetByEpisodeID(myitem.EpisodeID);
foreach (CrossRef_File_Episode xref in xrefs)
{
if (xref.CrossRefSource != (int)CrossRefSource.AniDB)
{
hash = xref.Hash;
break;
}
}
}
if (!string.IsNullOrEmpty(hash))
{
// find the video associated with this record
VideoLocal vl = repVidLocals.GetByHash(hash);
if (vl == null)
{
continue;
}
foreach (JMMUser juser in aniDBUsers)
{
bool localStatus = false;
int? jmmUserID = null;
// doesn't matter which anidb user we use
jmmUserID = juser.JMMUserID;
VideoLocal_User userRecord = vl.GetUserRecord(juser.JMMUserID);
if (userRecord != null)
{
localStatus = true;
}
string action = "";
if (localStatus != myitem.IsWatched)
{
if (localStatus == true)
{
// local = watched, anidb = unwatched
if (ServerSettings.AniDB_MyList_ReadUnwatched)
{
modifiedItems++;
if (jmmUserID.HasValue)
{
vl.ToggleWatchedStatus(myitem.IsWatched, false, myitem.WatchedDate,
false, false, jmmUserID.Value, false,
true);
}
action = "Used AniDB Status";
}
}
else
{
// means local is un-watched, and anidb is watched
if (ServerSettings.AniDB_MyList_ReadWatched)
{
modifiedItems++;
if (jmmUserID.HasValue)
{
vl.ToggleWatchedStatus(true, false, myitem.WatchedDate, false, false,
jmmUserID.Value, false, true);
}
action = "Updated Local record to Watched";
}
}
string msg =
string.Format(
"MYLISTDIFF:: File {0} - Local Status = {1}, AniDB Status = {2} --- {3}",
vl.FullServerPath, localStatus, myitem.IsWatched, action);
logger.Info(msg);
}
}
//string msg = string.Format("MYLIST:: File {0} - Local Status = {1}, AniDB Status = {2} --- {3}",
// vl.FullServerPath, localStatus, myitem.IsWatched, action);
//logger.Info(msg);
}
}
// now update all stats
Importer.UpdateAllStats();
logger.Info("Process MyList: {0} Items, {1} Watched, {2} Modified", totalItems, watchedItems,
modifiedItems);
sched.LastUpdate = DateTime.Now;
repSched.Save(sched);
}
}
catch (Exception ex)
{
logger.Error("Error processing CommandRequest_SyncMyList: {0} ", ex.ToString());
return;
}
}
// List of Default priorities for commands
// Pri 1
//------
// Reserved for commands user manually initiates from UI
//------
// Pri 2
//------
// CommandRequest_GetAnimeHTTP
//------
// Pri 3
//------
// CommandRequest_ProcessFile
// CommandRequest_GetFile
//------
// Pri 4
//------
// CommandRequest_GetUpdated
// CommandRequest_ReadMediaInfo
// CommandRequest_GetEpsode
//------
// Pri 5
//------
// CommandRequest_GetReleaseGroupStatus
//------
// Pri 6
//------
// CommandRequest_SyncMyList
// CommandRequest_SyncMyVotes
//------
// Pri 7
//------
// CommandRequest_GetCalendar
//------
// Pri 8
//------
// CommandRequest_UpdateMyListFileStatus
// CommandRequest_GetCharactersCreators
// CommandRequest_TraktSyncCollection
// CommandRequest_TvDBUpdateSeriesAndEpisodes
// CommandRequest_TvDBDownloadImages
// CommandRequest_TvDBSearchAnime
// CommandRequest_MovieDBSearchAnime
// CommandRequest_TraktSearchAnime
// CommandRequest_MALSearchAnime
//------
// Pri 9
//------
// CommandRequest_WebCacheSendFileHash
// CommandRequest_GetReviews
// CommandRequest_GetReleaseGroup
// CommandRequest_WebCacheSendXRefFileEpisode
// CommandRequest_WebCacheDeleteXRefFileEpisode
// CommandRequest_AddFileToMyList
// CommandRequest_DeleteFileFromMyList
// CommandRequest_VoteAnime
// CommandRequest_WebCacheDeleteXRefAniDBTvDB
// CommandRequest_WebCacheDeleteXRefAniDBTvDBAll
// CommandRequest_WebCacheSendXRefAniDBTvDB
// CommandRequest_WebCacheSendXRefAniDBOther
// CommandRequest_WebCacheDeleteXRefAniDBOther
// CommandRequest_WebCacheDeleteXRefAniDBTrakt
// CommandRequest_WebCacheSendXRefAniDBTrakt
// CommandRequest_TraktUpdateInfoAndImages
// CommandRequest_TraktSyncCollectionSeries
// CommandRequest_TraktShowEpisodeUnseen
// CommandRequest_DownloadImage
// CommandRequest_TraktUpdateAllSeries
// CommandRequest_MALUpdatedWatchedStatus
// CommandRequest_MALUploadStatusToMAL
// CommandRequest_MALDownloadStatusFromMAL
// CommandRequest_WebCacheSendAniDB_File
// CommandRequest_Azure_SendAnimeFull
//------
// Pri 10
//------
// CommandRequest_UpdateMylistStats
// CommandRequest_Azure_SendAnimeXML
//------
// Pri 11
//------
// CommandRequest_Azure_SendAnimeTitle
public static ICommandRequest GetCommand(CommandRequest crdb)
{
CommandRequestType crt = (CommandRequestType)crdb.CommandType;
switch (crt)
{
case CommandRequestType.Trakt_SyncCollectionSeries:
CommandRequest_TraktSyncCollectionSeries cr_CommandRequest_TraktSyncCollectionSeries = new CommandRequest_TraktSyncCollectionSeries();
cr_CommandRequest_TraktSyncCollectionSeries.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_CommandRequest_TraktSyncCollectionSeries;
case CommandRequestType.AniDB_GetEpisodeUDP:
CommandRequest_GetEpisode cr_CommandRequest_GetEpisode = new CommandRequest_GetEpisode();
cr_CommandRequest_GetEpisode.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_CommandRequest_GetEpisode;
case CommandRequestType.Azure_SendAnimeTitle:
CommandRequest_Azure_SendAnimeTitle cr_CommandRequest_Azure_SendAnimeTitle = new CommandRequest_Azure_SendAnimeTitle();
cr_CommandRequest_Azure_SendAnimeTitle.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_CommandRequest_Azure_SendAnimeTitle;
case CommandRequestType.AniDB_GetTitles:
CommandRequest_GetAniDBTitles cr_CommandRequest_GetAniDBTitles = new CommandRequest_GetAniDBTitles();
cr_CommandRequest_GetAniDBTitles.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_CommandRequest_GetAniDBTitles;
case CommandRequestType.Azure_SendAnimeXML:
CommandRequest_Azure_SendAnimeXML cr_CommandRequest_Azure_SendAnimeXML = new CommandRequest_Azure_SendAnimeXML();
cr_CommandRequest_Azure_SendAnimeXML.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_CommandRequest_Azure_SendAnimeXML;
case CommandRequestType.Azure_SendAnimeFull:
CommandRequest_Azure_SendAnimeFull cr_CommandRequest_Azure_SendAnimeFull = new CommandRequest_Azure_SendAnimeFull();
cr_CommandRequest_Azure_SendAnimeFull.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_CommandRequest_Azure_SendAnimeFull;
case CommandRequestType.Azure_SendUserInfo:
CommandRequest_Azure_SendUserInfo cr_CommandRequest_Azure_SendUserInfo = new CommandRequest_Azure_SendUserInfo();
cr_CommandRequest_Azure_SendUserInfo.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_CommandRequest_Azure_SendUserInfo;
case CommandRequestType.AniDB_UpdateMylistStats:
CommandRequest_UpdateMylistStats cr_AniDB_UpdateMylistStats = new CommandRequest_UpdateMylistStats();
cr_AniDB_UpdateMylistStats.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_AniDB_UpdateMylistStats;
case CommandRequestType.MAL_DownloadWatchedStates:
CommandRequest_MALDownloadStatusFromMAL cr_MAL_DownloadWatchedStates = new CommandRequest_MALDownloadStatusFromMAL();
cr_MAL_DownloadWatchedStates.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_MAL_DownloadWatchedStates;
case CommandRequestType.MAL_UploadWatchedStates:
CommandRequest_MALUploadStatusToMAL cr_MAL_UploadWatchedStates = new CommandRequest_MALUploadStatusToMAL();
cr_MAL_UploadWatchedStates.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_MAL_UploadWatchedStates;
case CommandRequestType.MAL_UpdateStatus:
CommandRequest_MALUpdatedWatchedStatus cr_MAL_UpdateStatus = new CommandRequest_MALUpdatedWatchedStatus();
cr_MAL_UpdateStatus.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_MAL_UpdateStatus;
case CommandRequestType.MAL_SearchAnime:
CommandRequest_MALSearchAnime cr_MAL_SearchAnime = new CommandRequest_MALSearchAnime();
cr_MAL_SearchAnime.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_MAL_SearchAnime;
case CommandRequestType.WebCache_SendXRefAniDBMAL:
CommandRequest_WebCacheSendXRefAniDBMAL cr_WebCacheSendXRefAniDBMAL = new CommandRequest_WebCacheSendXRefAniDBMAL();
cr_WebCacheSendXRefAniDBMAL.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_WebCacheSendXRefAniDBMAL;
case CommandRequestType.WebCache_DeleteXRefAniDBMAL:
CommandRequest_WebCacheDeleteXRefAniDBMAL cr_WebCacheDeleteXRefAniDBMAL = new CommandRequest_WebCacheDeleteXRefAniDBMAL();
cr_WebCacheDeleteXRefAniDBMAL.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_WebCacheDeleteXRefAniDBMAL;
case CommandRequestType.AniDB_GetFileUDP:
CommandRequest_GetFile cr_AniDB_GetFileUDP = new CommandRequest_GetFile();
cr_AniDB_GetFileUDP.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_AniDB_GetFileUDP;
case CommandRequestType.ReadMediaInfo:
CommandRequest_ReadMediaInfo cr_ReadMediaInfo = new CommandRequest_ReadMediaInfo();
cr_ReadMediaInfo.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_ReadMediaInfo;
case CommandRequestType.Trakt_UpdateAllSeries:
CommandRequest_TraktUpdateAllSeries cr_Trakt_UpdateAllSeries = new CommandRequest_TraktUpdateAllSeries();
cr_Trakt_UpdateAllSeries.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_Trakt_UpdateAllSeries;
case CommandRequestType.Trakt_EpisodeCollection:
CommandRequest_TraktCollectionEpisode cr_TraktCollectionEpisode = new CommandRequest_TraktCollectionEpisode();
cr_TraktCollectionEpisode.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_TraktCollectionEpisode;
case CommandRequestType.Trakt_SyncCollection:
CommandRequest_TraktSyncCollection cr_Trakt_SyncCollection = new CommandRequest_TraktSyncCollection();
cr_Trakt_SyncCollection.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_Trakt_SyncCollection;
case CommandRequestType.Trakt_EpisodeHistory:
CommandRequest_TraktHistoryEpisode cr_Trakt_EpisodeHistory = new CommandRequest_TraktHistoryEpisode();
cr_Trakt_EpisodeHistory.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_Trakt_EpisodeHistory;
case CommandRequestType.Trakt_UpdateInfoImages:
CommandRequest_TraktUpdateInfoAndImages cr_Trakt_UpdateInfoImages = new CommandRequest_TraktUpdateInfoAndImages();
cr_Trakt_UpdateInfoImages.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_Trakt_UpdateInfoImages;
case CommandRequestType.WebCache_SendXRefAniDBTrakt:
CommandRequest_WebCacheSendXRefAniDBTrakt cr_WebCache_SendXRefAniDBTrakt = new CommandRequest_WebCacheSendXRefAniDBTrakt();
cr_WebCache_SendXRefAniDBTrakt.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_WebCache_SendXRefAniDBTrakt;
case CommandRequestType.WebCache_DeleteXRefAniDBTrakt:
CommandRequest_WebCacheDeleteXRefAniDBTrakt cr_WebCache_DeleteXRefAniDBTrakt = new CommandRequest_WebCacheDeleteXRefAniDBTrakt();
cr_WebCache_DeleteXRefAniDBTrakt.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_WebCache_DeleteXRefAniDBTrakt;
case CommandRequestType.Trakt_SearchAnime:
CommandRequest_TraktSearchAnime cr_Trakt_SearchAnime = new CommandRequest_TraktSearchAnime();
cr_Trakt_SearchAnime.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_Trakt_SearchAnime;
case CommandRequestType.MovieDB_SearchAnime:
CommandRequest_MovieDBSearchAnime cr_MovieDB_SearchAnime = new CommandRequest_MovieDBSearchAnime();
cr_MovieDB_SearchAnime.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_MovieDB_SearchAnime;
case CommandRequestType.WebCache_DeleteXRefAniDBOther:
CommandRequest_WebCacheDeleteXRefAniDBOther cr_SendXRefAniDBOther = new CommandRequest_WebCacheDeleteXRefAniDBOther();
cr_SendXRefAniDBOther.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_SendXRefAniDBOther;
case CommandRequestType.WebCache_SendXRefAniDBOther:
CommandRequest_WebCacheSendXRefAniDBOther cr_WebCacheSendXRefAniDBOther = new CommandRequest_WebCacheSendXRefAniDBOther();
cr_WebCacheSendXRefAniDBOther.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_WebCacheSendXRefAniDBOther;
case CommandRequestType.AniDB_DeleteFileUDP:
CommandRequest_DeleteFileFromMyList cr_AniDB_DeleteFileUDP = new CommandRequest_DeleteFileFromMyList();
cr_AniDB_DeleteFileUDP.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_AniDB_DeleteFileUDP;
case CommandRequestType.ImageDownload:
CommandRequest_DownloadImage cr_ImageDownload = new CommandRequest_DownloadImage();
cr_ImageDownload.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_ImageDownload;
case CommandRequestType.WebCache_DeleteXRefAniDBTvDB:
CommandRequest_WebCacheDeleteXRefAniDBTvDB cr_DeleteXRefAniDBTvDB = new CommandRequest_WebCacheDeleteXRefAniDBTvDB();
cr_DeleteXRefAniDBTvDB.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_DeleteXRefAniDBTvDB;
case CommandRequestType.WebCache_SendXRefAniDBTvDB:
CommandRequest_WebCacheSendXRefAniDBTvDB cr_SendXRefAniDBTvDB = new CommandRequest_WebCacheSendXRefAniDBTvDB();
cr_SendXRefAniDBTvDB.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_SendXRefAniDBTvDB;
case CommandRequestType.TvDB_SearchAnime:
CommandRequest_TvDBSearchAnime cr_TvDB_SearchAnime = new CommandRequest_TvDBSearchAnime();
cr_TvDB_SearchAnime.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_TvDB_SearchAnime;
case CommandRequestType.TvDB_DownloadImages:
CommandRequest_TvDBDownloadImages cr_TvDB_DownloadImages = new CommandRequest_TvDBDownloadImages();
cr_TvDB_DownloadImages.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_TvDB_DownloadImages;
case CommandRequestType.TvDB_SeriesEpisodes:
CommandRequest_TvDBUpdateSeriesAndEpisodes cr_TvDB_Episodes = new CommandRequest_TvDBUpdateSeriesAndEpisodes();
cr_TvDB_Episodes.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_TvDB_Episodes;
case CommandRequestType.AniDB_SyncVotes:
CommandRequest_SyncMyVotes cr_SyncVotes = new CommandRequest_SyncMyVotes();
cr_SyncVotes.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_SyncVotes;
case CommandRequestType.AniDB_VoteAnime:
CommandRequest_VoteAnime cr_VoteAnime = new CommandRequest_VoteAnime();
cr_VoteAnime.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_VoteAnime;
case CommandRequestType.AniDB_GetCalendar:
CommandRequest_GetCalendar cr_GetCalendar = new CommandRequest_GetCalendar();
cr_GetCalendar.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_GetCalendar;
case CommandRequestType.AniDB_GetReleaseGroup:
CommandRequest_GetReleaseGroup cr_GetReleaseGroup = new CommandRequest_GetReleaseGroup();
cr_GetReleaseGroup.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_GetReleaseGroup;
case CommandRequestType.AniDB_GetAnimeHTTP:
CommandRequest_GetAnimeHTTP cr_geth = new CommandRequest_GetAnimeHTTP();
cr_geth.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_geth;
case CommandRequestType.AniDB_GetReleaseGroupStatus:
CommandRequest_GetReleaseGroupStatus cr_GetReleaseGroupStatus = new CommandRequest_GetReleaseGroupStatus();
cr_GetReleaseGroupStatus.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_GetReleaseGroupStatus;
case CommandRequestType.HashFile:
CommandRequest_HashFile cr_HashFile = new CommandRequest_HashFile();
cr_HashFile.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_HashFile;
case CommandRequestType.ProcessFile:
CommandRequest_ProcessFile cr_pf = new CommandRequest_ProcessFile();
cr_pf.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_pf;
case CommandRequestType.AniDB_AddFileUDP:
CommandRequest_AddFileToMyList cr_af = new CommandRequest_AddFileToMyList();
cr_af.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_af;
case CommandRequestType.AniDB_UpdateWatchedUDP:
CommandRequest_UpdateMyListFileStatus cr_umlf = new CommandRequest_UpdateMyListFileStatus();
cr_umlf.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_umlf;
case CommandRequestType.WebCache_DeleteXRefFileEpisode:
CommandRequest_WebCacheDeleteXRefFileEpisode cr_DeleteXRefFileEpisode = new CommandRequest_WebCacheDeleteXRefFileEpisode();
cr_DeleteXRefFileEpisode.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_DeleteXRefFileEpisode;
case CommandRequestType.WebCache_SendXRefFileEpisode:
CommandRequest_WebCacheSendXRefFileEpisode cr_SendXRefFileEpisode = new CommandRequest_WebCacheSendXRefFileEpisode();
cr_SendXRefFileEpisode.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_SendXRefFileEpisode;
case CommandRequestType.AniDB_GetReviews:
CommandRequest_GetReviews cr_GetReviews = new CommandRequest_GetReviews();
cr_GetReviews.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_GetReviews;
case CommandRequestType.AniDB_GetUpdated:
CommandRequest_GetUpdated cr_GetUpdated = new CommandRequest_GetUpdated();
cr_GetUpdated.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_GetUpdated;
case CommandRequestType.AniDB_SyncMyList:
CommandRequest_SyncMyList cr_SyncMyList = new CommandRequest_SyncMyList();
cr_SyncMyList.LoadFromDBCommand(crdb);
return (ICommandRequest)cr_SyncMyList;
case CommandRequestType.Refresh_AnimeStats:
CommandRequest_RefreshAnime cr_refreshAnime=new CommandRequest_RefreshAnime();
cr_refreshAnime.LoadFromDBCommand(crdb);
return cr_refreshAnime;
}
return null;
}
public string AssociateSingleFile(int videoLocalID, int animeEpisodeID)
{
try
{
VideoLocal vid = RepoFactory.VideoLocal.GetByID(videoLocalID);
if (vid == null)
return "Could not find video record";
if (string.IsNullOrEmpty(vid.Hash))
return "Could not associate a cloud file without hash, hash it locally first";
AnimeEpisode ep = RepoFactory.AnimeEpisode.GetByID(animeEpisodeID);
if (ep == null)
return "Could not find episode record";
CrossRef_File_Episode xref = new CrossRef_File_Episode();
try
{
xref.PopulateManually(vid, ep);
}
catch (Exception ex)
{
string msg = string.Format("Error populating XREF: {0}", vid.ToStringDetailed());
throw;
}
RepoFactory.CrossRef_File_Episode.Save(xref);
CommandRequest_WebCacheSendXRefFileEpisode cr = new CommandRequest_WebCacheSendXRefFileEpisode(xref.CrossRef_File_EpisodeID);
cr.Save();
vid.Places.ForEach(a =>
{
a.RenameIfRequired();
a.MoveFileIfRequired();
});
AnimeSeries ser = ep.GetAnimeSeries();
ser.EpisodeAddedDate = DateTime.Now;
RepoFactory.AnimeSeries.Save(ser, false, true);
//Update will re-save
ser.QueueUpdateStats();
foreach (AnimeGroup grp in ser.AllGroupsAbove)
{
grp.EpisodeAddedDate = DateTime.Now;
RepoFactory.AnimeGroup.Save(grp, false, false);
}
CommandRequest_AddFileToMyList cmdAddFile = new CommandRequest_AddFileToMyList(vid.Hash);
cmdAddFile.Save();
return "";
}
catch (Exception ex)
{
logger.Error( ex,ex.ToString());
}
return "";
}
public override void ProcessCommand()
{
logger.Info("Processing CommandRequest_SyncMyList");
try
{
// we will always assume that an anime was downloaded via http first
ScheduledUpdateRepository repSched = new ScheduledUpdateRepository();
AniDB_FileRepository repAniFile = new AniDB_FileRepository();
VideoLocalRepository repVidLocals = new VideoLocalRepository();
ScheduledUpdate sched = repSched.GetByUpdateType((int)ScheduledUpdateType.AniDBMyListSync);
if (sched == null)
{
sched = new ScheduledUpdate();
sched.UpdateType = (int)ScheduledUpdateType.AniDBMyListSync;
sched.UpdateDetails = "";
}
else
{
int freqHours = Utils.GetScheduledHours(ServerSettings.AniDB_MyList_UpdateFrequency);
// if we have run this in the last 24 hours and are not forcing it, then exit
TimeSpan tsLastRun = DateTime.Now - sched.LastUpdate;
if (tsLastRun.TotalHours < freqHours)
{
if (!ForceRefresh) return;
}
}
AniDBHTTPCommand_GetMyList cmd = new AniDBHTTPCommand_GetMyList();
cmd.Init(ServerSettings.AniDB_Username, ServerSettings.AniDB_Password);
enHelperActivityType ev = cmd.Process();
if (ev == enHelperActivityType.GotMyListHTTP && cmd.MyListItems.Count > 1)
{
int totalItems = 0;
int watchedItems = 0;
int modifiedItems = 0;
double pct = 0;
// 2. find files locally for the user, which are not recorded on anidb
// and then add them to anidb
Dictionary<int, Raw_AniDB_MyListFile> onlineFiles = new Dictionary<int, Raw_AniDB_MyListFile>();
foreach (Raw_AniDB_MyListFile myitem in cmd.MyListItems)
onlineFiles[myitem.FileID] = myitem;
Dictionary<string, AniDB_File> dictAniFiles = new Dictionary<string, AniDB_File>();
List<AniDB_File> allAniFiles = repAniFile.GetAll();
foreach (AniDB_File anifile in allAniFiles)
dictAniFiles[anifile.Hash] = anifile;
int missingFiles = 0;
foreach (VideoLocal vid in repVidLocals.GetAll())
{
if (!dictAniFiles.ContainsKey(vid.Hash)) continue;
int fileID = dictAniFiles[vid.Hash].FileID;
if (!onlineFiles.ContainsKey(fileID))
{
// means we have found a file in our local collection, which is not recorded online
CommandRequest_AddFileToMyList cmdAddFile = new CommandRequest_AddFileToMyList(vid.Hash);
cmdAddFile.Save();
missingFiles++;
}
}
logger.Info(string.Format("MYLIST Missing Files: {0} Added to queue for inclusion", missingFiles));
JMMUserRepository repUsers = new JMMUserRepository();
List<JMMUser> aniDBUsers = repUsers.GetAniDBUsers();
VideoLocal_UserRepository repVidUsers = new VideoLocal_UserRepository();
CrossRef_File_EpisodeRepository repFileEp = new CrossRef_File_EpisodeRepository();
// 1 . sync mylist items
foreach (Raw_AniDB_MyListFile myitem in cmd.MyListItems)
{
// ignore files mark as deleted by the user
if (myitem.State == (int)AniDBFileStatus.Deleted) continue;
totalItems++;
if (myitem.IsWatched) watchedItems++;
//calculate percentage
pct = (double)totalItems / (double)cmd.MyListItems.Count * (double)100;
string spct = pct.ToString("#0.0");
string hash = string.Empty;
AniDB_File anifile = repAniFile.GetByFileID(myitem.FileID);
if (anifile != null)
hash = anifile.Hash;
else
{
// look for manually linked files
List<CrossRef_File_Episode> xrefs = repFileEp.GetByEpisodeID(myitem.EpisodeID);
foreach (CrossRef_File_Episode xref in xrefs)
{
if (xref.CrossRefSource != (int)CrossRefSource.AniDB)
{
hash = xref.Hash;
break;
}
}
}
if (!string.IsNullOrEmpty(hash))
{
// find the video associated with this record
VideoLocal vl = repVidLocals.GetByHash(hash);
if (vl == null) continue;
foreach (JMMUser juser in aniDBUsers)
{
bool localStatus = false;
int? jmmUserID = null;
// doesn't matter which anidb user we use
jmmUserID = juser.JMMUserID;
VideoLocal_User userRecord = vl.GetUserRecord(juser.JMMUserID);
if (userRecord != null) localStatus = true;
string action = "";
if (localStatus != myitem.IsWatched)
{
if (localStatus == true)
{
// local = watched, anidb = unwatched
if (ServerSettings.AniDB_MyList_ReadUnwatched)
{
modifiedItems++;
if (jmmUserID.HasValue)
vl.ToggleWatchedStatus(myitem.IsWatched, false, myitem.WatchedDate, false, false, jmmUserID.Value, false, true);
action = "Used AniDB Status";
}
}
else
{
// means local is un-watched, and anidb is watched
if (ServerSettings.AniDB_MyList_ReadWatched)
{
modifiedItems++;
if (jmmUserID.HasValue)
vl.ToggleWatchedStatus(true, false, myitem.WatchedDate, false, false, jmmUserID.Value, false, true);
action = "Updated Local record to Watched";
}
}
string msg = string.Format("MYLISTDIFF:: File {0} - Local Status = {1}, AniDB Status = {2} --- {3}",
vl.FullServerPath, localStatus, myitem.IsWatched, action);
logger.Info(msg);
}
}
//string msg = string.Format("MYLIST:: File {0} - Local Status = {1}, AniDB Status = {2} --- {3}",
// vl.FullServerPath, localStatus, myitem.IsWatched, action);
//logger.Info(msg);
}
}
// now update all stats
Importer.UpdateAllStats();
logger.Info("Process MyList: {0} Items, {1} Watched, {2} Modified", totalItems, watchedItems, modifiedItems);
sched.LastUpdate = DateTime.Now;
repSched.Save(sched);
}
}
catch (Exception ex)
{
logger.Error("Error processing CommandRequest_SyncMyList: {0} ", ex.ToString());
return;
}
}
private void ProcessFile_AniDB(VideoLocal vidLocal)
{
logger.Trace("Checking for AniDB_File record for: {0} --- {1}", vidLocal.Hash, vidLocal.FileName);
// check if we already have this AniDB_File info in the database
lock (vidLocal)
{
AniDB_File aniFile = null;
if (!ForceAniDB)
{
aniFile = RepoFactory.AniDB_File.GetByHashAndFileSize(vidLocal.Hash, vlocal.FileSize);
if (aniFile == null)
logger.Trace("AniDB_File record not found");
}
int animeID = 0;
if (aniFile == null)
{
// get info from AniDB
logger.Debug("Getting AniDB_File record from AniDB....");
Raw_AniDB_File fileInfo = JMMService.AnidbProcessor.GetFileInfo(vidLocal);
if (fileInfo != null)
{
// check if we already have a record
aniFile = RepoFactory.AniDB_File.GetByHashAndFileSize(vidLocal.Hash, vlocal.FileSize);
if (aniFile == null)
aniFile = new AniDB_File();
aniFile.Populate(fileInfo);
//overwrite with local file name
string localFileName = vidLocal.FileName;
aniFile.FileName = localFileName;
RepoFactory.AniDB_File.Save(aniFile, false);
aniFile.CreateLanguages();
aniFile.CreateCrossEpisodes(localFileName);
if (!string.IsNullOrEmpty(fileInfo.OtherEpisodesRAW))
{
string[] epIDs = fileInfo.OtherEpisodesRAW.Split(',');
foreach (string epid in epIDs)
{
int id = 0;
if (int.TryParse(epid, out id))
{
CommandRequest_GetEpisode cmdEp = new CommandRequest_GetEpisode(id);
cmdEp.Save();
}
}
}
animeID = aniFile.AnimeID;
}
}
bool missingEpisodes = false;
// if we still haven't got the AniDB_File Info we try the web cache or local records
if (aniFile == null)
{
// check if we have any records from previous imports
List<CrossRef_File_Episode> crossRefs = RepoFactory.CrossRef_File_Episode.GetByHash(vidLocal.Hash);
if (crossRefs == null || crossRefs.Count == 0)
{
// lets see if we can find the episode/anime info from the web cache
if (ServerSettings.WebCache_XRefFileEpisode_Get)
{
List<JMMServer.Providers.Azure.CrossRef_File_Episode> xrefs =
JMMServer.Providers.Azure.AzureWebAPI.Get_CrossRefFileEpisode(vidLocal);
crossRefs = new List<CrossRef_File_Episode>();
if (xrefs == null || xrefs.Count == 0)
{
logger.Debug(
"Cannot find AniDB_File record or get cross ref from web cache record so exiting: {0}",
vidLocal.ED2KHash);
return;
}
else
{
foreach (JMMServer.Providers.Azure.CrossRef_File_Episode xref in xrefs)
{
CrossRef_File_Episode xrefEnt = new CrossRef_File_Episode();
xrefEnt.Hash = vidLocal.ED2KHash;
xrefEnt.FileName = vidLocal.FileName;
xrefEnt.FileSize = vidLocal.FileSize;
xrefEnt.CrossRefSource = (int) JMMServer.CrossRefSource.WebCache;
xrefEnt.AnimeID = xref.AnimeID;
xrefEnt.EpisodeID = xref.EpisodeID;
xrefEnt.Percentage = xref.Percentage;
xrefEnt.EpisodeOrder = xref.EpisodeOrder;
bool duplicate = false;
foreach (CrossRef_File_Episode xrefcheck in crossRefs)
{
if (xrefcheck.AnimeID == xrefEnt.AnimeID &&
xrefcheck.EpisodeID == xrefEnt.EpisodeID &&
xrefcheck.Hash == xrefEnt.Hash)
duplicate = true;
}
if (!duplicate)
{
crossRefs.Add(xrefEnt);
// in this case we need to save the cross refs manually as AniDB did not provide them
RepoFactory.CrossRef_File_Episode.Save(xrefEnt);
}
}
}
}
else
{
logger.Debug("Cannot get AniDB_File record so exiting: {0}", vidLocal.ED2KHash);
return;
}
}
// we assume that all episodes belong to the same anime
foreach (CrossRef_File_Episode xref in crossRefs)
{
animeID = xref.AnimeID;
AniDB_Episode ep = RepoFactory.AniDB_Episode.GetByEpisodeID(xref.EpisodeID);
if (ep == null) missingEpisodes = true;
}
}
else
{
// check if we have the episode info
// if we don't, we will need to re-download the anime info (which also has episode info)
if (aniFile.EpisodeCrossRefs.Count == 0)
{
animeID = aniFile.AnimeID;
// if we have the anidb file, but no cross refs it means something has been broken
logger.Debug("Could not find any cross ref records for: {0}", vidLocal.ED2KHash);
missingEpisodes = true;
}
else
{
foreach (CrossRef_File_Episode xref in aniFile.EpisodeCrossRefs)
{
AniDB_Episode ep = RepoFactory.AniDB_Episode.GetByEpisodeID(xref.EpisodeID);
if (ep == null)
missingEpisodes = true;
animeID = xref.AnimeID;
}
}
}
// get from DB
AniDB_Anime anime = RepoFactory.AniDB_Anime.GetByAnimeID(animeID);
bool animeRecentlyUpdated = false;
if (anime != null)
{
TimeSpan ts = DateTime.Now - anime.DateTimeUpdated;
if (ts.TotalHours < 4) animeRecentlyUpdated = true;
}
// even if we are missing episode info, don't get data more than once every 4 hours
// this is to prevent banning
if (missingEpisodes && !animeRecentlyUpdated)
{
logger.Debug("Getting Anime record from AniDB....");
anime = JMMService.AnidbProcessor.GetAnimeInfoHTTP(animeID, true, ServerSettings.AutoGroupSeries);
}
// create the group/series/episode records if needed
AnimeSeries ser = null;
if (anime != null)
{
logger.Debug("Creating groups, series and episodes....");
// check if there is an AnimeSeries Record associated with this AnimeID
ser = RepoFactory.AnimeSeries.GetByAnimeID(animeID);
if (ser == null)
{
// create a new AnimeSeries record
ser = anime.CreateAnimeSeriesAndGroup();
}
ser.CreateAnimeEpisodes();
// check if we have any group status data for this associated anime
// if not we will download it now
if (RepoFactory.AniDB_GroupStatus.GetByAnimeID(anime.AnimeID).Count == 0)
{
CommandRequest_GetReleaseGroupStatus cmdStatus =
new CommandRequest_GetReleaseGroupStatus(anime.AnimeID, false);
cmdStatus.Save();
}
// update stats
ser.EpisodeAddedDate = DateTime.Now;
RepoFactory.AnimeSeries.Save(ser, false, false);
foreach (AnimeGroup grp in ser.AllGroupsAbove)
{
grp.EpisodeAddedDate = DateTime.Now;
RepoFactory.AnimeGroup.Save(grp, true, false);
}
}
vidLocal.Places.ForEach(a =>
{
a.RenameIfRequired();
a.MoveFileIfRequired();
});
// update stats for groups and series
if (ser != null)
{
// update all the groups above this series in the heirarchy
ser.QueueUpdateStats();
//StatsCache.Instance.UpdateUsingSeries(ser.AnimeSeriesID);
}
// Add this file to the users list
if (ServerSettings.AniDB_MyList_AddFiles)
{
CommandRequest_AddFileToMyList cmd = new CommandRequest_AddFileToMyList(vidLocal.ED2KHash);
cmd.Save();
}
}
}
