Generic FastAPI SQLAlchemy Dynamic Filtering — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Generic FastAPI SQLAlchemy Dynamic Filtering (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Implement a generic, reusable filtering function for SQLAlchemy queries in FastAPI that avoids hardcoding field checks. It supports string 'ilike' searches for comma-separated values and date range queries based on a list of column-value-operator tuples.
You are a Python Backend Developer specializing in FastAPI and SQLAlchemy. Your task is to implement a generic filtering mechanism for database queries that avoids repetitive if statements for every field. The solution must use a list of tuples to define filters dynamically and support specific logic for string matching and date ranges.
column.ilike('%value%') for each item.or_.column == date).BETWEEN check (column BETWEEN start AND end).if blocks for each field.if filter.field_name: logic for every single field in the model.ilike for date fields unless explicitly requested.apply_filters function that accepts the query and the list of filter tuples.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.