-
Notifications
You must be signed in to change notification settings - Fork 0
/
transaction_ingester.py
109 lines (82 loc) · 2.94 KB
/
transaction_ingester.py
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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
import argparse
import json
from typing import Optional
import httpx
from backend.api_models import Account, AccountCreate
def get_account_id(account: AccountCreate) -> Optional[Account]:
# use httpx to get the account using the institution and name as query parameters
response = httpx.get(
"http://localhost:8000/api/accounts/",
params={"institution": account.institution, "name": account.name},
)
# Raise an exception if the response status code is not 200
response.raise_for_status()
results = response.json()
if len(results) == 0:
return None
return Account(**results[0])
def create_account(account: AccountCreate) -> Optional[Account]:
# Create the account
response = httpx.post(
"http://localhost:8000/api/accounts/",
json=account.model_dump(),
)
response.raise_for_status()
return Account(**response.json())
def post_transactions(account: Account, transaction_file):
# check file extenstion for csv or ofx
if transaction_file.name.endswith(".csv"):
data_type = "text/csv"
elif transaction_file.name.endswith(".ofx"):
data_type = "text/xml"
else:
raise ValueError("Unsupported file type")
# Post the transactions
with open(transaction_file.name, "rb") as f:
files = {"upload_file": (transaction_file.name, f, data_type)}
response = httpx.post(
f"http://localhost:8000/api/accounts/{account.id}/transactions/?ingest_type={account.default_ingest_type}",
files=files,
)
print(response.json())
response.raise_for_status()
def main():
# Create the argument parser
parser = argparse.ArgumentParser(description="CLI for Transaction Ingestion")
# Add the required arguments
parser.add_argument(
"account_file",
type=argparse.FileType("r"),
help="Path to a JSON file holding an account.",
)
parser.add_argument(
"transaction_file",
type=argparse.FileType("r"),
help="Path to the transaction file to ingest",
)
# add optional argument, bool, create account if not found
parser.add_argument(
"--create",
action="store_true",
help="Create the account if it does not exist",
)
# Parse the command line arguments
args = parser.parse_args()
account_create = AccountCreate(**json.load(args.account_file))
# find the account using the json
account = get_account_id(account_create)
if not account and args.create:
account = create_account(account_create)
if not account:
print("Account not found and not created")
return
# print account object
print(f"Ingesting to {account.institution} - {account.name} ({account.id})")
# Post the transactions
post_transactions(account, args.transaction_file)
if __name__ == "__main__":
try:
main()
except Exception as e:
print(f"Error: {str(e)}")
exit(1)