DIR : /home/kozerus/public_html/go/eidogo/tourney/todos.sh

/home/kozerus/public_html/go/eidogo/tourney

# todos.sh

# todos=`sqlite3 eidogo.db3 "select dt,black,white,idx,id from tourney" | sed -e "s: :_:g"`
todos=`sqlite3 eidogo.db3 "select dt,black,white,idx,id from tourney" | sed -e "s: :_:g" > todos.psv`
todos=`cat todos.psv`

j=0; k=0;
for todo in $todos; do
	let j=j+1
	dt=`echo $todo | awk -F"|" '{ print $1 }'`
	black=`echo $todo | awk -F"|" '{ print $2 }' | awk -F"_" '{ print $1 }'`
	white=`echo $todo | awk -F"|" '{ print $3 }' | awk -F"_" '{ print $1 }'`
	idx=`echo $todo | awk -F"|" '{ print $4 }' `
	id=`echo $todo | awk -F"|" '{ print $5 }'`


	id2=`grep "$dt" sgf/*.sgf | grep "$black" | awk -F":" '{ print $1 }' | head -1`
	echo "$j dt=$dt black=$black idx=$idx id=$id id2=$id2 todo=$todo"

	sqlite3 eidogo.db3 "update tourney set id2='$id2' where id='$id'"
	done

sqlite3 eidogo.db3 "select idx,id,id2 from tourney"