from . import (
    sql01 as ex01,
    sql02 as ex02,
    sql03 as ex03,
    sql04 as ex04,
    sql05 as ex05,
    sql06 as ex06,
    sql07 as ex07,
)
from common.common import (
    user_input,
    run_func,
    print_run_func,
    opcs_default,
    clear
)

tab = '   '

def challenges():
    select_ok = False
    while not select_ok:
        clear()
        print(tab, '1)', ex01.sql_01.__doc__)
        print(tab, '2)', ex02.sql_02.__doc__)
        print(tab, '3)', ex03.sql_03.__doc__)
        print(tab, '4)', ex04.sql_04.__doc__)
        print(tab, '5)', ex05.sql_05.__doc__)
        print(tab, '6)', ex06.sql_06.__doc__)
        print(tab, '7)', ex07.sql_07.__doc__)
        opcs_default(1)
        selection = user_input(9)
        match selection:
            case 1:
                run_func(ex01.sql_01)
            case 2:
                run_func(ex02.sql_02)
            case 3:
                run_func(ex03.sql_03)
            case 4:
                run_func(ex04.sql_04)
            case 5:
                run_func(ex05.sql_05)
            case 6:
                run_func(ex06.sql_06)
            case 7:
                print_run_func(ex07.sql_07)
            case 'v':
                return
            case 's':
                select_ok = True
                exit(0)
            case _:
                continue