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.

Project links

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Latest release

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for jai-python3 from gravatar.com jai-python3

Credits

Author: Jaideep Sundaram

Requires

Python >=3.6

Tags

database_reporting_utils

Classifiers

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

database_reporting_utils-0.1.3.tar.gz (14.1 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

database_reporting_utils-0.1.3-py2.py3-none-any.whl (9.5 kB view details)

Uploaded Python 2Python 3

File details

Details for the file database_reporting_utils-0.1.3.tar.gz.

File metadata

  • Download URL: database_reporting_utils-0.1.3.tar.gz
  • Upload date:
  • Size: 14.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.10.12

File hashes

Hashes for database_reporting_utils-0.1.3.tar.gz
Algorithm Hash digest
SHA256 f8623fa54e56037994ff079e3707ccb700242b17f9e05f3660b0a8cfb1e197c7
MD5 31ffe8132c3f49be1230b748712c1a62
BLAKE2b-256 aafff9d4673871de88c7421694b248797fec534c331cb3275ca9c46232ceb7f6

See more details on using hashes here.

File details

Details for the file database_reporting_utils-0.1.3-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for database_reporting_utils-0.1.3-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 92e4990fa43e5cba8b2364e441e6fb11e8cffcf72821baabb7fc9ea581c29ccf
MD5 7f4440c1835b3899e3bd607f426f5728
BLAKE2b-256 4db34856dc523aa0c4e18deaf9bdb7c8437b6762c0881069f75e87dc6cee2f86

See more details on using hashes here.

Release history Release notifications | RSS feed

This release

0.1.3 This release

2 files

0.1.2

2 files

0.1.0

2 files

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page