[PYTHON/PYSQLITE] Cursor 클래스 : fetchall 메소드를 사용해 모든 레코드 가져오기

icodebroker PYSQLITE 2024-06-18

■ Cursor 클래스의 fetchall 메소드를 사용해 모든 레코드를 가져오는 방법을 보여준다.

▶ 예제 코드 (PY)


import sqlite3

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

cursor = connection.cursor()

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

sql = "INSERT INTO PHONE_BOOK VALUES (?, ?);"

parameterTupleTuple = \
(
    ("Derick", "010-1234-5678"),
    ("Tom"   , "010-5432-5432"),
    ("DSP"   , "010-1234-1234")
)

cursor.executemany(sql, parameterTupleTuple)

cursor.execute("SELECT * FROM PHONE_BOOK;")

rowTupleList = cursor.fetchall()

for rowTuple in rowTupleList:
    print(rowTuple)

"""
('Derick', '010-1234-5678')
('Tom', '010-5432-5432')
('DSP', '010-1234-1234')
"""

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

import sqlite3

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

cursor = connection.cursor()

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

sql = "INSERT INTO PHONE_BOOK VALUES (?, ?);"

parameterTupleTuple = \

(

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

("Tom" , "010-5432-5432"),

("DSP" , "010-1234-1234")

)

cursor.executemany(sql, parameterTupleTuple)

cursor.execute("SELECT * FROM PHONE_BOOK;")

rowTupleList = cursor.fetchall()

for rowTuple in rowTupleList:

print(rowTuple)

"""

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

('Tom', '010-5432-5432')

('DSP', '010-1234-1234')

"""