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)