virtuoso.sh

#!/bin/bash
SETTINGS_DIR=/settings
mkdir -p $SETTINGS_DIR

cd /data

mkdir -p dumps

if [ ! -f ./virtuoso.ini ];
then
  mv /virtuoso.ini . 2>/dev/null
fi

chmod +x /clean-logs.sh
mv /clean-logs.sh . 2>/dev/null

if [ ! -f "$SETTINGS_DIR/.config_set" ];
then
  echo "Converting environment variables to ini file"
  printenv | grep -P "^VIRT_" | while read setting
  do
    section=`echo "$setting" | grep -o -P "^VIRT_[^_]+" | sed 's/^.\{5\}//g'`
    key=`echo "$setting" | sed -E 's/^VIRT_[^_]+_(.*)=.*$/\1/g'`
    value=`echo "$setting" | grep -o -P "=.*$" | sed 's/^=//g'`
    echo "Registering $section[$key] to be $value"
    crudini --set virtuoso.ini $section $key "$value"
  done
  echo "`date +%Y-%m%-dT%H:%M:%S%:z`" >  $SETTINGS_DIR/.config_set
  echo "Finished converting environment variables to ini file"
fi

# NOTE: Make a temporary copy of virtuoso.ini to start Virtuoso
#       on another port while doing initial setup
cp virtuoso.ini /tmp/virtuoso.ini
crudini --set /tmp/virtuoso.ini HTTPServer ServerPort 27015

if [ ! -f ".backup_restored" -a -d "backups" -a ! -z "$BACKUP_PREFIX" ] ;
then
    echo "Start restoring a backup with prefix $BACKUP_PREFIX"
    cd backups
    virtuoso-t +restore-backup $BACKUP_PREFIX +configfile /tmp/virtuoso.ini
    if [ $? -eq 0 ]; then
        cd /data
        echo "`date +%Y-%m-%dT%H:%M:%S%:z`" > .backup_restored
    else
        exit -1
    fi
fi

if [ ! -f ".dba_pwd_set" ];
then
  touch /tmp/sql-query.sql
  if [ "$DBA_PASSWORD" ]; then echo "user_set_password('dba', '$DBA_PASSWORD');" >> /tmp/sql-query.sql ; fi
  if [ "$SPARQL_UPDATE" = "true" ]; then echo "GRANT SPARQL_UPDATE to \"SPARQL\";" >> /tmp/sql-query.sql ; fi
  virtuoso-t +configfile /tmp/virtuoso.ini +wait && isql-v -U dba -P dba < /docker-virtuoso/dump_nquads_procedure.sql && isql-v -U dba -P dba < /tmp/sql-query.sql
  kill "$(ps aux | grep '[v]irtuoso-t' | awk '{print $2}')"
  echo "`date +%Y-%m-%dT%H:%M:%S%:z`" >  .dba_pwd_set
fi

VIRTUOSO_DB_PASSWORD=${DBA_PASSWORD:-"dba"}
if [ ! -f ".data_loaded" -a -d "toLoad" ] ;
then
    echo "Start data loading from toLoad folder"
    graph="http://localhost:8890/DAV"

    echo "Fetch checkpoint and scheduler intervals from virtuoso.ini"
    checkpoint_interval=$(cat virtuoso.ini | grep -i checkpointinterval | cut -d '=' -f 2)
    scheduler_interval=$(cat virtuoso.ini | grep -i schedulerinterval | cut -d '=' -f 2)

    if [ "$DEFAULT_GRAPH" ]; then graph="$DEFAULT_GRAPH" ; fi
    echo "ld_dir('toLoad', '*', '$graph');" >> /tmp/load_data.sql
    echo "rdf_loader_run();" >> /tmp/load_data.sql
    echo "exec('checkpoint');" >> /tmp/load_data.sql
    echo "checkpoint_interval($checkpoint_interval);" >> /tmp/load_data.sql
    echo "scheduler_interval($scheduler_interval);" >> /tmp/load_data.sql  
    echo "WAIT_FOR_CHILDREN; " >> /tmp/load_data.sql    
    echo "$(cat /tmp/load_data.sql)"
    virtuoso-t +configfile /tmp/virtuoso.ini +wait && isql-v -U dba -P "$VIRTUOSO_DB_PASSWORD" < /tmp/load_data.sql
    kill $(ps aux | grep '[v]irtuoso-t' | awk '{print $2}')
    echo "`date +%Y-%m-%dT%H:%M:%S%:z`" > .data_loaded
fi

if [ "$SPARQL_UPDATE" = "true" ];
then
    echo "WARNING: applying user rights workaround"
    echo "DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 7);" > /tmp/sql-query.sql
    echo "shutdown();" >> /tmp/sql-query.sql
    virtuoso-t +configfile /tmp/virtuoso.ini +wait && isql-v -U dba -P "$VIRTUOSO_DB_PASSWORD" < /tmp/sql-query.sql
    rm /tmp/sql-query.sql
fi


if [ ! -z "$ENABLE_CORS" ];
then
    echo "enabling cors on SPARQL endpoint"
    virtuoso-t +configfile /tmp/virtuoso.ini +wait && isql-v -U dba -P "$VIRTUOSO_DB_PASSWORD" < /docker-virtuoso/add_cors.sql
    kill $(ps aux | grep '[v]irtuoso-t' | awk '{print $2}')
fi

rm /tmp/virtuoso.ini
exec virtuoso-t +wait +foreground