datacoco-db¶
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