[chronojump] At importer if debug active, shows all sql commands



commit d398a26dc92d3b5f0a4cef64504eea0832532cc8
Author: Xavier de Blas <xaviblas gmail com>
Date:   Wed Jun 10 13:19:40 2020 +0200

    At importer if debug active, shows all sql commands

 src/chronojump-importer/chronojump_importer.py | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)
---
diff --git a/src/chronojump-importer/chronojump_importer.py b/src/chronojump-importer/chronojump_importer.py
index e969436c..8d146fc2 100755
--- a/src/chronojump-importer/chronojump_importer.py
+++ b/src/chronojump-importer/chronojump_importer.py
@@ -216,9 +216,6 @@ class Database:
                        "join_clause": join_clause, "where": where_condition, "group_by": group_by}
 
         sql = "SELECT {column_names} FROM {table_names_str} {join_clause} {where} 
{group_by}".format(**format_data)
-        if(DEBUGTOFILE):
-                debugFile.write(str(sql) + "\n")
-
         self._execute_query_and_log(sql, [])
 
         results = self._cursor.fetchall()
@@ -383,6 +380,10 @@ class Database:
 
     def _execute_query_and_log(self, sql, where_values):
         logging.debug("SQL: {} - values: {}".format(sql, where_values))
+        if(DEBUGTOFILE):
+                debugFile.write("\n")
+                debugFile.write("SQL: {} - values: {}".format(sql, where_values))
+
         self._cursor.execute(sql, where_values)
 
 


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]