Guest User

Untitled

a guest
Apr 5th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. outcoming = [445557378, 54667402, 11365645, 52258043, 332914832, 357652627, 276344229, 170537256, 480499887, 226384949, 81816373, 230656439, 164630458, 178836923, 310206267, 155180221, 264821829, 2146377, 170161869, 91485777, 64653010, 229433813, 277918294, 436511322, 63895647, 171503843, 56553574, 429354732, 61759727, 122231536, 442422643, 426659704, 317070969, 52351738, 192707195, 24703613]
  2.  
  3. import mysql.connector
  4.  
  5. database = mysql.connector.connect(user=settings.db_login, password=settings.db_password,
  6. host=settings.dp_ip, database=settings.db_name, use_unicode=True,
  7. charset='utf8', collation='utf8_general_ci', autocommit=True)
  8. cursor = database.cursor()
  9. cursor.execute("""DELETE from list_of_tables WHERE user_id = (%s)""", (outcoming))
  10.  
  11. for user_id in outcoming:
  12. cursor.execute("""DELETE from list_of_users WHERE user_id = (%s)""", (user_id))
  13.  
  14. for id in outcoming:
  15. cursor.execute("""DELETE from list_of_tables WHERE user_id = (%s)""", (id))
Add Comment
Please, Sign In to add comment