# 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
1. duplicate SQLAlchemy
Github : https://gist.github.com/tombohub/0c666583c48c1686c736ae2eb76cb2ea
Raw data
{
"_id": null,
"home_page": "https://github.com/Byeongin-Jeong/integdb",
"name": "integ-db",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": null,
"keywords": "mysql, mssql, mariadb, python db, python database, integrate database, sqlalchemy",
"author": "byeongin.jeong",
"author_email": "jbi0214@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/01/70/564d379b470ed57ef1b0d19b8f544ab503a15ed9e546e0ac3e247def10b6/integ_db-0.1.1.tar.gz",
"platform": null,
"description": "# integdb\r\n### This package Integrated Database library, based on PyMySQL, pymssql, mariadb, SQLAlchemy.\r\n\r\n#### Requirements\r\n- MySQL\r\n- MSSQL(SQL Server)\r\n- MariaDB\r\n\r\n#### Controller Object\r\n- MySQL\r\n- MariaDB\r\n- MSSQL\r\n- SQLAlchemy\r\n\r\n#### Object that provides a pool\r\n- MySQL\r\n- MariaDB\r\n\r\n## Special Feature\r\n- The SQLAlchemy sql_export(to_sql) function support duplicate keys\r\n\r\n## Install\r\n#### From PIP\r\n```\r\npip install integ-db\r\n```\r\n## Example\r\n```\r\nfrom integdb import Controller\r\n\r\nhost = \"localhost\"\r\nuser = \"usrname\"\r\npassword = \"password\"\r\nport = 3306\r\nschema = \"database_name\"\r\ncontroller = Controller(\r\n host=host,\r\n user=user,\r\n password=password,\r\n port=port,\r\n schema=schema,\r\n connection_pool=False)\r\ntry:\r\n controller.MySQL.connect()\r\n sql_context = \"SELECT * FROM TEST_DB\"\r\n rows = controller.MySQL.sql_executer(sql_context)\r\n print (rows)\r\nexcept Exception as e:\r\n print (e)\r\nfinally:\r\n controller.MySQL.close()\r\n```\r\n\r\n---\r\n## Reference\r\n1. duplicate SQLAlchemy \r\nGithub : https://gist.github.com/tombohub/0c666583c48c1686c736ae2eb76cb2ea\r\n",
"bugtrack_url": null,
"license": null,
"summary": "This package Integrated Database library",
"version": "0.1.1",
"project_urls": {
"Bug Tracker": "https://github.com/Byeongin-Jeong/integdb/issues",
"Homepage": "https://github.com/Byeongin-Jeong/integdb"
},
"split_keywords": [
"mysql",
" mssql",
" mariadb",
" python db",
" python database",
" integrate database",
" sqlalchemy"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "5f878b66afaee723997868677eccab344dc9306353555d68f97210311fcb5eae",
"md5": "f17666b4de239cd36acf93b138654f4a",
"sha256": "4c29dea8915148380de65488260cd019c3ada247aae22cd8a442dd339cf23775"
},
"downloads": -1,
"filename": "integ_db-0.1.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "f17666b4de239cd36acf93b138654f4a",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.6",
"size": 7052,
"upload_time": "2024-04-17T08:32:26",
"upload_time_iso_8601": "2024-04-17T08:32:26.455520Z",
"url": "https://files.pythonhosted.org/packages/5f/87/8b66afaee723997868677eccab344dc9306353555d68f97210311fcb5eae/integ_db-0.1.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "0170564d379b470ed57ef1b0d19b8f544ab503a15ed9e546e0ac3e247def10b6",
"md5": "5256c280bbe6356d8570d34b13be9683",
"sha256": "b2dde2d0319bc87c9cf68000a07d8341505d07a48f0a42611e5cc932a91895dd"
},
"downloads": -1,
"filename": "integ_db-0.1.1.tar.gz",
"has_sig": false,
"md5_digest": "5256c280bbe6356d8570d34b13be9683",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 5428,
"upload_time": "2024-04-17T08:32:27",
"upload_time_iso_8601": "2024-04-17T08:32:27.574297Z",
"url": "https://files.pythonhosted.org/packages/01/70/564d379b470ed57ef1b0d19b8f544ab503a15ed9e546e0ac3e247def10b6/integ_db-0.1.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-04-17 08:32:27",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "Byeongin-Jeong",
"github_project": "integdb",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "integ-db"
}
JSON
