[PYTHON/PYSQLITE] Cursor 클래스 : fetchmany 메소드를 사용해 레코드 N건 가져오기

icodebroker PYSQLITE 2024-06-18

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

▶ 예제 코드 (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.fetchmany(2)

for rowTuple in rowTupleList:
    print(rowTuple)

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

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

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.fetchmany(2)

for rowTuple in rowTupleList:

print(rowTuple)

"""

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

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

"""