[PYTHON/PSYCOPG2] with ... as ... 구문 : 리소스 자동 해제하기

■ with … as … 구문을 사용해 리소스를 자동으로 해제하는 방법을 보여준다.

▶ 예제 코드 (PY)


import psycopg2

with psycopg2.connect("host='192.168.29.118' dbname='testdb' user='testuser1' password='test1234'") as connection:
    with connection.cursor() as cursor:
        cursor.execute("SELECT * FROM test")

        resultList = cursor.fetchall()

        for result in resultList:
            print(result)

import psycopg2

with psycopg2.connect("host='192.168.29.118' dbname='testdb' user='testuser1' password='test1234'") as connection:

with connection.cursor() as cursor:

cursor.execute("SELECT * FROM test")

resultList = cursor.fetchall()

for result in resultList:

print(result)

▶ requirements.txt


psycopg2-binary==2.9.9

psycopg2-binary==2.9.9