sqlite3 레코드 추가/수정/삭제

sqlite3 레코드 추가/수정/삭제시 Connection의 commit()함수 호출

# -*- coding:utf-8 -*-
import sqlite3
 
conn = sqlite3.connect('test.db')
conn.text_factory = str 
cursor = conn.cursor()
 
cursor.execute("""
INSERT INTO testtable (NAME, PHONE, EMAIL) 
VALUES(?, ?, ?)
""", ("테스트1", '010-3333-5555', 'aaa@naver.com'))
 
id = cursor.lastrowid
print(id)
 
cursor.execute("""
INSERT INTO testtable (NAME, PHONE, EMAIL) 
VALUES(?, ?, ?)
""", ('테스트2', '010-5555-6666', 'bbb@gmail.com'))
 
id = cursor.lastrowid
print(id)
 
conn.commit()
 
cursor.close()
conn.close()