Data common code for database interactions by Equinox
Project description
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.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
