GitHub - atleag/CTMS-MySQL: Arduino project to monitor temperature in a cabin and store the data to a MySql Database. This is currently just a token of history.

This repository was archived by the owner on Dec 28, 2022. It is now read-only.

atleag / CTMS-MySQL Public archive

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Arduino project to monitor temperature in a cabin and store the data to a MySql Database. This is currently just a token of history.

0 stars 0 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name	Name	Last commit date
Latest commit History 270 Commits
CTS	CTS
CTS_Application	CTS_Application
Properties	Properties
database	database
mysqlConnector	mysqlConnector
.gitattributes	.gitattributes
.gitignore	.gitignore
App.config	App.config
CTS.csproj	CTS.csproj
CTS.sln	CTS.sln
CodeMap1.dgml	CodeMap1.dgml
Form1.Designer.cs	Form1.Designer.cs
Form1.cs	Form1.cs
Program.cs	Program.cs	6D96
README.txt	README.txt

Repository files navigation

All programming done in Visual Studio Ultimate 2013
Database: Mysql
DBSM: HeidiSql
IMPORTANT: To develop you'll need to install the MySql connector provided in this repo

#The program:

The program is a school project where the intention is to monitor the temperature within
a cabin. All recordings are done by using an Arduino to transfer analog data to a computer.
The program will then trigger an alarm if the real_temp value is outside of the defined setpoints.
An alarm will be sent to a set of subscribers via email.
Every alarm, recording, subscriber info and settings are stored in a MYSQL database.


Gridview for alarms. Collums edited in GUI for gridview. Autosize and fill.


Changes:

Enabled AUTO_INCREMENT in MySQL Via HEidiSQL
Enabled auto-timestamp in Mysql via Heidisql

How To:
Add datasource to graph:
Add dataset
Add graph
Graph properties->Data->Datasource