Database for Humans
Project description
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 module for mysql, install it using:
$ apt-get install python3-mysql.connector
$ apt-get install python-mysql.connector
Or using offical site: https://dev.mysql.com/downloads/connector/python/
For PostgreSQL install psycopg2 module:
$ pip install psycopg2
using pip:
$ pip install dbConnect
from source code:
$ git clone git@github.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 dbConnect
or
$ pydoc3 -p 8000
and open http://localhost:8000/ in browser
Enjoy
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for dbConnect-2.0.1-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | af30cd76941d7dd56a14d0a3a124e8cdf5d25ed4c0e1a5c89f9c95d208bea2cc |
|
MD5 | 653edbcd8f10b1ee0b7357500d20ce45 |
|
BLAKE2b-256 | 5a0a04e5f8b8131c496a6cd31355be9cfbf94b1fdf4a3635c736fba1e4c16416 |