# HG changeset patch # User Kostis Kyzirakos # Date 1342619699 -10800 # Node ID e614ad7569c56a0c764a21f4572e89fe900d252a # Parent 2d32cfc2db188c8f2c875d5211ee6aa2eeea7ba5 polishing diff -r 2d32cfc2db18 -r e614ad7569c5 scripts/v2.2/runNoaRefinementChain.sh --- a/scripts/v2.2/runNoaRefinementChain.sh Wed Jul 18 16:47:35 2012 +0300 +++ b/scripts/v2.2/runNoaRefinementChain.sh Wed Jul 18 16:54:59 2012 +0300 @@ -11,7 +11,7 @@ #CHECKDIR="/home/konstantina/allhot/" #CHECKDIR="${HOME}/teleios/nkua/Hotspots/" -POSTGISTEMPLATE="postgistemplate" +#POSTGISTEMPLATE="postgistemplate" #POSTGISTEMPLATE="template_postgis" #dataDir="http://localhost/noa-teleios/out_triples/" @@ -103,6 +103,7 @@ createdb -U postgres ${DB} # load data +echo "initializing database" curl -s http://dev.strabon.di.uoa.gr/rdf/Kallikratis-Coastline-Corine-dump-postgres-${POSTGRES_MAIN_VERSION}.tgz | tar xz -O | psql -U postgres -d ${DB} psql ${DB} -U postgres -c 'VACUUM ANALYZE ' @@ -114,11 +115,8 @@ sudo service ${tomcat} start fi -exit - -echo "initializing database" -echo "IM S D R TP" >stderr.txt - +#echo "IM S D R TP" >stderr.txt +echo "Store Municipalities DeleteInSea Corine RefineInCoast TimePersistency" >stderr.txt #./scripts/endpoint query ${ENDPOINT} "SELECT (COUNT(*) AS ?C) WHERE {?s ?p ?o}" #sudo -u postgres psql -d endpoint -c 'CREATE INDEX datetime_values_idx_value ON datetime_values USING btree(value)'; @@ -127,8 +125,6 @@ #echo "Continue?" #read a - - for y in 7 8 10 11 ;do for mon in `seq 4 10`; do for d in `seq 1 30`; do @@ -178,6 +174,7 @@ ../endpoint update ${ENDPOINT} "${query}" tmr2=$(timer) + printf '%s ' $((tmr2-tmr1)) >>stderr.txt echo;echo;echo;echo "File ${file} inserted Municipalities!"