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.

Files for dbConnect, version 2.1
Filename, size File type Python version Upload date Hashes
Filename, size dbConnect-2.1-py2.py3-none-any.whl (12.1 kB) File type Wheel Python version py2.py3 Upload date Hashes View
Filename, size dbConnect-2.1.tar.gz (6.3 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page