Skip to main content

common code for DBs

Project description

https://api.codacy.com/project/badge/Grade/4d85afc6c49f40eab14f9aa60336ac64 https://img.shields.io/badge/Contributor%20Covenant-v2.0%20adopted-ff69b4.svg

Equinox Common Code Utility for Python 3 for DB interactions! There are currently interaction classes for the following DBs and Apps:

  • MSSQL
  • MySQL
  • SQLite
  • Postgres
  • Redshift

Quick Start

Sample Usage

from datacoco_db import MSSQLInteraction

mssql = MSSQLInteraction(dbname="db_name",
                        host="server",
                        user="user",
                        password="password",
                        port=1433)

mssql.conn() # open a connection

mssql.batch_open() # cursor

results = mssql.fetch_sql_one("SELECT * FROM MyTable") # fetch one

print(results)

mssql.batch_close() # close cursor

The example above makes use of mssql_tools. All tools follows the same pattern in terms of usage.

Installation

datacoco-db requires Python 3.6+

python3 -m venv <virtual env name>
source <virtual env name>/bin/activate
pip install datacoco-db

Development

Getting Started

It is recommended to use the steps below to set up a virtual environment for development:

python3 -m venv <virtual env name>
source <virtual env name>/bin/activate
pip install -r requirements.txt

Testing

pip install -r requirements-dev.txt

Modify the connection configuration for integration testing.

To run the testing suite, simply run the command: python -m unittest discover tests

For coverage report, run tox View the results in .tox/coverage/index.html

Contributing

Contributions to datacoco_db are welcome!

Please reference guidelines to help with setting up your development environment here.

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 datacoco-db, version 0.1.3
Filename, size File type Python version Upload date Hashes
Filename, size datacoco-db-0.1.3.tar.gz (12.8 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page