Advertisement
Guest User

pipi

a guest
Jan 28th, 2019
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. import sys
  2. import psycopg2
  3.  
  4.  
  5.  
  6. host="db"
  7. port ="5432"
  8. database="jwirt001"
  9. user="jwirt001"
  10. password="abc"
  11.  
  12.  
  13. try:
  14. cnx = psycopg2.connect(user=user, password=password,
  15. database=database, host=host, port=port)
  16.  
  17. st = cnx.cursor()
  18. st.execute("UPDATE event SET datum = datum + 14")
  19. except psycopg2.Error("Eingabefehler"):
  20. print ("Verbindungsfehler")
  21. sys.exit()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement