#!/usr/bin/bash
# Usage: doS2C.sh node task cc resdir segs workd dbfile
node=$1
task=$2
cc=$3
resdir=$4
segs=$5
workd=$6
dbfile=$7

f=${dbfile%.db}
i=${f#*cdx}

echo "> $node.$task: $segs $i"

sqlite3 $dbfile ".mode csv" ".once $workd/$i.csv" "select count(*),* from props group by segment,ftype,https,nlangs" ".quit"

echo "< $node.$task: $segs $i";