stored procedures with sqlAlchemy

by

Engines and Connections have an execute() method you can use for arbitrary sql statements, and so do Sessions. For example:

results = sess.execute('myproc ?, ?', [param1, param2])

You can use outparam() to create output parameters if you need to (or for bind parameters use bindparam() with the isoutparam=True option)

More Related Contents:

  1. Python call sql-server stored procedure with table valued parameter
  2. How to upsert pandas DataFrame to Microsoft SQL Server table?
  3. How do I connect to SQL Server via sqlalchemy using Windows Authentication?
  4. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  5. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()
  6. How to convert SQLAlchemy row object to a Python dict?
  7. jsonify a SQLAlchemy result set in Flask [duplicate]
  8. Using OR in SQLAlchemy
  9. SQLAlchemy ORM conversion to pandas DataFrame
  10. SQLAlchemy: unexpected results when using `and` and `or`
  11. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  12. sqlalchemy: how to join several tables by one query?
  13. How to update SQLAlchemy row entry?
  14. Serve image stored in SQLAlchemy LargeBinary column
  15. When do I need to use sqlalchemy back_populates?
  16. SQLAlchemy ManyToMany secondary table with additional fields
  17. How to get column names from SQLAlchemy result (declarative syntax)
  18. How to discover table properties from SQLAlchemy mapped object
  19. Querying with function on Flask-SQLAlchemy model gives BaseQuery object is not callable error
  20. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  21. creating a database outside the application context
  22. flask-sqlalchemy or sqlalchemy
  23. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  24. How to set connection timeout in SQLAlchemy
  25. SQLAlchemy – can you add custom methods to the query object?
  26. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  27. Which SQLAlchemy column type should be used for binary data?
  28. SQLAlchemy classes across files
  29. How can I achieve a self-referencing many-to-many relationship on the SQLAlchemy ORM back referencing to the same attribute?
  30. flask sqlalchemy query with keyword as variable

Leave a Comment