from typing import List
# pyrefly: ignore [missing-import]
from fastapi import FastAPI
# pyrefly: ignore [missing-import]
from pydantic import BaseModel

from app.storage.mkt_day_end import (
    get_mkt_day_end_data_from_sqlite,
    post_mkt_day_end_data_to_sqlite,
)
from app.storage.mkt_security import post_mkt_security_to_sqlite, get_mkt_security_from_sqlite
from app.calculations.lvarCal import lvrCal
from app.database import projectState_delete, projectState_init, rename_security_code_in_all_tables
from app.helper import get_last_entry_from_sqlite

app = FastAPI()


# Pydantic model for the incoming data structure
class projectDataInit(BaseModel):
    status: int
    message: str
    data: List[
        dict
    ]  # List of dictionaries, can be customized further if structure is known


class syncData(BaseModel):
    status: int
    message: str
    mde: List[
        dict
    ]
    msi: List[
        dict
    ]
    csh: List[
        dict
    ]


@app.get("/")
def read_root():
    return {"message": "Hello World"}


@app.get("/get-last-entry")
def get_last_entry():
    result = get_last_entry_from_sqlite()
    return result


@app.post("/get-lvar-data")
def get_lvar_data(payload: syncData):
    result_mde = post_mkt_day_end_data_to_sqlite(payload.mde)
    result_msi = post_mkt_security_to_sqlite(payload.msi)

    if result_mde["status"] == 200 and result_msi["status"] == 200:
        result_lvrCal = lvrCal(payload.csh)
        if result_lvrCal["status"] == 200:
            return {
                "status": 200,
                "message": "Data stored and LVR calculated successfully",
                "data": result_lvrCal,
            }
        else:
            return {
                "status": 500,
                "message": "LVR calculation failed",
            }
    else:
        return {
            "status": 500,
            "message": "Data stored failed",
            "mde": result_mde,
            "msi": result_msi,
        }


@app.get("/get-mkt-day-end-data/filter={filter_type}/{filter_value}")
def get_mkt_day_end_data(filter_type: str, filter_value: str):
    result = get_mkt_day_end_data_from_sqlite(filter_type, filter_value)

    reply_data = {
        "status": 200,
        "message": "Market day-end data retrieved successfully",
        "records_count": len(result),
        "data": result,
    }
    return reply_data


@app.get("/get-mkt-security-data")
def get_mkt_security_data():
    result = get_mkt_security_from_sqlite()
    reply_data = {
        "status": 200,
        "message": "Market security data retrieved successfully",
        "records_count": len(result),
        "data": result,
    }
    return reply_data


# project state related functions
# initialize the project state
@app.post("/project_init/{project_name}/{password}")
def project_init(project_name: str, password: str):
    if project_name == "rt01" and password == "123456":
        result = projectState_init()
        if result:
            return {
                "message": "Project initialized successfully",
                "project_name": project_name,
            }
        else:
            return {
                "message": "Project initialization failed",
                "project_name": project_name,
            }
    else:
        return {"message": "Project not found or invalid credentials"}


# delete the project state
@app.post("/project_delete/{project_name}/{password}")
def project_delete(project_name: str, password: str):
    if project_name == "rt01" and password == "123456":
        result = projectState_delete()
        if result:
            return {
                "message": "Project deleted successfully",
                "project_name": project_name,
            }
        else:
            return {
                "message": "Project deletion failed",
                "project_name": project_name,
            }
    else:
        return {"message": "Project not found or invalid credentials"}


@app.post("/project_data_init_mde")
def project_data_init(payload: projectDataInit):
    result = post_mkt_day_end_data_to_sqlite(payload.data)
    if result["status"] == 200:
        return {
            "message": "Project data initialized successfully",
            "data_count": result["data_count"],
        }
    else:
        return {
            "message": "Project data initialization failed",
            "data_count": result,
        }


@app.post("/project_data_init_msi")
def project_data_init_msi(payload: projectDataInit):
    result = post_mkt_security_to_sqlite(payload.data)
    if result["status"] == 200:
        return {
            "message": "Project security data initialized successfully",
            "data_count": result["data_count"],
        }
    else:
        return {
            "message": "Project security data initialization failed",
            "data_count": result,
        }


# Rename a security_code across all SQLite tables
@app.put("/rename-security-code/{old_code}/{new_code}")
def rename_security_code(old_code: str, new_code: str):
    """
    Rename *old_code* to *new_code* in every table that references security_code
    (mktSecurityInfo and mktDayEndData) inside a single atomic transaction.

    Example:
        PUT /rename-security-code/BATBC/BATBC_NEW
    """
    if not old_code or not new_code:
        return {"status": 400, "message": "Both old_code and new_code are required"}
    if old_code == new_code:
        return {"status": 400, "message": "old_code and new_code must be different"}

    result = rename_security_code_in_all_tables(old_code, new_code)
    return result

