[PYTHON/PYSQLITE] Connection 클래스 : commit/rollback 메소드를 사용해 트랜잭션 처리하기

icodebroker PYSQLITE 2024-06-18

■ Connection 클래스의 commit/rollback 메소드를 사용해 트랜잭션을 처리하는 방법을 보여준다.

▶ 예제 코드 (PY)


import sqlite3

connection = sqlite3.connect("test.db")

cursor = connection.cursor()

cursor.execute("CREATE TABLE PHONE_BOOK (NAME TEXT, PHONE_NUMBER TEXT);")

try:
    cursor.execute("INSERT INTO PHONE_BOOK VALUES ('Derick', '010-1234-5678');")

    connection.commit()
except:
    connection.rollback()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

import sqlite3

connection = sqlite3.connect("test.db")

cursor = connection.cursor()

cursor.execute("CREATE TABLE PHONE_BOOK (NAME TEXT, PHONE_NUMBER TEXT);")

try:

cursor.execute("INSERT INTO PHONE_BOOK VALUES ('Derick', '010-1234-5678');")

connection.commit()

except:

connection.rollback()