cast to string
@@ -153,7 +153,7 @@ def get_treatments(connection, start, end, machine):
TrackTreatment.Edit_DtTm >= %(start)s AND
TrackTreatment.Create_DtTm <= %(end)s
""",
- {"machine": machine, "start": start, "end": end},
+ {"machine": str(machine), "start": str(start), "end": str(end)},
)
table = pd.DataFrame(
@@ -238,7 +238,7 @@ def get_qcls_by_date(connection, location, start, end):
Chklist.Act_DtTm >= %(start)s AND
Chklist.Act_DtTm < %(end)s
""",
- {"location": location, "start": start, "end": end},
+ {"location": str(location), "start": str(start), "end": str(end)},
)
results = pd.DataFrame(
