/[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 190 by william, Sat Mar 16 19:59:44 2013 UTC revision 191 by william, Sat Mar 16 20:07:53 2013 UTC
# Line 838  namespace GBPVRProgramDatabaseFixer Line 838  namespace GBPVRProgramDatabaseFixer
838                  gLog.Error.WriteLine("Failed to remove one or more program(s)");                  gLog.Error.WriteLine("Failed to remove one or more program(s)");
839              }              }
840              st.Stop();              st.Stop();
841              gLog.Warn.WriteLine("    operation took: {0} seconds", st.Elapsed.TotalSeconds);              gLog.Warn.WriteLine("    operation took: {0:0.00000} minutes", st.Elapsed.TotalMinutes);
842          }          }
843          public void UpdateGBPVRPrograms(List<IOldNewProgram> programs)          public void UpdateGBPVRPrograms(List<IOldNewProgram> programs)
844          {          {
# Line 852  namespace GBPVRProgramDatabaseFixer Line 852  namespace GBPVRProgramDatabaseFixer
852                  new_program_list.Add(program.NewProgram);                  new_program_list.Add(program.NewProgram);
853              }              }
854              new_program_list.TrimExcess();              new_program_list.TrimExcess();
855              gLog.Info.WriteLine("Inserting {0} gbpvr programs.", new_program_list.Count);              gLog.Info.WriteLine("Inserting {0} gbpvr programs.", new_program_list.ToArray().Count());
856              Stopwatch st = new Stopwatch();              Stopwatch st = new Stopwatch();
857              st.Start();              st.Start();
858              if (!InsertProgramEntryDatabase(new_program_list))              if (!InsertProgramEntryDatabase(new_program_list))
# Line 861  namespace GBPVRProgramDatabaseFixer Line 861  namespace GBPVRProgramDatabaseFixer
861              }              }
862              //string command = BuildGBPVRMultiInsertCommand(new_program_list);              //string command = BuildGBPVRMultiInsertCommand(new_program_list);
863              st.Stop();              st.Stop();
864              gLog.Warn.WriteLine("    operation took: {0} seconds", st.Elapsed.TotalSeconds);              gLog.Warn.WriteLine("    operation took: {0:0.00000} minutes", st.Elapsed.TotalMinutes);
865          }          }
866    
867          private bool RemoveAllProgramDatabaseEntries()          private bool RemoveAllProgramDatabaseEntries()

Legend:
Removed from v.190  
changed lines
  Added in v.191

  ViewVC Help
Powered by ViewVC 1.1.22