Python logging handler that stores logs in postgresql
Project description
Install
Grab the code with pip:
$ pip install logtopg
But you also have to install the ltree contrib module into your database:
$ sudo -u postgres psql -c "create extension ltree";
Try it out
Here’s an example script:
import logging import logging.config log = logging.getLogger("logtopg.example") if __name__ == "__main__": # These need to be correct, so you'll likely need to change them. db_credentials = { "database":"logtopg", "host":"localhost", "user":"logtopg", "password":"l0gt0pg"} d = dict({ 'disable_existing_loggers': False, 'handlers': { 'pg': { 'class': 'logtopg.PGHandler', 'level': 'DEBUG', 'log_table_name': 'logtopg_example', 'params': db_credentials}, "console": { "class": "logging.StreamHandler", "level": "DEBUG" }}, 'root': { 'handlers': ["console", 'pg'], 'level': 'DEBUG'}, 'version': 1}) logging.config.dictConfig(d) log.debug("debug!") log.info("info!") log.warn("warn!") log.error("error!") log.critical("critical!")
Contribute to logtopg
Get a copy of the code:
$ git clone --origin github https://github.com/216software/logtopg.git
Install it like this:
$ cd logtopg $ pip install -e .
Create test user and test database:
$ sudo -u postgres createuser --pwprompt logtopg $ sudo -u postgres createdb --owner logtopg logtopg $ sudo -u postgres psql -c "create extension ltree";
Then run the tests like this:
$ python tests/test_logtopg.py ..... ---------------------------------------------------------------------- Ran 5 tests in 0.465s OK
And hopefully stuff works!
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
LogToPG-0.0.5.tar.gz
(2.7 kB
view hashes)