[PYTHON/PYSQLITE] Connection 클래스 : iterdump 메소드를 사용해 데이터베이스 덤프 만들기

■ Connection 클래스의 iterdump 메소드를 사용해 데이터베이스 덤프를 만드는 방법을 보여준다.

▶ 예제 코드 (PY)


import sqlite3

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

cursor = connection.cursor()

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

cursor.execute("INSERT INTO PHONE_BOOK VALUES ('Derick', '010-1234-5678');")
cursor.execute("INSERT INTO PHONE_BOOK VALUES ('Tom'   , '010-5432-7833');")
cursor.execute("INSERT INTO PHONE_BOOK VALUES ('DSP'   , '010-1234-9876');")

with open("dump.sql", "w") as textIOWrapper:
    for line in connection.iterdump():
        textIOWrapper.write("{0}\n".format(line))

"""
BEGIN TRANSACTION;
CREATE TABLE PHONE_BOOK (NAME TEXT, PHONE_NUMBER TEXT);
INSERT INTO "PHONE_BOOK" VALUES('Derick','010-1234-5678');
INSERT INTO "PHONE_BOOK" VALUES('Tom','010-5432-7833');
INSERT INTO "PHONE_BOOK" VALUES('DSP','010-1234-9876');
COMMIT;
"""

import sqlite3

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

cursor = connection.cursor()

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

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

cursor.execute("INSERT INTO PHONE_BOOK VALUES ('Tom' , '010-5432-7833');")

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

with open("dump.sql", "w") as textIOWrapper:

for line in connection.iterdump():

textIOWrapper.write("{0}\n".format(line))

"""

BEGIN TRANSACTION;

CREATE TABLE PHONE_BOOK (NAME TEXT, PHONE_NUMBER TEXT);

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

INSERT INTO "PHONE_BOOK" VALUES('Tom','010-5432-7833');

INSERT INTO "PHONE_BOOK" VALUES('DSP','010-1234-9876');

COMMIT;

"""