# ========================================================================
# User ID API Endpoint
#

from fastapi import APIRouter
from api.core.EasyMessage import API_BaseRequest
from api.core.EasyMessage import API_BaseResponse
from api.core.EasySQL import EasySQL
from api.core.EasyUser import EasyUser

from api.core.EasyCrypt import generate_password_hash
from api.core.EasyCrypt import check_password_hash
from api.core.EasyCrypt import generate_session_token

import json

print("GET ALL SKILLS API ENDPOINT")

router = APIRouter()
sql_connection = EasySQL()
user = EasyUser()

class API_Request(API_BaseRequest):
    pass

class API_Response(API_BaseResponse):
    skills: str = ""

@router.post("/skills/get_all_skills", tags=['skills'])
def get_all_skills(request: API_Request):

    api_response = API_Response()

    sql_connection.db_init()
    sql_connection.db_connect()
    rows = sql_connection.select('skills')

    api_response.success = True
    api_response.status_code = 200
    api_response.reason = ""
    api_response.skills = json.dumps(rows)

    return api_response