dbo.gestor_prompt_scope

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.gestor_prompt_scope
    @accion VARCHAR(20),
    @aiPromptScopeID INT = NULL,
    @scope_name VARCHAR(100) = NULL,
    @scope_description VARCHAR(250) = NULL,
    @user_id VARCHAR(100) = NULL,
    @active bit = NULL

AS
BEGIN

    SET @accion= upper(@accion)

    IF(@accion = 'INSERT_PROMPT_SCOPE')
    BEGIN
        INSERT INTO ai_prompts_scope(
            scope_name,
            scope_description,
            created_by
        )VALUES(
            @scope_name,
            @scope_description,
            @user_id
        )
    END

    IF (@accion = 'EDIT_PROMPT_SCOPE')
    BEGIN
        UPDATE 
            ai_prompts_scope 
        SET 
            scope_name = @scope_name, 
            scope_description = @scope_description, 
            created_by = @user_id,
            active = @active        
        WHERE 
            aiPromptScopeID = @aiPromptScopeID
    END

    IF(@accion = 'ALL_PROMPT_SCOPE')
    BEGIN
        SELECT
            scope_name,
            scope_description,
            created_by,
            aiPromptScopeID,
            active
        FROM
            ai_prompts_scope
    END
END
GO