python - Flask logging to database class doesn't work

Question

I'm trying to log request info to database (need for admin frontend). Coded a primitive class to test it. So it doesn't work at all bot on test server and in production. Database request is correct, I've checked it. Where can be a problem?

...
import logging

db = sqlalchemy.create_engine(config.connection_string)

class Logger(logging.Handler):
    def emit(self, record):
        path = request.path
        method = request.method
        ip = request.remote_addr

        db.execute(f'INSERT INTO request_log(req_type, req_ip, req_route) VALUES({method}, {ip}, {path})')

app = Flask(__name__)
log = Logger()
log.setLevel(logging.INFO)
app.logger.addHandler(log)

# routes
@app.route("/someroute", methods=['GET'])
...
...

Answer 1

等待大神答复