Access to ACE Databases
Project description
acesql_pypi
This is an project to allow users to have access to databases on ACE platform.
Usage
from acesql import writeSQL
## Parameters
# df: spark dataframe which cantains the data
# url: jdbc url - i.e: jdbc:sqlserver://url:portnumber
# database: Name of the database to write - i.e.: ace-db
# dbtable: schema and abd the name of the table - i.e.: dbo.dbs
# username: Username of the database
# password: Password of the user
writeSQL(df, url, database, dbtable, username, password)
from acesql import readSQL
# url: jdbc url - i.e: jdbc:sqlserver://url:portnumber
# database: Name of the database to write - i.e.: ace-db
# dbtable: schema and abd the name of the table - i.e.: dbo.dbs
# username: Username of the database
# password: Password of the user
def readSQL(url, database, dbtable, username, password):
Developing
To onstall acesqlm along with the tools you need to develop and run tests, run the following in your vistualenv:
pip install -e .[dev]
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
acesql-0.1.6.tar.gz
(2.7 kB
view details)
Built Distribution
File details
Details for the file acesql-0.1.6.tar.gz
.
File metadata
- Download URL: acesql-0.1.6.tar.gz
- Upload date:
- Size: 2.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.2 importlib_metadata/4.8.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.2 CPython/3.9.6
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9e4a10bf301b87ae7da68d6dd15a90dbe4d01d6c62328826372b54719144f25b |
|
MD5 | 1b2b8549a19da0882942e3ccd83336da |
|
BLAKE2b-256 | 2795c45cdd945964c37e04b3c73b286450d30d6797ec675f0b4f6f38194faaba |
File details
Details for the file acesql-0.1.6-py3-none-any.whl
.
File metadata
- Download URL: acesql-0.1.6-py3-none-any.whl
- Upload date:
- Size: 3.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.2 importlib_metadata/4.8.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.2 CPython/3.9.6
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2eccf6b7ab708bf973a7e99394d845e9eb231bea37b676c3908bfecf0e54e666 |
|
MD5 | c982936e328e62aa70bab87c2131964a |
|
BLAKE2b-256 | c14fb4d4c3183da1a6e166bd0e45481acece6256125cb1559bce1573b59d101d |