How do I create an API with MySQL database using Python?

So far I have,

@app.get("/assumptions/{id}")

def assumptions(id: int):

cursor = conn.cursor()

query = 'SELECT column1, column2, column3 FROM database.assumptions WHERE id = :id'

cursor.execute(query, {'id' : id})

result = cursor.fetchone()

cursor.close()

assump_response = models.ProjectionAssumptions(column1 = result['column1'],

column2 = result['column2'],

column3 = result['column3'])

return assump_response