FastAPI-Async-SQLA

v0.2.0

SQLAlchemy extension for FastAPI with support for asynchronous SQLAlchemy sessions and pagination. For more information about how to use this package see README

Latest version published 3 months ago

License: MIT

PyPI

GitHub

Package Health Score

75 / 100

security
No known security issues
popularity
Small
maintenance
Sustainable
community
Active

Popularity

Small

GitHub Stars: 1.23K
Forks: 96
Contributors: 30

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package FastAPI-Async-SQLA, we found that it has been starred 1,233 times.

Security

No known security issues

Security and license risk for latest version

Release Date: Sep 9, 2024
Direct Vulnerabilities: 0
C
0
H
0
M
0
L
Indirect Vulnerabilities: 0
C
0
H
0
M
0
L
License Risk: 0
H
0
M
0
L

All security vulnerabilities belong to production dependencies of direct and indirect packages.

License

MIT

Security Policy

We found a way for you to contribute to the project! Looks like FastAPI-Async-SQLA is missing a security policy.

You can connect your project's repository to Snyk to stay up to date on security alerts and receive automatic fix pull requests.

Keep your project free of vulnerabilities with Snyk

Maintenance

Sustainable

Commit Frequency

Open Issues: 31
Open PR: 10
Last Release: 3 months ago
Last Commit: 5 months ago

Further analysis of the maintenance status of FastAPI-Async-SQLA based on released PyPI versions cadence, the repository activity, and other data points determined that its maintenance is Sustainable.

We found that FastAPI-Async-SQLA demonstrates a positive version release cadence with at least one new version released in the past 12 months.

In the past month we didn't find any pull request activity or change in issues status has been detected for the GitHub repository.

Community

Active

Readme: Yes
Contributing.md: Yes
Code of Conduct: Yes
Contributors: 30
Funding: No

With more than 10 contributors for the FastAPI-Async-SQLA repository, this is possibly a sign for a growing and inviting community.

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Python Versions Compatibility: >=3.12

Age: 3 months
Latest Release: 3 months ago
Dependencies: 0 Direct
Versions: 1
Maintainers: 0
Wheels: OS Independent

Readme

FastAPI-Async-SQLA

FastAPI-Async-SQLA is an [SQLAlchemy] extension for [FastAPI]. It supports asynchronous SQLAlchemy sessions using SQLAlchemy >= 2.0 and provides pagination support.

Installing

Using pip:

pip install fastapi-async-sqla

Quick Example

Assuming it runs against a DB with a table user with 2 columns id and name:

# main.py
from fastapi import FastAPI, HTTPException
from fastapi_async_sqla import Base, Item, Page, Paginate, Session, lifespan
from pydantic import BaseModel
from sqlalchemy import select


app = FastAPI(lifespan=lifespan)


class User(Base):
    __tablename__ = "user"


class UserIn(BaseModel):
    name: str


class UserModel(UserIn):
    id: int


@app.get("/users", response_model=Page[UserModel])
async def list_users(paginate: Paginate):
    return await paginate(select(User))


@app.get("/users/{user_id}", response_model=Item[UserModel])
async def get_user(user_id: int, session: Session):
    user = await session.get(User, user_id)
    if user is None:
        raise HTTPException(404)
    return {"data": user}


@app.post("/users", response_model=Item[UserModel])
async def create_user(new_user: UserIn, session: Session):
    user = User(**new_user.model_dump())
    session.add(user)
    await session.flush()
    return {"data": user}

Creating a db using sqlite3:

sqlite3 db.sqlite &lt;

FAQs

What is FastAPI-Async-SQLA?

SQLAlchemy extension for FastAPI with support for asynchronous SQLAlchemy sessions and pagination. Visit Snyk Advisor to see a full health score report for FastAPI-Async-SQLA, including popularity, security, maintenance & community analysis.

Is FastAPI-Async-SQLA popular?

We’re still processing downloads data for the python package FastAPI-Async-SQLA. Visit the popularity section on Snyk Advisor to see the full popularity analysis.

Is FastAPI-Async-SQLA well maintained?

We found indications that FastAPI-Async-SQLA maintenance is sustainable demonstrating some project activity. We saw a total of 30 open source contributors collaborating on the project. See the full package health analysis to learn more about the package maintenance status.

Is FastAPI-Async-SQLA safe to use?

The python package FastAPI-Async-SQLA was scanned for known vulnerabilities and missing license, and no issues were found. Thus the package was deemed as safe to use. See the full health analysis review.

Last updated on 19 December-2024, at 01:02 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

Package Health Score

Direct Usage Popularity

Security and license risk for latest version

Commit Frequency

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Readme

FastAPI-Async-SQLA

Installing

Quick Example

FAQs

What is FastAPI-Async-SQLA?

Is FastAPI-Async-SQLA popular?

Is FastAPI-Async-SQLA well maintained?

Is FastAPI-Async-SQLA safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues