# QuerySource #
QuerySource is a powerful Python library designed to streamline access to multiple databases and external APIs through a single, unified interface. Utilizing the proxy design pattern, QuerySource allows developers to seamlessly integrate various data sources into their projects without worrying about the complexities of managing multiple connections.
## Features ##
* Unified interface for querying multiple databases (Redis, PostgreSQL, MySQL, Oracle, SQL Server, InfluxDB, CouchDB, Druid)
* Support for external APIs (Salesforce, ShopperTrack, ZipCodeAPI, etc.)
* Easy-to-use API for executing queries
* Extensible design, allowing for easy addition of new data sources
## Installation
<div class="termy">
```console
$ pip install querysource
---> 100%
Successfully installed querysource
```
### Requirements ###
* Python >= 3.9
* asyncio (https://pypi.python.org/pypi/asyncio/)
## Basic Usage ##
QuerySource can be used in several ways, one is using QS object itself:
```python
from querysource.queries.qs import QS
query = QS(
query='SELECT * FROM tests',
output_format='pandas'
)
result, error = await query.query()
```
## Extending QuerySource ##
To add support for a new data source, create a new class inheriting from the BaseProvider or BaseAPI class and implement the required methods (prepare_connection, query, close). Then, register the new data source in the QuerySource class by adding it to the appropriate dictionary (_supported_databases or _supported_apis).
### Contributing ###
We welcome contributions to QuerySource! If you'd like to contribute, please follow these steps:
* Fork the repository
* Create a new branch for your feature or bugfix
* Implement your changes
* Add tests covering your changes
* Create a pull request against the original repository
### Contribution guidelines ###
* Writing tests
* Code review
* Other guidelines
### License ###
QuerySource is released under the BSD License. See the LICENSE file for more details.
Raw data
{
"_id": null,
"home_page": "https://github.com/phenobarbital/querysource/",
"name": "querysource",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.9.16",
"maintainer_email": null,
"keywords": null,
"author": "Jesus Lara",
"author_email": "\"Jesus Lara G.\" <jesuslarag@gmail.com>",
"download_url": null,
"platform": null,
"description": "# QuerySource #\n\nQuerySource is a powerful Python library designed to streamline access to multiple databases and external APIs through a single, unified interface. Utilizing the proxy design pattern, QuerySource allows developers to seamlessly integrate various data sources into their projects without worrying about the complexities of managing multiple connections.\n\n## Features ##\n\n* Unified interface for querying multiple databases (Redis, PostgreSQL, MySQL, Oracle, SQL Server, InfluxDB, CouchDB, Druid)\n* Support for external APIs (Salesforce, ShopperTrack, ZipCodeAPI, etc.)\n* Easy-to-use API for executing queries\n* Extensible design, allowing for easy addition of new data sources\n\n## Installation\n\n<div class=\"termy\">\n\n```console\n$ pip install querysource\n---> 100%\nSuccessfully installed querysource\n```\n\n\n### Requirements ###\n\n* Python >= 3.9\n* asyncio (https://pypi.python.org/pypi/asyncio/)\n\n## Basic Usage ##\n\nQuerySource can be used in several ways, one is using QS object itself:\n\n```python\nfrom querysource.queries.qs import QS\n\nquery = QS(\n query='SELECT * FROM tests',\n output_format='pandas'\n)\nresult, error = await query.query()\n```\n\n## Extending QuerySource ##\n\nTo add support for a new data source, create a new class inheriting from the BaseProvider or BaseAPI class and implement the required methods (prepare_connection, query, close). Then, register the new data source in the QuerySource class by adding it to the appropriate dictionary (_supported_databases or _supported_apis).\n\n\n### Contributing ###\n\nWe welcome contributions to QuerySource! If you'd like to contribute, please follow these steps:\n\n* Fork the repository\n* Create a new branch for your feature or bugfix\n* Implement your changes\n* Add tests covering your changes\n* Create a pull request against the original repository\n\n### Contribution guidelines ###\n\n* Writing tests\n* Code review\n* Other guidelines\n\n### License ###\n\nQuerySource is released under the BSD License. See the LICENSE file for more details.\n",
"bugtrack_url": null,
"license": "BSD",
"summary": "QuerySource is a Library for Querying Databases. QuerySource Query parser and generator.",
"version": "3.13.8",
"project_urls": {
"Documentation": "https://querysource.readthedocs.io/en/latest/",
"Funding": "https://paypal.me/phenobarbital",
"Homepage": "https://github.com/phenobarbital/querysource/",
"Say Thanks!": "https://saythanks.io/to/phenobarbital",
"Source": "https://github.com/phenobarbital/querysource/",
"Tracker": "https://github.com/phenobarbital/querysource/issues"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "00b755ec1cfa01d09969ab8d7ee801d8c5217a8c086dda5c280f46a85b10736e",
"md5": "cfeb7ae0945c264ea5eccccc2be71b29",
"sha256": "e4c7a70bd1923611fa5f59569b9d462ec928005b4d702a5b60588cf1c4b3748c"
},
"downloads": -1,
"filename": "querysource-3.13.8-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "cfeb7ae0945c264ea5eccccc2be71b29",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.9.16",
"size": 5109789,
"upload_time": "2024-12-16T23:02:45",
"upload_time_iso_8601": "2024-12-16T23:02:45.686365Z",
"url": "https://files.pythonhosted.org/packages/00/b7/55ec1cfa01d09969ab8d7ee801d8c5217a8c086dda5c280f46a85b10736e/querysource-3.13.8-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "9e39aebc1cc7dc8891aa90c15db09035d2e8b457d0caf285ff840ac788ab93b4",
"md5": "6c79e68da630e861c56aad42dcd75cfc",
"sha256": "549a17218f0aa14ce032a0c8769c43b810cf770e04131a865c178d18f1b38f4e"
},
"downloads": -1,
"filename": "querysource-3.13.8-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "6c79e68da630e861c56aad42dcd75cfc",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.9.16",
"size": 5378804,
"upload_time": "2024-12-16T23:02:49",
"upload_time_iso_8601": "2024-12-16T23:02:49.591025Z",
"url": "https://files.pythonhosted.org/packages/9e/39/aebc1cc7dc8891aa90c15db09035d2e8b457d0caf285ff840ac788ab93b4/querysource-3.13.8-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "59abbc03ba0e4c124cf3cb49f3d1beb3541e510014a67925989e2502c350c11d",
"md5": "a415c35aa9252e9dc987689036c6f69d",
"sha256": "aede9e6e622c24bee83821039290289e06eaf9d68a5b9062cfe545725d681635"
},
"downloads": -1,
"filename": "querysource-3.13.8-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "a415c35aa9252e9dc987689036c6f69d",
"packagetype": "bdist_wheel",
"python_version": "cp312",
"requires_python": ">=3.9.16",
"size": 5832676,
"upload_time": "2024-12-16T23:02:51",
"upload_time_iso_8601": "2024-12-16T23:02:51.483860Z",
"url": "https://files.pythonhosted.org/packages/59/ab/bc03ba0e4c124cf3cb49f3d1beb3541e510014a67925989e2502c350c11d/querysource-3.13.8-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "dd30860625cae911e5e52748a6b84436eb4b597d613a3ccf310846cf90bbbb75",
"md5": "b1214cc1cb63ff9dbcdb6317322e192c",
"sha256": "7b0a51c115d20993ecaa19ee23f0fc8486fa411804273de7d2b4153c8e436e39"
},
"downloads": -1,
"filename": "querysource-3.13.8-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "b1214cc1cb63ff9dbcdb6317322e192c",
"packagetype": "bdist_wheel",
"python_version": "cp39",
"requires_python": ">=3.9.16",
"size": 5122422,
"upload_time": "2024-12-16T23:02:54",
"upload_time_iso_8601": "2024-12-16T23:02:54.336147Z",
"url": "https://files.pythonhosted.org/packages/dd/30/860625cae911e5e52748a6b84436eb4b597d613a3ccf310846cf90bbbb75/querysource-3.13.8-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-12-16 23:02:45",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "phenobarbital",
"github_project": "querysource",
"github_not_found": true,
"lcname": "querysource"
}
JSON
