Untitled

import sqlite3
import os
import zeep
import secrets
import json
import time
from loguru import logger

# %% Connect to IntegrationService
credentials = ("школа", "Parsec", "12345")
client = zeep.Client("http://172.16.16.5:10101/IntegrationService/IntegrationService.asmx?WSDL")
# print(client.service.GetVersion())
session = client.service.OpenSession(*credentials)
sessionId = session.Value.SessionID

base = sqlite3.connect('baza.db', check_same_thread=True)
cur = base.cursor()
base.execute('CREATE TABLE IF NOT EXISTS data(last_name,first_name,middle_name,id PRIMARY KEY,id_parents)')
base.commit()

clear = lambda: os.system('cls')

red = "\u001b[31;1m"
gr = "\u001b[32m"
ye = "\u001b[33;1m"

guests = []




def count():
    global guests
    if len(guests) > 10:
        guests.pop(-1)
    # for i in guests:
    #     print(guests[i])
    return guests


while True:
    data = (client.service.GetHardwareEventsResolved(sessionId, 0))

    for i in range(len(data)):
        data2 = (data[i])
        data3 = json.loads(data2)
        if data3['User']['Raw'] == "00000000-0000-0000-0000-000000000000":
            continue

        if data3['User']['Resolved']:
            data4 = (data3['Date'], data3['User']['Resolved'], data3['Component']['Resolved'], data3['User']['Raw'])
            guests.append(data4)
            guests.insert(0, data4)
            count()
        
    print()
    print()
    for i in range(25):
        guests2 = (guests[i])
        logger.info(f'{gr}{guests2[0]} {red}{guests2[1]} {gr}{guests2[2]}')
        # print(guests2[0],guests2[1],guests2[2])
    time.sleep(5)
    clear()

# data2 = (data[41])
# data3 = json.loads(data2)
# print(data3['Date'], "|", data3['User']['Resolved'], "|", data3['Component']['Resolved'], "|", data3['User']['Raw'])
# ba = cur.execute('SELECT * FROM data WHERE id == ?', (data3['User']['Raw'],)).fetchall()
# print(ba)
# for i in range(len(data)):
#     data2 = (data[i])
#     data3 = json.loads(data2)
#     if data3['User']['Resolved']:
#         if (data3['Component']['Raw'] == "7d41863e-1836-4319-9439-7fca7dae24f7" or
#                 data3['Component']['Raw'] == "6f5a2a3e-e802-4048-90de-fd6829b7f177" or
#                 data3['Component']['Raw'] == "c2b73d4f-c793-4dc4-b2e5-e6ffe506edc1" or
#                 data3['Component']['Raw'] == "955cf25f-8119-4a75-a6f7-2317ac868faa"):
#             # print(data3['Date'], "|", data3['User']['Resolved'], "|", data3['Component']['Resolved'], "|", data3['User']['Raw'])
#             print(data3['Date'], "|", data3['User']['Resolved'], "|", data3['Component']['Resolved'])
#             # print(data3['Date'], "|", data3['Component']['Raw'], "|", data3['Component']['Resolved'])
#     else:
#         continue


# data2=(data[-1])
# # print(data2)
# data3 = json.loads(data2)
# print(data3['Date'],"|",data3['Component']['Resolved'],"|",data3['User']['Resolved'],"|",data3['User']['Raw'])