import requests
import json
import time
from config import bot
from message import found_base_msg
from keyboards import kb_found
from threading import Thread
import sqlite3 as sq


def parsing(num, url):
    prev_len = 190
    counter = num
    while counter <= 3600:
        print('go')
        r = requests.get(url)
        content = json.loads(r.text)
        real_len = len(content)
        print(real_len)
        time.sleep(1)
        if prev_len < real_len:
            diff_len = real_len - prev_len
            for i in range(1, diff_len + 1):
                i = -i
                print(i)
                element = content[i]
                point_x = element['x']
                point_z = element['z']
                word = element['dimension']
                if word == 'overworld':
                    conn = sq.connect('coords.db')
                    cur = conn.cursor()
                    cur.execute("""SELECT user_id FROM players_coords
                            WHERE x_1 <= (?)
                            AND x_2 >= (?)
                            AND z_1 <= (?)
                            AND z_2 >= (?)""", (point_x, point_x, point_z, point_z))
                    result = cur.fetchall()
                    for e in result:
                        id_u = e[0]
                        await bot.send_message(id_u, found_base_msg, reply_markup=kb_found)
                        conn.close()
            prev_len = real_len
            if counter < 3600:
                counter += 1
        elif counter == 3600:
            counter = 0
            print('sleep')
            time.sleep(300)
        else:
            counter += 1


thread_1 = Thread(target=parsing,
                  args=(0, 'https://www.2b2t.online/api/coords/v2'))