# 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.12.32",
"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": "042eb124210d711d093e42f42ef67a187beba65e68c335263bb982972ba67694",
"md5": "cc38c0bfdde27bf01c3c5df8631c3656",
"sha256": "0ceb93a70fb4edb821719d2bf3ecd6565007ec8d990f7b160518b3740ae00e51"
},
"downloads": -1,
"filename": "querysource-3.12.32-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "cc38c0bfdde27bf01c3c5df8631c3656",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.9.16",
"size": 5019284,
"upload_time": "2024-11-09T00:05:35",
"upload_time_iso_8601": "2024-11-09T00:05:35.145267Z",
"url": "https://files.pythonhosted.org/packages/04/2e/b124210d711d093e42f42ef67a187beba65e68c335263bb982972ba67694/querysource-3.12.32-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "3fad82e7c058100f1b09d628f8fc7ee3dce75b962f6c6d821570cbdc16256d0d",
"md5": "6271646f10d40db79dfec4dff7dd76d8",
"sha256": "99fd6ec83519c9e912e0abc27d4509c1dbee13f90e7de715e215817865e86bc6"
},
"downloads": -1,
"filename": "querysource-3.12.32-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "6271646f10d40db79dfec4dff7dd76d8",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.9.16",
"size": 5283431,
"upload_time": "2024-11-09T00:05:37",
"upload_time_iso_8601": "2024-11-09T00:05:37.640707Z",
"url": "https://files.pythonhosted.org/packages/3f/ad/82e7c058100f1b09d628f8fc7ee3dce75b962f6c6d821570cbdc16256d0d/querysource-3.12.32-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "8420d79d4d26f4ff8990857e4b0760aac9cdae067555f50042d0b5cba3d14b5b",
"md5": "f0eb13843cdfe1731618ed268319f4d2",
"sha256": "7cc750041c6f6b477b261c317b427e8cb15e80784c6154e2cc2e98fd5a68aff8"
},
"downloads": -1,
"filename": "querysource-3.12.32-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "f0eb13843cdfe1731618ed268319f4d2",
"packagetype": "bdist_wheel",
"python_version": "cp312",
"requires_python": ">=3.9.16",
"size": 5731324,
"upload_time": "2024-11-09T00:05:39",
"upload_time_iso_8601": "2024-11-09T00:05:39.253737Z",
"url": "https://files.pythonhosted.org/packages/84/20/d79d4d26f4ff8990857e4b0760aac9cdae067555f50042d0b5cba3d14b5b/querysource-3.12.32-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "74c98d7c4be7b141ca5603184403da70a1a42882b38939bdfa5b75f1fc2ca5dd",
"md5": "128e86458bebc46f160e6efd91eb5706",
"sha256": "18b257a14e81c8ad613f3d40def07b87f55557134a0e86393f3e0f657ce2ee1f"
},
"downloads": -1,
"filename": "querysource-3.12.32-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "128e86458bebc46f160e6efd91eb5706",
"packagetype": "bdist_wheel",
"python_version": "cp39",
"requires_python": ">=3.9.16",
"size": 5034719,
"upload_time": "2024-11-09T00:05:41",
"upload_time_iso_8601": "2024-11-09T00:05:41.357209Z",
"url": "https://files.pythonhosted.org/packages/74/c9/8d7c4be7b141ca5603184403da70a1a42882b38939bdfa5b75f1fc2ca5dd/querysource-3.12.32-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-09 00:05:35",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "phenobarbital",
"github_project": "querysource",
"github_not_found": true,
"lcname": "querysource"
}
JSON
