sqlite3은 기본 포함되어 있다.

import sqlite3

메모리에 DB 생성 – 일회성 con = sqlite3.connect(‘:memory:’)

파일 DB con = sqlite3.connect(‘./test.db’)

cur = con.cursor() cur.execute(“CREATE TABLE PhoneBook(Name text, PhoneNum text);”)

데이터 삽입 cur = con.cursor() cur.execute(“INSERT INTO PhoneBook Values(‘Derick’, ‘010-1234-5678’);”)

or

name = ‘SangJung’ phoneNumber = ‘010-5670-2343’ cur = con.cursor() cur.execute(‘INSERT INTO PhoneBook VALUES(?, ?);’, (name, phoneNumber))

or

name = ‘SangJung’ phoneNumber = ‘010-5670-2343’ cur = con.cursor() cur.execute(‘INSERT INTO PhoneBook VALUES(:name, :phoneNumber);’, {“name”:name, “phoneNumber”:phoneNumber})

or

dataList = ((‘Tom’, ‘010-543-5432’), (‘DSP’, ‘010-123-1234’)) cur = con.cursor() cur.executemany(“INSERT INTO PhoneBook VALUES(?, ?);”, dataList)

데이터 조회

순회 조회

cur.execute(‘SELECT * FROM PhoneBook’) for row in cur: print(row)

(‘Derick’, ‘010-1234-5678’) (‘SangJung’, ‘010-5670-2343’) (‘Tom’, ‘010-543-5432’) (‘DSP’, ‘010-123-1234’)

단건 조회

cur.execute(‘SELECT * FROM PhoneBook’) cur.fetchone() (‘Derick’, ‘010-1234-5678’)

다건 조회

cur.fetchmany(2) [(‘SangJung’, ‘010-5670-2343’), (‘SangJung’, ‘010-5670-2343’)]

모두 조회

cur.fetchall() [(‘Tom’, ‘010-543-5432’), (‘DSP’, ‘010-123-1234’)]

con.commit()