pytest-flask-sqlalchemy | pytest plugin for preserving test isolation | SQL Database library

by jeancochrane Python Version: 1.1.0 License: MIT

X-Ray Key Features Code Snippets Community Discussions(2)Vulnerabilities Install Support

kandi X-RAY | pytest-flask-sqlalchemy Summary

pytest-flask-sqlalchemy is a Python library typically used in Database, SQL Database applications. pytest-flask-sqlalchemy has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has low support. You can install using 'pip install pytest-flask-sqlalchemy' or download it from GitHub, PyPI.

A pytest plugin for preserving test isolation in Flask-SQLAlchemy using database transactions.

Support

Quality

Security

License

Reuse

Support

pytest-flask-sqlalchemy has a low active ecosystem.

It has 179 star(s) with 26 fork(s). There are 4 watchers for this library.

It had no major release in the last 12 months.

There are 22 open issues and 6 have been closed. On average issues are closed in 101 days. There are 3 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of pytest-flask-sqlalchemy is 1.1.0

Quality

pytest-flask-sqlalchemy has 0 bugs and 0 code smells.

Security

pytest-flask-sqlalchemy has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

pytest-flask-sqlalchemy code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

pytest-flask-sqlalchemy is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

pytest-flask-sqlalchemy releases are available to install and integrate.

Deployable package is available in PyPI.

Build file is available. You can build the component from source.

Installation instructions are not available. Examples and code snippets are available.

pytest-flask-sqlalchemy saves you 252 person hours of effort in developing the same functionality from scratch.

It has 613 lines of code, 39 functions and 8 files.

It has medium code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed pytest-flask-sqlalchemy and discovered the below as its top functions. This is intended to give you an instant insight into pytest-flask-sqlalchemy implemented functionality, and help decide if they suit your requirements.

Return the contents of the README . md file .

Get all kandi verified functions for this library.

pytest-flask-sqlalchemy Key Features

No Key Features are available at this moment for pytest-flask-sqlalchemy.

pytest-flask-sqlalchemy Examples and Code Snippets

No Code Snippets are available at this moment for pytest-flask-sqlalchemy.

Community Discussions

Trending Discussions on pytest-flask-sqlalchemy

SQLAlchemy Joining a Session into an External Transaction Not Working as Expected

Pytest Flask rollback transactions after tests when using the Unit of Work pattern

QUESTION

SQLAlchemy Joining a Session into an External Transaction Not Working as Expected

Asked 2022-Feb-23 at 17:04

I'm working on rewriting the test suite for a large application using pytest and looking to have isolation between each test function. What I've noticed is, multiple calls to commit inside a SAVEPOINT are causing records to be entered into the DB. I've distilled out as much code as possible for the following example:

init.py

...

ANSWER

Answered 2022-Feb-23 at 17:04

With the help of SQLAlchemy's Gitter community I was able to solve this. There were two issues that needed solving:

The after_transaction_end event was being registered for each individual test but not removed after the test ended. Because of this multiple events were being invoked between each test.
The _db being yielded from the db fixture was inside the app context, which it shouldn't have been.

Updated conftest.py:

Source https://stackoverflow.com/questions/71186875

QUESTION

Pytest Flask rollback transactions after tests when using the Unit of Work pattern

Asked 2021-Mar-15 at 23:46

I am studying the "Cosmic Python" book and chapter 6 explains how to use the Unit of Work pattern to change the interaction with the database/repository.

Chapter 6 of the book can be accessed here: https://www.cosmicpython.com/book/chapter_06_uow.html

The code provided by the author is the following:

...

ANSWER

Answered 2021-Mar-15 at 23:46

Finally, I got to make the rollback functionality happen after every test.

I got that working when I saw a package called pytest-postgresql implementing it on itself. I just made my adjustments to make tests rollback the database data that I was working with. For that, I just had to implement this function on conftest.py:

Source https://stackoverflow.com/questions/66387810

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install pytest-flask-sqlalchemy

You can install using 'pip install pytest-flask-sqlalchemy' or download it from GitHub, PyPI.
You can use pytest-flask-sqlalchemy like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: