app.py

from smolagents import CodeAgent,DuckDuckGoSearchTool, HfApiModel,load_tool,tool
import datetime
import requests
import pytz
import yaml
from tools.final_answer import FinalAnswerTool

from Gradio_UI import GradioUI

# Below is an example of a tool that does nothing. Amaze us with your creativity !
@tool
def my_custom_tool(arg1:str, arg2:int)-> str: #it's import to specify the return type
    #Keep this format for the description / args / args description but feel free to modify the tool
    """A tool that does nothing yet 
    Args:
        arg1: the first argument
        arg2: the second argument
    """
    return "What magic will you build ?"

@tool
def get_current_time_in_timezone(timezone: str) -> str:
    """A tool that fetches the current local time in a specified timezone.
    Args:
        timezone: A string representing a valid timezone (e.g., 'America/New_York').
    """
    try:
        # Create timezone object
        tz = pytz.timezone(timezone)
        # Get current time in that timezone
        local_time = datetime.datetime.now(tz).strftime("%Y-%m-%d %H:%M:%S")
        return f"The current local time in {timezone} is: {local_time}"
    except Exception as e:
        return f"Error fetching time for timezone '{timezone}': {str(e)}"
@tool
def sql_engine(query: str) -> str:
    """
    Allows you to perform SQL queries on the table. Beware that this tool's output is a string representation of the execution output.\nIt can use the following tables:\n\nTable 'ekh_dvou_tax_values':\nColumns:\n  - taxdate: VARCHAR(250)\n  - sumtax: NUMBER\n  - employeeisn: VARCHAR(250)\n  - inn: VARCHAR(250)\n  - employeefio: VARCHAR(4000)\n\nTable 'ekh_employeeabsencesdata':\nColumns:\n  - load_date: DATE\n  - dateto: DATE\n  - datefrom: DATE\n  - absencetype: VARCHAR(225)\n  - employeeisn: NUMBER\n  - employeeuid: VARCHAR(225)\n  - personuid: VARCHAR(225)\n\nTable 'ekh_employeedismissal':\nColumns:\n  - groupofactivities: VARCHAR(1000)\n  - student: VARCHAR(10)\n  - offerfromanothercompany: VARCHAR(1000)\n  - supervisordismissalreason: VARCHAR(1000)\n  - employeedismissalreason: VARCHAR(1000)\n  - realdismissalreason: VARCHAR(1000)\n  - votchetepotekuchestikadrov: VARCHAR(1000)\n  - labourcode: VARCHAR(1000)\n  - dismissaldate: VARCHAR(1000)\n  - employeeid: VARCHAR(1000)\n  - uid1: VARCHAR(1000)\n  - personuid: VARCHAR(1000)
    Args:
        query: запрос для выполнения
    """
    return "sql code"

final_answer = FinalAnswerTool()

# If the agent does not answer, the model is overloaded, please use another model or the following Hugging Face Endpoint that also contains qwen2.5 coder:
# model_id='https://pflgm2locj2t89co.us-east-1.aws.endpoints.huggingface.cloud' 

model = HfApiModel(
max_tokens=2096,
temperature=0.5,
model_id='Qwen/Qwen2.5-Coder-32B-Instruct',# it is possible that this model may be overloaded
custom_role_conversions=None,
)


# Import tool from Hub
image_generation_tool = load_tool("agents-course/text-to-image", trust_remote_code=True)

with open("prompts.yaml", 'r') as stream:
    prompt_templates = yaml.safe_load(stream)
    
agent = CodeAgent(
    model=model,
    tools=[final_answer, sql_engine], ## add your tools here (don't remove final answer)
    max_steps=6,
    verbosity_level=1,
    grammar=None,
    planning_interval=None,
    name=None,
    description=None,
    prompt_templates=prompt_templates
)


GradioUI(agent).launch()