sqlite3 사용하기

# 버전확인
import sqlite3

print(sqlite3.version) # 모듈 자체 버전
print(sqlite3.sqlite_version) # sqlite 버전

# database 생성
dbConn = sqlite3.connec(database='path')

# cursor 생성 / execute
cs = dbConn.cursor()
cs.execute("create table x(a int)")
cs.execute("insert into x values (?)", (12345,))
cs.execute("select * from x").fetchall()

# commit
dbConn.commit()

# db 닫기
dbConn.close()