This package Integrated Database library
Project description
integdb
This package Integrated Database library, based on PyMySQL, pymssql, mariadb, SQLAlchemy.
Requirements
- MySQL
- MSSQL(SQL Server)
- MaridDB
Controller Object
- MySQL
- MaridDB
- MSSQL
- SQLAlchemy
Object that provides a pool
- MySQL
- MariaDB
Install
From PIP
pip install integ-db
Example
from integdb import Controller
host = "localhost"
user = "usrname"
password = "password"
port = 3306
schema = "database_name"
controller = Controller(
host=host,
user=user,
password=password,
port=port,
schema=schema,
connection_pool=False)
try:
controller.MySQL.connect()
sql_context = "SELECT * FROM TEST_DB"
rows = controller.MySQL.sql_executer(sql_context)
print (rows)
except Exception as e:
print (e)
finally:
controller.MySQL.close()
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.
Source Distribution
integ-db-0.0.7.tar.gz
(4.6 kB
view hashes)