Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- connect = psycopg2.connect("host='10.10.10.10' port='8080' user='XXX' dbname='service' password='********'")
- baza = connect.cursor()
- 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)")
- mkad = baza.fetchall()
- 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")
- camers = baza.fetchall()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement