How can I convert SQL Server stored procedure to Python (SQLAlchemy) def

Question

How can I convert SQL Server stored procedure to Python (SQLAlchemy) def?

My target : [MSSQL SP] to [python(SQLAlchemy) def]

There's no automatic way to do that. You need to work out what the procedure does, then write the logic in Python. — snakecharmerb, Feb 13 '22 at 15:19

Bastien B · Answer 1 · 2022-02-13T21:04:09.470

You are explicitly speaking of "stored procedure" so I assume you don't have models nor ORM used in the app using this db. You have 2 options:

Use sqlalchemy to map your db models and interact with them without using your procedures.
Call your procedure through an SQL connector (that can be provided by SQLAlchemy)

You can do a mix of both solutions if you have part of your app that need to stay unmapped by an orm (for legal or certification raisons for example)

Since you did add the FastAPI tag, the first link is the official FastAPI doc on how to use SQLAlchemy with the framework.

1 Answers1