https://prefect.io logo
r

Rafale Rodrigues

08/10/2023, 7:51 PM
Hello All! I have a question about SQLAlchemy, I guess it is simple and probably a missight on my side but I just can't get it to work. I have a small block to delete some data from MS SQL Server, I can see the command in SQL Profiler but it seems it is being rolled back cuz the data won't get deleted. I would really appreciate any help.
Copy code
sql_block = SqlAlchemyConnector.load("bdprod")
        with sql_block:
                rowsaffected = sql_block.execute_many(sql_qrydelete, parameters={"start": start, "end": end})