50 lines
2.2 KiB
JavaScript
50 lines
2.2 KiB
JavaScript
import { z } from "zod";
|
|
import { withAuth } from "../../auth/index.js";
|
|
import { withAuthParams } from "../helpers/authSchema.js";
|
|
import { handleToolError } from "../helpers/errorHandler.js";
|
|
import { callSchemaEndpoint } from "./_schemaEndpoint.js";
|
|
|
|
// Tool: delete_table
|
|
// Borra el schema (ini.php) de una tabla. Si dropData=true tambien hace DROP TABLE
|
|
// en MySQL — destruye los datos de forma IRREVERSIBLE. Si la tabla tiene registros
|
|
// y dropData=false el backend devuelve error con recordCount (intencional: no se
|
|
// debe borrar el schema dejando datos huerfanos en MySQL sin confirmacion explicita).
|
|
|
|
export function registerDeleteTableTool(server) {
|
|
server.tool(
|
|
"delete_table",
|
|
`Delete a table from the project. IRREVERSIBLE when dropData=true.
|
|
|
|
Behaviour:
|
|
- dropData=false (default): deletes the schema (.ini.php). If the MySQL table
|
|
has records, the backend refuses and returns recordCount so you can warn
|
|
the user.
|
|
- dropData=true: DROP TABLE in MySQL + delete schema. Data is permanently
|
|
destroyed.
|
|
- dryRun=true: does not delete anything, only reports recordCount. Use as a
|
|
pre-flight check before asking the user for confirmation.
|
|
|
|
Table names are WITHOUT the 'cms_' prefix.`,
|
|
withAuthParams({
|
|
tableName: z.string().describe("Table name without 'cms_' prefix"),
|
|
dropData: z.boolean().optional().describe("If true, DROP the MySQL table. Default false."),
|
|
dryRun: z.boolean().optional().describe("If true, only report recordCount without deleting. Default false."),
|
|
}),
|
|
{ readOnlyHint: false, destructiveHint: true },
|
|
withAuth(async ({ tableName, dropData, dryRun }, _extra) => {
|
|
try {
|
|
const body = {
|
|
tableName,
|
|
confirm: true,
|
|
dropData: dropData === true,
|
|
dryRun: dryRun === true,
|
|
};
|
|
const { mcp } = await callSchemaEndpoint("/api/schema/delete-table", body);
|
|
return mcp;
|
|
} catch (error) {
|
|
return handleToolError(error, "delete_table", { tableName, dropData: dropData === true, dryRun: dryRun === true });
|
|
}
|
|
})
|
|
);
|
|
}
|