Advertisement
WupEly

Untitled

Nov 21st, 2022
23
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. import sqlite3
  2.  
  3.  
  4. def sort_fst(n):
  5. return n[0]
  6.  
  7.  
  8. name = input()
  9. rules = input()
  10. coords = []
  11.  
  12. conn = sqlite3.connect(name)
  13.  
  14. cursor = conn.cursor()
  15.  
  16. request = f"SELECT latitude, longitude FROM Island WHERE NOT ({rules})"
  17.  
  18. for row in cursor.execute(request):
  19. coords.append(row)
  20.  
  21. conn.close()
  22.  
  23. coords.sort(key=sort_fst)
  24.  
  25. for coord in coords:
  26. print(coord)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement