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_fetcher',
                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: list):
        cur = self.conn.cursor()

        try:
            cur.executemany('insert into tles (sat, sat_cat_num, tle) values (?,?,?)', tles)
        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 ignore into sat_groups (sat_cat_num, 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()