Guest User

Untitled

a guest
Jun 23rd, 2018
227
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. import pymysql
  2.  
  3. conn = pymysql.connect(host="******", user="******", password="******", db="******")
  4.  
  5. def test(table):
  6. print(f"SELECT * FROM {table} WHERE pid NOT IN (")
  7. pids = []
  8. with conn.cursor() as cur:
  9. cur.execute(f"SELECT pid FROM {table}")
  10. for r in cur:
  11. pids.append(r[0])
  12. cur.close()
  13.  
  14. error_count = 0
  15. for pid in pids:
  16. with conn.cursor() as cur:
  17. try:
  18. cur.execute(f"SELECT * FROM {table} WHERE pid = %s", (pid,))
  19. r = cur.fetchone()
  20. except:
  21. print(f"{pid},", end="")
  22. error_count += 1
  23. if error_count == 20:
  24. print()
  25. finally:
  26. cur.close()
  27.  
  28. print("-1);\n")
  29.  
  30. try:
  31. test("student_photos")
  32. finally:
  33. conn.close()
Add Comment
Please, Sign In to add comment