File size: 1,986 Bytes
28fad98 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 | from datetime import datetime
from decimal import Decimal
from typing_extensions import Optional
from sqlalchemy.orm import Session
from src.db import Session, Transaction
def insert_transaction_tool(
timestamp: str,
amount: int,
type: str,
description: str,
category: str,
subcategory: Optional[str],
notes: Optional[str],
) -> dict:
"""Insert a transaction into the database
Args:
timestamp (str): Transaction date
amount (str): Amount of the transaction
type (str): Transaction type (income or expense)
description (str): The transaction description
category (str): Transaction category
subcategory (str): Optional sub-category based on the transaction category
notes (str): Optional notes specified by the user
Returns:
dict: A dictionary containing the transaction record.
Includes a 'status' key ('success' or 'error').
If 'success', includes a 'summary' key with weather details.
If 'error', includes an 'error_message' key.
"""
timestamp = datetime.strptime(timestamp, "%Y-%m-%d %H:%M:%S")
amount = Decimal(amount)
session = Session()
new_transaction = Transaction(
timestamp=timestamp,
amount=amount,
type=type.lower(),
description=description,
category=category.lower(),
subcategory=subcategory.lower(),
notes=notes,
)
session.add(new_transaction)
session.commit()
session.close()
return {
"status": "success",
"summary": (
"Transaction recorded successfully..\n"
f"Type: {type}\n"
f"Amount: {amount}\n"
f"Timestamp: {timestamp}\n"
f"Description: {description}\n"
f"Category: {category}\n"
f"Sub Category: {subcategory}\n"
f"Notes: {notes}"
)
}
def read_transaction_tool():
pass |