Advertisement
Guest User

Untitled

a guest
Feb 24th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. connect = psycopg2.connect("host='10.10.10.10' port='8080' user='XXX' dbname='service' password='********'")
  2. baza = connect.cursor()
  3. baza.execute("SELECT camera FROM camers_list WHERE type = 1 AND (place_full LIKE '%ПАРАМЕТР%' OR place_full LIKE '%ПАРАМЕТР%') AND dateto = (select max(dateto) from camers_list)")
  4. mkad = baza.fetchall()
  5. baza.execute("SELECT camera,dist72 FROM camers_list WHERE type = 1 AND dateto = (SELECT MAX(dateto) FROM camers_list) AND dist72 != -1 ORDER BY dist72")
  6. camers = baza.fetchall()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement