Skip to main content

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


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)

Uploaded Source

Built Distribution

acesql-0.1.6-py3-none-any.whl (3.0 kB view details)

Uploaded Python 3

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

Hashes for acesql-0.1.6.tar.gz
Algorithm Hash digest
SHA256 9e4a10bf301b87ae7da68d6dd15a90dbe4d01d6c62328826372b54719144f25b
MD5 1b2b8549a19da0882942e3ccd83336da
BLAKE2b-256 2795c45cdd945964c37e04b3c73b286450d30d6797ec675f0b4f6f38194faaba

See more details on using hashes here.

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

Hashes for acesql-0.1.6-py3-none-any.whl
Algorithm Hash digest
SHA256 2eccf6b7ab708bf973a7e99394d845e9eb231bea37b676c3908bfecf0e54e666
MD5 c982936e328e62aa70bab87c2131964a
BLAKE2b-256 c14fb4d4c3183da1a6e166bd0e45481acece6256125cb1559bce1573b59d101d

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page