Scheduled send data to MySQL from Bluetooth Sensor and ThingSpeak (Raspberry Pi 3) | ThingSpeak Projects | Forum

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed sp_TopicIcon
Scheduled send data to MySQL from Bluetooth Sensor and ThingSpeak (Raspberry Pi 3)
No permission to create posts
February 27, 2018
11:06 pm
Avatar
rezaaryadi
New Member
Members
Forum Posts: 1
Member Since:
February 27, 2018
sp_UserOfflineSmall Offline

Hello, so in my project i will send command hcitool data scheduled every hour everyday depends on the schedule in MySQL table.

Example: Monday 10.00 - 13.00

Wednesday 15.00 - 17.00

Then my raspi will do hcitool command to capture bluetooth MAC address around it at monday 10, 12, 13 and wednesday 15, 16, 17.

 

The question is, do anyone know how to trigger it from MySQL? 

 

Best regards

March 2, 2018
5:37 am
Avatar
rw950431

Top
Members
Forum Posts: 279
Member Since:
January 30, 2014
sp_UserOfflineSmall Offline

Where is the MySQL table located?  Is MySQL running on your raspi or somewhere else?

If its running on the raspi then one solution is a cron job that runs every hour. This triggers a script that compares the current time to the list stored in the database and takes action when they match.

What is the structure of your table?  How are you going to represent the range of time and days?

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
14 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 272

Vinod: 240

piajola: 95

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 8665

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 14

Topics: 1600

Posts: 5760

Newest Members:

khanhNguyen_CT, susyburr, quijano__, meosuckhoe, briskpanda, Dejw0089

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457