For AFS developer to access Datasource
Project description
AFS2-DataSource SDK
The AFS2-DataSource SDK package allows developers to easily access PostgreSQL, MongoDB, InfluxDB.
Installation
Support Pyton version 3.6 or later
pip install afs2-datasource
Example
Database config
Database config from environment variable.
Export database config on command line.
export PAI_DATA_DIR="{"type": "mongo-firehose","data": {"dbType": "internal","querySql": "{QUERY_STRING}","collection": "{COLLECTION_NAME}","credential": {"username": "{DB_USERNAME}","password": "{DB_PASSWORD}","database": "{DB_NAME}","port": {DB_PORT},"host": "{DB_HOST}"}}}"
Export database config via Python
os.environ['PAI_DATA_DIR'] = {
"type": "mongo-firehose",
"data": {
"dbType": "internal",
"querySql": "{QUERY_STRING}",
"collection": "{COLLECTION_NAME}",
"credential": {
"username": "{DB_USERNAME}",
"password": "{DB_PASSWORD}",
"database": "{DB_NAME}",
"port": {DB_PORT},
"host": "{DB_HOST}"
}
}
}
DBManager Example
from afs2datasource import DBManager
# Init DBManager
manager = DBManager()
# Connect DB
manager.connect()
# Execute querySql in DB config
data = manager.execute_query()
# Return type: DataFrame
"""
Age Cabin Embarked Fare ... Sex Survived Ticket_info Title2
0 22.0 7.0 2.0 7.2500 ... 1.0 0.0 2.0 2.0
1 38.0 2.0 0.0 71.2833 ... 0.0 1.0 14.0 3.0
2 26.0 7.0 2.0 7.9250 ... 0.0 1.0 31.0 1.0
3 35.0 2.0 2.0 53.1000 ... 0.0 1.0 36.0 3.0
4 35.0 7.0 2.0 8.0500 ... 1.0 0.0 36.0 2.0
...
"""
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
afs2-datasource-2.1.14.tar.gz
(3.9 kB
view hashes)
Built Distribution
Close
Hashes for afs2_datasource-2.1.14-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 706f9ebfbfb95d09889f8681ce4cca8caeb1872c9256ef3d638c2218a9ef6aba |
|
MD5 | 2de1a63cb48b8582788138b2882ae7d5 |
|
BLAKE2b-256 | 24cee665536369f465c931ee2c7f24062211c3281b7bb9c22f3fac7848867814 |