/[xmltv_parser]/trunk/GBPVRProgramDatabaseFixer/SQLLITE.cs
ViewVC logotype

Diff of /trunk/GBPVRProgramDatabaseFixer/SQLLITE.cs

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 166 by william, Sat Mar 16 13:16:42 2013 UTC revision 167 by william, Sat Mar 16 13:26:09 2013 UTC
# Line 287  namespace GBPVRProgramDatabaseFixer Line 287  namespace GBPVRProgramDatabaseFixer
287              DateTime last = new DateTime();              DateTime last = new DateTime();
288              first = list.OrderBy(s => s.start_time).ToList().First().start_time;                          first = list.OrderBy(s => s.start_time).ToList().First().start_time;            
289              last = list.OrderBy(s => s.start_time).ToList().Last().start_time;              last = list.OrderBy(s => s.start_time).ToList().Last().start_time;
290              gLog.Info.WriteLine("\tFirst: {0} = ({1})", first.ToString("yyyy/MM/dd HH:mm:ss.fffffff"), first.ToDateTimeString());              gLog.Verbose.Debug.WriteLine("\tFirst: {0} = ({1})", first.ToString("yyyy/MM/dd HH:mm:ss.fffffff"), first.ToDateTimeString());
291              gLog.Info.WriteLine("\tLast: {0} = ({1})", last.ToString("yyyy/MM/dd HH:mm:ss.fffffff"), last.ToDateTimeString());              gLog.Verbose.Debug.WriteLine("\tLast: {0} = ({1})", last.ToString("yyyy/MM/dd HH:mm:ss.fffffff"), last.ToDateTimeString());
292              var range = DateTimeRange.Create(first, last);              var range = DateTimeRange.Create(first, last);
293              return range;              return range;
294          }          }
# Line 321  namespace GBPVRProgramDatabaseFixer Line 321  namespace GBPVRProgramDatabaseFixer
321                  //    removed_programs.Add(program);                  //    removed_programs.Add(program);
322                  //}                    //}  
323                  progress = 100.0 * (index / total);                  progress = 100.0 * (index / total);
324                  gLog.ReportProgress(this, new ReportProgressEventArgs((int)progress, string.Format("SQLLITE: Filtering GBPVR Programs: {1:00}%", progress)));                  gLog.ReportProgress(this, new ReportProgressEventArgs((int)progress, string.Format("Filtering GBPVR Programs: {0:00}%", (int)progress)));
325                  var xmltv_entry = program.AsXMLTVProgramDefinition(this);                  var xmltv_entry = program.AsXMLTVProgramDefinition(this);
326                  if (xmltv_programs.Contains(xmltv_entry))                  if (xmltv_programs.Contains(xmltv_entry))
327                  {                  {
# Line 346  namespace GBPVRProgramDatabaseFixer Line 346  namespace GBPVRProgramDatabaseFixer
346    
347              source_valid = source_valid.OrderBy(s => s.channel_oid).ThenBy(s => s.start_time).ToList();              source_valid = source_valid.OrderBy(s => s.channel_oid).ThenBy(s => s.start_time).ToList();
348              source_invalid = source_invalid.OrderBy(s => s.channel_oid).ThenBy(s => s.start_time).ToList();              source_invalid = source_invalid.OrderBy(s => s.channel_oid).ThenBy(s => s.start_time).ToList();
349    
350                gLog.Info.WriteLine("Total XMLTV Programs: 0x{0:x8}", xmltv_programs.Count);
351                gLog.Info.WriteLine("Found: 0x{0:x8} valid GB-PVR Programs", source_valid.Count);
352                gLog.Info.WriteLine("Found: 0x{0:x8} invalid GB-PVR Programs", source_invalid.Count);
353                gLog.Info.WriteLine("Total GB-PVR Programs: 0x{0:x8}", source_valid.Count + source_invalid.Count);
354    
355              return source_valid;              return source_valid;
356          }          }
357          #endregion          #endregion
Legend:
Removed from v.166  
changed lines
  Added in v.167
  ViewVC Help
Powered by ViewVC 1.1.22