import sqlite3
import os

DB_PATH = os.path.join(os.path.dirname(__file__), 'logs.db')

def init_db():
    conn = sqlite3.connect(DB_PATH)
    c = conn.cursor()
    c.execute('''CREATE TABLE IF NOT EXISTS logs
                 (timestamp TEXT, hostname TEXT, ip_address TEXT, message TEXT)''')
    c.execute('''CREATE TABLE IF NOT EXISTS boards
                 (hostname TEXT PRIMARY KEY, ip_address TEXT, input1 TEXT, input2 TEXT, input3 TEXT, input4 TEXT, relay1 TEXT, relay2 TEXT, relay3 TEXT, relay4 TEXT)''')
    c.execute('''CREATE TABLE IF NOT EXISTS mir_server_missions
                 (ip TEXT, authorization TEXT, username TEXT, password TEXT, mission_id TEXT PRIMARY KEY)''')
    c.execute('''CREATE TABLE IF NOT EXISTS requested_missions
                 (state TEXT, start_time TEXT, mission TEXT, mission_name TEXT, robot_id INTEGER, id INTEGER PRIMARY KEY)''')
    c.execute('''CREATE TABLE IF NOT EXISTS robots
                 (ip TEXT PRIMARY KEY, url TEXT)''')
    conn.commit()

    # Insert a first row into the mir_server_missions table
    c.execute('''INSERT OR IGNORE INTO mir_server_missions (ip, authorization, username, password, mission_id)
                 VALUES (?, ?, ?, ?, ?)''',
              ("10.76.153.4", "Basic ZGlzdHJpYnV0b3I6Y2RjYjhiNjAzYzFhZDNjNjVkZTM4ZGY2OWU5YjFkM2ZhMDA2OWEwMDcyMzZkMDNkOGVhNjMyNDVhMDg3YjJkZA==", "distributor", "cdc8b603c1ad3c65de38df69e9b1d3fa0069a007236d03d8ea63245a087b2dd", "a1343edc-975c-11ef-87e6-0242ac120002"))
    conn.commit()
    conn.close()