integdb

This package Integrated Database library, based on PyMySQL, pymssql, mariadb, SQLAlchemy.

Requirements

MySQL
MSSQL(SQL Server)
MariaDB

Controller Object

MySQL
MariaDB
MSSQL
SQLAlchemy

Object that provides a pool

MySQL
MariaDB

Special Feature

The SQLAlchemy sql_export(to_sql) function support duplicate keys

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()

Reference

duplicate SQLAlchemy Github : https://gist.github.com/tombohub/0c666583c48c1686c736ae2eb76cb2ea

Metadata

Release files for integ-db 0.1.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for integ-db 0.1.1
File	Size	Uploaded
integ_db-0.1.1.tar.gz	5.4 kB	Apr 17, 2024	Details

Built distribution (wheel)

Table of built distributions (wheels) for integ-db 0.1.1
File	Interpreter	ABI	Platform	Reset
integ_db-0.1.1-py3-none-any.whl 7.1 kB Apr 17, 2024	Python 3	none	any	Details

Total release size: 12.5 kB

Release files / integ_db-0.1.1.tar.gz

Download URL	integ_db-0.1.1.tar.gz
Size	5.4 kB
Tags	Source
SHA-256 checksum How to use checksums	`b2dde2d0319bc87c9cf68000a07d8341505d07a48f0a42611e5cc932a91895dd`
BLAKE2b-256 checksum How to use checksums	`0170564d379b470ed57ef1b0d19b8f544ab503a15ed9e546e0ac3e247def10b6`
Upload date	Apr 17, 2024
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/5.0.0 CPython/3.10.11`

Release files / integ_db-0.1.1-py3-none-any.whl

Download URL	integ_db-0.1.1-py3-none-any.whl
Size	7.1 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`4c29dea8915148380de65488260cd019c3ada247aae22cd8a442dd339cf23775`
BLAKE2b-256 checksum How to use checksums	`5f878b66afaee723997868677eccab344dc9306353555d68f97210311fcb5eae`
Upload date	Apr 17, 2024
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/5.0.0 CPython/3.10.11`