// Generated by Qleany v1.5.1 from frontend_entity_commands.tera

//! Table entity commands
#![allow(unused_imports, dead_code)]

use crate::app_context::AppContext;
use anyhow::{Context, Result};
use common::direct_access::table::TableRelationshipField;
use common::types::EntityId;
use direct_access::TableRelationshipDto;
use direct_access::{CreateTableDto, TableDto, UpdateTableDto, table_controller};

/// Create a new table entity (orphan, no parent)
pub fn create_orphan_table(
    ctx: &AppContext,
    stack_id: Option<u64>,
    dto: &CreateTableDto,
) -> Result<TableDto> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::create_orphan(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        dto,
    )
    .context("creating table")
}
/// Create a new table entity as child of owner
pub fn create_table(
    ctx: &AppContext,
    stack_id: Option<u64>,
    dto: &CreateTableDto,
    owner_id: EntityId,
    index: i32,
) -> Result<TableDto> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::create(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        dto,
        owner_id,
        index,
    )
    .context("creating table")
}
/// Create multiple table entities (orphan, no parent)
pub fn create_orphan_table_multi(
    ctx: &AppContext,
    stack_id: Option<u64>,
    dtos: &[CreateTableDto],
) -> Result<Vec<TableDto>> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::create_orphan_multi(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        dtos,
    )
    .context("creating table entities")
}
/// Create multiple table entities as children of owner
pub fn create_table_multi(
    ctx: &AppContext,
    stack_id: Option<u64>,
    dtos: &[CreateTableDto],
    owner_id: EntityId,
    index: i32,
) -> Result<Vec<TableDto>> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::create_multi(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        dtos,
        owner_id,
        index,
    )
    .context("creating table entities")
}
/// Get a table entity by ID
pub fn get_table(ctx: &AppContext, id: &EntityId) -> Result<Option<TableDto>> {
    table_controller::get(&ctx.db_context, id).context("getting table")
}

/// Get multiple table entities by IDs
pub fn get_table_multi(ctx: &AppContext, ids: &[EntityId]) -> Result<Vec<Option<TableDto>>> {
    table_controller::get_multi(&ctx.db_context, ids).context("getting table entities")
}

/// Get all table entities.
/// Note: returns entities in database key order (by EntityId), not insertion order
/// or any user-defined sort. For ordered collections, use relationship-based
/// retrieval (e.g. get_*_relationship for ordered_one_to_many fields).
pub fn get_all_table(ctx: &AppContext) -> Result<Vec<TableDto>> {
    table_controller::get_all(&ctx.db_context).context("getting all table entities")
}

/// Update a table entity
pub fn update_table(
    ctx: &AppContext,
    stack_id: Option<u64>,
    dto: &UpdateTableDto,
) -> Result<TableDto> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::update(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        dto,
    )
    .context("updating table")
}

/// Update multiple table entities
pub fn update_table_multi(
    ctx: &AppContext,
    stack_id: Option<u64>,
    dtos: &[UpdateTableDto],
) -> Result<Vec<TableDto>> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::update_multi(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        dtos,
    )
    .context("updating table entities")
}

/// Update a table entity with relationships
pub fn update_table_with_relationships(
    ctx: &AppContext,
    stack_id: Option<u64>,
    dto: &TableDto,
) -> Result<TableDto> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::update_with_relationships(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        dto,
    )
    .context("updating table with relationships")
}

/// Update multiple table entities with relationships
pub fn update_table_with_relationships_multi(
    ctx: &AppContext,
    stack_id: Option<u64>,
    dtos: &[TableDto],
) -> Result<Vec<TableDto>> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::update_with_relationships_multi(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        dtos,
    )
    .context("updating table entities with relationships")
}

/// Remove a table entity by ID
pub fn remove_table(ctx: &AppContext, stack_id: Option<u64>, id: &EntityId) -> Result<()> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::remove(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        id,
    )
    .context("removing table")
}

/// Remove multiple table entities by IDs
pub fn remove_table_multi(ctx: &AppContext, stack_id: Option<u64>, ids: &[EntityId]) -> Result<()> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::remove_multi(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        ids,
    )
    .context("removing table entities")
}

/// Get a table relationship
pub fn get_table_relationship(
    ctx: &AppContext,
    id: &EntityId,
    field: &TableRelationshipField,
) -> Result<Vec<EntityId>> {
    table_controller::get_relationship(&ctx.db_context, id, field)
        .context("getting table relationship")
}

/// Get relationship IDs for multiple table entities at once
pub fn get_table_relationship_many(
    ctx: &AppContext,
    ids: &[EntityId],
    field: &TableRelationshipField,
) -> Result<std::collections::HashMap<EntityId, Vec<EntityId>>> {
    table_controller::get_relationship_many(&ctx.db_context, ids, field)
        .context("getting table relationships (many)")
}

/// Get relationship count for a table entity
pub fn get_table_relationship_count(
    ctx: &AppContext,
    id: &EntityId,
    field: &TableRelationshipField,
) -> Result<usize> {
    table_controller::get_relationship_count(&ctx.db_context, id, field)
        .context("getting table relationship count")
}

/// Get relationship IDs for a table entity with pagination
pub fn get_table_relationship_in_range(
    ctx: &AppContext,
    id: &EntityId,
    field: &TableRelationshipField,
    offset: usize,
    limit: usize,
) -> Result<Vec<EntityId>> {
    table_controller::get_relationship_in_range(&ctx.db_context, id, field, offset, limit)
        .context("getting table relationship range")
}

/// Set a table relationship
pub fn set_table_relationship(
    ctx: &AppContext,
    stack_id: Option<u64>,
    dto: &TableRelationshipDto,
) -> Result<()> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::set_relationship(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        dto,
    )
    .context("setting table relationship")
}

/// Move (reorder) IDs within a table relationship
pub fn move_table_relationship(
    ctx: &AppContext,
    stack_id: Option<u64>,
    id: &EntityId,
    field: &TableRelationshipField,
    ids_to_move: &[EntityId],
    new_index: i32,
) -> Result<Vec<EntityId>> {
    let mut undo_redo_manager = ctx.undo_redo_manager.lock().unwrap();
    table_controller::move_relationship(
        &ctx.db_context,
        &ctx.event_hub,
        &mut undo_redo_manager,
        stack_id,
        id,
        field,
        ids_to_move,
        new_index,
    )
    .context("moving table relationship")
}
