Search Results for "sqlalchemy"

Flask-Migrate is a Flask extension that integrates SQLAlchemy database migrations into Flask applications by leveraging Alembic, making schema changes easier and safer across development and deployment environments. It provides a set of command-line routines tied into Flask’s CLI such that developers can generate migration scripts, apply upgrades, and roll back changes with simple commands, keeping the database structure in sync with evolving application models.

Records is a Python library designed to make direct SQL querying convenient without introducing a full object-relational mapper. It supports relational databases including PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, and Amazon Redshift through SQLAlchemy. Query results are exposed as friendly Record objects whose fields can be accessed by attribute, key, or numeric index. Queries support safe parameterization, SQL files, transactions, and bulk operations. Result collections can be converted into dictionaries or exported through Tablib to formats such as CSV, JSON, Excel, HTML, YAML, and Pandas DataFrames. ...

This is a very simple module for those that don't need all the extra baggage that comes along with SQLAlchemy and other ORMs. It merely takes pyodbc one step farther by putting the tuples retrieved by pyodbc into a class that's made on the fly.