Guest User

Untitled

a guest
Dec 5th, 2020
37
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.50 KB | None | 0 0
  1.  
  2. async def parsing(num, url):
  3.     prev_len = 190
  4.     counter = num
  5.     while counter <= 3600:
  6.         print('go')
  7.         r = requests.get(url)
  8.         content = json.loads(r.text)
  9.         real_len = len(content)
  10.         print(real_len)
  11.         time.sleep(1)
  12.         if prev_len < real_len:
  13.             diff_len = real_len - prev_len
  14.             for i in range(1, diff_len + 1):
  15.                 i = -i
  16.                 print(i)
  17.                 element = content[i]
  18.                 point_x = element['x']
  19.                 point_z = element['z']
  20.                 word = element['dimension']
  21.                 if word == 'overworld':
  22.                     conn = sq.connect('coords.db')
  23.                     cur = conn.cursor()
  24.                     cur.execute("""SELECT user_id FROM players_coords
  25.                            WHERE x_1 <= (?)
  26.                            AND x_2 >= (?)
  27.                            AND z_1 <= (?)
  28.                            AND z_2 >= (?)""", (point_x, point_x, point_z, point_z))
  29.                     result = cur.fetchall()
  30.                     for e in result:
  31.                         id_u = e[0]
  32.                         await bot.send_message(id_u, found_base_msg, reply_markup=kb_found)
  33.                         conn.close()
  34.             prev_len = real_len
  35.             if counter < 3600:
  36.                 counter += 1
  37.         elif counter == 3600:
  38.             counter = 0
  39.             print('sleep')
  40.             time.sleep(300)
  41.         else:
  42.             counter += 1
  43.  
Advertisement
Add Comment
Please, Sign In to add comment