Advertisement
Guest User

Untitled

a guest
Sep 21st, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. # encoding=utf-8
  2. import datetime
  3. import multiprocessing
  4. import psycopg2
  5.  
  6. def exe(cmd):
  7. conn = psycopg2.connect("dbname = test user = pj password = dbrgdbrg")
  8. cur = conn.cursor()
  9. try:
  10. sql = "SELECT id FROM test WHERE ST_MAKEENVELOPE(118,38,119,39,4326) && wkb_geometry;"
  11. cur.execute(sql)
  12. print cur.fetchone()
  13. except Exception, e:
  14. print e
  15.  
  16. if __name__ == "__main__":
  17. cmds=range(5)
  18. for cmd in cmds:
  19. p = multiprocessing.Process(target=exe,args=(cmd,))
  20. p.start()
  21. p.join()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement