Python customize logging

Question

I have a webapp (Flask) and I need to enable some logging. I need to log to a mysql table with the columns:

id, timestamp, userid, orderid, service, msg, response

I would like to use the python's std logging. Example usage would be:

special_logger = logging.getSpecialLogger() # instead of logging.getLogger()

special_logger.setLevel(level=logging.DEBUG)
special_logger.addHandler(myMysqlHandler)
special_logger.debug(current_uid, myorderid, 'SERVICE1', 'Exception happened', serviceResponse)

How I can achieve that?

I updated my answer in response to your comment.

Vinay Sajip
– Vinay Sajip

2014-09-16 16:42:50 +00:00
Commented Sep 16, 2014 at 16:42 — Vinay Sajip
– Vinay Sajip, Commented Sep 16, 2014 at 16:42

Community · Accepted Answer · 2017-05-23 12:21:40Z

1

Just use a normal logger, and a database handler as described in this answer. Although my other answer doesn't address MySQL specifically, it uses DB-API and so should be adaptable to a MySQL Python driver which conforms to DB-API 2.0.

Update: You can pass extra data to the log by following the documentation here.

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Sep 15, 2014 at 21:19

Vinay Sajip

100k15 gold badges184 silver badges196 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

gosom Over a year ago

thanks for the answer. I can write an LogHandler. The problem is that I need to pass extra data in the logger. Check the last line in the code in the question

Collectives™ on Stack Overflow

Python customize logging

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related