summaryrefslogtreecommitdiff
path: root/sandbox/test_isready_connection_closed.py
blob: e70e8e18d4826eaac7ac78d704c276c718221681 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
import gc
import sys
import os
import signal
import warnings
import psycopg2

print("Testing psycopg2 version %s" % psycopg2.__version__)

dbname = os.environ.get('PSYCOPG2_TESTDB', 'psycopg2_test')
conn = psycopg2.connect("dbname=%s" % dbname)
curs = conn.cursor()
curs.isready()

print("Now restart the test postgresql server to drop all connections, press enter when done.")
raw_input()

try:
    curs.isready() # No need to test return value
    curs.isready()
except:
    print("Test passed")
    sys.exit(0)

if curs.isready():
    print("Warning: looks like the connection didn't get killed. This test is probably in-effective")
    print("Test inconclusive")
    sys.exit(1)

gc.collect() # used to error here
print("Test Passed")