Notes

@pytest.mark.asyncio
async def test_investors_api(self):
params = {
"asOf": "2024-08-04",
"initials": ["JRQ", "MOC", "MR"],
"investmentDivision": ["CFII", "CII", "CRGI"]
}

investors_mock = {
"date": "2024-01-31",
"investors": [
{
"cgPersonID": "02399",
"initials": "JRQ",
"name": "John Queen",
"investmentDivision": "CFII"
},
{
"cgPersonID": "10446",
"initials": "MOC",
"name": "Mark Casey",
"investmentDivision": "CII"
},
{
"cgPersonID": "03773",
"initials": "MR",
"name": "Martin Romo",
"investmentDivision": "CRGI"
}
]
}

with patch("app.database.execute_named_query", return_value=pd.DataFrame(investors_mock['investors'])):
response = client.get("/api/v1/investors", params=params)

print("Response status code:", response.status_code)
print("Response JSON:", response.json())

if response.json() == {'detail': 'No investors found.'}:
assert response.status_code == 404
else:
> assert response.status_code == 200, f"Expected status code 200, but got {response.status_code}"
E AssertionError: Expected status code 200, but got 500
E assert 500 == 200
E + where 500 = <Response [500 Internal Server Error]>.status_code

test_model.py:74: AssertionError</failure></testcase><testcase classname="application-source.app.test_model_inv.TestInvestors" name="test_investors" time="0.006" /><testcase classname="application-source.app.test_model_inv.TestInvestors" name="test_investors_api" time="0.013"><failure message="assert 500 == 200&#10; + where 500 = &lt;Response [500 Internal Server Error]&gt;.status_code">mock_db_conn_pool = &lt;app.test_model_inv.TestInvestors object at 0x000001E37FDF3C90&gt;

@pytest.mark.asyncio
async def test_investors_api(mock_db_conn_pool):
params = {
"asOf": "2024-08-04",
"initials" : ["JRQ", "MOC", "MR"],
"investmentDivision": ["CFII", "CII", "CRGI"]
}

investors_mock = {
"date": "2024-01-31",
"investors": [
{
"cgPersonID": "02399",
"initials": "JRQ",
"name": "John Queen",
"investmentDivision": "CFII"
},
{
"cgPersonID": "10446",
"initials": "MOC",
"name": "Mark Casey",
"investmentDivision": "CII"
},
{
"cgPersonID": "03773",
"initials": "MR",
"name": "Martin Romo",
"investmentDivision": "CRGI"
}
]
}

expected_investors = Investors(
date = date(2024,8,4),
investors = [
{
"cgPersonID": "02399",
"initials": "JRQ",
"name": "John Queen",
"investmentDivision": "CFII"
},
{
"cgPersonID": "10446",
"initials": "MOC",
"name": "Mark Casey",
"investmentDivision": "CII"
},
{
"cgPersonID": "03773",
"initials": "MR",
"name": "Martin Romo",
"investmentDivision": "CRGI"
}
]
)

with patch("app.database.execute_named_query",return_value=pd.DataFrame(investors_mock['investors'])):
response = client.get("/api/v1/investors", params=params)
print("Response output",response)
# breakpoint()
if response.json() == {'detail': 'No investors found.'}:
assert response.status_code == 404
else:
&gt; assert response.status_code == 200
E assert 500 == 200
E + where 500 = &lt;Response [500 Internal Server Error]&gt;.status_code

test_model_inv.py:137: AssertionError</failure></testcase></testsuite></testsuites>