update database update #620
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: ci frontend | |
on: | |
push: | |
branches: [main] | |
pull_request: | |
branches: [main] | |
jobs: | |
test_frontend: | |
runs-on: ubuntu-20.04 | |
services: | |
mysql: | |
image: mysql:5.7 | |
env: | |
MYSQL_ALLOW_EMPTY_PASSWORD: yes | |
MYSQL_USER: test_user | |
MYSQL_PASSWORD: password | |
MYSQL_ROOT_PASSWORD: password | |
MYSQL_DATABASE: test_db | |
ports: | |
- 3306:3306 | |
options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3 | |
steps: | |
# download repository | |
- uses: actions/checkout@v3 | |
- name: set environment variables | |
run: | | |
echo "ngs-bits-version=2022_10" >> $GITHUB_ENV | |
echo "samtools-version=1.11" >> $GITHUB_ENV | |
echo "htslib-version=1.16" >> $GITHUB_ENV | |
echo "toolspath=src/tools" >> $GITHUB_ENV | |
echo "install_scripts_path=src/tools/script" >> $GITHUB_ENV | |
# echo "job-name=test_annotation_service" >> $GITHUB_ENV | |
# install os dependencies | |
- name: install OS dependencies | |
run: | | |
sudo apt-get update | |
sudo apt-get install autoconf automake make gcc perl zlib1g-dev libbz2-dev liblzma-dev libcurl4-gnutls-dev libssl-dev libncurses5-dev libncursesw5-dev | |
sudo apt-get install g++ libqt5xmlpatterns5-dev libqt5sql5-mysql libcurl4 libcurl4-openssl-dev | |
sudo apt-get install qtbase5-dev qtchooser qt5-qmake qtbase5-dev-tools | |
sudo apt-get install -y mysql-client | |
# setup keycloak | |
- uses: actions/setup-java@v3 | |
with: | |
distribution: 'zulu' | |
java-version: 11 | |
- name: Prepare Keycloak | |
run: | | |
chmod 755 src/frontend_celery/tests/script/prepare_keycloak.sh | |
src/frontend_celery/tests/script/prepare_keycloak.sh | |
- name: Start Keycloak | |
run: | | |
chmod 755 src/frontend_celery/tests/script/start_keycloak_for_tests.sh | |
src/frontend_celery/tests/script/start_keycloak_for_tests.sh | |
# init dbs | |
- name: Verify MySQL connection from container | |
run: | | |
export MOST_RECENT_DUMP_DATE=$(cat resources/backups/database_dumper/most_recent_dump.txt) | |
gunzip resources/backups/database_dumper/structure/structure-$MOST_RECENT_DUMP_DATE.sql.gz | |
mysql --host 0.0.0.0 -uroot -ppassword test_db < resources/backups/database_dumper/structure/structure-$MOST_RECENT_DUMP_DATE.sql | |
mysql --host 0.0.0.0 -uroot -ppassword test_db < src/frontend_celery/tests/data/heredivar_test_data.sql | |
mysql --host 0.0.0.0 -uroot -ppassword test_db -e "SHOW TABLES" | |
- name: Init NGSD | |
run: | | |
mysql --host 0.0.0.0 -uroot -ppassword --port 3306 -e "CREATE DATABASE IF NOT EXISTS ngsd;" | |
mysql --host 0.0.0.0 -uroot -ppassword --port 3306 -e "SHOW DATABASES LIKE 'ngsd';" | |
mysql --host 0.0.0.0 -uroot -ppassword --port 3306 ngsd < src/frontend_celery/tests/data/ngsd_test_data.sql | |
mysql --host 0.0.0.0 -uroot -ppassword --port 3306 -e "SHOW TABLES FROM ngsd" | |
# setup ngs-bits | |
- name: cache ngs-bits | |
id: cache-ngs-bits | |
uses: actions/cache@v3 | |
env: | |
cache-name: cache-ngs-bits | |
with: | |
path: ${{ env.toolspath }}/ngs-bits | |
key: ${{ runner.os }}-build-${{ env.cache-name }}-${{ env.ngs-bits-version }} | |
- if: ${{ steps.cache-ngs-bits.outputs.cache-hit != 'true' }} | |
name: install ngs-bits local | |
run: | | |
chmod 755 ${{ env.install_scripts_path }}/install_ngs_bits.sh | |
${{ env.install_scripts_path }}/install_ngs_bits.sh -p ${{ env.toolspath }} -v ${{ env.ngs-bits-version }} | |
- name: Connect ngs-bits with ngsd | |
run: | | |
echo $(pwd) | |
settingsfile=${{ env.toolspath }}/ngs-bits/bin/settings.ini | |
echo $settingsfile | |
echo "ngsd_host = \"0.0.0.0\"" > $settingsfile | |
echo "ngsd_port = 3306" >> $settingsfile | |
echo "ngsd_name = \"ngsd\"" >> $settingsfile | |
echo "ngsd_user = \"root\"" >> $settingsfile | |
echo "ngsd_pass = \"password\"" >> $settingsfile | |
# install tools dependencies (used for crossmap) | |
# install tools dependencies | |
- name: cache samtools | |
id: cache-samtools | |
uses: actions/cache@v3 | |
env: | |
cache-name: cache-samtools | |
with: | |
path: ${{ env.toolspath }}/samtools | |
key: ${{ runner.os }}-build-${{ env.cache-name }}-${{ env.samtools-version }} | |
- if: ${{ steps.cache-samtools.outputs.cache-hit != 'true' }} | |
name: install samtools | |
run: | | |
chmod 755 ${{ env.install_scripts_path }}/install_samtools.sh | |
${{ env.install_scripts_path }}/install_samtools.sh -p ${{ env.toolspath }} -v ${{ env.samtools-version }} | |
- name: cache htslib | |
id: cache-htslib | |
uses: actions/cache@v3 | |
env: | |
cache-name: cache-htslib | |
with: | |
path: ${{ env.toolspath }}/htslib | |
key: ${{ runner.os }}-build-${{ env.cache-name }}-${{ env.htslib-version }} | |
- if: ${{ steps.cache-htslib.outputs.cache-hit != 'true' }} | |
name: install htslib | |
run: | | |
chmod 755 ${{ env.install_scripts_path }}/install_htslib.sh | |
${{ env.install_scripts_path }}/install_htslib.sh -p ${{ env.toolspath }} -v ${{ env.htslib-version }} | |
- name: update environment variables | |
run: | | |
echo "$GITHUB_WORKSPACE/${{ env.toolspath }}/samtools" >> $GITHUB_PATH | |
echo "$GITHUB_WORKSPACE/${{ env.toolspath }}/htslib" >> $GITHUB_PATH | |
echo "$GITHUB_WORKSPACE/${{ env.toolspath }}/ngs-bits/bin" >> $GITHUB_PATH | |
# build python | |
- name: Set up Python | |
uses: actions/setup-python@v4 | |
with: | |
python-version: '3.8.10' # use 3.x to use the most up-to-date python3 version | |
architecture: 'x64' # Optional - x64 or x86 architecture, defaults to x64 | |
- uses: actions/cache@v3 # cache the python environment to speed up tests | |
id: cache-python-modules | |
with: | |
path: ${{ env.pythonLocation }} | |
key: ${{ env.pythonLocation }}-${{ hashFiles('requirements.txt') }} | |
- if: ${{ steps.cache-python-modules.outputs.cache-hit != 'true' }} | |
name: Install dependencies | |
run: | | |
python3 -m pip install --upgrade pip | |
${{ env.install_scripts_path }}/install_python.sh -p . | |
#if [ -f requirements.txt ]; then pip install -r requirements.txt; fi | |
# download genomes | |
- name: download grch37 | |
run: | | |
wget -q ftp://ftp.1000genomes.ebi.ac.uk/vol1/ftp/technical/reference/phase2_reference_assembly_sequence/hs37d5.fa.gz | |
(gunzip -c hs37d5.fa.gz | sed -r 's/>/>chr/g' > GRCh37.fa) || true | |
rm hs37d5.fa.gz | |
samtools faidx GRCh37.fa | |
- name: download grch38 | |
run: | | |
wget -q ftp://ftp.ncbi.nlm.nih.gov/genomes/all/GCA/000/001/405/GCA_000001405.15_GRCh38/seqs_for_alignment_pipelines.ucsc_ids/GCA_000001405.15_GRCh38_no_alt_plus_hs38d1_analysis_set.fna.gz | |
(gunzip -c GCA_000001405.15_GRCh38_no_alt_plus_hs38d1_analysis_set.fna.gz | sed -r 's/>chrM/>chrMT/g' > GRCh38.fa) || true | |
rm GCA_000001405.15_GRCh38_no_alt_plus_hs38d1_analysis_set.fna.gz | |
samtools faidx GRCh38.fa | |
- name: download chainfile | |
run: | | |
wget -q http://hgdownload.soe.ucsc.edu/goldenPath/hg19/liftOver/hg19ToHg38.over.chain.gz | |
(gunzip -c hg19ToHg38.over.chain.gz | sed -r 's/chrM/chrMT/g' | bgzip > hg19ToHg38.fixed.over.chain.gz) || true | |
rm hg19ToHg38.over.chain.gz | |
# download other dependencies | |
#- name: download phylop | |
# run: wget -q http://hgdownload.soe.ucsc.edu/goldenPath/hg38/phyloP100way/hg38.phyloP100way.bw | |
# write .env file | |
- name: prepare settings | |
run: | | |
cd src/common | |
echo "HOST=127.0.0.1" > .env | |
echo "ISSUER=http://0.0.0.0:5050/realms/HerediVar" >> .env | |
echo "DB_HOST=0.0.0.0" >> .env | |
echo "DB_NAME=test_db" >> .env | |
echo "DB_USER=test_user" >> .env | |
echo "DB_USER_PW=password" >> .env | |
echo "DB_SUPER_USER=test_user" >> .env | |
echo "DB_SUPER_USER_PW=password" >> .env | |
echo "DB_ANNOTATION_USER=test_user" >> .env | |
echo "DB_ANNOTATION_USER_PW=password" >> .env | |
echo "DB_READ_ONLY=test_user" >> .env | |
echo "DB_READ_ONLY_PW=password" >> .env | |
echo "CLINVAR_API_KEY=${{ secrets.CLINVAR_API_KEY }}" >> .env | |
echo "FLASK_SECRET_KEY=The_testing_key" >> .env | |
echo "CLIENT_ID=${{ secrets.CLIENT_ID }}" >> .env | |
echo "CLIENT_SECRET=${{ secrets.CLIENT_SECRET }}" >> .env | |
echo "ENTREZ_MAIL=${{ secrets.ENTREZ_MAIL }}" >> .env | |
# run tests | |
- name: test frontend | |
run: | | |
source .venv/bin/activate | |
chmod 755 src/frontend_celery/tests/script/run_tests.sh | |
src/frontend_celery/tests/script/run_tests.sh | |
##### !secrets are loaded from github: https://github.com/Azure/actions-workflow-samples/blob/master/assets/create-secrets-for-GitHub-workflows.md | |
env: | |
WEBAPP_ENV: githubtest | |
shell: bash | |
# run tests | |
- name: test annotation service | |
run: | | |
echo $PATH | |
source .venv/bin/activate | |
chmod 755 src/annotation_service/tests/run_tests.sh | |
src/annotation_service/tests/run_tests.sh | |
env: | |
WEBAPP_ENV: githubtest | |
shell: bash | |
#- name: Lint with flake8 | |
# run: | | |
# # stop the build if there are Python syntax errors or undefined names | |
# flake8 . --count --select=E9,F63,F7,F82 --show-source --statistics | |
# # exit-zero treats all errors as warnings. The GitHub editor is 127 chars wide | |
# flake8 . --count --exit-zero --max-complexity=10 --max-line-length=127 --statistics | |
#- uses: conda-incubator/setup-miniconda@v2 | |
# with: | |
# python-version: 3.6.9 | |
# auto-activate-base: false | |
# channels: defaults,conda-forge,bioconda | |
#- name: test install conda | |
# run: | | |
# conda install flake8 | |
# conda list | |
# conda info | |
#- name: install ngs-bits | |
# run: conda install ngs-bits | |
#- name: install perl | |
# uses: shogo82148/actions-setup-perl@v1 | |
# with: | |
# perl-version: '5.34' | |
#- name: install vep | |
# run: src/tools/download_tools_vep.sh | |
#- name: install vep | |
# run: docker pull ensemblorg/ensembl-vep:release_104.3 | |
#- name: start vep container | |
# run: | | |
# docker images | |
# docker run -d -it 43bc9e0feefb /bin/bash > vep-container.txt | |
# docker ps -a | |
#- name: install vep plugins | |
# run: | | |
# vepcontainer=$(cat vep-container.txt) | |
# docker exec $vepcontainer INSTALL.pl -a p --PLUGINS REVEL,CADD,MaxEntScan --NO_UPDATE --NO_BIOPERL --NO_TEST --NO_HTSLIB | |
# docker exec $vepcontainer cp /opt/vep/.vep/Plugins/REVEL.pm modules | |
# docker exec $vepcontainer cp /opt/vep/.vep/Plugins/CADD.pm modules | |
# docker exec $vepcontainer cp /opt/vep/.vep/Plugins/MaxEntScan.pm modules | |
#- name: install maxentscan | |
# run: | | |
# vepcontainer=$(cat vep-container.txt) | |
# docker exec $vepcontainer mkdir -p MaxEntScan | |
# docker exec $vepcontainer wget http://hollywood.mit.edu/burgelab/maxent/download/fordownload.tar.gz MaxEntScan | |
# docker exec $vepcontainer tar xzf MaxEntScan/fordownload.tar.gz | |
# docker exec $vepcontainer mv MaxEntScan/fordownload/* . | |
# docker exec $vepcontainer rm -rf MaxEntScan/fordownload* | |
# docker exec $vepcontainer chmod -R 755 MaxEntScan | |
#- name: test vep | |
# run: | | |
# vepcontainer=$(cat vep-container.txt) | |
# docker exec $vepcontainer ./vep --help | |
# this step installs ngs-bits though miniconda | |
# $CONDA is an environment variable pointing to the root of the miniconda directory | |
#- name: prepare conda | |
# run: | | |
# $CONDA/bin/conda config --add channels conda-forge | |
# $CONDA/bin/conda config --add channels bioconda | |
# $CONDA/bin/conda config --add channels defaults | |
#- name: install samtools | |
# run: | | |
# conda install -c bioconda samtools | |
# conda list | |
# conda info | |
# ls -l $CONDA/bin | |
#- name: install ngs-bits | |
# run: | | |
# $CONDA/bin/conda install ngs-bits | |
# $CONDA/bin/ReadQC --help |