plotly-dashboard

Dashboard for sensor data using Dash from plot.ly

Legacy Notes

data-trans contains 2019 Spring Python Code for Raspberry Pi Data Relay (repeater.py) and Xbee Chaser Car Client (serialReceiver.py).

sim-arduino contains test simulation code for plotly to ensure it will work.

Installation & Requirements

• Create a new virtual environment.
• Run pip install -r requirements.txt.
• All commands are run with Python3. Please config or change cmd according to your local environment.

Usage

• Check MySQL is running, proper database and tables are set.
  • MAMP is recommended for fast setup on macOS, phpmyadmin is a good GUI tool to deal with MySQL, which packaged in MAMP as well, use the script database/uscsolarcar.sql to fast set up, but please finish reading this README first.
  • XAMPP is equivalent MAMP on windows.
  • Linux user should know what they are doing.
• Check the configuration for serial port in serialReceiver.py, each time USB plugged into computer, the serial port number will change.
• Run python3 dashboard.py to start the dashboard webserver. The access url will shown in terminal.
• Run python3 serialReceiver.py to receive and update sensor data. This script will be updated by Telemetry Team.

Dev Instruction

• Check Workflow Wiki page if new to pull request.

serialReceiver.py

Data Format

Each group of data has multiple new lines, each line contains one value of a sensor data.

Each entry of data in a group is recorded by sensors at the current time.

Database

Use MySQL database running on localhost to store and management the data.

Not using SQLite3 for concurrent access problem

Database Data Scheme

Important: There is a init script to set up MySQL database locally. The scheme divergence should follow that script (database/uscsolarcar.sql). Important Again: the sql script does not set up user information for the databse. To understand how to set up user and privilege for MySQL, please google it. The python scripts in this repo using databse requires proper user info modified in the codes.

Data from BMS Arduino:

temporature

id	timestamp	temp1	...	temp24

id is auto increment int as primary key, timestamp is the default timestamp when insert.

voltage

id	timestamp	voltage1	...	voltage28

Data from CAN Arduino:

motor

id	timestamp	current	rpm	temp

rpm round per minutes; temp temprature of motor, null now.

workCondition

id	timestamp	voltage	current	outputVoltage

voltage array of voltage, null now. current array of voltage, null now. outputVoltage motor output voltage.