tmpl_nameOfTool
Analyze and process database arguments to generate formatted query results with metadata for Teradata database operations.
Instructions
Arguments: arguments - arguments to analyze
Returns: ResponseType: formatted response with query results + metadata
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| argument | Yes |
Implementation Reference
- The handle_tmpl_nameOfTool function implements the core logic for the tmpl_nameOfTool tool. It executes a parameterized Teradata SQL query based on the provided argument, fetches results, formats them as JSON, adds metadata including the tool name, and returns a structured response.def handle_tmpl_nameOfTool(conn: TeradataConnection, argument: str | None, *args, **kwargs): """ <description of what the tool is for> Arguments: arguments - arguments to analyze Returns: ResponseType: formatted response with query results + metadata """ logger.debug(f"Tool: handle_tmpl_nameOfTool: Args: argument: {argument}") with conn.cursor() as cur: if argument == "": logger.debug("No argument provided") rows = cur.execute("Teradata query goes here;") else: logger.debug(f"Argument provided: {argument}") rows = cur.execute(f"Teradata query goes here with argument {argument};") data = rows_to_json(cur.description, rows.fetchall()) metadata = { "tool_name": "tmpl_nameOfTool", "argument": argument, "rows": len(data) } logger.debug(f"Tool: handle_tmpl_nameOfTool: metadata: {metadata}") return create_response(data, metadata)