# import mysql.connector
import psycopg2
from datetime import datetime as dt

conn = psycopg2.connect(host="localhost", port=5432, user="postgres",
                        password="raffito2015", dbname='cbba')

"""
mydb = mysql.connector.connect(
  host="10.5.0.29", user="root", passwd="raffito2015",
  database="prueba"
)
mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM probando ORDER BY id DESC LIMIT 1")

myresult = mycursor.fetchall()
"""

# mycursor.execute("SELECT * FROM probando")

# for x in myresult:
  # print(x)
# print(myresult[0])

momento = dt.now().strftime("%Y-%m-%d %H:%M:%S-03")
print(momento)

myresult = [(22.3, 40.2, 'vacio')]

sql = "INSERT INTO public.general_arduinoprueba(fecha, temp, hum, obs) VALUES ('{}', {}, {}, '{}');"
cursor = conn.cursor()
sql_exec = sql.format(momento, myresult[0][0], myresult[0][1], str(myresult[0][2]))
cursor.execute(sql_exec)
# print(sql_exec)
conn.commit()
cursor.close()
conn.close()