dbConnect: Database for Humans
WHY?
dbConnect was made as a little module to be used in small projects that need to do some interactions with MySQL or PostgreSQL databases.
It’s just a big time saver for developers specially for making data analyzing and data scraping and it helps to keep your code clean and readable by using python-like structure.
Installation
requirements:
dbConnect uses mysql.connector and mysqlclient modules for mysql, install one of them using:
$ apt-get install python3-mysql.connector
$ apt-get install python-mysql.connector
Or using offical site: https://dev.mysql.com/downloads/connector/python/
$ pip install mysqlclient
More details on mysqlclient: https://github.com/PyMySQL/mysqlclient-python
For PostgreSQL install psycopg2 module:
$ pip install psycopg2
using pip:
$ pip install dbConnect
from source code:
$ git clone git@gitlab.com:mastizada/dbConnect.git
$ cd dbConnect
$ sudo python setup.py install
Usage
Importing and making a connection:
>>> from dbConnect import DBConnect
>>> database = DBConnect(credentials.json)
>>> database.fetch('tableName', limit=5, filters={'company': 'pyninjas'})
Documentation
Alternate Docs: https://pythonhosted.org/dbConnect/
Check generated documentation using:
$ pydoc3 dbConnector
$ pydoc3 -p 8000and open http://localhost:8000/ in browser
Enjoy
Release files for dbConnect 2.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| dbConnect-2.1.tar.gz | 6.3 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| dbConnect-2.1-py2.py3-none-any.whl | Python 3, Python 2 | none | any | Details |
Total release size: 18.4 kB
Release files / dbConnect-2.1.tar.gz
| Download URL | dbConnect-2.1.tar.gz |
|---|---|
| Size | 6.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
bcbcf71000d705bb85c4a80c0fe27d5bed3432d8c6040cb646da279d9eed15fd
|
|
BLAKE2b-256 checksum How to use checksums |
0f77426037a43714786b64dd150da245ee23bd698cf37f74a6768d9a822b2f05
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Release files / dbConnect-2.1-py2.py3-none-any.whl
| Download URL | dbConnect-2.1-py2.py3-none-any.whl |
|---|---|
| Size | 12.1 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
0668869e28a558d4c9554053cca821208f0c0792cbe24aede246a434c60b97a9
|
|
BLAKE2b-256 checksum How to use checksums |
c0407bf772af9251c9095d3ceeef46580255b8ad68e119dd3d3825134e54a01b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |