ini: create separate log handlers for color and null, and add comments hinting how they can be used

Let development.ini use color for the root logger as before. The special effect
of color_sql was not visible with the default sqlalchemy log level of WARN, so
just use color there as well.

development.ini

@@ -356,7 +356,7 b' script_location = kallithea:alembic'
 keys = root, routes, kallithea, sqlalchemy, tg, gearbox, beaker, templates, whoosh_indexer, werkzeug, backlash
 
 [handlers]
-keys = console, console_sql
+keys = console, console_color, console_color_sql, null
 
 [formatters]
 keys = generic, color_formatter, color_formatter_sql
@@ -367,7 +367,10 b' keys = generic, color_formatter, color_f'
 
 [logger_root]
 level = NOTSET
-handlers = console
+#handlers = console
+handlers = console_color
+# For coloring based on log level:
+# handlers = console_color
 
 [logger_routes]
 #level = WARN
@@ -408,9 +411,12 b' qualname = gearbox'
 
 [logger_sqlalchemy]
 level = WARN
-handlers = console_sql
+handlers =
 qualname = sqlalchemy.engine
-propagate = 0
+# For coloring based on log level and pretty printing of SQL:
+# level = INFO
+# handlers = console_color_sql
+# propagate = 0
 
 [logger_whoosh_indexer]
 #level = WARN
@@ -435,15 +441,24 b' qualname = backlash'
 [handler_console]
 class = StreamHandler
 args = (sys.stderr,)
-#formatter = generic
+formatter = generic
+
+[handler_console_color]
+# ANSI color coding based on log level
+class = StreamHandler
+args = (sys.stderr,)
 formatter = color_formatter
 
-[handler_console_sql]
+[handler_console_color_sql]
+# ANSI color coding and pretty printing of SQL statements
 class = StreamHandler
 args = (sys.stderr,)
-#formatter = generic
 formatter = color_formatter_sql
 
+[handler_null]
+class = NullHandler
+args = ()
+
 ################
 ## FORMATTERS ##
 ################

kallithea/lib/paster_commands/template.ini.mako

@@ -537,7 +537,7 b' script_location = kallithea:alembic'
 keys = root, routes, kallithea, sqlalchemy, tg, gearbox, beaker, templates, whoosh_indexer, werkzeug, backlash
 
 [handlers]
-keys = console, console_sql
+keys = console, console_color, console_color_sql, null
 
 [formatters]
 keys = generic, color_formatter, color_formatter_sql
@@ -549,6 +549,8 b' keys = generic, color_formatter, color_f'
 [logger_root]
 level = NOTSET
 handlers = console
+# For coloring based on log level:
+# handlers = console_color
 
 [logger_routes]
 level = WARN
@@ -583,9 +585,12 b' qualname = gearbox'
 
 [logger_sqlalchemy]
 level = WARN
-handlers = console_sql
+handlers =
 qualname = sqlalchemy.engine
-propagate = 0
+# For coloring based on log level and pretty printing of SQL:
+# level = INFO
+# handlers = console_color_sql
+# propagate = 0
 
 [logger_whoosh_indexer]
 level = WARN
@@ -611,10 +616,21 b' class = StreamHandler'
 args = (sys.stderr,)
 formatter = generic
 
-[handler_console_sql]
+[handler_console_color]
+# ANSI color coding based on log level
 class = StreamHandler
 args = (sys.stderr,)
-formatter = generic
+formatter = color_formatter
+
+[handler_console_color_sql]
+# ANSI color coding and pretty printing of SQL statements
+class = StreamHandler
+args = (sys.stderr,)
+formatter = color_formatter_sql
+
+[handler_null]
+class = NullHandler
+args = ()
 
 <%text>################</%text>
 <%text>## FORMATTERS ##</%text>

scripts/generate-ini.py

@@ -19,11 +19,8 b' ini_files = ['
                 'app_instance_uuid': 'development-not-secret',
                 'session.secret': 'development-not-secret',
             },
-            '[handler_console]': {
-                'formatter': 'color_formatter',
-            },
-            '[handler_console_sql]': {
-                'formatter': 'color_formatter_sql',
+            '[logger_root]': {
+                'handlers': 'console_color',
             },
             '[logger_routes]': {
                 'level': 'DEBUG',