dbConnect

dbConnect: Database for Humans

https://travis-ci.org/mastizada/dbConnect.svg?branch=master

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

Docs: http://dbconnect.readthedocs.org/
Alternate Docs: https://pythonhosted.org/dbConnect/
Check generated documentation using:
```
$ pydoc3 dbConnect
```
or
```
$ pydoc3 -p 8000
```
and open http://localhost:8000/ in browser

Enjoy

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbConnect-2.1.tar.gz (6.3 kB view details)

Uploaded Jun 14, 2018 Source

Built Distribution

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

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

dbConnect-2.1-py2.py3-none-any.whl (12.1 kB view details)

Uploaded Jun 14, 2018 Python 2Python 3

File details

Details for the file dbConnect-2.1.tar.gz.

File metadata

Download URL: dbConnect-2.1.tar.gz
Upload date: Jun 14, 2018
Size: 6.3 kB
Tags: Source
Uploaded using Trusted Publishing? No

File hashes

Hashes for dbConnect-2.1.tar.gz
Algorithm	Hash digest
SHA256	`bcbcf71000d705bb85c4a80c0fe27d5bed3432d8c6040cb646da279d9eed15fd`
MD5	`7418d5378bb4995e55ef542df957c774`
BLAKE2b-256	`0f77426037a43714786b64dd150da245ee23bd698cf37f74a6768d9a822b2f05`

See more details on using hashes here.

File details

Details for the file dbConnect-2.1-py2.py3-none-any.whl.

File metadata

Download URL: dbConnect-2.1-py2.py3-none-any.whl
Upload date: Jun 14, 2018
Size: 12.1 kB
Tags: Python 2, Python 3
Uploaded using Trusted Publishing? No

File hashes

Hashes for dbConnect-2.1-py2.py3-none-any.whl
Algorithm	Hash digest
SHA256	`0668869e28a558d4c9554053cca821208f0c0792cbe24aede246a434c60b97a9`
MD5	`b7845ffd2bf51a4ad506481ebac2297a`
BLAKE2b-256	`c0407bf772af9251c9095d3ceeef46580255b8ad68e119dd3d3825134e54a01b`