server.py

import discord, requests, datetime, os, camelot, asyncio, json
from bs4 import *

days = ['lunedi', 'martedi', 'mercoledi', 'giovedi', 'venerdi', 'sabato', 'domenica']
month_names = {
    1: "gennaio", 2: "febbraio", 3: "marzo", 4: "aprile", 5: "maggio", 6: "giugno",
    7: "luglio", 8: "agosto", 9: "settembre", 10: "ottobre", 11: "novembre", 12: "dicembre"
}

class server:
    @staticmethod
    def get_url(day_number: int) -> str:
        html = requests.get("https://www.ispascalcomandini.it/variazioni-orario-istituto-tecnico-tecnologico/2017/09/15/")
        soup = BeautifulSoup(html.text, 'html.parser')
        for tag in soup.find_all('a'):
            if 'variazioni' in tag.text and str(day_number) in tag.text:
                return tag['href']
        
    @staticmethod 
    def make_output_row(class_identifier: str, hour: int | None, absent_professor: str, substitute: str, note: str) -> object:
        return {
            'class':class_identifier,
            'hour': hour,
            'absent_professor': absent_professor,
            'substitute': substitute,
            'note': note
        }
    
    @staticmethod
    def delete_pdf():
        date = datetime.datetime.today() + datetime.timedelta(days=1)
        day_number = date.day
        month = month_names[date.month]
        
        if os.path.exists(f'./{month}-{day_number}.pdf'):
            os.remove(f'./{month}-{day_number}.pdf')
        
    def __init__(self, guild_id: discord.Guild.id, channel: discord.channel, class_identifier: str) -> None:
        self.guild_id = guild_id
        self.channel = channel
        self.class_identifier = class_identifier
    
    def delete_json(self):
        date = datetime.datetime.today()
        day_number = date.day
        month = month_names[date.month]

        if os.path.exists(f'./{month}-{day_number}-{self.class_identifier}-{self.guild_id}.json'):
            os.remove(f'./{month}-{day_number}-{self.class_identifier}-{self.guild_id}.json')
    
    async def send_variation(self, variation: object, deleted=False):
        color = 0x1dcf4c if deleted is False else 0xed1515
        embed = embed = discord.Embed(title=f"{variation['class']} - Variazione", color=0x1dcf4c)
        embed.add_field(name=f"{variation['hour']} ora - Docente assente: ", value=f"{variation['absent_professor']} -> {variation['substitute']}", inline=False)
        embed.add_field(name="Note: ", value=variation['note'], inline=False)
        embed.set_footer(text="---------------------------------------------------------------------------------")
        
        await self.channel.send(embed=embed)

    async def update(self):
        date = datetime.datetime.today() + datetime.timedelta(days=1)
        day_of_week = days[date.weekday()]
        day_number = date.day
        month = month_names[date.month]
        
        if day_of_week == days[6]: return
        
        pdf_path = f'./{month}-{day_number}.pdf'
        json_path= f'./{month}-{day_number}-{self.class_identifier}-{self.guild_id}.json'
        
        if not os.path.exists(pdf_path):
            response = requests.get(self.get_url(day_number=day_number))
            
            open(pdf_path, 'wb').write(response.content)
                
        output = []

        tables = camelot.read_pdf(pdf_path)
        for table in tables:
            rows = table.df.values.tolist()
            rows.pop(0) #removing how to read the data in the spreadsheet
            
            data = [row[0].split("\n") for row in rows]
            
            for row in data:
                if row[0] == self.class_identifier:
                    try:
                        output.append(self.make_output_row(self.class_identifier, int(row[1]), row[2], row[3], row[-2]))
                    except: pass
        
        deleted_variations = []
        
        if not os.path.exists(json_path):
            with open(json_path, 'w') as file:
                for variation in output:
                    file.write(json.dumps(variation))
        else:
            old_output = [json.loads(variation) for variation in open(json_path, 'r').readlines()]

            for variation in old_output:
                if variation in output: 
                    output.remove(variation)
                else:
                    deleted_variations.append(variation)
                    old_output.remove(variation)
        
        for variation in deleted_variations:
            await self.send_variation(variation=variation, deleted=True)
        
        with open(json_path, 'a') as file:
            for variation in output:
                #if variation['absent_professor'] == '-': variation['absent_professor'] = 'Nessun sostituto'
                await self.send_variation(variation=variation)
                file.write(json.dumps(variation) + "\n")