Skip to main content

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)

Source distribution for database-reporting-utils 0.1.3
File Size Uploaded
database_reporting_utils-0.1.3.tar.gz 14.1 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for database-reporting-utils 0.1.3
File Interpreter ABI Platform
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

Release history Release notifications | RSS feed

This release

0.1.3 This release

2 release files

0.1.2

2 release files

0.1.0

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page