aboutcode-org / aboutcode-org/scancode-analyzer

Write safer SQL Queries

Open
#62 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
4
Forks
4
PR merge metrics
No merged PRs in 30d

Description

Write better (safer) functions to prevent SQLi

It is generally considered bad practice to write SQL statements as such without _preparing_ them first (See: [this](https://bobby-tables.com/python))
https://github.com/nexB/scancode-analyzer/blob/813732ace5f0cb9647fe1c8ff504a4d30a1c67ac/etc/load_scan_into_dataframe/postgres.py#L59

Maybe, the Queries can be written using placeholders so that the database can fill in the data values properly and safely.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.