| 1 | #!/usr/bin/env python
|
|---|
| 2 |
|
|---|
| 3 | import sys
|
|---|
| 4 | import psycopg2
|
|---|
| 5 |
|
|---|
| 6 |
|
|---|
| 7 | for level in (0, 1, 2):
|
|---|
| 8 | connection = psycopg2.connect(sys.argv[1])
|
|---|
| 9 | connection.set_isolation_level(1)
|
|---|
| 10 |
|
|---|
| 11 | print 'In isolation level: %d' % (level,)
|
|---|
| 12 |
|
|---|
| 13 | c = connection.cursor()
|
|---|
| 14 | c.execute('SHOW TIME ZONE')
|
|---|
| 15 | print 'Original time zone: %s' % (c.fetchone()[0],)
|
|---|
| 16 |
|
|---|
| 17 | c = connection.cursor()
|
|---|
| 18 | c.execute('SET TIME ZONE \'EST\'')
|
|---|
| 19 | c.execute('SHOW TIME ZONE')
|
|---|
| 20 | print 'Set timezone to: %s' % (c.fetchone()[0],)
|
|---|
| 21 | connection.commit()
|
|---|
| 22 |
|
|---|
| 23 | c = connection.cursor()
|
|---|
| 24 | c.execute('SHOW TIME ZONE')
|
|---|
| 25 | print 'Next cursor got time zone: %s' % (c.fetchone()[0],)
|
|---|
| 26 |
|
|---|
| 27 | connection.close()
|
|---|