S-F0/text2sql

1from smolagents import CodeAgent,DuckDuckGoSearchTool, HfApiModel,load_tool,tool2import datetime3import requests4import pytz5import yaml6from tools.final_answer import FinalAnswerTool7 8from Gradio_UI import GradioUI9 10@tool11def text_to_sql(query: str) -> str:12    """Converts a natural language query into an SQL statement.13    Args:14        query: A natural language description of the SQL query.15    Returns:16        Generated SQL statement.17    """18    try:19        sql_generation_tool = load_tool("agents-course/text-to-sql", trust_remote_code=True)20        sql_query = sql_generation_tool.run(query)21        return sql_query22    except Exception as e:23        return f"Error generating SQL: {str(e)}"24 25@tool26def get_current_time_in_timezone(timezone: str) -> str:27    """A tool that fetches the current local time in a specified timezone.28    Args:29        timezone: A string representing a valid timezone (e.g., 'America/New_York').30    """31    try:32        # Create timezone object33        tz = pytz.timezone(timezone)34        # Get current time in that timezone35        local_time = datetime.datetime.now(tz).strftime("%Y-%m-%d %H:%M:%S")36        return f"The current local time in {timezone} is: {local_time}"37    except Exception as e:38        return f"Error fetching time for timezone '{timezone}': {str(e)}"39 40 41final_answer = FinalAnswerTool()42model = HfApiModel(43max_tokens=2096,44temperature=0.5,45model_id='Qwen/Qwen2.5-Coder-32B-Instruct',# it is possible that this model may be overloaded46custom_role_conversions=None,47)48 49 50# Import tool from Hub51image_generation_tool = load_tool("agents-course/text-to-image", trust_remote_code=True)52 53with open("prompts.yaml", 'r') as stream:54    prompt_templates = yaml.safe_load(stream)55    56agent = CodeAgent(57    model=model,58    tools=[final_answer, text_to_sql], ## add your tools here (don't remove final answer)59    max_steps=6,60    verbosity_level=1,61    grammar=None,62    planning_interval=None,63    name=None,64    description=None,65    prompt_templates=prompt_templates66)67 68 69GradioUI(agent).launch()