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

icodebroker PYSQLITE 2024-06-18

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

▶ 예제 코드 (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;")

rowTuple = cursor.fetchone()

print(rowTuple)

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

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

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;")

rowTuple = cursor.fetchone()

print(rowTuple)

"""

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

"""