semvec/pypi-packages huggingface dataset:
pyboost-auditor 0.2.2
An upgrade assistant to audit Python projects and estimate cloud cost savings.
License: MIT
Requires Python: >=3.8

# pyboost-auditor

**An upgrade assistant for Python projects that audits code and estimates cloud cost savings.**

## 🚀 About the Project

`pyboost-auditor` is a powerful command-line tool designed to help developers and organizations transition to modern Python versions with confidence. It goes beyond simple dependency checks by providing a clear, financial case for upgrading, helping you identify and quantify potential cloud cost savings.

## ✨ Key Features

  * **Automated Scanning:** Automatically detects the Python version in your project by scanning for `Dockerfile` and `environment.yaml` files.
  * **Cost Analysis:** Provides a clear estimate of your annual cloud savings based on your monthly bill and a hard-coded knowledge base of performance improvements in recent Python releases. This turns a technical decision into a business-friendly one.
  * **Dependency Checks:** Runs `pip check` to find potential dependency conflicts before you upgrade, serving as a proactive guardrail to prevent issues.
  * **CI/CD Ready:** Designed to be easily integrated into your CI/CD pipeline as a quality check.
  * **Visual Reports:** Provides a clear, color-coded report in the terminal for easy reading and quick decision-making, thanks to the `rich` library.

## 🛠️ How to Use

### 1\. Installation

You can install `pyboost-auditor` directly from PyPI:

```bash
pip install pyboost-auditor
```

### 2\. Basic Usage

Navigate to your project directory and run the command with your estimated monthly cloud bill. The tool will then scan your project and provide a report.

```bash
pyboost --monthly-bill [YOUR_BILL_AMOUNT] --compute-percentage [PERCENTAGE]
```

  * `--monthly-bill`: Your average monthly cloud bill.
  * `--compute-percentage`: The percentage of your bill that is allocated to computing resources.

### 3\. Example

```bash
pyboost --monthly-bill 2300000 --compute-percentage 0.6
```

This command would analyze your project and provide a report that estimates the annual savings based on a monthly cloud bill of `$2,300,000` with `60%` allocated to compute.

## 🤝 Contributing

We welcome contributions from the community\! Feel free to report a bug, suggest a new feature, or submit a pull request on GitHub.

## 📄 License

This project is licensed under the MIT License.
apisql 0.7.4
A flask blueprint providing a read-lny API for querying RDBMS
License: MIT
Keywords: data

# apisql

![PyPI - Python Version](https://img.shields.io/pypi/pyversions/apisql.svg)

apisql is a flask blueprint providing an API for read-only access for a DBMS using direct SQL Queries

## endpoints

### `/query`

Returns query results in json format.

Query parameters that can be send:
- **query**: The SQL query to execute on the DB. The query can be provided in plain text or base64 encoded.
- **num_rows**: The maximum number of rows to return. If not specified, will return the aount defined in the configuration, the amount defined in the environment variable `APISQL__MAX_ROWS` or 100.
- **page_size**: The size of the 'page', when doing paging. By default will use `num_rows` and in any way the page size it won't exceed `num_rows`.
- **page**: Which page to fetch, starting from page 0

### `/download`

Downloads query results in either csv, xls or xlsx format.

Query parameters that can be send:
- **query**: The SQL query to execute on the DB. The query can be provided in plain text or base64 encoded.
- **format**: Either `csv` or `xlsx`. Defaults to `csv`.
- **filename**: The filename for the file to be downloaded, *without the extension*. Defaults to `query-results`.
- **headers**: A semicolon separated list of the headers for the output file. Headers should match the field names that appear in the query.
  Headers may contain one or more modifiers, which appear after a colon. The currently supported modifiers are:
  - `number`, to convert numeric values to strings
  - `yesno`, which converts boolean values to "Yes" / "No"
  - `comma-separated`, which converts arrays of strings to a comma separated list of these strings.
  Finally, the content for a column may be fetched from a different field in the query output, by specifying the field name after a `<` character.

  Example:
  `Fiscal Year:number<fiscal_year;Leap Year:yesno<0;`



**Example:**
For the following SQL:
```
select employee_name as "Employee Name", employee_salary as "Salary", is_manager as "Managerial role?" from employees
```

`headers` could be specified as `Employee Name;Managerial role?:yesno;Salary:number`.

## configuration

Flask configuration for this blueprint:


```python

    from apisql import apisql_blueprint

    app.register_blueprint(
        apisql_blueprint(connection_string='psql://host/database', max_rows=1000, debug=False),
        url_prefix='/api/db/'
    )
```