Python Forum
Two Raspberry pi (Different location ) to SQL database
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Two Raspberry pi (Different location ) to SQL database
#1
Dear All,
I am working on the project with a raspberry pi and SQL server. Currently, I have connected 2 Ardunio to 1 raspberry pi data uploaded to the SQL database via LAN. The current setup is working fine.
But now I want to add one more raspberry pi from Remote location (Different City) and add the data to the same SQL server to process further.

Please refer attached picture.
[python[Image: tPmcjK4]

Please, someone, guide me to connect different raspberry pi from a different location.

Current Python Code

]import pymysql
import datetime
import serial
import time

ser=serial.Serial("/dev/ttyACM1",9600)
ser.baudrate=9600
ser1=serial.Serial("/dev/ttyUSB0",9600)
ser1.baudrate=9600

serialmessage = str(ser.readline())
serialmessage1 = str(ser1.readline())
temp = str(serialmessage1[2:4])
data = str(serialmessage)
data2 = len(serialmessage)
timestamp = str(datetime.datetime.now())

if data2 == 15:#4.00 digit number
data = str(serialmessage[3:10] + " kg/m3")

elif data2 == 14:#3.00 digit number
data = str(serialmessage[3:9] + " kg/m3")

elif data2 == 13:#2.00 digit number
data = str(serialmessage[3:8] + " kg/m3")

elif data2 == 12:#1.00 digit number
data = str(serialmessage[3:7] + " kg/m3")

elif data2 == 11:#0.00 digit number
data = str(serialmessage[3:6] + " kg/m3")

list1 = [temp,data,timestamp]

con = pymysql.connect(host='localhost',user='root',passwd='1234',db='Density_Meter')

mycursor = con.cursor()

sql = "INSERT INTO table1(temperature,Density,Timestamp) VALUES %r;" % (tuple(list1),)
mycursor.execute(sql)

con.commit()
con.close()
[/python]
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020