- Install dependencies for PyODBC and tds
$ apt-get install -y tdsodbc unixodbc-dev
$ apt install unixodbc-bin -y
$ apt-get clean -y
- Edit /etc/odbcinst.ini
echo "[FreeTDS]
[FreeTDS]
Description = FreeTDS unixODBC Driver
Driver = /usr/lib/arm-linux-gnueabihf/odbc/libtdsodbc.so
Setup = /usr/lib/arm-linux-gnueabihf/odbc/libtdsS.so
- Install requirements (contains pyodbc)
pip install --no-cache-dir -r requirements.txt
- Create a new service file.
$ vim /lib/systemd/system/website-demo.service
[Unit]
Description=Raspberry WebSite Demo
After= network-online.target
[Service]
ExecStart=/usr/bin/python3 /home/pi/Desktop/demo/manage.py runserver 0.0.0.0:8000
WorkingDirectory=/home/pi/Desktop/demo
User = nobody
- Linked this file to the systemctl path
ln -fs /lib/systemd/system/website-demo.service /etc/systemd/system/website-demo.service
- Register service
$ sudo systemctl daemon-reload
$ sudo systemctl restart website-demo.service
$ sudo systemctl enable website-demo.service
-
Restful Method:
- POST - Create
- GET - Read
- PATCH - Update
- DELETE - Delete