Pi 5 : API Server

ชุดคำสั่งที่ใช้ในการติดตั้ง

1.On Terminal
1.1 Update latest version
sudo apt update
sudo apt upgrade -y
1.2 Install VSCode
sudo apt install wget gpg
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | gpg –dearmor > microsoft.gpg
sudo install -o root -g root -m 644 microsoft.gpg /etc/apt/trusted.gpg.d/
sudo sh -c ‘echo “deb [arch=arm64] https://packages.microsoft.com/repos/code stable main” > /etc/apt/sources.list.d/vscode.list’
sudo apt update
sudo apt install code

1.3 Install python , tdsodbc
sudo apt install -y python3 python3-pip python3-venv
sudo apt install -y freetds-bin freetds-dev tdsodbc unixodbc unixodbc-dev

3.mkdir APIServer

4.Open VS Code (Open Folder at APIServer)
New Terminal

python3 -m venv venv
source venv/bin/activate
pip install fastapi uvicorn[standard]
pip install pyodbc
pip install python-multipart
pip install requests

5.Testing
python3 testODBC1.py
python3 testODBC2.py