def muestreo(aux_lat,aux_lon,aux_alt,muestras,tiempo):
n=muestras
LAT=aux_lat
LON=aux_lon
ALT=aux_alt
while n>0:
temp=sensor_temperatura.read_temp()[0]
print ("Midiendo Temperatura: ")
print (temp)
reading_time = time.ctime(time.time())
print ("Midiendo OPR: ")
OPR= i2c.leerSensores("R","OPR")
print (OPR)
print ("Midiendo DO: ")
DO= i2c.leerSensores("R","DO")
print (DO)
print ("Midiendo PH: ")
PH= i2c.leerSensores("R","PH")
print (PH)
print ("Midiendo CE: ")
CEt= i2c.leerSensores("R","CE")
print (CEt)
print ("DATOS RECOLECTADOS : ")
ce= CEt.split(",")
CE=ce[0]
TDS= ce[1]
S= ce[2]
SEN= {"Lat":LAT, "Lon":LON, "Alt":ALT ,"Temp":temp,"DO":DO,"OPR":OPR,"PH":PH, "CE":CE,"TDS": TDS, "S": S}
print (SEN)
lect=(LAT,LON,ALT,temp,PH,DO,CE,TDS,S,OPR)
# client.publish("sonda/raspberry/ph", PH)
# client.publish("sonda/raspberry/temp", temp)
# client.publish("sonda/raspberry/do", DO)
# client.publish("sonda/raspberry/opr", OPR)
# client.publish("sonda/raspberry/ce", CE)
# client.publish("sonda/raspberry/tds", TDS)
# client.publish("sonda/raspberry/s", S)
## Almacenamiento en BD
#sql_insert(conn,lect)
print("Carga Exitosa, timepo de espera: " + str(tiempo) +" [s]. ")
time.sleep(tiempo)
#print ("[lat long]" + str(aux_lat) + str(aux_lon))
print ("Muestro " + str(muestras-n+1 ) +" de "+ str(muestras))
auxMuestra=False
client.publish("sonda/muestro/fin", True)
n -=1
#client.publish("sonda/sensores",json.dumps({"pos": {"lat": 1, "lon": 1, "alt": 1},"temp": temp, "ph": PH,"do": DO,"opr": OPR,"ce": CE,"tds": TDS,"s": S}))
ourClient.publish("sonda/sensores",json.dumps({"lat": int(float(LAT)),"lon": int(float(LON)),"alt": int(float(ALT)),"temp": int(temp),"ph": int(float(PH)),"do": int(float(DO)),"opr": int(float(OPR)),"ce": int(float(CE)),"tds": int(float(TDS)), "s": int(float(S)), "cont":cont1}))
def muestreo(n,tiempo):
while n>1:
temp=sensor_temperatura.read_temp()[0]
print ("Midiendo Temperatura: ")
print (temp)
reading_time = time.ctime(time.time())
print ("Midiendo OPR: ")
OPR= i2c.leerSensores("R","OPR")
print (OPR)
print ("Midiendo DO: ")
DO= i2c.leerSensores("R","DO")
print (DO)
print ("Midiendo PH: ")
PH= i2c.leerSensores("R","PH")
print (PH)
print ("Midiendo CE: ")
CEt= i2c.leerSensores("R","CE")
print (CEt)
print ("DATOS RECOLECTADOS : ")
ce= CEt.split(",")
CE=ce[0]
TDS= ce[1]
S= ce[2]
SEN= {"Temp":temp,"DO":DO,"OPR":OPR,"PH":PH, "CE":CE,"TDS": TDS, "S": S}
print (SEN)
lect=(temp,PH,DO,CE,TDS,S,OPR)
mqttConf.ourClient.publish("sonda/raspberry/ph", PH)
mqttConf.ourClient.publish("sonda/raspberry/temp", temp)
mqttConf.ourClient.publish("sonda/raspberry/do", DO)
mqttConf.ourClient.publish("sonda/raspberry/opr", OPR)
mqttConf.ourClient.publish("sonda/raspberry/ce", CE)
mqttConf.ourClient.publish("sonda/raspberry/tds", TDS)
mqttConf.ourClient.publish("sonda/raspberry/s", S)
## Almacenamiento en BD
# sql_insert(conn,lect)
print("Carga Exitosa, timepo de espera: " + str(tiempo) +" [s]. ")
time.sleep(tiempo)
n -=1
def sensorsRead():
temp=0.0
PH=0.0
DO=0.0
CE=0.0
TDS=0.0
S=0.0
OPR=0.0
sensor = i2c.AtlasI2C()
##Lectura de Sensores i2c
i2cAdd=sensor.list_i2c_devices()
print(i2cAdd)
temp=sensor_temperatura.read_temp()[0]
print ("Temperatura Medido Correctamente: " + str(temp))
for x in range(0,len(i2cAdd)):
mesure=sensor.leerSensores("R",dir.get(i2cAdd[x]))
print (dir.get(i2cAdd[x])+ " Medido Correctamente: " + mesure)
if (dir.get(i2cAdd[x])== "PH"):
PH=mesure
elif(dir.get(i2cAdd[x])== "DO"):
DO=mesure
elif(dir.get(i2cAdd[x])== "CE"):
CET=mesure
ce = CET.split(",")
CE = ce[0]
TDS= ce[1]
S = ce[2]
elif(dir.get(i2cAdd[x])== "OPR"):
OPR=mesure
else:
pass
sensor.apagarSensor(dir.get(i2cAdd[x]))
lect=(temp,PH,DO,CE,TDS,S,OPR)
SEN= {"Temp":temp,"DO":DO,"OPR":OPR,"PH":PH, "CE":CE,"TDS": TDS, "S": S}
print ("Lectura Corecta de "+ str(len(i2cAdd)) + " Sensores " )
print (SEN)
return lect
def sql_insert(conn, lecturas):
cur = conn.cursor()
cur.execute(
"INSERT INTO lecturas(datatime,Tempertatura,pH,DO,CE,TDS,S,OPR) VALUES(datetime('now','localtime'),?,?,?,?,?,?,?)",
lecturas)
conn.commit()
conn = sql_connection()
##sql_table(conn)
c = conn.cursor()
##Lectura de Sensores
while True:
temp = sensor_temperatura.read_temp()[0]
print("Midiendo Temperatura: ")
print(temp)
reading_time = time.ctime(time.time())
print("Midiendo OPR: ")
OPR = i2c.leerSensores("R", "OPR")
print(OPR)
print("Midiendo DO: ")
DO = i2c.leerSensores("R", "DO")
print(DO)
print("Midiendo PH: ")
PH = i2c.leerSensores("R", "PH")
print(PH)
print("Midiendo CE: ")
CEt = i2c.leerSensores("R", "CE")
print(CEt)