파이썬기초92 : 데이터베이스 실습해보기

import sqlite3

con = sqlite3.connect(":memory:")

cur = con.cursor()

cur.execute("create table PhoneBook(Name text, PhoneNumber text);")

cur.execute("insert into PhoneBook Values('Derick', '010-1234-5678');")

name = "Gildong"

phoneNumber = "010-222-3333"

cur.execute("insert into PhoneBook values(?,?);", (name, phoneNumber))

cur.execute("insert into PhoneBook values(:inputName, :inputNum);", {"inputNum":phoneNumber, "inputName":name})

datalist = (('Tom','010-333-4444'), ('DSP','010-222-5555'))

cur.executemany("insert into PhoneBook values(?,?);", datalist)

def dataGenerator():

datalist = {('Tom','010-543-1111'), ('DSP','010-444-5555')}

for item in datalist:

yield item

cur.executemany("insert into PhoneBook values(?,?);", dataGenerator())

cur.execute("select * from PhoneBook;")

for row in cur:

print(row)

('Derick', '010-1234-5678')

('Gildong', '010-222-3333')

('Gildong', '010-222-3333')

('Tom', '010-333-4444')

('DSP', '010-222-5555')

('Tom', '010-543-1111')

('DSP', '010-444-5555')

cur.execute("select * from PhoneBook;")

cur.fetchone()

('Derick', '010-1234-5678')

cur.fetchmany(2)

[('Gildong', '010-222-3333'), ('Gildong', '010-222-3333')]

cur.fetchall()

[('Tom', '010-333-4444'), ('DSP', '010-222-5555'), ('Tom', '010-543-1111'), ('DSP', '010-444-5555')]

con = sqlite3.connect(":memory:")

with open("c:\\work\\dump.sql") as f:

SQLScript = f.read()

cur = con.cursor()

cur.executescript(SQLScript)

cur.execute("select * from PhoneBook;")

print([r for r in cur])

[('Derick', '010-1234-5678'), ('Tom', '010-543-5432'), ('DSP', '010-123-1234')]