from sqlalchemy.orm import Session
from db_classes import *
from sqlalchemy import create_engine
from initial_data import CONSOLE_DATA, LANGUAGES
#db pass MumMTK3bwjYJRfe

def create_db():
    engine = create_engine('mariadb+mariadbconnector://videogamedb:MumMTK3bwjYJRfe@simailadjalim.fr/videogamedb')
    Base.metadata.drop_all(engine)
    Base.metadata.create_all(engine)
    session = Session(engine)
    consoles = []
    rom_file_extensions = {}
    languages = []
    for console_name, console_data in CONSOLE_DATA.items():
        console = Console(console_name,console_data["console_core"] ,console_data["playable"], [])
        consoles.append(console)
        for extension in console_data["extensions"]:
            if extension not in rom_file_extensions:
                rom_file_extensions[extension] = RomFileExtensions(extension, [])
            rom_file_extensions[extension].consoles.append(console)

    for language_name, language_data in LANGUAGES.items():
        language = Language(language_name, [])
        languages.append(language)

    session.add_all(consoles)
    session.add_all(rom_file_extensions.values())
    session.add_all(languages)
    session.commit()

create_db()