import sys, psycopg2
import datetime
from _datetime import timedelta

host="db.intern.mi.hs-rm.de"
port="5432"
database="abopp001"
user="abopp001"
password="nh2402"

try:
    cnx = psycopg2.connect(user=user, password=password, database=database, host=host, port=port)
    print ("Postgres Login erfolgreich!")
except psycopg2.Error as msg:
    print ("Verbindungsfehler: " , msg)
    sys.exit()


st = cnx.cursor()
st.execute("SELECT * FROM Event WHERE V_K_Name = 'Konfirmation'")
for r in st.fetchall():
    print(r[1])
    end_date = r[1] + timedelta(days = 14)
    print(end_date)


cnx.commit()
st.close()
cnx.close()