Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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(type(end_date))
- print(end_date)
- st.execute("UPDATE Event SET Datum = '%s' WHERE V_K_Name = 'Konfirmation'" %(end_date))
- cnx.commit()
- st.close()
- cnx.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement