# If new requirements added, open Llama2_local in terminal again and run: pip3 install -r requirements.txt  

accelerate==0.25.0
bitsandbytes==0.41.1
gradio==4.14.0
protobuf==3.20.3
scipy==1.11.2
sentencepiece==0.1.99
spaces==0.20.0
torch==2.0.0
transformers==4.36.2

auto-gptq==0.3.0
tiktoken #newly added for Prompt Engineering from here: 23:53 https://www.youtube.com/watch?v=BP9fi_0XTlw 
CTransformers #newly added for Prompt Engineering from here: https://www.youtube.com/watch?v=AJOhV6Ryy5o
mysqlclient #newly added for data_fetcher.py 
#mysql-client installation did not work via terminal or requirements.txt, so I did run brew install mysql aswell as brew install mysql-client in terminal
#Note: MySQL is configured to only allow connections from localhost by default. To connect run: mysql -u root in terminal. Did not work for me. 
mysql-connector-python #newly added for data_fetcher.py
mysql-connector #newly added for data_fetcher.py
pymysql #newly added for data_fetcher.py

#from: https://singhaldhruv.medium.com/the-heros-sqlguide-conquering-the-subprocess-exited-with-error-error-92732cbe300#:~:text=The%20%E2%80%9Csubprocess%2Dexited%2Dwith%2Derror%E2%80%9D%20error%20is,confound%20even%20the%20bravest%20heroes.
#ran brew install python3-dev libmysqlclient-dev build-essential, then pip3 install --upgrade pip, then again pip3 install mysqlclient
#mysqlclient still did not work

#from: https://pypi.org/project/mysqlclient/
#ran brew install mysql pkg-config and then pip3 install mysqlclient
#mysqlclient could be installed successfully!! 

#Homebrew if zhs brew not found, run: export PATH="/opt/homebrew/bin:$PATH"

#mysql module not found :( 
#Troubleshooting from: https://stackabuse.com/bytes/fixing-modulenotfounderror-no-module-named-mysql-in-python/ 
#Checking if MySQL Package is Installed
#Before we proceed to install the MySQL module, it's good practice to first check if it's already installed. 
#You can do this by using the pip show command in your terminal:
#pip3 show mysql-connector-python
#If the MySQL module is installed, the above command will return information about the module.
#However, if it's not installed, the command will return nothing.
#If not installed, then run in terminal: pip3 install mysql-connector-python

#Still did not work, error: import mysql.connector ModuleNotFoundError: No module named 'mysql'
#Try to run in terminal: pip3 install mysql -> Getting requirements to build wheel ... error error: subprocess-exited-with-error
#Need to run: pip3 install mysql-connector BECAUSE THE MYSQL_CONNECTOR IS NEEDED IN ORDER TO RUN MYSQL WITH PYTHON, found at https://www.youtube.com/watch?v=Yugm4lzEPTU
mysql-connector

#ALSO, pip3 install tokenizer needed! 
tokenizer