acesql

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]