myodbc-fr8train 1.0.0

Refactoring of typical ODBC handling for myodbcSQL18

myodbc

By fr8train-sv

A refactored facade for ODBC connections.

  pip install myodbc-fr8train

Upgrade this specific library by running:

  pip install --upgrade myodbc-fr8train

Important Commands

The following list of commands are important for project maintenance.

Building the Library

To build the library, ensure that the necessary build tools are installed in your environment. This can be done by installing setuptools, build, and wheel:

  pip install build twine setuptools wheel

twine can also be installed here while we're installing shit since we'll need it later.

REMEMBER: INCREMENT YOUR VERSION NUMBER IN THE TOML BEFORE BUILDING.

REMEMBER: REMOVE THE /DIST DIRECTORY BEFORE BUILDING FOR A CLEAN BUILD

Now, you can create the distribution files (source distribution and wheel) using the following command:

  python3 -m build

This will generate builds in the dist/ directory.

Deploying to PyPI

Ensure you have a valid PyPI account and credentials added to your .pypirc file or provide them during the publish process. Then, upload your package to PyPI with:

  python3 -m twine upload dist/*

Follow any prompts from twine to successfully upload your package. Once deployed, your package will be available on PyPI.

Usage

Initialization

To start using the API SDK, you will need to initialize an API object:

from myodbc.myodbc import MyODBC

my = MyODBC(override=True)

This will reach out into your project for a .env file for credentials to establish a connection to the Agilix API Gateway. Structure your .env file like the example below and maintain it at the root of your project directory.

SQL_HOST=
SQL_PORT=
SQL_USER=
SQL_PASSWORD=
SQL_DATABASE=