Guest User

Untitled

a guest
Dec 17th, 2017
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. import psycopg2
  2.  
  3. conn = psycopg2.connect(
  4. "dbname=gpx user=postgres password=postgres host=localhost")
  5.  
  6. cur = conn.cursor()
  7. cur.execute(
  8. "CREATE TABLE gpx (object_name VARCHAR(50) NOT NULL PRIMARY KEY, object_value xml);")
  9.  
  10. with open("bla.gpx", 'r') as gpxfile:
  11. data = gpxfile.read()
  12. cur.execute('INSERT INTO gpx (object_name, object_value) VALUES (%(filename)s, %(xmlstring)s)',
  13. {'filename': filename, 'xmlstring': data})
  14.  
  15. conn.commit()
Add Comment
Please, Sign In to add comment