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.
Metadata
Release files for database-reporting-utils 0.1.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| database_reporting_utils-0.1.3.tar.gz | 14.1 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| database_reporting_utils-0.1.3-py2.py3-none-any.whl | Python 3, Python 2 | none | any | Details |
Total release size: 23.6 kB
Release files / database_reporting_utils-0.1.3.tar.gz
| Download URL | database_reporting_utils-0.1.3.tar.gz |
|---|---|
| Size | 14.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
f8623fa54e56037994ff079e3707ccb700242b17f9e05f3660b0a8cfb1e197c7
|
|
BLAKE2b-256 checksum How to use checksums |
aafff9d4673871de88c7421694b248797fec534c331cb3275ca9c46232ceb7f6
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.10.12
|
Release files / database_reporting_utils-0.1.3-py2.py3-none-any.whl
| Download URL | database_reporting_utils-0.1.3-py2.py3-none-any.whl |
|---|---|
| Size | 9.5 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
92e4990fa43e5cba8b2364e441e6fb11e8cffcf72821baabb7fc9ea581c29ccf
|
|
BLAKE2b-256 checksum How to use checksums |
4db34856dc523aa0c4e18deaf9bdb7c8437b6762c0881069f75e87dc6cee2f86
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.10.12
|