| 386 | |
| 387 | |
| 388 | def test_auto_transaction(conn): |
| 389 | conn.pgconn.exec_(bclass="st">"drop table if exists foo") |
| 390 | conn.pgconn.exec_(bclass="st">"create table foo (id int primary key)") |
| 391 | |
| 392 | cur = conn.cursor() |
| 393 | assert conn.pgconn.transaction_status == pq.TransactionStatus.IDLE |
| 394 | |
| 395 | cur.execute(class="st">"insert into foo values (1)") |
| 396 | assert conn.pgconn.transaction_status == pq.TransactionStatus.INTRANS |
| 397 | |
| 398 | conn.commit() |
| 399 | assert conn.pgconn.transaction_status == pq.TransactionStatus.IDLE |
| 400 | cur.execute(class="st">"select * from foo") |
| 401 | assert cur.fetchone() == (1,) |
| 402 | assert conn.pgconn.transaction_status == pq.TransactionStatus.INTRANS |
| 403 | |
| 404 | |
| 405 | def test_auto_transaction_fail(conn): |