- MySQL
- MSSQL(SQL Server)
- MariaDB
- MySQL
- MariaDB
- MSSQL
- SQLAlchemy
- MySQL
- MariaDB
pip install integ-db
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()
- duplicate SQLalchemy Github : https://gist.github.com/tombohub/0c666583c48c1686c736ae2eb76cb2ea