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

$ pip install querysource
---> 100%
Successfully installed querysource

Requirements

Basic Usage

QuerySource can be used in several ways, one is using QS object itself:

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.

Project links

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Newer release available (4.5.11)

2 maintainers

PyPI data
Data sourced directly from PyPI's database.
Avatar for jelitox from gravatar.com jelitox Avatar for phenobarbital from gravatar.com phenobarbital

Credits

PyPI data
Data sourced directly from PyPI's database.

Author: Jesus Lara

License

BSD License (BSD-3-Clause)

Requires

Python >=3.10.1

Provides Extra

analytics vectors sharepoint s3 dev

Tags

querysource database query aiohttp web service

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

querysource-4.5.1.tar.gz (3.2 MB view details)

Uploaded Source

Built Distributions

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

querysource-4.5.1-cp313-cp313-musllinux_1_2_x86_64.whl (13.8 MB view details)

Uploaded CPython 3.13musllinux: musl 1.2+ x86-64

querysource-4.5.1-cp313-cp313-manylinux_2_28_x86_64.whl (13.8 MB view details)

Uploaded CPython 3.13manylinux: glibc 2.28+ x86-64

querysource-4.5.1-cp312-cp312-musllinux_1_2_x86_64.whl (13.9 MB view details)

Uploaded CPython 3.12musllinux: musl 1.2+ x86-64

querysource-4.5.1-cp312-cp312-manylinux_2_28_x86_64.whl (13.9 MB view details)

Uploaded CPython 3.12manylinux: glibc 2.28+ x86-64

querysource-4.5.1-cp311-cp311-musllinux_1_2_x86_64.whl (13.7 MB view details)

Uploaded CPython 3.11musllinux: musl 1.2+ x86-64

querysource-4.5.1-cp311-cp311-manylinux_2_28_x86_64.whl (13.6 MB view details)

Uploaded CPython 3.11manylinux: glibc 2.28+ x86-64

querysource-4.5.1-cp310-cp310-musllinux_1_2_x86_64.whl (12.9 MB view details)

Uploaded CPython 3.10musllinux: musl 1.2+ x86-64

querysource-4.5.1-cp310-cp310-manylinux_2_28_x86_64.whl (12.8 MB view details)

Uploaded CPython 3.10manylinux: glibc 2.28+ x86-64

File details

Details for the file querysource-4.5.1.tar.gz.

File metadata

  • Download URL: querysource-4.5.1.tar.gz
  • Upload date:
  • Size: 3.2 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.12.3

File hashes

Hashes for querysource-4.5.1.tar.gz
Algorithm Hash digest
SHA256 6abff8704c5aaeaa89f9e0af4aaf0886d2c7656a12550457c5f46d36ff57469e
MD5 cda2400cf25de0c3535f3b146232d5f3
BLAKE2b-256 595e7ad1792a65a0f6958eaa65a815a1b1bec222e3068606b53229f2eca52d18

See more details on using hashes here.

File details

Details for the file querysource-4.5.1-cp313-cp313-musllinux_1_2_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.1-cp313-cp313-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 8ea9c8db9e0f47a5f2adb0d1d1e67718537d0f55a55fc4fcc4854550a5fdc565
MD5 16649700ccef1951b3d8e2535ba547a9
BLAKE2b-256 e34b219afda1977a512a8c8c71327674663ec3b8eee3d5e7feceb61f29d67371

See more details on using hashes here.

File details

Details for the file querysource-4.5.1-cp313-cp313-manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.1-cp313-cp313-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 e9c8d8fdc7c97334de47fbc79468fb02bb4ead0c9b062f38c0107fdaa29a9e58
MD5 c60db4c65d2c6885e7f19f56651a7b87
BLAKE2b-256 9b924c934482d12a5c818a669bd4c306efd3439d1c9993126628de0923e7ef10

See more details on using hashes here.

File details

Details for the file querysource-4.5.1-cp312-cp312-musllinux_1_2_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.1-cp312-cp312-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 e93437cbd881092413dd2d49078d218523e545c781d2becb6b194a7cfe47f053
MD5 c883811dcc6fe4d9f3e253bb70e5b7ab
BLAKE2b-256 344dad3b4f55d58342e332d7d5c843060b2061c7ebd8ee33d7d954ea5840ce60

See more details on using hashes here.

File details

Details for the file querysource-4.5.1-cp312-cp312-manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.1-cp312-cp312-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 1e82e90aec8efff65c0bb9563786cc7463b22d1640f4d9d25a5afe0abb5c0f81
MD5 3b495144cfc72bb864d36dfe6e97a284
BLAKE2b-256 6de45b54ac41bf0b4ecc7ca2f95276725a20b4f014e296c5a30ad8c6fb40b376

See more details on using hashes here.

File details

Details for the file querysource-4.5.1-cp311-cp311-musllinux_1_2_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.1-cp311-cp311-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 ebd02e59f9d9f6a15cce48b47b8f559b1e237fed5066e88b2c3895903dd58959
MD5 7e90cba4d5cca57606be66504672c27c
BLAKE2b-256 e1db8cfa3eca755d41d80abe7c43b149728b004d6e2dfe2c46b864910a6b81e1

See more details on using hashes here.

File details

Details for the file querysource-4.5.1-cp311-cp311-manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.1-cp311-cp311-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 807d6581bf09c62af22c790a763d664b60020d5b3db0e669f6d6e8eca797566d
MD5 fddb522a22080a3034e253c2fd581903
BLAKE2b-256 9ffe91204d479c623685741b8c3117883c35256db4bf92b91163282dd13eb2da

See more details on using hashes here.

File details

Details for the file querysource-4.5.1-cp310-cp310-musllinux_1_2_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.1-cp310-cp310-musllinux_1_2_x86_64.whl
Algorithm Hash digest
SHA256 f43f2573550dcd55772588b011177b278fc215a19680bff6ec4d8189c1f62f78
MD5 b7bd33f6bcfda76001774bb247bef0c2
BLAKE2b-256 b5e128469f05474a2c4c2ebf49ae53ff00881592b26a5ca1b108db9b7d90db99

See more details on using hashes here.

File details

Details for the file querysource-4.5.1-cp310-cp310-manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for querysource-4.5.1-cp310-cp310-manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 a1b3505d1bc2835f4dd23bdc7fb39c6349b566ba0e2fb5afe2436e49f1ca4448
MD5 88f148f4843f9d2ecc6b1111dcdbcacb
BLAKE2b-256 1b5ed6904aed0e5166f986fb65d4d385ee9d905894e964d488e01d84bfae8874

See more details on using hashes here.

Release history Release notifications | RSS feed

4.5.11

4.5.10

4.5.9

4.5.8

4.5.7

4.5.6

4.5.5

4.5.4

This release

4.5.1

4.5.0

4.4.3

4.4.2

4.4.0

4.3.0

4.2.1

4.2.0

4.1.12

4.1.11

4.1.10

4.1.9

4.1.7

4.1.6

4.1.5

4.1.4

4.1.3

4.1.2

4.1.1

4.1.0

4.0.2

4.0.1

4.0.0

4.0.0rc1 pre-release

3.17.11

3.17.10

3.17.9

3.17.8

3.17.7

3.17.6

3.17.5

3.17.4

3.17.3

3.17.2

3.17.1

3.17.0

3.16.9

3.16.8

3.16.7

3.16.6

3.16.5

3.16.4

3.16.3

3.16.2

3.16.1

3.15.43

3.15.42

3.15.41

3.15.40

3.15.39

3.15.38

3.15.37

3.15.36

3.15.35

3.15.34

3.15.33

3.15.32

3.15.31

3.15.30

3.15.29

3.15.28

3.15.27

3.15.26

3.15.25

3.15.24

3.15.23

3.15.22

3.15.21

3.15.20

3.15.19

3.15.18

3.15.17

3.15.16

3.15.15

3.15.14

3.15.12

3.15.11

3.15.10

3.15.9

3.15.8

3.15.7

3.15.6

3.15.5

3.15.4

3.15.3

3.15.2

3.15.1

3.15.0

3.14.1

3.14.0

3.13.15

3.13.14

3.13.13

3.13.12

3.13.11

3.13.10

3.13.9

3.13.8

3.13.6

3.13.5

3.13.4

3.13.3

3.13.2

3.13.1

3.13.0

3.12.33

3.12.32

3.12.31

3.12.30

3.12.29

3.12.28

3.12.27

3.12.26

3.12.25

3.12.24

3.12.23

3.12.22

3.12.20

3.12.19

3.12.18

3.12.17

3.12.16

3.12.15

3.12.14

3.12.13

3.12.12

3.12.11

3.12.10

3.12.9

3.12.8

3.12.7

3.12.6

3.12.5

3.12.4

3.12.3

3.12.2

3.12.1

3.11.23

3.11.22

3.11.21

3.11.20

3.11.18

3.11.17

3.11.16

3.11.15

3.11.14

3.11.13

3.11.12

3.11.11

3.11.10

3.11.9

3.11.8

3.11.7

3.11.6

3.11.5

3.11.4

3.11.3

3.11.2

3.11.1

3.11.0

3.10.2

3.10.1

3.10.0

3.9.3

3.9.2

3.9.1

3.9.0

3.8.14

3.8.13

3.8.12

3.8.11

3.8.10

3.8.9

3.8.8

3.8.7

3.8.6

3.8.5

3.8.4

3.8.3

3.8.2

3.8.1

3.8.0

3.7.13

3.7.12

3.7.11

3.7.10

3.7.9

3.7.8

3.7.7

3.7.6

3.7.5

3.7.4

3.7.3

3.7.2

3.7.1

3.7.0

3.6.53

3.6.52

3.6.51

3.6.50

3.6.49

3.6.48

3.6.47

3.6.46

3.6.45

3.6.44

3.6.43

3.6.42

3.6.41

3.6.39

3.6.38

3.6.37

3.6.36

3.6.35

3.6.34

3.6.33

3.6.32

3.6.31

3.6.30

3.6.28

3.6.27

3.6.26

3.6.25

3.6.24

3.6.23

3.6.22

3.6.21

3.6.20

3.6.18

3.6.17

3.6.16

3.6.15

3.6.14

3.6.13

3.6.11

3.6.9

3.6.8

3.6.7

3.6.6

3.6.5

3.6.4

3.6.3

3.6.2

3.6.1

3.6.0

Supported by

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