/[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

--- trunk/GBPVRProgramDatabaseFixer/SQLLITE.cs	2013/03/16 18:50:06	184
+++ trunk/GBPVRProgramDatabaseFixer/SQLLITE.cs	2013/03/16 18:55:49	185
@@ -867,15 +867,15 @@
                 {
                     try
                     {
-                        gLog.Verbose.Info.WriteLine("Removing old program with oid: '{0}'", old_program.oid);
+                        //gLog.Verbose.Info.WriteLine("Removing old program with oid: '{0}'", old_program.oid);
                         con.Open();
                         string command_text = string.Format(@"DELETE FROM [{0}] WHERE [oid] = @oid;", TABLES.PROGRAMME);
-                        gLog.Verbose.Debug.WriteLine("Executing Command: '{0}'", command_text);
+                        //gLog.Verbose.Debug.WriteLine("Executing Command: '{0}'", command_text);
                         using (SQLiteCommand cmd = new SQLiteCommand(command_text, con))
                         {
                             cmd.Parameters.Add(new SQLiteParameter("oid", old_program.oid));
                             int rowsupdated = cmd.ExecuteNonQuery();
-                            gLog.Verbose.Info.WriteLine("Updated '{0}' rows", rowsupdated);
+                            //gLog.Verbose.Info.WriteLine("Updated '{0}' rows", rowsupdated);
                         }
                         result = true;
                     }
@@ -906,7 +906,7 @@
                 {
                     try
                     {
-                        gLog.Verbose.Info.WriteLine("Updating old program with oid: '{0}'", new_program.oid);
+                        //gLog.Verbose.Info.WriteLine("Updating old program with oid: '{0}'", new_program.oid);
                         con.Open();
                         //string command_text = string.Format(@"UPDATE [{0}] SET [name]=@name,[sub_title]=@subtitle, WHERE [OID] = @oid", TABLES.PROGRAMME);
                         string command_text = string.Empty;
@@ -923,7 +923,7 @@
                         builder.AppendFormat("[rating]=@rating");
                         builder.AppendLine(" WHERE [oid] = @oid");
                         command_text = builder.ToString();
-                        gLog.Verbose.Debug.WriteLine("Executing Command: '{0}'", command_text);
+                        //gLog.Verbose.Debug.WriteLine("Executing Command: '{0}'", command_text);
                         using (SQLiteCommand cmd = new SQLiteCommand(command_text, con))
                         {
                             cmd.Parameters.Add(new SQLiteParameter("oid", new_program.oid));
@@ -936,7 +936,7 @@
                             cmd.Parameters.Add(new SQLiteParameter("unique_identifier", new_program.unique_identifier));
                             cmd.Parameters.Add(new SQLiteParameter("rating", new_program.rating));
                             int rowsupdated = cmd.ExecuteNonQuery();
-                            gLog.Verbose.Info.WriteLine("Updated '{0}' rows", rowsupdated);
+                            //gLog.Verbose.Info.WriteLine("Updated '{0}' rows", rowsupdated);
                         }
 
                         result = true;

 

  ViewVC Help
Powered by ViewVC 1.1.22