Python/SQLite

[Python] sqlite3 iterdump( ) - SQL 쿼리 형식으로 데이터베이스를 덤프

Pydole 2019. 1. 2. 20:10

# 현재 DB를 SQL 쿼리 형식으로 리턴

import sqlite3

conn = sqlite3.connect(r'C:\Temp\test.db')
cur = conn.cursor()

for row in conn.iterdump():
    print(row) 

----------------------------------------------------------
BEGIN TRANSACTION;
CREATE TABLE Score(nation, point);
INSERT INTO "Score" VALUES('kr',90);
INSERT INTO "Score" VALUES('jp',80);
INSERT INTO "Score" VALUES('cn',85);
INSERT INTO "Score" VALUES('cn',85);
COMMIT;