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

The ThingSpeak community site has been upgraded to a new site. This site is currently in read-only mode. You can ask questions or post and read discussions on the new site.
Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —





— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
sp_RankInfo
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
Go to Top
1sp_Permalink sp_Print

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 29, 2014
sp_UserOfflineSmall Offline
Go to Top
2sp_Permalink sp_Print

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?

No permission to create posts
sp_Feed
Go to top
Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
22 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:

Advantagetreeexperts, laundrydaddyuk, techhhelp5, ken, tran, huldacormier

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457