common code for DBs
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
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
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.