Skip to main content

Database for Humans

Project description

dbConnect: Database for Humans

Documentation Status https://travis-ci.org/mastizada/dbConnect.svg?branch=master Code Health

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

Enjoy

Project details


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 hashes)

Uploaded source

Built Distribution

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

Uploaded py2 py3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page