import sys, string
import _mssql
import psycopg2

postdb = psycopg2.connect("dbname=Energydatabase user=edmon")
cur=conn.cursor()
mssql = _mssql.connect(server='10.131.90.67', user='sa', password='edmon' database='edmon')

def insert_into(date,water,warmwater,light outside,elektricity,Outsidetemp,insidetemp1,insidetemp2):
    cur.execute("""INSERT INTO measurements
    VALUES (%s,%s,%d,%s,%s,%s,%s,%s)""", (date,water,warmwater,light outside,elektricity,Outsidetemp,insidetemp1,insidetemp2))

def get_last_five():
    mssql.execute_row("""SELECT TOP 5 * FROM Mittaukset
    ORDER BY [Date and time] DESC""")

get_last_five()
for row in mssql:
    insert_into(row['Date and time'],row['Vesimäärä'],row['Lämpömäärä'],row['Valoisuus ulkona'],row['Sähkömäärä'],row['Ulkoilma'],row['Ruokasali huonelämpötila'],row['h 202 hounelämpötila'])

mssql.close()
postdb.commit()
cur.close()
postdb.close()