2
97%
master: 97%

Ran 26 Oct 2017 04:22PM UTC

Files 22

Run time 0s

Badge

Embed ▾

Committed 26 Oct 2017 04:20PM UTC coverage: 96.198% (-0.7%) from 96.938%

Job # 195.2

Build Type

push

travis-ci

Committed by

pumazi

Commit Message

Explicitly close all postgres db connections

The psycopg2 db connection `with` statement does not actually close the
database connection causing lots of idle postgres connections on the
production servers.  An idle postgres connection can be found by doing
`ps aux` on the database servers, for example you will see something
like this:

```
postgres 25498  0.0  0.5 302652 10996 ?        Ss   09:31   0:00 postgres: cnxarchive cnxarchive 192.168.122.250(42646) idle
```

On http://initd.org/psycopg/docs/usage.html#with-statement

"Note that, unlike file objects or other resources, exiting the
connection’s with block doesn't close the connection but only the
transaction associated with it"

This change creates a `db_connect` function that is like
`psycopg2.connect` but closes the db connection when exiting the `with`
block.

Run Details

1012 of 1052 relevant lines covered (96.2%)

0.96 hits per line

karenc / db-migrator / 195 / 2
97%
master: 97%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 195.2

karenc / db-migrator / 195 / 2 97% master: 97%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 195.2

karenc / db-migrator / 195 / 2
97%
master: 97%

README BADGES
x