aktin / aktin/aktin-scripts

Add usability features to migration scripts

Open
#11 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Shell
Stars
0
Forks
0
PR merge metrics
No merged PRs in 30d

Description

Especially while migrating large databases, the scripts have no user feedback implemented. If the data warehouse host interrupts there will be no feedback. Additionally it is helpful to have a approximation of calculation time.

## Task: Add a loading feature

Display loading progresses for each individual step and
display the overall progress (search for a progress marker that works for postgres as well)

There are apt libraries that can be used, like **pv (pipe viewer)**, to show progress by file size:
```
# install pipe viewer
sudo apt-get install pv

# example usage
sudo docker exec -i "$docker_db_container" \
bash -c "pv /backup/backup_i2b2.sql | psql -U postgres -d i2b2 -q"
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.