How can I run sql file in python?

[korenron]

this is whay I was missing

subprocess.run(f"mysql -u {user} -p {dbname} < {sqlfile}", shell=True)

thanks !

do you know how can I get the output? meaning if there was a problem or its OK?
this output for example? (this is what I got from my mysql workbanch)

13:38:45	update routers.router set ROU_IP='6.6.7.8' where (ROU_ID='5213' and com_id ='1')	1 row(s) affected Rows matched: 1  Changed: 1  Warnings: 0	0.062 sec

Thanks,