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 hashes)
Built Distribution
acesql-0.1.6-py3-none-any.whl
(3.0 kB
view hashes)