DesignSafe relational database connection scripts
Project description
DS Database
dsdatabase
is a library that simplifies accessing databases on DesignSafe via Jupyter Notebooks.
Features
Connects to SQL databases on DesignSafe:
Database | dbname | env_prefix |
---|---|---|
NGL | ngl |
NGL_ |
Earthake Recovery | eq |
EQ_ |
Vp | vp |
VP_ |
Define the following environment variables:
{env_prefix}DB_USER
{env_prefix}DB_PASSWORD
{env_prefix}DB_HOST
{env_prefix}DB_PORT
For e.g., to add the environment variable NGL_DB_USER
edit ~/.bashrc
, ~/.zshrc
, or a similar shell-specific configuration file for the current user and add export NGL_DB_USER="dspublic"
.
Installation
Install dsdatabase
via pip
pip3 install dsdatabase
To install the current development version of the library use:
pip install git+https://github.com/DesignSafe-CI/dsdatabase.git --quiet
Example usage:
from dsdatabase.db import DSDatabase
db = DSDatabase("ngl")
sql = 'SELECT * FROM SITE'
df = db.read_sql(sql)
print(df)
# Optionally, close the database connection when done
db.close()
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
dsdatabase-0.1.0.tar.gz
(3.7 kB
view hashes)
Built Distribution
Close
Hashes for dsdatabase-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0107f7a43bd413fa22e40578b96bfcc391dbd4752ec33261533a72a0014d7536 |
|
MD5 | 3fe62a184e98ef49d539c66b53472b53 |
|
BLAKE2b-256 | d7f11227c131853972e3567801efde6ab7d24fca50c82bce0a3d66cf25038b9b |