database-reporting-utils 0.1.3

Collection of Python utils for executing queries and generating report files.

Database Reporting Utils

Collection of Python utils for executing queries and generating report files.

Exported Scripts

• run-queries

Usage

Install the package

pip install database-report-utils

Create the .env file

DB_SERVER = localhost
DB_DATABASE = mydatabase
DB_USERNAME = root
DB_PASSWORD = root
DB_DRIVER = ODBC Driver 17 for SQL Server

Create the queries file

my_queries.sql

SELECT COUNT(*)
FROM table1
WHERE column1 = "condition-1";

SELECT COUNT(*)
FROM table2
WHERE column2 = "condition-2";

Execute queries and generate report

run-queries --infile my_queries.sql

History

0.1.0 (2025-02-08)

• First release on PyPI.