#!/bin/bash

team_id=4

rm -f releases.db
sqlite3 releases.db < $HOME/_work/sevzavoz/git_releases/releases.db.sql


rm -f all_teams_git.txt

for team_id in 2 3 4 5 6 7 8; do
    echo $team_id
    team_name=`echo "select  teamname from teams where id=${team_id};" | sqlite3 releases.db | awk -F":" {'print $1'}`
    team_folder="0${team_id}_${team_name}"
    mkdir -p ${team_folder}
    rm -f ${team_folder}/all_git.txt
    result=""

    for svc in `echo "select svc from services where team_id=${team_id};" | sqlite3 releases.db`; do
        echo ${team_name}: $svc
        git_url=`echo "select git_ssh from services where svc='${svc}';" | sqlite3 releases.db`
        if [ -z "$result" ]; then
            result="$svc"
        else
            result="$result,$svc"
        fi
        echo $svc:${git_url} >> ${team_folder}/all_git.txt
        echo $svc:${git_url} >> all_teams_git.txt
        ln -s "../../$svc" ${team_folder}/$svc 2>/dev/null
        rm -f ${team_folder}/$svc/$svc


    done
    echo $result > ${team_folder}/all_services.txt

done