connector database
Project description
connector_db_tools
connector_db_tools is a Python library that implements for connection databases
Installation
The code is packaged for PyPI, so that the installation consists in running:
pip install spark-datax-schema-tools
Usage
wrapper take connection database using pandas and modin
example1: (generate dummy_data)
================================
import ray
import os
from connector_db_tools import Core
ray.shutdown()
ray.init(local_mode=True)
""""config.json
{"ORACLE":{
"oracle":{
"host":"XXXXXX",
"port":1521,
"db":"XXXXXX",
"username":"XXXXX",
"password":"XXXXX",
"driver":"{Microsoft ODBC for Oracle}"
}
}
""""
path = os.getcwd()
path_file_config = os.path.join(path, "config.json")
df = Core.database_query(file_config=path_file_config,
server="oracle",
database="oracle",
query=query,
is_sql_direct=False)
df.head(10)
License
New features v1.0
BugFix
- choco install visualcpp-build-tools
Reference
- Jonathan Quiza github.
- Jonathan Quiza RumiMLSpark.
- Jonathan Quiza linkedin.
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
Built Distribution
Close
Hashes for connector_db_tools-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b2c50675b07d7aae0c605673c56d26e345585858d68c1622a9385fa83158c8cb |
|
MD5 | 2333b96d3ff418c0c8eecd8571c6b818 |
|
BLAKE2b-256 | cca323742a4041112a1b00535ce71c2a1e203724558b12218e4fe1ede878eb72 |