========================
Database Reporting Utils
========================
Collection of Python utils for executing queries and generating report files.
Exported Scripts
----------------
* run-queries
Usage
-----
Install the package
-------------------
.. code-block:: shell
pip install database-report-utils
Create the .env file
--------------------
.. code-block:: bash
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
.. code-block:: sql
SELECT COUNT(*)
FROM table1
WHERE column1 = "condition-1";
SELECT COUNT(*)
FROM table2
WHERE column2 = "condition-2";
Execute queries and generate report
-----------------------------------
.. code-block:: shell
run-queries --infile my_queries.sql
=======
History
=======
0.1.0 (2025-02-08)
------------------
* First release on PyPI.
Raw data
{
"_id": null,
"home_page": "https://github.com/jai-python3/database-reporting-utils",
"name": "database-reporting-utils",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": null,
"keywords": "database_reporting_utils",
"author": "Jaideep Sundaram",
"author_email": "jai.python3@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/aa/ff/f9d4673871de88c7421694b248797fec534c331cb3275ca9c46232ceb7f6/database_reporting_utils-0.1.3.tar.gz",
"platform": null,
"description": "========================\nDatabase Reporting Utils\n========================\nCollection of Python utils for executing queries and generating report files.\n\nExported Scripts\n----------------\n\n* run-queries\n\nUsage\n-----\n\nInstall the package\n-------------------\n\n.. code-block:: shell\n\n pip install database-report-utils\n\nCreate the .env file\n--------------------\n\n.. code-block:: bash\n\n DB_SERVER = localhost\n DB_DATABASE = mydatabase\n DB_USERNAME = root\n DB_PASSWORD = root\n DB_DRIVER = ODBC Driver 17 for SQL Server\n\nCreate the queries file\n-----------------------\n\nmy_queries.sql\n\n.. code-block:: sql\n\n SELECT COUNT(*) \n FROM table1\n WHERE column1 = \"condition-1\";\n\n SELECT COUNT(*) \n FROM table2\n WHERE column2 = \"condition-2\";\n\nExecute queries and generate report\n-----------------------------------\n\n.. code-block:: shell\n\n run-queries --infile my_queries.sql\n\n\n=======\nHistory\n=======\n\n0.1.0 (2025-02-08)\n------------------\n\n* First release on PyPI.\n",
"bugtrack_url": null,
"license": null,
"summary": "Collection of Python utils for executing queries and generating report files.",
"version": "0.1.3",
"project_urls": {
"Homepage": "https://github.com/jai-python3/database-reporting-utils"
},
"split_keywords": [
"database_reporting_utils"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "4db34856dc523aa0c4e18deaf9bdb7c8437b6762c0881069f75e87dc6cee2f86",
"md5": "7f4440c1835b3899e3bd607f426f5728",
"sha256": "92e4990fa43e5cba8b2364e441e6fb11e8cffcf72821baabb7fc9ea581c29ccf"
},
"downloads": -1,
"filename": "database_reporting_utils-0.1.3-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "7f4440c1835b3899e3bd607f426f5728",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": ">=3.6",
"size": 9549,
"upload_time": "2025-02-08T22:42:04",
"upload_time_iso_8601": "2025-02-08T22:42:04.230901Z",
"url": "https://files.pythonhosted.org/packages/4d/b3/4856dc523aa0c4e18deaf9bdb7c8437b6762c0881069f75e87dc6cee2f86/database_reporting_utils-0.1.3-py2.py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "aafff9d4673871de88c7421694b248797fec534c331cb3275ca9c46232ceb7f6",
"md5": "31ffe8132c3f49be1230b748712c1a62",
"sha256": "f8623fa54e56037994ff079e3707ccb700242b17f9e05f3660b0a8cfb1e197c7"
},
"downloads": -1,
"filename": "database_reporting_utils-0.1.3.tar.gz",
"has_sig": false,
"md5_digest": "31ffe8132c3f49be1230b748712c1a62",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 14088,
"upload_time": "2025-02-08T22:42:06",
"upload_time_iso_8601": "2025-02-08T22:42:06.497981Z",
"url": "https://files.pythonhosted.org/packages/aa/ff/f9d4673871de88c7421694b248797fec534c331cb3275ca9c46232ceb7f6/database_reporting_utils-0.1.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-02-08 22:42:06",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "jai-python3",
"github_project": "database-reporting-utils",
"github_not_found": true,
"lcname": "database-reporting-utils"
}
JSON
