Update app.py

app.py

@@ -32,7 +32,14 @@ def get_current_time_in_timezone(timezone: str) -> str:
         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()
 
@@ -55,7 +62,7 @@ with open("prompts.yaml", 'r') as stream:
     
 agent = CodeAgent(
     model=model,
-    tools=[final_answer], ## add your tools here (don't remove final answer)
+    tools=[final_answer, sql_engine], ## add your tools here (don't remove final answer)
     max_steps=6,
     verbosity_level=1,
     grammar=None,