datacoco-db 0.1.6

Data common code for database interactions by Equinox

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

Pyodbc Dependency Installation

Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15

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.