How can I run sql file in python?

[korenron]

Hello,
I have a sql file with ~ 50 lines of update\delete\set commands
everything is config to work according to the router ID

set @ID = (select rou_id from Company1.router where
rou_serial_no like '%SN123456%'); ## put here the Rou Serial number!

delete FROM israel_v7.history_router
where rou_id=@ID and com_id=@OldCompany;
.
.
.
Update Company1.router set Company1.router.ROU_STATE = @State where Company1.router.ROU_ID = @ID;

can I write a python code where I enter the serial_number --> save it as @ID then run the all sql file according to the Serial I have entered?

Thanks,