import mariadb
import logging
import sys

logger = logging.getLogger('tle_fetcher.' + __name__)

class TleDatabase: 

    def __init__(self):
        self.conn = None

    def connect_db(self):

        # Connect to MariaDB
        try:
            conn = mariadb.connect(
                user='tle_getter',
                host='localhost',
                port=3306,
                database='celestrak_tles'
            )
        except mariadb.Error as e:
            logger.error("Error connecting to MariaDB Platform: %s", e.msg)
            sys.exit(1)

        self.conn = conn

    def delete_rows(self):
        cur = self.conn.cursor()

        try:
            cur.execute('delete from sat_groups')
            cur.execute('delete from tles')     
        except mariadb.Error as e: 
            logger.error("Error clearing tables: %s", e.msg)
        self.conn.commit()

    def update_tles(self, tles: dict):
        cur = self.conn.cursor()

        try: 
            cur.executemany('INSERT INTO tles (sat, tle) values (?,?)', list(tles.items()))
        except mariadb.Error as e: 
            logger.error("Error updating TLEs: %s", e.msg)
        self.conn.commit() 

    def update_sat_group(self, group: list):
        cur = self.conn.cursor()

        try:    
            cur.executemany('INSERT INTO sat_groups (sat, group_name) values (?,?)', group)
        except mariadb.Error as e: 
            logger.error("Error updating groups: %s", e.msg)
        self.conn.commit()

    def close_db(self):
        self.conn.close()