■ SQLDatabase 클래스의 run 메소드를 사용해 SQLITE 데이터를 가져오는 방법을 보여준다.
▶ main.py
|
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 |
import ast import re from langchain_community.utilities import SQLDatabase sqlDatabase = SQLDatabase.from_uri("sqlite:///chinook.db") def getSQLiteData(sqlDatabase, sql): resultString = sqlDatabase.run(sql) resultTupleList = ast.literal_eval(resultString) resultList1 = [element for resultTuple in resultTupleList for element in resultTuple if element] resultList2 = [re.sub(r"\b\d+\b", "", result).strip() for result in resultList1] return list(set(resultList2)) artistNameList = getSQLiteData(sqlDatabase, "SELECT Name FROM artists") albumTitleList = getSQLiteData(sqlDatabase, "SELECT Title FROM albums ") print(artistNameList[:5]) print(albumTitleList[:5]) """ ['Fretwork', 'Aaron Copland & London Symphony Orchestra', 'Raimundos', 'Seu Jorge', 'Ney Matogrosso'] ['St. Anger', 'Mezmerize', 'Speak of the Devil', 'Allegri: Miserere', 'Machine Head'] """ |
▶ requirements.txt
|
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 34 35 36 |
aiohttp==3.9.5 aiosignal==1.3.1 annotated-types==0.7.0 async-timeout==4.0.3 attrs==23.2.0 certifi==2024.6.2 charset-normalizer==3.3.2 dataclasses-json==0.6.7 frozenlist==1.4.1 greenlet==3.0.3 idna==3.7 jsonpatch==1.33 jsonpointer==3.0.0 langchain==0.2.3 langchain-community==0.2.4 langchain-core==0.2.5 langchain-text-splitters==0.2.1 langsmith==0.1.77 marshmallow==3.21.3 multidict==6.0.5 mypy-extensions==1.0.0 numpy==1.26.4 orjson==3.10.4 packaging==23.2 pydantic==2.7.4 pydantic_core==2.18.4 PyYAML==6.0.1 requests==2.32.3 SQLAlchemy==2.0.30 tenacity==8.3.0 typing-inspect==0.9.0 typing_extensions==4.12.2 urllib3==2.2.1 yarl==1.9.4 |
※ pip install langchain-community 명령을 실행했다.
