dbConnect: MySQL for Humans

Installation

requirements:

dbConnect uses mysql.connector module, 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/

using pip:

$ pip install dbConnect

from source code:

$ git clone git@github.com:mastizada/dbConnect.git
$ cd dbConnect
$ sudo pip install -r requirements.txt --allow-external mysql-connector-python
$ 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/

• Another Docs: https://pythonhosted.org/dbConnect/

• Check generated documentation using:

  $ pydoc3 dbConnect

  or

  $ pydoc3 -p 1994

  and open localhost:1994/ in browser

Enjoy